public void updateMiscFromClassExam(int classId, int examId, Collection <MiscEntryCL> miscCol)
{
foreach (MiscEntryCL item in miscCol)
{
MiscEntry queryMiscDB = (from x in dbcontext.MiscEntries where x.ExaminationId == examId && x.StudentId == item.studentId && x.IsDeleted == false select x).FirstOrDefault();
if (queryMiscDB == null)
{
dbcontext.MiscEntries.Add(new MiscEntry()
{
DateCreated = DateTime.Now,
DateModified = DateTime.Now,
ExaminationId = examId,
IsDeleted = false,
Attendance = item.attendance,
Remarks = item.remarks,
SessionId = item.sessionId,
StudentId = item.studentId,
ClassSubjectId = 0,
});
}
else
{
queryMiscDB.DateModified = DateTime.Now;
queryMiscDB.Attendance = item.attendance;
queryMiscDB.Remarks = item.remarks;
}
dbcontext.SaveChanges();
}
}
public MiscEntryCL viewMiscByStudentId(int studentId, int examId)
{
MiscEntryCL miscEntry = new MiscEntryCL();
MiscEntry queryMiscDB = (from x in dbcontext.MiscEntries where x.ExaminationId == examId && x.StudentId == studentId && x.IsDeleted == false select x).FirstOrDefault();
if (queryMiscDB == null)
{
miscEntry.attendance = string.Empty;
miscEntry.remarks = string.Empty;
}
else
{
miscEntry.attendance = queryMiscDB.Attendance;
miscEntry.remarks = queryMiscDB.Remarks;
}
return(miscEntry);
}