/// <summary>
/// Method creates an pupilAttendance record for the selected pupil
/// </summary>
/// <param name="pupilId"></param>
/// <param name="attendanceDate"></param>
/// <returns>
/// int signifying success (1) or failure (0) of operation
/// </returns>
public int CreatePupilAttendane(int pupilId, DateTime attendanceDate)
{
/* Need to check the database to see if an attendance exists for the selected date and is associated to the pupil's class
* Get the id of the attendance if it exists and create the pupilAttendance
* If no attendance exists for the date and class selected we need to create one for that date and then create the pupilAttendance
*/
Pupil selectedPupil = GetPupilDetails(pupilId);
int attendanceCreated = 0;
if (smaDB.Attendances.Any(a => DbFunctions.TruncateTime(a.AttendanceDate) == DbFunctions.TruncateTime(attendanceDate) && a.ClassId == selectedPupil.ClassId))
{
// An attendance exists for the date and class
var attendance = smaDB.Attendances.Where(a => DbFunctions.TruncateTime(a.AttendanceDate) == DbFunctions.TruncateTime(attendanceDate) && a.ClassId == selectedPupil.ClassId).FirstOrDefault();
smaDB.PupilAttendances.Add(new PupilAttendance
{
AttendanceId = attendance.AttendanceId,
PupilId = pupilId
});
attendanceCreated = smaDB.SaveChanges();
}
else
{
// No attendance exists for the date and class
smaDB.Attendances.Add(new Attendance
{
AttendanceDate = attendanceDate,
ClassId = selectedPupil.ClassId
});
smaDB.SaveChanges();
// Create the pupilAttendance for the selected date
var attendance = smaDB.Attendances.Where(a => DbFunctions.TruncateTime(a.AttendanceDate) == DbFunctions.TruncateTime(attendanceDate) && a.ClassId == selectedPupil.ClassId).FirstOrDefault();
smaDB.PupilAttendances.Add(new PupilAttendance
{
AttendanceId = attendance.AttendanceId,
PupilId = pupilId
});
attendanceCreated = smaDB.SaveChanges();
}
return(attendanceCreated);
}