public static STD_Routine GetSTD_RoutineByRoutineID(int RoutineID)
{
STD_Routine sTD_Routine = new STD_Routine();
SqlSTD_RoutineProvider sqlSTD_RoutineProvider = new SqlSTD_RoutineProvider();
sTD_Routine = sqlSTD_RoutineProvider.GetSTD_RoutineByRoutineID(RoutineID);
return sTD_Routine;
}
public static DataSet GetDropDownListAllSTD_Routine()
{
DataSet sTD_Routines = new DataSet();
SqlSTD_RoutineProvider sqlSTD_RoutineProvider = new SqlSTD_RoutineProvider();
sTD_Routines = sqlSTD_RoutineProvider.GetDropDownListAllSTD_Routine();
return sTD_Routines;
}
public static void LoadSTD_RoutinePage(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_RoutineProvider sqlSTD_RoutineProvider = new SqlSTD_RoutineProvider();
DataSet ds = sqlSTD_RoutineProvider.GetSTD_RoutinePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
sTD_RoutinesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static bool UpdateSTD_Routine(STD_Routine sTD_Routine)
{
SqlSTD_RoutineProvider sqlSTD_RoutineProvider = new SqlSTD_RoutineProvider();
return sqlSTD_RoutineProvider.UpdateSTD_Routine(sTD_Routine);
}
public static int InsertSTD_Routine(STD_Routine sTD_Routine)
{
SqlSTD_RoutineProvider sqlSTD_RoutineProvider = new SqlSTD_RoutineProvider();
return sqlSTD_RoutineProvider.InsertSTD_Routine(sTD_Routine);
}
public static bool DeleteSTD_Routine(int sTD_RoutineID)
{
SqlSTD_RoutineProvider sqlSTD_RoutineProvider = new SqlSTD_RoutineProvider();
return sqlSTD_RoutineProvider.DeleteSTD_Routine(sTD_RoutineID);
}