public DataSet BAL_SYS_Attendance_SchoolAdmin(SYS_Attendance Prop_SYS_Attendance, String mode)
{
DataSet ds = new DataSet();
DAL_SYS_Status = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BoardID", Prop_SYS_Attendance.BoardID));
return(DAL_SYS_Status.DAL_Select("PROC_Select_StaDiv", arrParameter));
}
// By Arpit
public void BAL_StudentAttedance_Insert(SYS_Attendance Prop_SYS_Attendance, string mode)
{
DAL_SYS_Status = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("CreatedBy", Prop_SYS_Attendance.EmployeeID));
arrParameter.Add(new parameter("BMSID", Prop_SYS_Attendance.BMSID));
arrParameter.Add(new parameter("DivisionID", Prop_SYS_Attendance.DivisionId));
arrParameter.Add(new parameter("AttedanceDetails", Prop_SYS_Attendance.AttedanceDetails));
arrParameter.Add(new parameter("SchoolID", Prop_SYS_Attendance.SchoolID));
DAL_SYS_Status.DAL_InsertUpdate("proc_FillAttendance", arrParameter);
}
public DataSet BAL_SYS_Attendance_TeacherWiseStudents(SYS_Attendance Prop_SYS_Attendance, String mode)
{
DAL_SYS_Status = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("DivisionID", Prop_SYS_Attendance.DivisionId));
arrParameter.Add(new parameter("SchoolID", Prop_SYS_Attendance.SchoolID));
arrParameter.Add(new parameter("BMSID", Prop_SYS_Attendance.BMSID));
arrParameter.Add(new parameter("SortBy", Prop_SYS_Attendance.SortBy));
DataSet dsselect = new DataSet();
dsselect = DAL_SYS_Status.DAL_Select("Proc_GetStudentAttendance", arrParameter);
return(dsselect);
}
public DataSet BAL_SYS_Attendance_SelectAll(SYS_Attendance Prop_SYS_Attendance, String mode)
{
DAL_SYS_Status = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("EmployeeID", Prop_SYS_Attendance.EmployeeID));
arrParameter.Add(new parameter("DivisionID", Prop_SYS_Attendance.DivisionId));
arrParameter.Add(new parameter("BMSID", Prop_SYS_Attendance.BMSID));
DataSet dsselect = new DataSet();
dsselect = DAL_SYS_Status.DAL_Select("PROC_Select_Student", arrParameter);
return(dsselect);
}
public DataSet BAL_SYS_Attendance_Details(SYS_Attendance Prop_SYS_Attendance, String mode)
{
DataSet ds = new DataSet();
DAL_SYS_Status = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", Prop_SYS_Attendance.BMSID));
arrParameter.Add(new parameter("DivisionID", Prop_SYS_Attendance.DivisionId));
arrParameter.Add(new parameter("DivisionIDstr", Prop_SYS_Attendance.DivisionIdstr));
arrParameter.Add(new parameter("StartDate", Prop_SYS_Attendance.StartDate));
arrParameter.Add(new parameter("EndDate", Prop_SYS_Attendance.EndDate));
return(DAL_SYS_Status.DAL_Select("PROC_Select_Attendance", arrParameter));
}
public DataSet BAL_SYS_GetAttendaceStudent(SYS_Attendance Prop_SYS_Attendance, String mode)
{
DataSet dsselect = new DataSet();
try
{
DAL_SYS_Status = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("CreatedBy", Prop_SYS_Attendance.EmployeeID));
arrParameter.Add(new parameter("BMSID", Prop_SYS_Attendance.BMSID));
arrParameter.Add(new parameter("DivisionID", Prop_SYS_Attendance.DivisionId));
arrParameter.Add(new parameter("AttedanceDetails", Prop_SYS_Attendance.AttedanceDetails));
arrParameter.Add(new parameter("SchoolID", Prop_SYS_Attendance.SchoolID));
dsselect = DAL_SYS_Status.DAL_Select("proc_LogAttendanceRecord", arrParameter);
}
catch (Exception ex)
{
}
return(dsselect);
}
