public ActionResult DeleteConfirmed(int id, audit_trail audit)
{
var check = db.training_course_instance.Where(s => s.Instructor_ID == id).FirstOrDefault();
if (check == null)
{
training_course training_course = db.training_course.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 ID: " + training_course.Training_Course_ID.ToString() + "Employee ID: " + training_course.Employee_ID.ToString()
+ "Training Course Type ID: " + training_course.Training_Course_Type_ID.ToString() + " " + training_course.Training_Course_Name + " " + training_course.Training_Course_Description;
audit.Trail_Description = "Deleted a Training Course.";
db.audit_trail.Add(audit);
db.training_course.Remove(training_course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
training_course training_course = db.training_course.Find(id);
ViewBag.Error = "Can't delete a training course description that has been used in training course instance, keep it as a record for historic purposes.";
return(View(training_course));
}
}
public ActionResult DeleteConfirmed(int id)
{
training_course training_course = db.training_course.Find(id);
db.training_course.Remove(training_course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Training_Course_ID,Training_Course_Name,Training_Course_Description,Employee_ID,Training_Course_Type_ID")] training_course training_course)
{
if (ModelState.IsValid)
{
db.Entry(training_course).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", training_course.Employee_ID);
ViewBag.Training_Course_Type_ID = new SelectList(db.training_course_type, "Training_Course_Type_ID", "Course_Name", training_course.Training_Course_Type_ID);
return(View(training_course));
}
// GET: training_course/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
training_course training_course = db.training_course.Find(id);
if (training_course == null)
{
return(HttpNotFound());
}
return(View(training_course));
}
// GET: training_course/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
training_course training_course = db.training_course.Find(id);
if (training_course == null)
{
return(HttpNotFound());
}
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", training_course.Employee_ID);
ViewBag.Training_Course_Type_ID = new SelectList(db.training_course_type, "Training_Course_Type_ID", "Course_Name", training_course.Training_Course_Type_ID);
return(View(training_course));
}
public ActionResult Edit([Bind(Include = "Training_Course_ID,Training_Course_Name,Training_Course_Description,Employee_ID,Training_Course_Type_ID")] training_course training_course)
{
bool val = db.training_course.Any(s => s.Training_Course_Name == training_course.Training_Course_Name && s.Training_Course_ID != training_course.Training_Course_ID);
if (ModelState.IsValid && val == false)
{
db.Entry(training_course).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
ViewBag.StatusMessage = "There is already an: " + training_course.Training_Course_Name + " type in the database.";
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", training_course.Employee_ID);
ViewBag.Training_Course_Type_ID = new SelectList(db.training_course_type, "Training_Course_Type_ID", "Course_Name", training_course.Training_Course_Type_ID);
return(View());
}
ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", training_course.Employee_ID);
ViewBag.Training_Course_Type_ID = new SelectList(db.training_course_type, "Training_Course_Type_ID", "Course_Name", training_course.Training_Course_Type_ID);
return(View(training_course));
}
