public async Task <ActionResult <IEnumerable <Attendance> > > Get(int studentID, int attendanceStateID, DateTime startDate, DateTime endDate)
{
// Call GetAttendanceBLL method with all the parameters
object BLLResponse = new AttendanceBLL(_context).GetAttendanceBLL(studentID: studentID, attendanceStateID: attendanceStateID, startDate: startDate, endDate: endDate, userClaims: User);
// Get the base class for the response
// Ref: https://docs.microsoft.com/en-us/dotnet/api/system.type.basetype?view=netcore-3.1
if (BLLResponse.GetType().BaseType == typeof(Exception))
{
// Create log entries for Debug log
((APIException)BLLResponse).Exceptions.ForEach(ex => Logger.Msg <AttendancesController>((Exception)ex, Serilog.Events.LogEventLevel.Debug));
// Return response from API
return(BadRequest(new { errors = ((APIException)BLLResponse).Exceptions.Select(x => x.Message).ToArray() }));
}
else
{
try
{
// Create a dictionary to interpret response
Dictionary <string, object> BLLResponseDic = (Dictionary <string, object>)(BLLResponse);
// Apply all the criteria with supplied or default values from BLL
IQueryable <Attendance> dbRequest = _context.AttendanceRecords
.Where(x => x.Date >= (DateTime)BLLResponseDic["StartDate"] && x.Date <= (DateTime)BLLResponseDic["EndDate"])
.Where(x => x.StudentID == (int)BLLResponseDic["StudentID"]);
// If specific type of attendance is sought (AttendanceStateID != 0) then apply criteria else return all
if ((int)BLLResponseDic["AttendanceStateID"] != 0)
{
dbRequest = dbRequest.Where(x => x.AttendanceStateID == (int)BLLResponseDic["AttendanceStateID"]);
}
List <Attendance> dbResponse = await dbRequest.ToListAsync();
// Convert result to AttendanceDTO
List <AttendanceDTO> response = new List <AttendanceDTO>();
dbResponse.ForEach(x => response.Add(new AttendanceDTO(x)));
Logger.Msg <AttendancesController>($"[{User.FindFirstValue("email")}] [GET]", Serilog.Events.LogEventLevel.Debug);
return(Ok(response));
}
catch (Exception ex)
{
// Local log entry. Database reconciliation issues are more serious so reported as Error
Logger.Msg <AttendancesController>($"[GET] Database sync error {ex.Message}", Serilog.Events.LogEventLevel.Error);
// Return response to client
return(StatusCode(500, new { errors = "Database update failed. Contact the administrator to resolve this issue." }));
}
}
} // End of Get
public async Task <ActionResult> ModifyAttendance([FromBody] AttendanceModDTO attendance)
{
if (AttendanceExists(attendance.RecordID))
{
// Call BLL method to run validation
object BLLResponse = new AttendanceBLL(_context).ModifyAttendanceBLL(attendance: attendance, userClaims: User);
if (BLLResponse.GetType().BaseType == typeof(Exception))
{
// Create log entries for Debug log
((APIException)BLLResponse).Exceptions.ForEach(ex => Logger.Msg <AttendancesController>((Exception)ex, Serilog.Events.LogEventLevel.Debug));
// Return response from API
return(BadRequest(new { errors = ((APIException)BLLResponse).Exceptions.Select(x => x.Message).ToArray() }));
}
else
{
try
{
// Cast the response to the correct type
AttendanceModDTO modAttendanceRecord = (AttendanceModDTO)BLLResponse;
// Modify the Attendance Record
Attendance attendanceRecord = _context.AttendanceRecords.Where(x => x.RecordID == modAttendanceRecord.RecordID).First();
attendanceRecord.AttendanceStateID = attendance.AttendanceStateID;
attendanceRecord.Comment = attendance.Comment;
// Save changes
await _context.SaveChangesAsync();
Logger.Msg <AttendancesController>($"[{User.FindFirstValue("email")}] [MODIFY] attendance RecordID '{attendanceRecord.RecordID}' updated", Serilog.Events.LogEventLevel.Information);
AttendanceDTO response = new AttendanceDTO(attendanceRecord);
return(Ok(response));
}
catch (Exception ex)
{
// Local log entry. Database reconciliation issues are more serious so reported as Error
Logger.Msg <AttendancesController>($"[MODIFY] Database sync error {ex.Message}", Serilog.Events.LogEventLevel.Error);
// Return response to client
return(StatusCode(500, new { errors = "Database update failed. Contact the administrator to resolve this issue." }));
}
}
}
else
{
return(NotFound());
}
} // End of ModifyAttendance
public async Task <ActionResult> AddAttendance([FromBody] AttendanceDTO attendance)
{
// Call BLL method to run validation
object BLLResponse = new AttendanceBLL(_context).AddAttendanceBLL(attendance: attendance, userClaims: User);
if (BLLResponse.GetType().BaseType == typeof(Exception))
{
// Create log entries for Debug log
((APIException)BLLResponse).Exceptions.ForEach(ex => Logger.Msg <AttendancesController>((Exception)ex, Serilog.Events.LogEventLevel.Debug));
// Return response from API
return(BadRequest(new { errors = ((APIException)BLLResponse).Exceptions.Select(x => x.Message).ToArray() }));
}
else
{
try
{
Attendance newAttendanceRecord = new Attendance
{
StudentID = attendance.StudentID,
StaffID = attendance.StaffID,
AttendanceStateID = attendance.AttendanceStateID,
Date = attendance.Date,
Comment = attendance.Comment
};
_context.AttendanceRecords.Add(newAttendanceRecord);
// Save changes
await _context.SaveChangesAsync();
Logger.Msg <AttendancesController>($"[{User.FindFirstValue("email")}] [ADD] attendance for StudentID '{newAttendanceRecord.StudentID}' recorded", Serilog.Events.LogEventLevel.Information);
AttendanceDTO response = new AttendanceDTO(newAttendanceRecord);
return(Ok(response));
}
catch (Exception ex)
{
// Local log entry. Database reconciliation issues are more serious so reported as Error
Logger.Msg <AttendancesController>($"[MODIFY] Database sync error {ex.Message}", Serilog.Events.LogEventLevel.Error);
// Return response to client
return(StatusCode(500, new { errors = "Database update failed. Contact the administrator to resolve this issue." }));
}
}
} // End of AddAttendance