public ActionResult DeleteTimetable(int id, FormCollection collection) { Project.Models.Timetable timetable = new Project.Models.Timetable(); try { using (DBmodel tution = new DBmodel()) { timetable = tution.Timetables.Where(x => x.classId == id).FirstOrDefault(); //var subje = tution.SubjectTBs.Where(m => m.SubjectName == timetable.Subject).Select(u => new { sub = u.SubjectCode }).Single(); //SubjectDetail subject = tution.SubjectDetails.Where(x => x.SubjectID == subje.sub).FirstOrDefault(); tution.Timetables.Remove(timetable); tution.SaveChanges(); //tution.SubjectDetails.Remove(subject); //tution.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("TimetableList")); } catch { return(View(timetable)); } }
public ActionResult EditTimetable(int id, Project.Models.Timetable timetable) { try { using (DBmodel tution = new DBmodel()) { //SubjectDetail subject = new SubjectDetail(); //string sub = tution.Timetables.Find(id).Subject.ToString(); timetable.classId = id; tution.Entry(timetable).State = EntityState.Modified; tution.SaveChanges(); //var subje = tution.SubjectTBs.Where(m => m.SubjectName == timetable.Subject).Select(u => new { sub = u.SubjectCode }).Single(); //subject.Hall = timetable.Hall; //subject.StartTime = timetable.StartTime; //subject.EndTime = timetable.EndTime; //subject.Day = timetable.Day; //subject.SubjectID = subje.sub; //tution.Entry(subject).State = EntityState.Modified; //tution.SaveChanges(); return(RedirectToAction("TimetableList")); } // TODO: Add update logic here } catch { return(RedirectToAction("TimetableList")); } }
public ActionResult CreateTimetable(Project.Models.Timetable timetable) { try { using (DBmodel tution = new DBmodel()) { ViewBag.IsError = false; try { if (ModelState.IsValid) { SubjectDetail subject = new SubjectDetail(); var subje = tution.SubjectTBs.Where(m => m.SubjectName == timetable.Subject).Select(u => new { sub = u.SubjectCode }).Single(); tution.Timetables.Add(timetable); tution.SaveChanges(); subject.Hall = timetable.Hall; subject.StartTime = timetable.StartTime; subject.EndTime = timetable.EndTime; subject.Day = timetable.Day; subject.SubjectID = subje.sub; tution.SubjectDetails.Add(subject); tution.SaveChanges(); return(RedirectToAction("TimetableList")); } } catch { } } } catch { DBmodel db = new DBmodel(); List <TeacherList> list = db.TeacherLists.ToList(); List <GradeList> grades = db.GradeLists.ToList(); List <subject> subjects = db.subjects.ToList(); ViewBag.teacherlist = new SelectList(list, "teacher_name", "teacher_name"); ViewBag.Grades = new SelectList(grades, "Grade", "Grade"); ViewBag.Subjects = new SelectList(subjects, "subject1", "subject1"); return(View()); } return(RedirectToAction("TimetableList")); }