public ActionResult DeleteConfirmed(int id, audit_trail audit) { var check = db.attendances.Where(s => s.Training_Course_Instance_ID == id).FirstOrDefault(); if (check == null) { training_course_instance training_course_instance = db.training_course_instance.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_instance.Training_Course_ID.ToString() + " Instructor Course ID: " + training_course_instance.Instructor_ID.ToString() + " Venue ID: " + training_course_instance.Venue_ID.ToString() + " Date:" + Convert.ToString(training_course_instance.Instance_Date) + " Start Time:" + Convert.ToString(training_course_instance.Instance_Start_Time) + " End Time:" + Convert.ToString(training_course_instance.Instance_End_Time); audit.Trail_Description = "Deleted a Training Course Instance."; db.audit_trail.Add(audit); db.training_course_instance.Remove(training_course_instance); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.Error = "Cannot delete a training course instance that has sales rep attendance."; training_course_instance training_course_instance = db.training_course_instance.Find(id); return(View(training_course_instance)); } }
public ActionResult DeleteConfirmed(int id) { training_course_instance training_course_instance = db.training_course_instance.Find(id); db.training_course_instance.Remove(training_course_instance); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Training_Course_Instance_ID,Instance_Date,Instance_Start_Time,Instance_End_Time,Venue_ID,Instructor_ID,Training_Course_ID")] training_course_instance training_course_instance) { if (ModelState.IsValid) { TimeSpan end = new TimeSpan(22, 0, 0); TimeSpan start = new TimeSpan(02, 59, 0); bool val = db.training_course_instance.Any(s => s.Instance_Date == training_course_instance.Instance_Date && (s.Instructor_ID == training_course_instance.Instructor_ID || s.Venue_ID == training_course_instance.Venue_ID) && //inside ((s.Instance_Start_Time <= training_course_instance.Instance_Start_Time && s.Instance_End_Time >= training_course_instance.Instance_End_Time) //outside || (s.Instance_Start_Time >= training_course_instance.Instance_Start_Time && s.Instance_End_Time <= training_course_instance.Instance_End_Time) //before start and after start || (s.Instance_Start_Time <= training_course_instance.Instance_Start_Time && training_course_instance.Instance_Start_Time <= s.Instance_End_Time) //befor end and after end || (s.Instance_Start_Time <= training_course_instance.Instance_End_Time && training_course_instance.Instance_End_Time <= s.Instance_End_Time))); bool time = training_course_instance.Instance_Start_Time <= start || training_course_instance.Instance_End_Time >= end; if (val == false && training_course_instance.Instance_Start_Time <= training_course_instance.Instance_End_Time && time == false) { db.training_course_instance.Add(training_course_instance); db.SaveChanges(); ViewBag.Instructor_ID = new SelectList(db.instructors, "Instructor_ID", "Instructor_Name", training_course_instance.Instructor_ID); ViewBag.Training_Course_ID = new SelectList(db.training_course, "Training_Course_ID", "Training_Course_Name", training_course_instance.Training_Course_ID); ViewBag.Venue_ID = new SelectList(db.venues, "Venue_ID", "Venue_Name", training_course_instance.Venue_ID); return(RedirectToAction("Index")); } else if (training_course_instance.Instance_Start_Time >= training_course_instance.Instance_End_Time) { ViewBag.Error = "The End time cannot be at the same time or an earlier time then the start time."; } else if (val == true) { ViewBag.Error = "The training course cannot be booked because there is another training course at the same time, please try a different time, or the venue is already booked, or the instructor is already giving a lecture at that time."; } else if (time == true) { ViewBag.Error = "The start time of a training course cannot start at any time between 00:00 and 02:59 and the end time of a training course cannot end at any time between 22:00 and 23:59."; } //db.training_course_instance.Add(training_course_instance); //db.SaveChanges(); ViewBag.Instructor_ID = new SelectList(db.instructors, "Instructor_ID", "Instructor_Name", training_course_instance.Instructor_ID); ViewBag.Training_Course_ID = new SelectList(db.training_course, "Training_Course_ID", "Training_Course_Name", training_course_instance.Training_Course_ID); ViewBag.Venue_ID = new SelectList(db.venues, "Venue_ID", "Venue_Name", training_course_instance.Venue_ID); return(View()); } ViewBag.Instructor_ID = new SelectList(db.instructors, "Instructor_ID", "Instructor_Name", training_course_instance.Instructor_ID); ViewBag.Training_Course_ID = new SelectList(db.training_course, "Training_Course_ID", "Training_Course_Name", training_course_instance.Training_Course_ID); ViewBag.Venue_ID = new SelectList(db.venues, "Venue_ID", "Venue_Name", training_course_instance.Venue_ID); return(View(training_course_instance)); }
// GET: training_course_instance/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } training_course_instance training_course_instance = db.training_course_instance.Find(id); if (training_course_instance == null) { return(HttpNotFound()); } return(View(training_course_instance)); }
// GET: training_course_instance/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } training_course_instance training_course_instance = db.training_course_instance.Find(id); if (training_course_instance == null) { return(HttpNotFound()); } ViewBag.Training_Course_ID = new SelectList(db.training_course, "Training_Course_ID", "Training_Course_Name", training_course_instance.Training_Course_ID); ViewBag.Venue_ID = new SelectList(db.venues, "Venue_ID", "Venue_Name", training_course_instance.Venue_ID); ViewBag.Instructor_ID = new SelectList(db.instructors, "Instructor_ID", "Instructor_Name", training_course_instance.Instructor_ID); return(View(training_course_instance)); }
public ActionResult Edit([Bind(Include = "Training_Course_Instance_ID,Instance_Date,Instance_Start_Time,Instance_End_Time,Venue_ID,Instructor_ID,Training_Course_ID")] training_course_instance training_course_instance) { if (ModelState.IsValid) { if (training_course_instance.Instance_Start_Time < training_course_instance.Instance_End_Time) { db.Entry(training_course_instance).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else if (training_course_instance.Instance_Start_Time >= training_course_instance.Instance_End_Time) { ViewBag.Error = "The End time cannot be at the same time or an earlier time then the start time."; } } ViewBag.Training_Course_ID = new SelectList(db.training_course, "Training_Course_ID", "Training_Course_Name", training_course_instance.Training_Course_ID); ViewBag.Venue_ID = new SelectList(db.venues, "Venue_ID", "Venue_Name", training_course_instance.Venue_ID); ViewBag.Instructor_ID = new SelectList(db.instructors, "Instructor_ID", "Instructor_Name", training_course_instance.Instructor_ID); return(View(training_course_instance)); }