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; }