1 files changed, 18 insertions, 0 deletions
diff --git a/interface/controllers/village.controller.js b/interface/controllers/village.controller.js
new file mode 100644
index 0000000..0a488d4
--- /dev/null
+++ b/interface/controllers/village.controller.js
@@ -0,0 +1,18 @@
+const db = require("../models");
+const village = db.village_master;
+
+
+exports.allVillages = () => {
+    return village.findAll({
+        attributes: ['village_id', 'village_name']
+    })
+};
+
+
+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 });
+    
+};
+
+