public static DataSet GetDropDownListAllSTD_RoutineTime()
{
DataSet sTD_RoutineTimes = new DataSet();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTimes = sqlSTD_RoutineTimeProvider.GetDropDownLisAllSTD_RoutineTime();
return sTD_RoutineTimes;
}
public static DataSet GetAllSTD_RoutineTimesByClassSubjectTeacher(int ClassID, int SubjectID, string teacherID)
{
DataSet sTD_RoutineTimes = new DataSet();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTimes = sqlSTD_RoutineTimeProvider.GetAllSTD_RoutineTimesByClassSubjectTeacher(ClassID, SubjectID, teacherID);
return sTD_RoutineTimes;
}
public static DataSet GetAllSTD_RoutineTimesWithRelation()
{
DataSet sTD_RoutineTimes = new DataSet();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTimes = sqlSTD_RoutineTimeProvider.GetAllSTD_RoutineTimes();
return sTD_RoutineTimes;
}
public static bool UpdateSTD_RoutineTime(STD_RoutineTime sTD_RoutineTime)
{
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
return sqlSTD_RoutineTimeProvider.UpdateSTD_RoutineTime(sTD_RoutineTime);
}
public static DataSet STD_SearchRoutineTimeForRoutineCheck(STD_RoutineTime routineTime, string studentID)
{
DataSet sTD_RoutineTimes = new DataSet();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTimes = sqlSTD_RoutineTimeProvider.STD_SearchRoutineTimeForRoutineCheck(routineTime, studentID);
return sTD_RoutineTimes;
}
public static void LoadSTD_RoutineTimePage(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_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
DataSet ds = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
sTD_RoutineTimesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertSTD_RoutineTime(STD_RoutineTime sTD_RoutineTime)
{
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
return sqlSTD_RoutineTimeProvider.InsertSTD_RoutineTime(sTD_RoutineTime);
}
public static STD_RoutineTime GetSTD_SubjectBySubjectID(int SubjectID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeBySubjectID(SubjectID);
return sTD_RoutineTime;
}
public static STD_RoutineTime GetSTD_RoutineTimeByRoutineTimeID(int RoutineTimeID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeByRoutineTimeID(RoutineTimeID);
return sTD_RoutineTime;
}
public static STD_RoutineTime GetSTD_EmployeeByEmployeeID(string EmployeeID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeByEmployeeID(EmployeeID);
return sTD_RoutineTime;
}
public static STD_RoutineTime GetSTD_ClassDayByClassDayID(int ClassDayID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeByClassDayID(ClassDayID);
return sTD_RoutineTime;
}
public static bool DeleteSTD_RoutineTime(int sTD_RoutineTimeID)
{
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
return sqlSTD_RoutineTimeProvider.DeleteSTD_RoutineTime(sTD_RoutineTimeID);
}
