public DataTable GetLevel()
{
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam("[GetLevels]");
return(ds.Tables[0]);
}
public DataTable UploadData(string Date)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[UploadData]");
return(ds.Tables[0]);
}
public DataTable GetAbsentesereport(string Date)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetAbsentesereport]");
return(ds.Tables[0]);
}
public DataTable GetStaybackExceptionReport(string Date)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@CDate", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[StaybackException]");
return(ds.Tables[0]);
}
public DataTable GetNotTrackedList(string EDate)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@EDate", EDate);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetNotTrackedList]");
return(ds.Tables[0]);
}
public DataTable GetEmailId(string BatchCode)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@BatchCode", BatchCode);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetAllEmailId]");
return(ds.Tables[0]);
}
public DataTable GET_EXCEL_ABSENTEES_REPORT(string Date)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@exam_date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[sp_final_exam_abs]");
return(ds.Tables[0]);
}
public DataTable GetSubject(int EmpId)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@EmpId", EmpId);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetSubject]");
return(ds.Tables[0]);
}
public DataTable GetBusDetails(int BusId, string Date)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@BusId", BusId);
param[1] = new SqlParameter("@Date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetBusDetails]");
return(ds.Tables[0]);
}
public DataTable GetINOUTReport(int ClassId, string FromDate)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ClassSectionId", ClassId);
param[1] = new SqlParameter("@Date", FromDate);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[ClassWiseDaliyInOut]");
return(ds.Tables[0]);
}
public DataTable GetAttendance(string Subject, DateTime TodayDate)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Subject", Subject);
param[1] = new SqlParameter("@TodayDate", TodayDate);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetAttendance]");
return(ds.Tables[0]);
}
public DataTable GetUserDetails(string UserName, string Password)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@UserName", UserName);
param[1] = new SqlParameter("@Password", Password);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetUserDetails]");
return(ds.Tables[0]);
}
public DataTable GetAttendanceNotTakenList(int Wing, string Date)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Wing", Wing);
param[1] = new SqlParameter("@Date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetAttendanceNotTakenList]");
return(ds.Tables[0]);
}
public DataTable ATTENDANCE_STUDENT_FROM_CLASS_ALL_SOURCES(string vdate, int class_id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@edate1", vdate);
param[1] = new SqlParameter("@class_id", class_id);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[ATTENDANCE_STUDENT_FROM_CLASS_ALL_SOURCES]");
return(ds.Tables[0]);
}
public DataTable Sp_getStudList_CardnotSwipedWithAttendance(string vdate, int class_id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@vdate", vdate);
param[1] = new SqlParameter("@classid", class_id);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[Sp_getStudList_CardnotSwipedWithAttendance]");
return(ds.Tables[0]);
}
public DataTable SP_GET_STUDLIST_CARD_NOTSWIPED(string vdate, int class_id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@vdate", vdate);
param[1] = new SqlParameter("@classid", class_id);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[SP_GET_STUDLIST_CARD_NOTSWIPED]");
return(ds.Tables[0]);
}
public DataTable ATTENDANCE_STUDENT_FROM_CLASS_ALL_SOURCES_EXCEPTION(string edate1, int flag)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@edate1", edate1);
param[1] = new SqlParameter("@flag", flag);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[ATTENDANCE_STUDENT_FROM_CLASS_ALL_SOURCES_EXCEPTION]");
return(ds.Tables[0]);
}
public DataTable STAYBACK_ATTENDANCE_STUDENT_MATCHED_WITH_RFID_EAEP_Rport(string edate1, int class_id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@edate1", edate1);
param[1] = new SqlParameter("@class_id", class_id);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[STAYBACK_ATTENDANCE_STUDENT_MATCHED_WITH_RFID_EAEP_Rport]");
return(ds.Tables[0]);
}
public DataTable StayBackWithOutReasonVB(int Wing, string Date)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Wing", Wing);
param[1] = new SqlParameter("@Date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetStayBackWithOutReasonVB]");
return(ds.Tables[0]);
}
public DataTable GetMorningRFIDAttendanceReport(int ClassSectionId, string Date)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ClassSectionId", ClassSectionId);
param[1] = new SqlParameter("@Date", Date);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetMorningRFIDAttendanceReport]");
return(ds.Tables[0]);
}
public DataTable GetSListForPreview(string ClassId, string DivId)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ClassId", ClassId);
param[1] = new SqlParameter("@DivId", DivId);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetSListForPreview]");
return(ds.Tables[0]);
}
public DataTable LabWiseDaliyInOut(string Date, int ClassSectionId)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Date", Date);
param[1] = new SqlParameter("@ClassSectionId", ClassSectionId);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[LabWiseDaliyInOut]");
return(ds.Tables[0]);
}
public DataTable GetBatchCode(int EmpId, string Subjects)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@EmpId", EmpId);
param[1] = new SqlParameter("@Subjects", Subjects);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetBatchCode]");
return(ds.Tables[0]);
}
public DataTable GetConsolidatedAttendancePercentage(int Class, string FromDate, string ToDate)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@class_id", Class);
param[1] = new SqlParameter("@edate1", FromDate);
param[2] = new SqlParameter("@edate2", ToDate);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[SP_CONSOLIDATED_ATTENDANCE]");
return(ds.Tables[0]);
}
public DataTable GetCheckBusRFIDAttendance(string FromDate, string FTime, string ToTime)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Date", FromDate);
param[1] = new SqlParameter("@FromTime", FTime);
param[2] = new SqlParameter("@ToTime", ToTime);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetCheckBusRFIDAttendance]");
return(ds.Tables[0]);
}
public DataTable GetAllBatches(string Level, string Shift, string EmpId)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Level", Level);
param[1] = new SqlParameter("@Timming", Shift);
param[2] = new SqlParameter("@EmpId", EmpId);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetAllBatches]");
return(ds.Tables[0]);
}
public DataTable GetConsolidatedAttendance(int Class, string FromDate, string ToDate)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@class_id", Class);
param[1] = new SqlParameter("@edate1", FromDate);
param[2] = new SqlParameter("@edate2", ToDate);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[ATTENDANCE_STUDENT_FROM_CLASS_ENTRY]");
return(ds.Tables[0]);
}
public DataTable GetAfterNoonExceptionReport(string Date, string FromTime, string ToTime)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Date", Date);
param[1] = new SqlParameter("@FromTime", FromTime);
param[2] = new SqlParameter("@ToTime", ToTime);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[AfterNoonException]");
return(ds.Tables[0]);
}
public DataTable GetSinglePuches(int Flag, string Date, int ClassId)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Flag", Flag);
param[1] = new SqlParameter("@Date", Date);
param[2] = new SqlParameter("@ClassId", ClassId);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetSinglePuches]");
return(ds.Tables[0]);
}
public DataTable GetSListForFacultyUndertaking(string ClassId, string DivId, string DDate)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@ClassId", ClassId);
param[1] = new SqlParameter("@DivId", DivId);
param[2] = new SqlParameter("@Date", DDate);
AttendanceDataAcessLayer da = new AttendanceDataAcessLayer();
DataSet ds = da.getDataByParam(param, "[GetSListForFacultyDetails_UnterTaking]");
return(ds.Tables[0]);
}
