public IList <Shreet> GetAllShreet(string sql, SqlParameter[] paras) { IList <Shreet> list = null; DataTable table = SQLDBHelper.GetDataTable(sql, paras); if (table != null) { if (table.Rows.Count > 0) { list = new List <Shreet>(); foreach (DataRow row in table.Rows) { Shreet shreet = new Shreet(); shreet.ShreetId = int.Parse(row["shreetId"].ToString()); shreet.ShreetName = row["shreetName"].ToString(); shreet.DistrictId = int.Parse(row["districtId"].ToString()); if (ds.GetDistrictByID(shreet.DistrictId) != null) { shreet.District = ds.GetDistrictByID(shreet.DistrictId)[0]; } list.Add(shreet); } } } return(list); }
public IList <District> GetAllDistrict(string sql, SqlParameter[] paras) { IList <District> list = null; DataTable table = SQLDBHelper.GetDataTable(sql, paras); if (table != null) { if (table.Rows.Count > 0) { list = new List <District>(); foreach (DataRow row in table.Rows) { District district = new District(); district.DistrictId = int.Parse(row["districtId"].ToString()); district.DistrictName = row["districtName"].ToString(); district.CityId = int.Parse(row["cityId"].ToString()); if (cs.GetCityByID(district.CityId) != null) { district.City = cs.GetCityByID(district.CityId)[0]; } list.Add(district); } } } return(list); }
public DataTable GetShreetByDistrictIdTwo(int districtId) { string sql = "SELECT * FROM Shreet where DistrictId=@DistrictId"; SqlParameter[] parameters = { new SqlParameter("@DistrictId", SqlDbType.Int, 4) }; parameters[0].Value = districtId; return(SQLDBHelper.GetDataTable(sql, parameters)); }
public DataTable GetShreetByKeyNameTooo(string KeyName) { string sql = "SELECT * FROM Shreet where ShreetName like '%" + KeyName + "%'"; SqlParameter[] parameters = { new SqlParameter("@ShreetName", SqlDbType.VarChar, 20) }; parameters[0].Value = KeyName; return(SQLDBHelper.GetDataTable(sql, parameters)); }
public DataTable GetDistrictByCityIDTwo(int cityId) { string sql = "SELECT * FROM District where CityId=@CityId"; SqlParameter[] parameters = { new SqlParameter("@CityId", SqlDbType.Int, 4) }; parameters[0].Value = cityId; return(SQLDBHelper.GetDataTable(sql, parameters)); }
public IList <City> GetAllCity(string sql, SqlParameter[] paras) { IList <City> list = null; DataTable table = SQLDBHelper.GetDataTable(sql, paras); if (table != null) { if (table.Rows.Count > 0) { list = new List <City>(); foreach (DataRow row in table.Rows) { City city = new City(); city.CityId = int.Parse(row["cityId"].ToString()); city.CityName = row["cityName"].ToString(); list.Add(city); } } } return(list); }
public IList <Shreet> GetShreetTx() { string sql = "SELECT * FROM Shreet"; IList <Shreet> list = null; DataTable table = SQLDBHelper.GetDataTable(sql, null); if (table != null) { if (table.Rows.Count > 0) { list = new List <Shreet>(); foreach (DataRow row in table.Rows) { Shreet shreet = new Shreet(); shreet.ShreetId = int.Parse(row["shreetId"].ToString()); shreet.ShreetName = row["shreetName"].ToString(); shreet.DistrictId = int.Parse(row["districtId"].ToString()); list.Add(shreet); } } } return(list); }