methods.ts 825 Bytes
Newer Older
Rosanny Sihombing's avatar
Rosanny Sihombing committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
const dbconn = require('../config/dbconn');

var methods = {
    getAllMailinglists: function(callback:any) {
        dbconn.project.query('CALL getAllLists', function (err:any, rows:any){
            if (err) throw err;
            callback(rows[0], err);
	    })
    },
    getProjectOverviewById: function(projectId:number, callback:any) {
        dbconn.project.query('CALL GetProjectInformationByProjectID(' + projectId+ ')', function (err:any, rows:any){
            if (err) throw err;
            callback(rows[0], err);
    	})
    },
    getProjectImagesById: function(projectId:number, callback:any) {
        dbconn.project.query('CALL getImagesByProjectID(' + projectId+ ')', function (err:any, rows:any){
            if (err) throw err;
            callback(rows[0], err);
        })
    }
};

export = methods;