public DataView GetWaitingList(int nClassInstanceID)
{
TblClassAttendance classAttendance = new TblClassAttendance();
DataTable table = classAttendance.GetClassAttendancesBaseClassInstanceID(nClassInstanceID);
table.DefaultView.RowFilter = "nStatusID = 1 or nStatusID = 2 or nStatusID = 4 or nStatusID is null";
return table.DefaultView;
}
public DataTable GetClassAttendanceReservedAndAttended(int nClassInstanceID)
{
TblClassAttendance classAttendance = new TblClassAttendance();
DataTable table = classAttendance.GetClassAttendancesBaseClassInstanceID(nClassInstanceID);
table.DefaultView.RowFilter = "(nStatusID = 0 or nStatusID = 1) and fMobileBooking=1";
return table.DefaultView.ToTable();
}
public DataView GetClassAttendanceView(int nClassInstanceID)
{
TblClassAttendance classAttendance = new TblClassAttendance();
DataTable table = classAttendance.GetClassAttendancesBaseClassInstanceID(nClassInstanceID);
table.DefaultView.RowFilter = "nStatusID = 1";
return table.DefaultView;
}
public DataTable GetClassAttendance(int nClassInstanceID)
{
TblClassAttendance classAttendance = new TblClassAttendance();
DataTable table = classAttendance.GetClassAttendancesBaseClassInstanceID(nClassInstanceID);
return table;
}