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