public Boolean addSubjectDetails(subject_details adding) { List <subject_details> slist = new List <subject_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { slist = dc.subject_details.OrderBy(a => a.subject_type).ToList(); int cc = slist.Count; for (int i = 0; i < cc; i++) { subjType = slist[i].subject_type; subjName = slist[i].subject_name; if (adding.subject_type.Equals(subjType) && adding.subject_name.Equals(subjName)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean guestSignUp(guest_signup gsignUp) { List <guest_signup> g = new List <guest_signup>(); using (EdujinniEntity entitu = new EdujinniEntity()) { g = entitu.guest_signup.OrderBy(a => a.first_name).ToList(); int cc = g.Count; for (int i = 0; i < cc; i++) { mobileNumber = g[i].mobile_no; if (gsignUp.mobile_no.Equals(mobileNumber)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingStudentDetails(student_details sdetails) { List <student_details> slist = new List <student_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { slist = dc.student_details.OrderBy(a => a.student_first_name).ToList(); int cc = slist.Count; for (int i = 0; i < cc; i++) { studentSection = slist[i].student_section; stdntRollnum = slist[i].student_roll_no; sclId = slist[i].school_id; if (sdetails.student_section.Equals(studentSection) && sdetails.school_id.Equals(sclId) && sdetails.student_roll_no.Equals(stdntRollnum)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingEventsDetails(event_details events) { List <event_details> elist = new List <event_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { elist = dc.event_details.OrderBy(a => a.event_name).ToList(); int cc = elist.Count; for (int i = 0; i < cc; i++) { eventName = elist[i].event_name; if (events.event_name.Equals(eventName)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingDairyData(dairy_details adding) { List <dairy_details> dlist = new List <dairy_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { dlist = dc.dairy_details.OrderBy(a => a.dairy_date).ToList(); int cc = dlist.Count; for (int i = 0; i < cc; i++) { issuedate = dlist[i].dairy_date; subject = dlist[i].dairy_subject; if (adding.dairy_date.Equals(issuedate) && adding.dairy_subject.Equals(subject)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingAchievemnts(Achievement_details adding) { List <Achievement_details> list = new List <Achievement_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList(); int cc = list.Count; for (int i = 0; i < cc; i++) { mnumber = list[i].achievement_type; studentId = list[i].student_id; sclId = list[i].school_id; if (adding.achievement_type.Equals(mnumber) && adding.student_id.Equals(studentId) && adding.school_id.Equals(sclId)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingSyllabus(syllabus_details adding) { List <syllabus_details> slist = new List <syllabus_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { slist = dc.syllabus_details.OrderBy(a => a.syllabus_subject).ToList(); int cc = slist.Count; for (int i = 0; i < cc; i++) { cls = slist[i].syllabus_class; subject = slist[i].syllabus_subject; unit = slist[i].syllabus_unit; topic = slist[i].syllabus_topic; if (adding.syllabus_class.Equals(cls) && adding.syllabus_subject.Equals(subject) && adding.syllabus_unit.Equals(unit) && adding.syllabus_topic.Equals(topic)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingTimeTable(timetable_details adding) { List <timetable_details> tlist = new List <timetable_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.timetable_details.OrderBy(a => a.timetable_day).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { day = tlist[i].timetable_day; sclId = tlist[i].school_id; if (adding.timetable_day.Equals(day) && adding.school_id.Equals(sclId)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
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 AddSection(Section sec) { List <Section> secList = new List <Section>(); using (EdujinniEntity entitu = new EdujinniEntity()) { secList = entitu.Sections.OrderBy(a => a.section_name).ToList(); for (int m = 0; m < secList.Count; m++) { secName = secList[m].section_name; if (sec.section_name.Equals(secName)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingSchool(school_details sdetails) { List <school_details> cdetails = new List <school_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { cdetails = dc.school_details.OrderBy(a => a.school_name).ToList(); int cc = cdetails.Count; for (int i = 0; i < cc; i++) { mnumber = Convert.ToInt64(cdetails[i].admin_mobile_no); email = cdetails[i].admin_email; if (sdetails.admin_mobile_no.Equals(mnumber) && sdetails.admin_email.Equals(email)) { // scl_id = cdetails[i].school_id; count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingAssignDetails(assignment_details details) { List <assignment_details> tlist = new List <assignment_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.assignment_details.OrderBy(a => a.assignment_from_date).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { fromDate = tlist[i].assignment_from_date; topicName = tlist[i].assignment_enter_topic; if (details.assignment_from_date.Equals(fromDate) && details.assignment_enter_topic.Equals(topicName)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingTeacher(teacher_details adding) { List <teacher_details> tdetails = new List <teacher_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tdetails = dc.teacher_details.OrderBy(a => a.teacher_first_name).ToList(); int cc = tdetails.Count; for (int i = 0; i < cc; i++) { tEmail = tdetails[i].teacher_email; tMobile = tdetails[i].teacher_phone_no; ttId = tdetails[i].teacher_teacherid; if (adding.teacher_email.Equals(tEmail) && adding.teacher_phone_no.Equals(tMobile) && adding.teacher_teacherid.Equals(ttId)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addLeaveRequest(leaverequest leave) { List <leaverequest> ll = new List <leaverequest>(); using (EdujinniEntity enty = new EdujinniEntity()) { ll = enty.leaverequests.OrderBy(a => a.insert_date).ToList(); for (int s = 0; s < ll.Count; s++) { d1 = ll[s].leaverequest_from_date; if (d1 == leave.leaverequest_from_date) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingClassDetails(class_details classDetails) { List <class_details> cdetails = new List <class_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { cdetails = dc.class_details.OrderBy(a => a.class_name).ToList(); int cc = cdetails.Count; for (int i = 0; i < cc; i++) { className = cdetails[i].class_name; classSection = cdetails[i].class_section_name; sclId = Convert.ToInt32(cdetails[i].school_id); if (classDetails.class_name.Equals(className) && classDetails.class_section_name.Equals(classSection) && classDetails.school_id.Equals(sclId)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingAteendance(attendence_details adding) { List <attendence_details> alist = new List <attendence_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { alist = dc.attendence_details.OrderBy(a => a.attendence_roll_no).ToList(); for (int i = 0; i < alist.Count; i++) { classId = alist[i].class_id; sclId = alist[i].school_id; studentId = alist[i].student_id; attenSection = alist[i].attendence_section; rollnumber = alist[i].attendence_roll_no; if (adding.class_id.Equals(classId) && adding.school_id.Equals(sclId) && adding.student_id.Equals(studentId) && adding.attendence_section.Equals(attenSection) && adding.attendence_roll_no.Equals(rollnumber)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean addingExamResults(exam_results eresults) { List <exam_results> erlist = new List <exam_results>(); using (EdujinniEntity dc = new EdujinniEntity()) { erlist = dc.exam_results.OrderBy(a => a.exam_id).ToList(); int cc = erlist.Count; for (int i = 0; i < cc; i++) { examId = erlist[i].exam_id; studentId = erlist[i].student_id; subject = erlist[i].examresult_subjects; if (eresults.exam_id.Equals(examId) && eresults.student_id.Equals(studentId) && eresults.examresult_subjects.Equals(subject)) { count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean updateExamSubjectsList(examsubject_details eupdate) { List <examsubject_details> tlist = new List <examsubject_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.examsubject_details.OrderBy(a => a.examsubject_class).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { examClass = tlist[i].examsubject_class; section = tlist[i].examsubject_section; subName = tlist[i].examsubject_subject_name; sclId = tlist[i].school_id; int examSubId = tlist[i].examsubject_id; if (eupdate.school_id.Equals(sclId) && eupdate.examsubject_id.Equals(examSubId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { examsubject_details updatedCustomer = (from c in entities.examsubject_details join p in entities.school_details on eupdate.school_id equals p.school_id where c.school_id == eupdate.school_id where c.examsubject_id == eupdate.examsubject_id select c).FirstOrDefault(); updatedCustomer.examsubject_class = eupdate.examsubject_class; updatedCustomer.examsubject_subject_type = eupdate.examsubject_subject_type; updatedCustomer.examsubject_marks = eupdate.examsubject_marks; updatedCustomer.examsubject_date = eupdate.examsubject_date; updatedCustomer.exam_id = eupdate.exam_id; updatedCustomer.examclass_id = eupdate.examclass_id; updatedCustomer.examsubject_syllabus = eupdate.examsubject_syllabus; updatedCustomer.examsubject_start_time = eupdate.examsubject_start_time; updatedCustomer.examsubject_end_time = eupdate.examsubject_end_time; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateAchievements(Achievement_details adetails) { List <Achievement_details> list = new List <Achievement_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList(); int cc = list.Count; for (int i = 0; i < cc; i++) { int achId = list[i].achievement_id; int sclId = list[i].school_id; //mnumber = list[i].achievement_type; //studentId = list[i].student_id; if (adetails.school_id.Equals(sclId) && adetails.achievement_id.Equals(achId)) { count = 1; break; } else { count = 0; } } } if (count == 1) { using (EdujinniEntity entities = new EdujinniEntity()) { Achievement_details updatedCustomer = (from c in entities.Achievement_details where c.achievement_id == adetails.achievement_id where c.school_id == adetails.school_id select c).FirstOrDefault(); updatedCustomer.class_id = adetails.class_id; updatedCustomer.section_id = adetails.section_id; updatedCustomer.student_id = adetails.student_id; updatedCustomer.achievement_student_name = adetails.achievement_student_name; updatedCustomer.achievement_description = adetails.achievement_description; updatedCustomer.achievement_date = adetails.achievement_date; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateExamResults(exam_results update) { List <exam_results> tlist = new List <exam_results>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.exam_results.OrderBy(a => a.examresult_subjects).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { examId = tlist[i].exam_id; studentId = tlist[i].student_id; subject = tlist[i].examresult_subjects; if (update.exam_id.Equals(examId) && update.student_id.Equals(studentId) && update.examresult_subjects.Equals(subject)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { exam_results updatedCustomer = (from c in entities.exam_results join p in entities.exam_details on update.exam_id equals p.exam_id where c.teacher_id == update.teacher_id where c.exam_id == update.exam_id where c.student_id == update.student_id select c).FirstOrDefault(); updatedCustomer.examresult_marks = update.examresult_marks; updatedCustomer.examresult_total_marks = update.examresult_total_marks; updatedCustomer.examresult_subjects = update.examresult_subjects; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateTimeTable(timetable_details update) { List <timetable_details> tlist = new List <timetable_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.timetable_details.OrderBy(a => a.timetable_day).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { day = tlist[i].timetable_day; sclId = tlist[i].school_id; subid = tlist[i].subject_id; clsid = tlist[i].class_id; teacid = tlist[i].teacher_id; int tmtId = tlist[i].timetable_id; if (update.school_id.Equals(sclId) && update.timetable_id.Equals(tmtId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { timetable_details updatedCustomer = (from c in entities.timetable_details join p in entities.school_details on update.school_id equals p.school_id where c.school_id == update.school_id where c.timetable_id == update.timetable_id select c).FirstOrDefault(); updatedCustomer.teacher_id = update.teacher_id; updatedCustomer.timetable_start_time = update.timetable_start_time; updatedCustomer.timetable_end_time = update.timetable_end_time; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean UpdateEvents(event_details events) { List <event_details> evList = new List <event_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { evList = dc.event_details.OrderBy(a => a.event_name).ToList(); int cc = evList.Count; for (int i = 0; i < cc; i++) { eventName = evList[i].event_name; sclId = evList[i].school_id; int evtId = evList[i].event_id; if (events.school_id.Equals(sclId) && events.event_id.Equals(evtId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { event_details updatedCustomer = (from c in entities.event_details where c.school_id == events.school_id where c.event_id == events.event_id select c).FirstOrDefault(); updatedCustomer.event_description = events.event_description; updatedCustomer.event_image = events.event_image; updatedCustomer.event_date = events.event_date; updatedCustomer.event_name = events.event_name; updatedCustomer.section_id = events.section_id; updatedCustomer.class_id = events.class_id; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateAttendence(attendence_details update) { List <attendence_details> alist = new List <attendence_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { alist = dc.attendence_details.OrderBy(a => a.attendence_roll_no).ToList(); for (int i = 0; i < alist.Count; i++) { classId = alist[i].class_id; sclId = alist[i].school_id; studentId = alist[i].student_id; attenSection = alist[i].attendence_section; rollnumber = alist[i].attendence_roll_no; if (update.class_id.Equals(classId) && update.school_id.Equals(sclId) && update.student_id.Equals(studentId) && update.attendence_section.Equals(attenSection) && update.attendence_roll_no.Equals(rollnumber)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { attendence_details updatedCustomer = (from c in entities.attendence_details join p in entities.school_details on update.school_id equals p.school_id where c.class_id == update.class_id where c.school_id == update.school_id where c.student_id == update.student_id where c.attendence_roll_no == update.attendence_roll_no select c).FirstOrDefault(); updatedCustomer.attendence_status = update.attendence_status; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean deleteStudent(student_details sdel) { List <student_details> slist = new List <student_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { slist = dc.student_details.OrderBy(a => a.student_first_name).ToList(); int cc = slist.Count; for (int i = 0; i < cc; i++) { studentSection = slist[i].student_section; stdntRollnum = slist[i].student_roll_no; sclId = slist[i].school_id; studentId = slist[i].student_id; if (sdel.student_id.Equals(studentId) && sdel.school_id.Equals(sclId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { student_details customer = (from c in entities.student_details where c.school_id == sdel.school_id where c.student_id == sdel.student_id select c).FirstOrDefault(); customer.Student_status = "In-Active"; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateExamClassDetails(exam_details edetails) { List <exam_details> tlist = new List <exam_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.exam_details.OrderBy(a => a.exam_type).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { examClass = tlist[i].exam_type; sclId = tlist[i].school_id; exmId = tlist[i].exam_id; if (edetails.school_id.Equals(sclId) && edetails.exam_id.Equals(exmId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { exam_details updatedCustomer = (from c in entities.exam_details join p in entities.school_details on edetails.school_id equals p.school_id where c.exam_id == edetails.exam_id where c.school_id == edetails.school_id select c).FirstOrDefault(); updatedCustomer.exam_start_date = edetails.exam_start_date; updatedCustomer.exam_end_date = edetails.exam_end_date; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateExamSubjectsList(school_details eupdate) { List <school_details> tlist = new List <school_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.school_details.OrderBy(a => a.school_name).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { mnumber = Convert.ToInt64(tlist[i].admin_mobile_no); email = tlist[i].admin_email; // mnumber = tlist[i].school_phone_no; if (eupdate.admin_mobile_no.Equals(mnumber)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { school_details updatedCustomer = (from c in entities.school_details //join p in entities.school_details on eupdate.school_id equals p.school_id where c.admin_mobile_no == eupdate.admin_mobile_no select c).FirstOrDefault(); updatedCustomer.password = eupdate.password; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateSyllabus(syllabus_details update) { List <syllabus_details> ulist = new List <syllabus_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { ulist = dc.syllabus_details.OrderBy(a => a.syllabus_class).ToList(); int cc = ulist.Count; for (int i = 0; i < cc; i++) { cls = ulist[i].syllabus_class; subject = ulist[i].syllabus_subject; schoolid = ulist[i].school_id; if (update.syllabus_class.Equals(cls) && update.syllabus_subject.Equals(subject) && update.school_id.Equals(schoolid)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { syllabus_details updatedCustomer = (from c in entities.syllabus_details join p in entities.school_details on update.school_id equals p.school_id where c.syllabus_class == update.syllabus_class select c).FirstOrDefault(); updatedCustomer.syllabus_topic = update.syllabus_topic; updatedCustomer.syllabus_subunit = update.syllabus_subunit; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean deleteExams(examsubject_details edel) { List <examsubject_details> tlist = new List <examsubject_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.examsubject_details.OrderBy(a => a.examsubject_class).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { examClass = tlist[i].examsubject_class; section = tlist[i].examsubject_section; subName = tlist[i].examsubject_subject_name; sclId = tlist[i].school_id; int examSubId = tlist[i].examsubject_id; if (edel.school_id.Equals(sclId) && edel.examsubject_id.Equals(examSubId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { examsubject_details custom = (from c in entities.examsubject_details where c.examsubject_id == edel.examsubject_id where c.school_id == edel.school_id select c).FirstOrDefault(); entities.examsubject_details.Remove(custom); entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean updateClasses(class_details cdeta) { List <class_details> secList = new List <class_details>(); using (EdujinniEntity entitu = new EdujinniEntity()) { secList = entitu.class_details.OrderBy(a => a.class_name).ToList(); for (int m = 0; m < secList.Count; m++) { className = secList[m].class_name; sclId = Convert.ToInt32(secList[m].school_id); //classSection = secList[m].class_section_name; int clsId = secList[m].class_id; if (cdeta.class_id.Equals(clsId) && cdeta.school_id.Equals(sclId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { class_details custom = (from c in entities.class_details where c.class_id == cdeta.class_id where c.school_id == cdeta.school_id select c).FirstOrDefault(); custom.class_name = cdeta.class_name; custom.class_section_name = cdeta.class_section_name; custom.section_id = cdeta.section_id; custom.teacher_id = cdeta.teacher_id; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean deleteTeacher(teacher_details tdata) { List <teacher_details> tlist = new List <teacher_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.teacher_details.OrderBy(a => a.teacher_first_name).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { tEmail = tlist[i].teacher_email; tMobile = tlist[i].teacher_phone_no; int scl_id = tlist[i].school_id; tId = tlist[i].teacher_id; if (tdata.school_id.Equals(scl_id) && tdata.teacher_id.Equals(tId)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { teacher_details updatedCustomer = (from c in entities.teacher_details where c.school_id == tdata.school_id where c.teacher_id == tdata.teacher_id select c).FirstOrDefault(); updatedCustomer.update_date = DateTime.Now; updatedCustomer.teacher_status = "In-Active"; entities.SaveChanges(); } return(true); } else { return(false); } }