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