public ActionResult DeleteConfirmed(Semester semester) { var db = DAL.DbContext.Create(); Semester sem = db.Semesters.Get(semester.Id); try { bool IsDeleted = db.DeleteSemester(semester); if (IsDeleted) { ModelState.AddModelError("", "Unable to delete semester due to dependencies. Make semester is not currenlty in used."); } else { return RedirectToAction("Index"); } } catch (Exception dex) { //Log the error (uncomment dex variable name and add a line here to write a log. return RedirectToAction("Delete", new { semester, saveChangesError = true }); } return View(sem); }
/// <summary> /// 根据ID修改 ///</summary> public static int UpdateSemester(Semester SemesterModel) { string sql = string.Format(" UPDATE Semester set SemesterName='{0}' where SemesterId={1} ", SemesterModel.SemesterName, SemesterModel.SemesterId); return(DBHelper.ExecuteCommand(sql)); }
/// <summary> /// 添加 ///</summary> public static int AddSemester(Semester SemesterModel) { string sql = string.Format("insert into Semester (SemesterName) values ('{0}')", SemesterModel.SemesterName); return(DBHelper.ExecuteCommand(sql)); }
public ActionResult Edit(Semester semester) { var db = DAL.DbContext.Create(); if (ModelState.IsValid) { db.UpdateSemester(semester); return RedirectToAction("Index"); } return View(semester); }