public District GetDistrict(int districtId)
{
string query = "SELECT * FROM tbl_district WHERE id='" + districtId + "'";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlConnection.Open();
ASqlDataReader = ASqlCommand.ExecuteReader();
if (ASqlDataReader.HasRows)
{
ASqlDataReader.Read();
District aDistrict = new District();
aDistrict.Id = Convert.ToInt16(ASqlDataReader["id"]);
aDistrict.Population = Convert.ToInt32(ASqlDataReader["population"]);
aDistrict.Name = ASqlDataReader["name"].ToString();
ASqlDataReader.Close();
ASqlConnection.Close();
return aDistrict;
}
else
{
ASqlDataReader.Close();
ASqlConnection.Close();
return null;
}
}
public District FindDistrict(string name)
{
string query = "SELECT * FROM tbl_district WHERE name='" + name + "'";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlConnection.Open();
ASqlDataReader = ASqlCommand.ExecuteReader();
if (ASqlDataReader.HasRows)
{
District aDistrict = new District();
ASqlDataReader.Read();
aDistrict.Id = (int) ASqlDataReader["id"];
aDistrict.Name = ASqlDataReader["name"].ToString();
aDistrict.Population = (int) ASqlDataReader["population"];
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return aDistrict;
}
else
{
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return null;
}
}
public List<District> GetAllDistricts()
{
List<District> districtList = new List<District>();
string query = "SELECT * FROM tbl_district";
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlConnection.Open();
ASqlDataReader = ASqlCommand.ExecuteReader();
while (ASqlDataReader.Read())
{
District aDistrict = new District();
aDistrict.Id = (int)ASqlDataReader["id"];
aDistrict.Name = ASqlDataReader["name"].ToString();
districtList.Add(aDistrict);
}
ASqlDataReader.Close();
ASqlCommand.Dispose();
ASqlConnection.Close();
return districtList;
}
