public ActionResult EditSchedule(int id)
{
ViewBag.Types = new SelectList(db.TypeTables, "ID", "Type", id);
ViewBag.Trainers = new SelectList(db.Trainers, "ID", "FirstName", id);
TrainerSchedule c = db.TrainerSchedules.Where(x => x.ID == id).FirstOrDefault();
return(View(c));
}
public ActionResult DeleteConfirmed(int id)
{
TrainerSchedule trainerSchedule = db.TrainerSchedules.Find(id);
db.TrainerSchedules.Remove(trainerSchedule);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteTrainerSchedule(TrainerSchedule s)
{
if (ModelState.IsValid)
{
db.TrainerSchedules.Attach(s);
db.TrainerSchedules.Remove(s);
db.SaveChanges();
TempData["Success"] = "Schedule deleted successfully.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
return(View());
}
public ActionResult Edit([Bind(Include = "Id,StartWorkout,EndWorkout,TrainerId,HallGymId")] TrainerSchedule trainerSchedule)
{
if (ModelState.IsValid)
{
db.Entry(trainerSchedule).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.HallGymId = new SelectList(db.HallGyms, "Id", "Title", trainerSchedule.HallGymId);
ViewBag.TrainerId = new SelectList(db.Trainers, "Id", "Id", trainerSchedule.TrainerId);
return(View(trainerSchedule));
}
// GET: TrainerSchedules/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TrainerSchedule trainerSchedule = db.TrainerSchedules.Find(id);
if (trainerSchedule == null)
{
return(HttpNotFound());
}
return(View(trainerSchedule));
}
// GET: TrainerSchedules/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TrainerSchedule trainerSchedule = db.TrainerSchedules.Find(id);
if (trainerSchedule == null)
{
return(HttpNotFound());
}
ViewBag.HallGymId = new SelectList(db.HallGyms, "Id", "Title", trainerSchedule.HallGymId);
ViewBag.TrainerId = new SelectList(db.Trainers, "Id", "Id", trainerSchedule.TrainerId);
return(View(trainerSchedule));
}
public ActionResult EditSchedule(TrainerSchedule t, String selectedID, String selectedIDforType)
{
if (ModelState.IsValid)
{
TrainerSchedule search = db.TrainerSchedules.Where(
x => x.StartTime.Value.Hour >= t.StartTime.Value.Hour &&
x.EndTime.Value.Hour <= t.EndTime.Value.Hour &&
x.StartTime.Value.Minute >= t.StartTime.Value.Minute &&
x.EndTime.Value.Minute <= t.EndTime.Value.Minute &&
x.StartTime.Value.Day == t.StartTime.Value.Day &&
x.StartTime.Value.Month == t.StartTime.Value.Month &&
x.StartTime.Value.Year == t.StartTime.Value.Year
).FirstOrDefault();
if (search != null)
{
TempData["Error"] = "A conflict has occurred.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
else if (t.EndTime == t.StartTime)
{
TempData["Error"] = "Start time and end time cannot be at the same time.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
TypeTable type = db.TypeTables.Find(Convert.ToInt32(selectedIDforType));
t.TrainerID = Convert.ToInt32(selectedID);
TrainerSchedule ts = new TrainerSchedule();
ts.ID = t.ID;
ts.TrainerID = Convert.ToInt32(selectedID);
ts.Type = type.ID;
ts.StartTime = t.StartTime;
ts.EndTime = t.EndTime;
var toBeUpdated = db.TrainerSchedules.Where(x => x.ID == t.ID).FirstOrDefault();
db.Entry(toBeUpdated).CurrentValues.SetValues(ts);
db.SaveChanges();
TempData["Success"] = "Schedule edited successfully.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
return(View(t));
}
public ActionResult AddTrainerSchedule(TrainerSchedule t, String selectedID, String selectedIDforType)
{
if (ModelState.IsValid)
{
t.TrainerID = Convert.ToInt32(selectedID);
t.Type = Convert.ToInt32(selectedIDforType);
TrainerSchedule search = db.TrainerSchedules.Where(
x => x.StartTime.Value.Hour >= t.StartTime.Value.Hour &&
x.EndTime.Value.Hour <= t.EndTime.Value.Hour &&
x.StartTime.Value.Minute >= t.StartTime.Value.Minute &&
x.EndTime.Value.Minute <= t.EndTime.Value.Minute &&
x.StartTime.Value.Day == t.StartTime.Value.Day &&
x.StartTime.Value.Month == t.StartTime.Value.Month &&
x.StartTime.Value.Year == t.StartTime.Value.Year
).FirstOrDefault();
if (search != null)
{
TempData["Error"] = "A conflict has occurred.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
else if (t.EndTime == t.StartTime)
{
TempData["Error"] = "Start time and end time cannot be at the same time.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
else
{
db.TrainerSchedules.Add(t);
db.SaveChanges();
TempData["Success"] = "Schedule added successfully.";
return(RedirectToAction("SetTrainerSchedule", "Staff"));
}
}
return(View());
}
public ActionResult DeleteTrainerSchedule(int id)
{
TrainerSchedule ts = db.TrainerSchedules.Where(x => x.ID == id).FirstOrDefault();
return(View(ts));
}
public ActionResult DeleteTrainerSchedule(TrainerSchedule s)
{
if (ModelState.IsValid)
{
db.TrainerSchedules.Attach(s);
db.TrainerSchedules.Remove(s);
db.SaveChanges();
return RedirectToAction("ManageCustomer", "Staff");
}
return View();
}
public ActionResult EditSchedule(TrainerSchedule t,String selectedID)
{
if (ModelState.IsValid)
{
t.TrainerID = Convert.ToInt32(selectedID);
TrainerSchedule ts = new TrainerSchedule();
ts.ID = t.ID;
ts.TrainerID = Convert.ToInt32(selectedID);
ts.Type = t.Type;
ts.Time = t.Time;
var toBeUpdated = db.TrainerSchedules.Where(x=>x.ID==t.ID).FirstOrDefault();
db.Entry(toBeUpdated).CurrentValues.SetValues(ts);
db.SaveChanges();
return RedirectToAction("SetTrainerSchedule", "Staff");
}
return View(t);
}
public ActionResult AddTrainerSchedule(TrainerSchedule t,String selectedID)
{
if(ModelState.IsValid) {
t.TrainerID = Convert.ToInt32(selectedID);
db.TrainerSchedules.Add(t);
db.SaveChanges();
return RedirectToAction("SetTrainerSchedule", "Staff");
}
return View();
}
public ActionResult AddTrainerSchedule(TrainerSchedule t, String selectedID, String selectedIDforType)
{
if (ModelState.IsValid)
{
t.TrainerID = Convert.ToInt32(selectedID);
t.Type = Convert.ToInt32(selectedIDforType);
TrainerSchedule search = db.TrainerSchedules.Where(
x => x.StartTime.Value.Hour >= t.StartTime.Value.Hour
&& x.EndTime.Value.Hour <= t.EndTime.Value.Hour
&& x.StartTime.Value.Minute >= t.StartTime.Value.Minute
&& x.EndTime.Value.Minute <= t.EndTime.Value.Minute
&& x.StartTime.Value.Day == t.StartTime.Value.Day
&& x.StartTime.Value.Month == t.StartTime.Value.Month
&& x.StartTime.Value.Year == t.StartTime.Value.Year
).FirstOrDefault();
if (search != null)
{
TempData["Error"] = "A conflict has occurred.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
else if (t.EndTime == t.StartTime)
{
TempData["Error"] = "Start time and end time cannot be at the same time.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
else
{
db.TrainerSchedules.Add(t);
db.SaveChanges();
TempData["Success"] = "Schedule added successfully.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
}
return View();
}
public ActionResult EditSchedule(TrainerSchedule t, String selectedID, String selectedIDforType)
{
if (ModelState.IsValid)
{
TrainerSchedule search = db.TrainerSchedules.Where(
x => x.StartTime.Value.Hour >= t.StartTime.Value.Hour
&& x.EndTime.Value.Hour <= t.EndTime.Value.Hour
&& x.StartTime.Value.Minute >= t.StartTime.Value.Minute
&& x.EndTime.Value.Minute <= t.EndTime.Value.Minute
&& x.StartTime.Value.Day == t.StartTime.Value.Day
&& x.StartTime.Value.Month == t.StartTime.Value.Month
&& x.StartTime.Value.Year == t.StartTime.Value.Year
).FirstOrDefault();
if (search != null)
{
TempData["Error"] = "A conflict has occurred.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
else if (t.EndTime == t.StartTime)
{
TempData["Error"] = "Start time and end time cannot be at the same time.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
TypeTable type = db.TypeTables.Find(Convert.ToInt32(selectedIDforType));
t.TrainerID = Convert.ToInt32(selectedID);
TrainerSchedule ts = new TrainerSchedule();
ts.ID = t.ID;
ts.TrainerID = Convert.ToInt32(selectedID);
ts.Type = type.ID;
ts.StartTime = t.StartTime;
ts.EndTime = t.EndTime;
var toBeUpdated = db.TrainerSchedules.Where(x => x.ID == t.ID).FirstOrDefault();
db.Entry(toBeUpdated).CurrentValues.SetValues(ts);
db.SaveChanges();
TempData["Success"] = "Schedule edited successfully.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
return View(t);
}
public ActionResult DeleteTrainerSchedule(TrainerSchedule s)
{
if (ModelState.IsValid)
{
db.TrainerSchedules.Attach(s);
db.TrainerSchedules.Remove(s);
db.SaveChanges();
TempData["Success"] = "Schedule deleted successfully.";
return RedirectToAction("SetTrainerSchedule", "Staff");
}
return View();
}
