public static DataSet GetDropDownListAllSTD_SubjectEmployee()
{
DataSet sTD_Classs = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Classs = sqlSTD_SubjectProvider.GetDropDownListAllSTD_SubjectEmployee();
return sTD_Classs;
}
public static DataSet GetDropDownListAllSTD_SubjectEnrollment(int courseID)
{
DataSet sTD_Subjects = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subjects = sqlSTD_SubjectProvider.GetDropDownListAllSTD_SubjectEnrollment(courseID);
return sTD_Subjects;
}
public static DataSet GetAllSTD_SubjectsWithRelation()
{
DataSet sTD_Subjects = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subjects = sqlSTD_SubjectProvider.GetAllSTD_Subjects();
return sTD_Subjects;
}
public static DataSet GetDropDownListAllSTD_SubjectByClassID(int ClassID)
{
DataSet sTD_Subject = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subject = sqlSTD_SubjectProvider.GetSTD_SubjectByClassID(ClassID);
return sTD_Subject;
}
public static bool UpdateSTD_Subject(STD_Subject sTD_Subject)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.UpdateSTD_Subject(sTD_Subject);
}
public static bool DeleteSTD_SubjectEmployee(int SubjectEmployeeID)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.DeleteSTD_SubjectEmployee(SubjectEmployeeID);
}
public static void LoadSTD_SubjectPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, DropDownList ddlCourseID)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
DataSet ds = sqlSTD_SubjectProvider.GetSTD_SubjectPageWise(pageIndex, PageSize, out recordCount,ddlCourseID.SelectedValue);
gv.DataSource = ds;
gv.DataBind();
//COMN_CommonManager common = new COMN_CommonManager();
COMN_CommonManager.Paggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool DeleteSTD_Subject(int sTD_SubjectID)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.DeleteSTD_Subject(sTD_SubjectID);
}
public static int InsertSTD_Subject(STD_Subject sTD_Subject)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.InsertSTD_Subject(sTD_Subject);
}
public static int InsertSTD_SubjectEmployee_List(STD_SubjectEmployee sTD_SubjectEmployee)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.InsertSTD_SubjectEmployee_List(sTD_SubjectEmployee);
}
public static List<STD_Subject> GetSTD_SubjectsByCourseID(int CourseID)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.GetSTD_SubjectsByCourseID(CourseID);
}
public static STD_Subject GetSTD_SubjectFromSubjectEmployeeBySubjectID(int SubjectID)
{
STD_Subject sTD_Subject = new STD_Subject();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subject = sqlSTD_SubjectProvider.GetSTD_SubjectFromSubjectEmployeeBySubjectID(SubjectID);
return sTD_Subject;
}
public static DataSet GetSTD_SubjectEmployeeBySubjectID(int subjectID)
{
DataSet sTD_ClassStudent = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_ClassStudent = sqlSTD_SubjectProvider.GetSTD_SubjectEmployeeBySubjectID(subjectID, true);
return sTD_ClassStudent;
}
public static DataSet GetSTD_SubjectByCourseIDByStudentIDWhoHasnotTakenTheClass(int CourseID,string studentID)
{
DataSet sTD_Subject = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subject = sqlSTD_SubjectProvider.GetSTD_SubjectByCourseIDByStudentIDWhoHasnotTakenTheClass(CourseID, studentID);
return sTD_Subject;
}
public static DataSet GetSTD_SubjectByCourseID(int CourseID)
{
DataSet sTD_Subject = new DataSet();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subject = sqlSTD_SubjectProvider.GetSTD_SubjectByCourseID(CourseID);
return sTD_Subject;
}
