public bool DeletePPEExamBlank(PPEExamBlank exam_blanks) { return(TryFunc <bool>(() => { bool res = false; using (EGESupportEntities context = new EGESupportEntities()) { IEnumerable <journals> jours = context.journals.Where(x => x.ppe_exam_id == exam_blanks.ppe_exam_id && x.auditorium == exam_blanks.aud); context.journals.RemoveRange(jours); context.SaveChanges(); res = true; } return res; })); }
public int InsertPPEExamBlank(PPEExamBlank exam_blanks) { return(TryFunc <int>(() => { int aud = exam_blanks.aud; using (EGESupportEntities context = new EGESupportEntities()) { if (exam_blanks.count_r > 0) { context.journals.Add(new journals() { ppe_exam_id = exam_blanks.ppe_exam_id, blank_type_id = 1, auditorium = exam_blanks.aud, count_blanks = exam_blanks.count_r, count_add_blanks = 0 }); } if (exam_blanks.count_1 > 0) { context.journals.Add(new journals() { ppe_exam_id = exam_blanks.ppe_exam_id, blank_type_id = 2, auditorium = exam_blanks.aud, count_blanks = exam_blanks.count_1, count_add_blanks = 0 }); } if (exam_blanks.count_2 > 0) { context.journals.Add(new journals() { ppe_exam_id = exam_blanks.ppe_exam_id, blank_type_id = 3, auditorium = exam_blanks.aud, count_blanks = exam_blanks.count_2, count_add_blanks = exam_blanks.count_add_2 }); } context.SaveChanges(); } return aud; })); }
public void UpdatePPEExamBlank(PPEExamBlank exam_blanks, int old_aud) { TryFunc <bool>(() => { bool res = false; using (EGESupportEntities context = new EGESupportEntities()) { IEnumerable <journals> jours = (from j in context.journals where j.ppe_exam_id == exam_blanks.ppe_exam_id && j.auditorium == old_aud select j); journals jour = jours.Where(x => x.blank_type_id == 1).SingleOrDefault(); if (exam_blanks.count_r > 0) { if (jour != null) { jour.auditorium = exam_blanks.aud; jour.count_blanks = exam_blanks.count_r; } else { context.journals.Add(new journals() { ppe_exam_id = exam_blanks.ppe_exam_id, blank_type_id = 1, auditorium = exam_blanks.aud, count_blanks = exam_blanks.count_r, count_add_blanks = 0 }); } } else { if (jour != null) { context.journals.Remove(jour); } } jour = jours.Where(x => x.blank_type_id == 2).SingleOrDefault(); if (exam_blanks.count_1 > 0) { if (jour != null) { jour.auditorium = exam_blanks.aud; jour.count_blanks = exam_blanks.count_1; } else { context.journals.Add(new journals() { ppe_exam_id = exam_blanks.ppe_exam_id, blank_type_id = 2, auditorium = exam_blanks.aud, count_blanks = exam_blanks.count_1, count_add_blanks = 0 }); } } else { if (jour != null) { context.journals.Remove(jour); } } jour = jours.Where(x => x.blank_type_id == 3).SingleOrDefault(); if (exam_blanks.count_2 > 0) { if (jour != null) { jour.auditorium = exam_blanks.aud; jour.count_blanks = exam_blanks.count_2; jour.count_add_blanks = exam_blanks.count_add_2; } else { context.journals.Add(new journals() { ppe_exam_id = exam_blanks.ppe_exam_id, blank_type_id = 3, auditorium = exam_blanks.aud, count_blanks = exam_blanks.count_2, count_add_blanks = exam_blanks.count_add_2 }); } } else { if (jour != null) { context.journals.Remove(jour); } } context.SaveChanges(); res = true; } return(res); }); }