public Boolean addingExamClassDetails(examclass_details exmclass) { List <examclass_details> exlist = new List <examclass_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { exlist = dc.examclass_details.OrderBy(a => a.examclass_class).ToList(); int cc = exlist.Count; for (int i = 0; i < cc; i++) { examClass = exlist[i].examclass_class; examSection = exlist[i].examclass_section; examType = exlist[i].examclass_exam_type; sclId = exlist[i].school_id; if (exmclass.examclass_class.Equals(examClass) && exmclass.school_id.Equals(sclId) && exmclass.examclass_section.Equals(examSection) && exmclass.examclass_exam_type.Equals(examType)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean updateExamClassDetails(examclass_details edetails) { List <examclass_details> tlist = new List <examclass_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.examclass_details.OrderBy(a => a.examclass_class).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { examClass = tlist[i].examclass_class; examSection = tlist[i].examclass_section; sclId = tlist[i].school_id; int examclass_id = tlist[i].examclass_id; if (edetails.school_id.Equals(sclId) && edetails.examclass_id.Equals(examclass_id)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { examclass_details updatedCustomer = (from c in entities.examclass_details join p in entities.school_details on edetails.school_id equals p.school_id where c.school_id == edetails.school_id where c.examclass_id == edetails.examclass_id select c).FirstOrDefault(); updatedCustomer.examclass_exam_type = edetails.examclass_exam_type; updatedCustomer.examclass_start_date = edetails.examclass_start_date; updatedCustomer.examclass_end_date = edetails.examclass_end_date; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean deleteClass(examclass_details edetails) { List <examclass_details> tlist = new List <examclass_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.examclass_details.OrderBy(a => a.examclass_class).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { examClass = tlist[i].examclass_class; examSection = tlist[i].examclass_section; sclId = tlist[i].school_id; int exmClsId = tlist[i].examclass_id; if (edetails.school_id.Equals(sclId) && edetails.examclass_id.Equals(exmClsId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { examclass_details custom = (from c in entities.examclass_details where c.examclass_id == edetails.examclass_id where c.school_id == edetails.school_id select c).FirstOrDefault(); entities.examclass_details.Remove(custom); entities.SaveChanges(); } return(true); } else { return(false); } }