public async Task <IActionResult> Edit(int id, AppointmentsDetailsViewModel objAppointmentVM) { if (ModelState.IsValid) { objAppointmentVM.Appointments.AppointmentDate = objAppointmentVM.Appointments.AppointmentDate .AddHours(objAppointmentVM.Appointments.AppointmentTime.Hour) .AddMinutes(objAppointmentVM.Appointments.AppointmentTime.Minute); var appointmentFromDb = _db.Appointments.Where(a => a.Id == objAppointmentVM.Appointments.Id).FirstOrDefault(); appointmentFromDb.CustomerName = objAppointmentVM.Appointments.CustomerName; appointmentFromDb.CustomerEmail = objAppointmentVM.Appointments.CustomerEmail; appointmentFromDb.CustomerPhoneNumber = objAppointmentVM.Appointments.CustomerPhoneNumber; appointmentFromDb.AppointmentDate = objAppointmentVM.Appointments.AppointmentDate; appointmentFromDb.isConfirmed = objAppointmentVM.Appointments.isConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentFromDb.SalesPersonId = objAppointmentVM.Appointments.SalesPersonId; } _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(objAppointmentVM)); }
public async Task <IActionResult> Delete(int?id) { if (id == null) { return(NotFound()); } var productList = (IEnumerable <Products>)(from p in _db.Products join a in _db.ProductsSelectedForAppointment on p.Id equals a.ProductID where a.AppointmentID == id select p).Include("ProductTypes"); AppointmentsDetailsViewModel ObjappointmentsVM = new AppointmentsDetailsViewModel() { appointment = _db.Appointments.Include(a => a.SalesPerson).Where(a => a.Id == id).FirstOrDefault(), SalesPerson = _db.ApplicationUser.ToList(), products = productList.ToList() }; return(View(ObjappointmentsVM)); }