diff options
| author | Bobby <[email protected]> | 2022-05-04 13:17:13 -0400 |
|---|---|---|
| committer | Bobby <[email protected]> | 2022-05-04 13:17:13 -0400 |
| commit | ef4d6c061dc2c0b4b0ab1d3faaacaba33a78706e (patch) | |
| tree | 1cacfc86c4ad23a79f79f685497fea7305ef2d4d /interface/controllers/citizens.controller.js | |
| parent | b2824e18d303490e6135439a368d855c0addfde1 (diff) | |
| download | Welfare-Schemes-DMQL-ef4d6c061dc2c0b4b0ab1d3faaacaba33a78706e.tar.xz Welfare-Schemes-DMQL-ef4d6c061dc2c0b4b0ab1d3faaacaba33a78706e.zip | |
fixed citizens ui
Diffstat (limited to 'interface/controllers/citizens.controller.js')
| -rw-r--r-- | interface/controllers/citizens.controller.js | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/interface/controllers/citizens.controller.js b/interface/controllers/citizens.controller.js index ae0204e..1cb61cb 100644 --- a/interface/controllers/citizens.controller.js +++ b/interface/controllers/citizens.controller.js @@ -51,7 +51,7 @@ exports.getCountOfCitizens = () => { }; exports.deleteCitizenbyId = (citizen_id) => { - const query = `delete from citizens where citizen_id = ${citizen_id};`; + const query = `delete from citizens where citizen_id = '${citizen_id}';`; return sequelize.query(query, { type: QueryTypes.DELETE }); }; @@ -62,13 +62,13 @@ exports.editCitizen = ( dob, marital_status ) => { - const query = `update citizens set address = '${address}', mobile_num = '${mobile_num}', dob = '${dob}', marital_status = '${marital_status}' where citizen_id = ${citizen_id};`; + const query = `update citizens set address = '${address}', mobile_num = '${mobile_num}', dob = '${dob}', marital_status = '${marital_status}' where citizen_id = '${citizen_id}';`; return sequelize.query(query, { type: QueryTypes.UPDATE }); }; //Check Citizen exists or not exports.checkCitizenId = (citizen_id) => { - const query = `select * from citizens where citizen_id = ${citizen_id};`; + const query = `select * from citizens where citizen_id = '${citizen_id}';`; return sequelize .query(query, { type: QueryTypes.SELECT }) .then((citizen_id) => { |