public ActionResult DeleteConfirmed(int id, audit_trail audit) { var check = db.training_course.Where(s => s.Training_Course_Type_ID == id).FirstOrDefault(); if (check == null) { training_course_type training_course_type = db.training_course_type.Find(id); var userId = System.Web.HttpContext.Current.Session["UserID"] as String; int IntID = Convert.ToInt32(userId); audit.Employee_ID = IntID; audit.Trail_DateTime = DateTime.Now.Date; audit.Deleted_Record = training_course_type.Training_Course_Type_ID.ToString() + " " + training_course_type.Course_Name + " " + training_course_type.Course_Description; audit.Trail_Description = "Deleted a Training Course Type."; db.audit_trail.Add(audit); db.training_course_type.Remove(training_course_type); db.SaveChanges(); return(RedirectToAction("Index")); } else { training_course_type training_course_type = db.training_course_type.Find(id); ViewBag.Error = "Can't delete a type that is in-use please add a new type instead, or delete all training courses related to this type first."; return(View(training_course_type)); } }
public ActionResult DeleteConfirmed(int id) { training_course_type training_course_type = db.training_course_type.Find(id); db.training_course_type.Remove(training_course_type); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Training_Course_Type_ID,Course_Name,Course_Description")] training_course_type training_course_type) { if (ModelState.IsValid) { db.Entry(training_course_type).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(training_course_type)); }
public ActionResult Create([Bind(Include = "Training_Course_Type_ID,Course_Name,Course_Description")] training_course_type training_course_type) { if (ModelState.IsValid) { db.training_course_type.Add(training_course_type); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(training_course_type)); }
// GET: training_course_type/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } training_course_type training_course_type = db.training_course_type.Find(id); if (training_course_type == null) { return(HttpNotFound()); } return(View(training_course_type)); }
public ActionResult Edit([Bind(Include = "Training_Course_Type_ID,Course_Name,Course_Description")] training_course_type training_course_type) { bool val = db.training_course_type.Any(s => s.Course_Name == training_course_type.Course_Name && s.Training_Course_Type_ID != training_course_type.Training_Course_Type_ID); if (ModelState.IsValid && val == false) { db.Entry(training_course_type).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else if (val == true) { ViewBag.StatusMessage = "There is already an: " + training_course_type.Course_Name + " type in the database."; return(View()); } return(View(training_course_type)); }
public ActionResult Create([Bind(Include = "Training_Course_Type_ID,Course_Name,Course_Description")] training_course_type training_course_type) { bool val = Validate(training_course_type.Course_Name); if (ModelState.IsValid && val == false) { db.training_course_type.Add(training_course_type); db.SaveChanges(); return(RedirectToAction("Index")); } else if (val == true) { ViewBag.StatusMessage = "There is already an: " + training_course_type.Course_Name + " type in the database."; return(View()); } return(View(training_course_type)); }