public ActionResult ScheduleView(CustomerLesson viewModel) { if (_context.Customers.Any(d => d.LessonDates.Date == viewModel.LessonDates.Date)) { var dbDates = _context.Customers.Where(d => d.LessonDates.Date == viewModel.LessonDates.Date).Include(i => i.TimeSlots).Include(d => d.LessonDates).OrderBy(t => t.TimeSlotsID); return(View(dbDates)); } else { return(RedirectToAction("NoLessonInDbIndex", "Admin")); } }
public ActionResult EditCancelList(CustomerLesson viewModel) { if (_context.Customers.Any(s => s.Surname == viewModel.Customers.Surname)) { var SurnameInDb = _context.Customers.Where(s => s.Surname == viewModel.Customers.Surname).Include(i => i.TimeSlots).Include(d => d.LessonDates).OrderBy(d => d.LessonDates.Date); return(View(SurnameInDb)); } else { return(RedirectToAction("NoNameFound", "Admin")); } }
// GET: Lesson/New public ActionResult New() { var TimeSlots = _context.TimeSlots.ToList(); var customer = new Customer(); var LessDate = new LessonDate(); var ViewModel = new CustomerLesson { TimeSlots = TimeSlots, Customers = customer, LessonDates = LessDate }; return(View(ViewModel)); }
/*GET METHOD*/ public ActionResult Delete(int?id, int?LessDateID) { var customer = _context.Customers.SingleOrDefault(c => c.ID == id); var TimeSlots = _context.TimeSlots.ToList(); var LessDate = _context.LessonDates.SingleOrDefault(d => d.ID == LessDateID); if (customer == null) { return(HttpNotFound()); } var ViewModel = new CustomerLesson { TimeSlots = TimeSlots, Customers = customer, LessonDates = LessDate }; return(View("Delete", ViewModel)); }
public ActionResult BookLesson(CustomerLesson viewModel) { viewModel.Customers.TimeSlots = _context.TimeSlots.First(t => t.ID == viewModel.Customers.TimeSlotsID); if (!ModelState.IsValid) { viewModel = new CustomerLesson { TimeSlots = _context.TimeSlots.ToList(), LessonDates = viewModel.LessonDates, Customers = viewModel.Customers }; return(View("New", viewModel)); } if ((_context.Customers.Any(d => d.LessonDates.Date.Equals(viewModel.LessonDates.Date)) && (_context.Customers.Any(t => t.TimeSlotsID.Equals(viewModel.Customers.TimeSlotsID))))) { var custInDB = _context.Customers.Include(d => d.LessonDates); foreach (Customer c in custInDB) { if ((c.LessonDates.Date == viewModel.LessonDates.Date) && (c.TimeSlotsID == viewModel.Customers.TimeSlotsID)) { viewModel = new CustomerLesson { TimeSlots = _context.TimeSlots.ToList(), LessonDates = viewModel.LessonDates, Customers = viewModel.Customers }; return(View("TryBookAgain", viewModel)); } } } /* NEW CUSTOMER LESSON*/ if (viewModel.Customers.ID == 0) { LessonDate newLessonDate = new LessonDate(); newLessonDate.Date = viewModel.LessonDates.Date; newLessonDate.ID = viewModel.LessonDates.ID; _context.LessonDates.Add(newLessonDate); _context.SaveChanges(); viewModel.Customers.LessonDatesID = newLessonDate.ID; _context.Customers.Add(viewModel.Customers); _context.SaveChanges(); _context.Customers.Add(viewModel.Customers); } /* EXISITING CUSTOMER LESSON*/ else { var existingBkdLesson = _context.Customers.Single(c => c.ID == viewModel.Customers.ID); var LessDateID = existingBkdLesson.LessonDatesID; var existingLessDate = _context.LessonDates.Single(d => d.ID == LessDateID); existingLessDate.Date = viewModel.LessonDates.Date; _context.SaveChanges(); existingBkdLesson.FirstName = viewModel.Customers.FirstName; existingBkdLesson.Surname = viewModel.Customers.Surname; existingBkdLesson.TelephoneNo = viewModel.Customers.TelephoneNo; existingBkdLesson.TimeSlotsID = viewModel.Customers.TimeSlotsID; _context.SaveChanges(); } return(RedirectToAction("BookingSuccess", "Lesson")); }