public ActionResult Delete(int id, SubjectTB subject) { try { using (DBmodel DBmodel = new DBmodel()) { subject model_subject = DBmodel.subjects.Find(id); teacher_grade model_grade = DBmodel.teacher_grade.Find(id); teacher_subject model_teacher = DBmodel.teacher_subject.Find(id); SubjectDetail subDetail = new SubjectDetail(); subject = DBmodel.SubjectTBs.Where(x => x.SubjectCode == id).FirstOrDefault(); if (DBmodel.SubjectDetails.Any(x => x.SubjectID == id)) { subDetail = DBmodel.SubjectDetails.Where(x => x.SubjectID == id).FirstOrDefault(); DBmodel.SubjectDetails.Remove(subDetail); } DBmodel.SubjectTBs.Remove(subject); DBmodel.SaveChanges(); string grade = model_grade.grade; int grade2 = model_grade.grade_id; int grade3 = model_grade.subjectCode; int grade4 = model_grade.teacher_id; DBmodel.teacher_grade.Remove(model_grade); // DBmodel.subjects.Remove(model_subject); // DBmodel.teacher_subject.Remove(model_teacher); DBmodel.SaveChanges(); } return(RedirectToAction("SubjectList")); } catch { return(View()); } }
public ActionResult Create(SubjectDetailsViewModel viewModel) { using (DBmodel DBmodel = new DBmodel()) { ViewBag.IsError = false; try { if (ModelState.IsValid) { SubjectTB model = new SubjectTB(); subject model_subject = new subject(); teacher_grade model_grade = new teacher_grade(); teacher_subject model_teacher = new teacher_subject(); model.Grade = viewModel.Subject.Grade; model.SubjectName = viewModel.Subject.SubjectName; model.Teacher = viewModel.Subject.Teacher; if (!DBmodel.SubjectTBs.Any(x => x.Teacher == viewModel.Subject.Teacher && x.Grade == viewModel.Subject.Grade && x.SubjectName == viewModel.Subject.SubjectName)) { DBmodel.SubjectTBs.Add(model); DBmodel.SaveChanges(); List <SubjectTB> list = DBmodel.SubjectTBs.ToList(); SubjectTB index = list.Last(); model_subject.subject_id = index.SubjectCode; model_subject.subject1 = index.SubjectName; model_grade.grade = index.Grade; model_grade.teacher_id = index.Teacher; model_grade.grade_id = DBmodel.GradeLists.Find(index.Grade).ID; model_grade.subjectCode = index.SubjectCode; model_teacher.subject_id = index.SubjectCode; model_teacher.teacher_id = index.Teacher; DBmodel.subjects.Add(model_subject); DBmodel.teacher_grade.Add(model_grade); DBmodel.teacher_subject.Add(model_teacher); DBmodel.SaveChanges(); return(RedirectToAction("SubjectList")); } else { ViewBag.DuplicateMessage = "Subject Details already exist."; ViewBag.IsError = true; } } } catch { } viewModel.Teachers = DBmodel.TeacherLists.ToList <TeacherList>(); viewModel.Grades = DBmodel.GradeLists.ToList <GradeList>(); } return(View(viewModel)); }