public static DataSet GetDropDownListAllSTD_Student()
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetDropDownListAllSTD_Student();
return sTD_Students;
}
public static STD_Student GetHR_ReligionByReligionID(int ReligionID)
{
STD_Student sTD_Student = new STD_Student();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Student = sqlSTD_StudentProvider.GetSTD_StudentByReligionID(ReligionID);
return sTD_Student;
}
public static DataSet GetAllSTD_StudentsWithRelation()
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetAllSTD_Students();
return sTD_Students;
}
public static DataSet DeleteSTD_StudentsAttentdantAlreadyAttended(int classID, int subjectID, string employeeID, string time)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.DeleteSTD_StudentsAttentdantAlreadyAttended(classID, subjectID, employeeID, time);
return sTD_Students;
}
public static STD_Student GetAllSTD_StudentsByBatchNo(int batchNo)
{
STD_Student sTD_Student = new STD_Student();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Student = sqlSTD_StudentProvider.GetAllSTD_StudentsByBatchNo(batchNo);
return sTD_Student;
}
public static STD_Student GetHR_MaritualStatusByMaritualStatusID(int MaritualStatusID)
{
STD_Student sTD_Student = new STD_Student();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Student = sqlSTD_StudentProvider.GetSTD_StudentByMaritualStatusID(MaritualStatusID);
return sTD_Student;
}
public static DataSet InsertSTD_Student(STD_Student sTD_Student)
{
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
return sqlSTD_StudentProvider.InsertSTD_Student(sTD_Student);
}
public static bool UpdateSTD_Student(STD_Student sTD_Student)
{
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
return sqlSTD_StudentProvider.UpdateSTD_Student(sTD_Student);
}
public static bool DeleteSTD_StudentAccordingToRowStatusID(string sTD_StudentID, int rowStatusID)
{
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
return sqlSTD_StudentProvider.DeleteSTD_StudentAccordingToRowStatusID(sTD_StudentID, rowStatusID);
}
public static DataSet GetSTD_ExamStudentsByExamDetailsID(int examDetailsID)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_ExamStudentsByExamDetailsID(examDetailsID);
return sTD_Students;
}
public static STD_Student GetHR_StudnetByStudentCode(string studentCode)
{
STD_Student sTD_Student = new STD_Student();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Student = sqlSTD_StudentProvider.GetSTD_StudentByStudentCode(studentCode);
return sTD_Student;
}
public static DataSet GetSTD_StudentsByExamIDnStudentID(int examID,string studentID)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_StudentsByExamIDnStudentID(examID, studentID);
return sTD_Students;
}
public static bool DeleteSTD_Student(string sTD_StudentID)
{
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
return sqlSTD_StudentProvider.DeleteSTD_Student(sTD_StudentID);
}
public static DataSet GetSTD_StudentsAttentdant(int classID, int subjectID, string employeeID)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_StudentsAttentdant(classID, subjectID, employeeID);
return sTD_Students;
}
public static STD_Student GetSTD_StudentMoneyReceitByStudentID(string StudentID)
{
STD_Student sTD_Student = new STD_Student();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Student = sqlSTD_StudentProvider.GetSTD_StudentMoneyReceitByStudentID(StudentID);
return sTD_Student;
}
public static DataSet GetSTD_StudentClassSummery(string studentCode, DateTime fromDate, DateTime toDate)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_StudentClassSummery(studentCode, fromDate, toDate);
return sTD_Students;
}
public static DataSet GetSTD_StudentByIDs(string IDs)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_StudentByIDs(IDs);
return sTD_Students;
}
public static void LoadSTD_StudentPage(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_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
DataSet ds = sqlSTD_StudentProvider.GetSTD_StudentPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
//COMN_CommonManager common = new COMN_CommonManager();
COMN_CommonManager.Paggination(rptPager, recordCount, pageIndex, PageSize);
}
public static List<STD_Student> SearchAllSTD_Students(string studentName, string studentCode, int batchNo, string phone, DateTime startDate, DateTime endDate)
{
List<STD_Student> sTD_Student = new List<STD_Student>();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Student = sqlSTD_StudentProvider.SearchAllSTD_Students(studentName, studentCode, batchNo, phone, startDate, endDate);
return sTD_Student;
}
public static DataSet GetSTD_ClassStudentsAttentdant(string employeeID, DateTime date)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_ClassStudentsAttentdant(employeeID, date);
return sTD_Students;
}
public static DataSet GetSTD_ClassSubjectEmployeeStudentByClassSubjectEmployeeIDForRepeating(string employeeID, DateTime date)
{
DataSet sTD_Students = new DataSet();
SqlSTD_StudentProvider sqlSTD_StudentProvider = new SqlSTD_StudentProvider();
sTD_Students = sqlSTD_StudentProvider.GetSTD_ClassSubjectEmployeeStudentByClassSubjectEmployeeIDForRepeating(employeeID, date);
return sTD_Students;
}