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