public List<Thana> GetThanaAccordingToDistrict(int id)
{
List<Thana> thanas=new List<Thana>();
SqlConnection connection = new SqlConnection(connectionstring);
string query = "SELECT t.thana_Id,t.thana_Name FROM Table_Thana as t join Table_District as d on t.thana_DistrictId=d.district_Id WHERE thana_DistrictId='"+id+"'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Thana thana = new Thana();
thana.Id = int.Parse(reader["thana_Id"].ToString());
thana.Name = reader["thana_Name"].ToString();
thanas.Add(thana);
}
reader.Close();
connection.Close();
return thanas;
}
public List<Thana> GeThanas()
{
List<Thana>thanas=new List<Thana>();
SqlConnection connection=new SqlConnection(connectionstring);
string query = "SELECT * FROM Table_Thana";
SqlCommand command=new SqlCommand(query,connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Thana thana=new Thana();
thana.Id = int.Parse(reader["thana_Id"].ToString());
thana.Name = reader["thana_Name"].ToString();
thana.DistrictId = int.Parse(reader["thana_DistrictId"].ToString());
thanas.Add(thana);
}
reader.Close();
connection.Close();
return thanas;
}