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; }