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