public static MetroLocation GetMetroLocationByMetroLocationID(int MetroLocationID)
{
MetroLocation metroLocation = new MetroLocation();
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
metroLocation = sqlMetroLocationProvider.GetMetroLocationByMetroLocationID(MetroLocationID);
return metroLocation;
}
public static DataSet GetDropDownListAllMetroLocation()
{
DataSet metroLocations = new DataSet();
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
metroLocations = sqlMetroLocationProvider.GetDropDownLisAllMetroLocation();
return metroLocations;
}
public static MetroLocation GetMetroLocationByMetroLocationID(int MetroLocationID)
{
MetroLocation metroLocation = new MetroLocation();
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
metroLocation = sqlMetroLocationProvider.GetMetroLocationByMetroLocationID(MetroLocationID);
return(metroLocation);
}
public static DataSet GetDropDownListAllMetroLocation()
{
DataSet metroLocations = new DataSet();
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
metroLocations = sqlMetroLocationProvider.GetDropDownLisAllMetroLocation();
return(metroLocations);
}
public static void LoadMetroLocationPage(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);
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
DataSet ds = sqlMetroLocationProvider.GetMetroLocationPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
metroLocationsPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static void LoadMetroLocationPage(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);
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
DataSet ds = sqlMetroLocationProvider.GetMetroLocationPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
metroLocationsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool DeleteMetroLocation(int metroLocationID)
{
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
return(sqlMetroLocationProvider.DeleteMetroLocation(metroLocationID));
}
public static bool UpdateMetroLocation(MetroLocation metroLocation)
{
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
return(sqlMetroLocationProvider.UpdateMetroLocation(metroLocation));
}
public static int InsertMetroLocation(MetroLocation metroLocation)
{
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
return(sqlMetroLocationProvider.InsertMetroLocation(metroLocation));
}
public static bool UpdateMetroLocation(MetroLocation metroLocation)
{
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
return sqlMetroLocationProvider.UpdateMetroLocation(metroLocation);
}
public static int InsertMetroLocation(MetroLocation metroLocation)
{
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
return sqlMetroLocationProvider.InsertMetroLocation(metroLocation);
}
public static bool DeleteMetroLocation(int metroLocationID)
{
SqlMetroLocationProvider sqlMetroLocationProvider = new SqlMetroLocationProvider();
return sqlMetroLocationProvider.DeleteMetroLocation(metroLocationID);
}
