methods.ts 1.15 KB
Newer Older
Rosanny Sihombing's avatar
updates    
Rosanny Sihombing committed
1
const dbconn = require('../config/dbconn');
Rosanny Sihombing's avatar
Rosanny Sihombing committed
2
3

var methods = {
Rosanny Sihombing's avatar
Rosanny Sihombing committed
4
5
6
7
8
9
10
11
12
13
    getAllMailinglists: async function() {
        try {
            let rows:any = await dbconn.project.promise().query('CALL getAllLists')
            if (rows[0][0]) {
                return rows[0][0]
            } else { return null }
        } catch (err) {
            console.error(err)
        }
        return null
Rosanny Sihombing's avatar
Rosanny Sihombing committed
14
    },
Rosanny Sihombing's avatar
Rosanny Sihombing committed
15
16
17
18
19
20
21
22
23
24
    getProjectOverviewById: async function(projectId:number) {
        try {
            let rows:any = await dbconn.project.promise().query('CALL GetProjectInformationByProjectID(' + projectId+ ')')
            if (rows[0][0]) {
                return rows[0][0]
            } else { return null }
        } catch (err) {
            console.error(err)
        }
        return null
Rosanny Sihombing's avatar
Rosanny Sihombing committed
25
    },
Rosanny Sihombing's avatar
Rosanny Sihombing committed
26
27
28
29
30
31
32
33
34
35
    getProjectImagesById: async function(projectId:number) {
        try {
            let rows:any = await dbconn.project.promise().query('CALL getImagesByProjectID(' + projectId+ ')')
            if (rows[0][0]) {
                return rows[0][0]
            } else { return null }
        } catch (err) {
            console.error(err)
        }
        return null
Rosanny Sihombing's avatar
Rosanny Sihombing committed
36
37
38
    }
};

39

Rosanny Sihombing's avatar
updates    
Rosanny Sihombing committed
40
export = methods;