//Get Edit
public async Task <IActionResult> Edit(int id)
{
if (id == null)
{
NotFound();
}
var lstProducts = (IEnumerable <Products>)(from p in _db.products
join a in _db.appointmentsProducts
on p.Id equals a.ProductId
where a.appointmentId == id
select p).Include("ProductTypes");
AppointmentsDetailsVM advm = new AppointmentsDetailsVM()
{
appointments = _db.appointments.Include(a => a.SalesPerson).Where(a => a.Id == id).FirstOrDefault(),
lstUsers = _db.users.Where(u => u.LockoutEnd == null || u.LockoutEnd < DateTime.Now).ToList(),
lstproducts = lstProducts.ToList()
};
return(View(advm));
}
public async Task <IActionResult> Edit(int id, AppointmentsDetailsVM value)
{
if (ModelState.IsValid)
{
value.appointments.AppointmentDate = value.appointments.AppointmentDate.AddHours(value.appointments.AppointmentTime.Hour).AddMinutes(value.appointments.AppointmentTime.Minute);
var dbappointment = _db.appointments.Where(a => a.Id == value.appointments.Id).FirstOrDefault();
dbappointment.CustomerName = value.appointments.CustomerName;
dbappointment.CustomerEmail = value.appointments.CustomerEmail;
dbappointment.CustomerPhone = value.appointments.CustomerPhone;
dbappointment.AppointmentDate = value.appointments.AppointmentDate;
dbappointment.Confirmed = value.appointments.Confirmed;
if (User.IsInRole(SD.SuperAdminUser))
{
dbappointment.SalesPersonID = value.appointments.SalesPersonID;
}
_db.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(value));
}