public List<Thana> GetAllThana(int id)
{
string searchMedicine = "SELECT * FROM tbl_thana where DistrictId='"+id+"' Order By Thana ASC";
sqlConnection.Open();
sqlCommand.CommandText = searchMedicine;
SqlDataReader reader = sqlCommand.ExecuteReader();
List<Thana> thanaList = new List<Thana>();
while (reader.Read())
{
Thana aThana = new Thana();
aThana.Id = Convert.ToInt32(reader["id"].ToString());
aThana.Name = reader["Thana"].ToString();
thanaList.Add(aThana);
}
reader.Close();
sqlConnection.Close();
return thanaList;
}
public List<Thana> GetAllThana(int id)
{
string query = "SELECT * FROM tbl_thana WHERE DistrictId='" + id + "'";
sqlConnection.Open();
sqlCommand.CommandText = query;
SqlDataReader aReader = sqlCommand.ExecuteReader();
List<Thana> thanaList = new List<Thana>();
while (aReader.Read())
{
Thana aThana = new Thana();
aThana.Id = (int)aReader["id"];
aThana.Name = aReader["Thana"].ToString();
aThana.DistrictId = (int)aReader["DistrictId"];
thanaList.Add(aThana);
}
aReader.Close();
sqlConnection.Close();
return thanaList;
}
public string GetThana(int thanaId)
{
string searchMedicine = "SELECT * FROM tbl_thana where id='" + thanaId + "'";
sqlConnection.Open();
sqlCommand.CommandText = searchMedicine;
SqlDataReader reader = sqlCommand.ExecuteReader();
Thana aThana = new Thana();
while (reader.Read())
{
aThana.Name = reader["Thana"].ToString();
}
reader.Close();
sqlConnection.Close();
return aThana.Name;
}
