From ef4d6c061dc2c0b4b0ab1d3faaacaba33a78706e Mon Sep 17 00:00:00 2001
From: Bobby <bobbyskhs@gmail.com>
Date: Wed, 4 May 2022 13:17:13 -0400
Subject: fixed citizens ui

---
 interface/controllers/citizens.controller.js | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'interface/controllers/citizens.controller.js')

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) => {
-- 
cgit v1.2.3