public ActionResult Create(ModuleViewModel MVM) { ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseDescription"); ViewBag.SemesterId = new SelectList(db.Semesters, "SemesterId", "SemesterName"); if (ModelState.IsValid) { //String sql = "Insert into Courses (CourseName, CourseCode, CreditHour) values ('" + course.CourseName + "', '" + course.CourseCode + "', '" + course.CreditHour + "')"; //db.Create(sql); // db.Courses.Add(Vmodel.Course); var CouSemMod = new CourseSemesterModule(); CouSemMod = new CourseSemesterModule() { CourseId = MVM.CourseId, SemesterId = MVM.SemesterId, ModuleId = MVM.Module.ModuleId }; db.Modules.Add(MVM.Module); db.CourseSemesterModules.Add(CouSemMod); db.SaveChanges(); return(RedirectToAction("Create")); } return(null); }
public ActionResult Create(Course cou) { if (ModelState.IsValid) { db.Courses.Add(cou); var CouSemMod = new CourseSemesterModule(); db.SaveChanges(); return(RedirectToAction("Create")); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseDescription", null); ViewBag.SemesterId = new SelectList(db.Semesters, "SemesterId", "SemesterName", null); return(View()); }