node-api/appointments.service.js at master · ptshn/node-api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
const mssql = require('../../mssql');
const { TYPES } = require('tedious');
const moment = require('moment')

const readAll = () => {
    const promise = mssql.executeProc('Appointments_SelectAll')
        .then(response => {
            const items = response.resultSets[1];
            return items
        })
        .catch(responseErrorHandler);

    return promise;
}

const readById = id => {
    const promise = mssql.executeProc('Appointments_Select_ById', sqlRequest => {
        sqlRequest.addParameter('RequesterId', TYPES.Int, id);
    })
        .then(response => {
            return response.resultSets[1];
        })
        .catch(responseErrorHandler)

    return promise;
}

const create = item => {
    const promise = mssql
        .executeProc('Appointments_Insert', sqlRequest => {
            sqlRequest.addParameter('RequesterId', TYPES.Int, item.requesterId),
                sqlRequest.addParameter('GuestId', TYPES.Int, item.guestId),
                sqlRequest.addParameter('AppointmentDate', TYPES.DateTime2, item.appointmentDate),
                sqlRequest.addParameter('AppointmentEndDate', TYPES.DateTime2, item.appointmentEndDate),
                sqlRequest.addParameter('Location', TYPES.NVarChar, item.location, {
                    length: 4000
                });
            sqlRequest.addParameter('Description', TYPES.NVarChar, item.description, {
                length: 4000
            });
            sqlRequest.addOutputParameter('Id', TYPES.Int, null);
        })
        .then(response => {
            return response.outputParameters;
        })
        .catch(responseErrorHandler);

    return promise;
}

const updateById = (id, item) => {
    const promise = mssql.executeProc('Appointments_Update_ById', sqlRequest => {
        sqlRequest.addParameter('RequesterId', TYPES.Int, item.requesterId);
        sqlRequest.addParameter('GuestId', TYPES.Int, item.guestId);
        sqlRequest.addParameter('AppointmentDate', TYPES.DateTime2, item.appointmentDate);
        sqlRequest.addParameter('Location', TYPES.NVarChar, item.location, {
            length: 4000
        });
        sqlRequest.addParameter('Description', TYPES.NVarChar, item.description, {
            length: 4000
        });
        sqlRequest.addParameter('Id', TYPES.Int, id);
    })
        .then(response => {
            return response
        })
        .catch(responseErrorHandler)

    return promise;
}

const readByMonthYear = (id, year, month) => {
    const startOfMonth = moment([year, month - 1]);  // using Moment for date manipulation. month in Moment is 0 based, so January is 0 (not 1) etc.
    const endOfMonth = moment(startOfMonth).endOf('month');  // further explanation https://stackoverflow.com/questions/26131003/moment-js-start-and-end-of-given-month

    const promise = mssql.executeProc('Appointments_Select_ByMonthAndYear', sqlRequest => {
        sqlRequest.addParameter('SelectedId', TYPES.Int, id);
        sqlRequest.addParameter('StartDate', TYPES.DateTime2, startOfMonth);
        sqlRequest.addParameter('EndDate', TYPES.DateTime2, endOfMonth);
    })
        .then(response => {
            return response.resultSets[1];
        })
        .catch(responseErrorHandler)

    return promise;
}

const del = id => {
    const promise = mssql.executeProc('Appointments_Delete', sqlRequest => {
        sqlRequest.addParameter('Id', TYPES.Int, id)
    })
        .then(response => {
            return response
        })
        .catch(responseErrorHandler)

    return promise;
}

const responseErrorHandler = error => {
    console.log(error);
    if (error && error.response && error.response.data && error.response.data.errors) {
        console.error(error.response.data.errors);
    }
    return Promise.reject(error);
}

module.exports = {
    create
    , readAll
    , readById
    , updateById
    , del
    , readByMonthYear
}