public static STD_City GetSTD_CountryByCountryID(int CountryID)
{
STD_City sTD_City = new STD_City();
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
sTD_City = sqlSTD_CityProvider.GetSTD_CityByCountryID(CountryID);
return sTD_City;
}
public static DataSet GetDropDownListAllSTD_City()
{
DataSet sTD_Cities = new DataSet();
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
sTD_Cities = sqlSTD_CityProvider.GetDropDownListAllSTD_City();
return sTD_Cities;
}
public static DataSet GetAllSTD_CitiesWithRelation()
{
DataSet sTD_Cities = new DataSet();
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
sTD_Cities = sqlSTD_CityProvider.GetAllSTD_Cities();
return sTD_Cities;
}
public static void LoadSTD_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);
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
DataSet ds = sqlSTD_CityProvider.GetSTD_CityPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
sTD_CitiesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertSTD_City(STD_City sTD_City)
{
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
return sqlSTD_CityProvider.InsertSTD_City(sTD_City);
}
public static bool DeleteSTD_City(int sTD_CityID)
{
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
return sqlSTD_CityProvider.DeleteSTD_City(sTD_CityID);
}
public static bool UpdateSTD_City(STD_City sTD_City)
{
SqlSTD_CityProvider sqlSTD_CityProvider = new SqlSTD_CityProvider();
return sqlSTD_CityProvider.UpdateSTD_City(sTD_City);
}