citizen adding working

4 files changed, 19 insertions, 18 deletions

diff --git a/interface/controllers/district.controller.js b/interface/controllers/district.controller.js
index 5b21530..468d5fb 100644
--- a/interface/controllers/district.controller.js
+++ b/interface/controllers/district.controller.js
@@ -10,10 +10,10 @@ exports.allDistricts = () => {
 
 exports.allDistrictsByStateId = (state_id) => {
     const query =`SELECT * FROM district_master WHERE state_id = ${state_id}`;
-    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });
+    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT }).then(districts => {
+        if (districts) {
+            return districts;
+        }
+        return null;
+    });
 };
-
-
-
-
-
diff --git a/interface/controllers/mandal.controller.js b/interface/controllers/mandal.controller.js
index 43842fe..5e4d287 100644
--- a/interface/controllers/mandal.controller.js
+++ b/interface/controllers/mandal.controller.js
@@ -11,6 +11,10 @@ exports.allMandals = () => {
 
 exports.allMandalsByDistrictId = (district_id) => {
     const query =`SELECT * FROM mandal_master WHERE district_id = ${district_id}`;
-    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });
-    
+    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT }).then(mandals => {
+        if (mandals) {
+            return mandals;
+        }
+        return null;
+    });
 };
diff --git a/interface/controllers/state.controller.js b/interface/controllers/state.controller.js
index 1a3a4ed..95bff0d 100644
--- a/interface/controllers/state.controller.js
+++ b/interface/controllers/state.controller.js
@@ -4,10 +4,5 @@ const state = db.state_master;
 // function to get all states
 exports.allStates = () => {
     const query = "SELECT * FROM state_master";
-    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });
-    
+    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });    
 };
-
-
-
-
diff --git a/interface/controllers/village.controller.js b/interface/controllers/village.controller.js
index 0a488d4..95372fa 100644
--- a/interface/controllers/village.controller.js
+++ b/interface/controllers/village.controller.js
@@ -11,8 +11,10 @@ exports.allVillages = () => {
 
 exports.allVillagesByMandalId = (mandal_id) => {
     const query =`SELECT * FROM village_master WHERE mandal_id = ${mandal_id}`;
-    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });
-    
+    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT }).then(villages => {
+        if (villages) {
+            return villages;
+        }
+        return null;
+    });
 };
-
-