public List <Panchayat> GetPanchayats()
{
List <Panchayat> panchayats = new List <Panchayat>();
MySqlCommand cmd = new MySqlCommand("select * from sbsdb.panchayat", con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Panchayat obj = new Panchayat();
obj.id = Convert.ToInt32(reader["id"]);
obj.name = Convert.ToString(reader["name"]);
obj.block_id = Convert.ToInt32(reader["block_id"]);
panchayats.Add(obj);
}
if (con != null)
{
con.Close();
}
if (reader != null)
{
reader.Close();
}
return(panchayats);
}
public List <Panchayat> GetPanchayats(int blockId)
{
List <Panchayat> panchayats = new List <Panchayat>();
MySqlCommand cmd = new MySqlCommand("select id, name from sbsdb.Panchayat where block_id=@blockId", con);
cmd.Parameters.Add(new MySqlParameter()
{
ParameterName = "@blockId", Value = blockId, MySqlDbType = MySqlDbType.Int32
});
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Panchayat obj = new Panchayat();
obj.id = Convert.ToInt32(reader["id"]);
obj.name = Convert.ToString(reader["name"]);
panchayats.Add(obj);
}
if (con != null)
{
con.Close();
}
if (reader != null)
{
reader.Close();
}
return(panchayats);
}
public void UpdatePanchayat(int id, [FromBody] Panchayat v)
{
repo.UpdatePanchayat(id, v.name);
}
public void Post(int blockId, [FromBody] Panchayat v)
{
repo.InsertPanchayat(v.name, blockId);
}
