working edit

1 files changed, 10 insertions, 16 deletions

diff --git a/interface/controllers/citizens.controller.js b/interface/controllers/citizens.controller.js
index 9eaf153..ee9355b 100644
--- a/interface/controllers/citizens.controller.js
+++ b/interface/controllers/citizens.controller.js
@@ -1,35 +1,29 @@
-const req = require("express/lib/request");
 const db = require("../models");
 const citizens = db.citizens;
-const village_master = db.village_master;
 const {QueryTypes} = require('sequelize');
 const { sequelize } = require("../models");
 
 
 // Retrieve all citizens from the database. Limit the number of citizens returned to 10.
 exports.findXCitizens = () => {
-  /**
-   * select c.first_name, c.last_name, c.address, c.mobile_num, c.dob, c.gender, c.marital_status, v.village_name  
-    from citizens c
-    join village_master v
-    on c.village_id = v.village_id
-    limit 10
-   */   
-  const limit = 10;
-  // Raw query in Sequelize 
-
   query = `select c.citizen_id, c.first_name, c.last_name, c.address, c.mobile_num, c.dob, c.gender, c.marital_status, c.village_id, v.village_name  
             from citizens c
             join village_master v
             on c.village_id = v.village_id
-            limit 10`
+            order by citizen_id limit 10;`;
 
   return sequelize.query(query, { type: QueryTypes.SELECT })
 };
 
-
-
-
+exports.editCitizen = (citizen_id, address, mobile_num, dob, marital_status) => {
+  return citizens.update({
+    address, mobile_num, dob, marital_status
+  }, {
+    where: {
+      citizen_id
+    }
+  });
+};
 
 // Get total number of male and female citizens
 exports.findGenderDistribution = () => {