public static DataSet GetDropDownListAllCOMN_City() { DataSet cOMN_Cities = new DataSet(); SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); cOMN_Cities = sqlCOMN_CityProvider.GetDropDownListAllCOMN_City(); return cOMN_Cities; }
public static COMN_City GetCOMN_CountryByCountryID(int CountryID) { COMN_City cOMN_City = new COMN_City(); SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); cOMN_City = sqlCOMN_CityProvider.GetCOMN_CityByCountryID(CountryID); return cOMN_City; }
public static DataSet GetAllCOMN_CitiesWithRelation() { DataSet cOMN_Cities = new DataSet(); SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); cOMN_Cities = sqlCOMN_CityProvider.GetAllCOMN_Cities(); return cOMN_Cities; }
public static void LoadCOMN_CityPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize) { int recordCount=0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); DataSet ds = sqlCOMN_CityProvider.GetCOMN_CityPageWise(pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); cOMN_CitiesPaggination(rptPager,recordCount, pageIndex, PageSize); }
public static int InsertCOMN_City(COMN_City cOMN_City) { SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); return sqlCOMN_CityProvider.InsertCOMN_City(cOMN_City); }
public static bool DeleteCOMN_City(int cOMN_CityID) { SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); return sqlCOMN_CityProvider.DeleteCOMN_City(cOMN_CityID); }
public static bool UpdateCOMN_City(COMN_City cOMN_City) { SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider(); return sqlCOMN_CityProvider.UpdateCOMN_City(cOMN_City); }