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); }