public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel objAppointmentVM, string strUrl) { if (ModelState.IsValid) { var appointmentFromDb = _db.Appointments.Where(a => a.Id == objAppointmentVM.Appointment.Id).FirstOrDefault(); appointmentFromDb.CustomerName = objAppointmentVM.Appointment.CustomerName; appointmentFromDb.CustomerEmail = objAppointmentVM.Appointment.CustomerEmail; appointmentFromDb.CustomerAddress = objAppointmentVM.Appointment.CustomerAddress; appointmentFromDb.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate; appointmentFromDb.isConfirmed = objAppointmentVM.Appointment.isConfirmed; appointmentFromDb.isCompleted = objAppointmentVM.Appointment.isCompleted; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentFromDb.SalesPersonId = objAppointmentVM.Appointment.SalesPersonId; } else { appointmentFromDb.SalesPersonId = null; } _db.SaveChanges(); return(Redirect(strUrl)); } return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel objAppointmentVM) { if (ModelState.IsValid) { objAppointmentVM.Appointments.AppointmentDate = objAppointmentVM.Appointments.AppointmentDate .AddHours(objAppointmentVM.Appointments.AppointmentTime.Hour) .AddMinutes(objAppointmentVM.Appointments.AppointmentTime.Minute); // this adds the time to the date to save it in the db var appointmentFromDb = await _db.Appointments.Where(a => a.Id == objAppointmentVM.Appointments.Id).FirstOrDefaultAsync(); appointmentFromDb.CustomerName = objAppointmentVM.Appointments.CustomerName; appointmentFromDb.CustomerPhoneNumber = objAppointmentVM.Appointments.CustomerPhoneNumber; appointmentFromDb.CustomerEmail = objAppointmentVM.Appointments.CustomerEmail; appointmentFromDb.AppointmentDate = objAppointmentVM.Appointments.AppointmentDate; appointmentFromDb.IsConfirmed = objAppointmentVM.Appointments.IsConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentFromDb.SalesPersonId = objAppointmentVM.Appointments.SalesPersonId; } await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(objAppointmentVM)); }
public async Task <IActionResult> Delete(int?id) { //check if id is null if (id == null) { return(NotFound()); } // we need to retrieve all of the products for an appointment, so we need to combine from ProductsSelectedForAppointment and Products models // and filter that based on appointment ID that is passed in and retrieve those products // we will use Linq to do that // join on tables, converted selected products to IEnumerable of products var productList = (IEnumerable <Products>)(from p in _db.Products join a in _db.ProductsSelectedForAppointments on p.Id equals a.ProductId where a.AppointmentId == id select p).Include("ProductTypes"); // We need new AppointmentsViewModel and to populate with specific appointment data AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = _db.Appointments.Include(a => a.SalesPerson).Where(a => a.Id == id).FirstOrDefault(), SalesPerson = _db.ApplicationUser.ToList(), Products = productList.ToList() }; // now that we have our products we ween to pas the m on to the view don't we? ;-) return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel appVM) { if (ModelState.IsValid) { appVM.Appointment.AppointmentDate = appVM.Appointment.AppointmentDate .AddHours(appVM.Appointment.AppointmentTime.Hour) .AddMinutes(appVM.Appointment.AppointmentTime.Minute); var appointmentFromDb = this.db.Appointments.Where(a => a.Id == appVM.Appointment.Id).FirstOrDefault(); appointmentFromDb.CustomerName = appVM.Appointment.CustomerName; appointmentFromDb.CustomerEmail = appVM.Appointment.CustomerEmail; appointmentFromDb.CustomerPhoneNumber = appVM.Appointment.CustomerPhoneNumber; appointmentFromDb.AppointmentDate = appVM.Appointment.AppointmentDate; appointmentFromDb.IsConfirmed = appVM.Appointment.IsConfirmed; if (User.IsInRole(StaticDetails.SuperAdminEndUser)) { appointmentFromDb.SalesPersonId = appVM.Appointment.SalesPersonId; } await this.db.SaveChangesAsync(); return(this.RedirectToAction(nameof(Index))); } return(this.View(appVM)); }
public IActionResult Details(int id) { var appointment = _appointmentService.GetById(id); if (appointment == null) { return(NotFound()); } var model = new AppointmentDetailsViewModel() { Id = appointment.Id, TechnicianId = appointment.TechnicianId, TechnicianName = appointment.TechnicianName, Observations = appointment.Observations, StartDate = appointment.StartDate, ExpectedFinalDate = appointment.ExpectedFinalDate, RealFinalDate = appointment.RealFinalDate, Address = appointment.Address, AppointmentName = appointment.AppointmentName, City = appointment.City, District = appointment.District, Number = appointment.Number, Postcode = appointment.Postcode, State = appointment.State, Completed = appointment.Completed }; return(View(model)); }
//GET Edit public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } var productList = (IEnumerable <Product>)(from p in _db.Products join a in _db.ProductAddToAppointment on p.ProductId equals a.ProductId where a.AppointmentId == id select p); List <CartItem> cart = new List <CartItem>(); foreach (Product item in productList) { CartItem halo = new CartItem(); var prd = _db.ProductAddToAppointment.Where(m => m.AppointmentId == id && m.ProductId == item.ProductId).FirstOrDefault(); halo.itemCart = item; halo.quantity = prd.Count; halo.totalItem = prd.Total; cart.Add(halo); } AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = _db.Appoinments.Include(a => a.SalePerson).Where(a => a.Id == id).FirstOrDefault(), SalesPerson = _db.ApplicationAdminUser.ToList(), Products = cart, }; return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel appDetailsVM) { if (ModelState.IsValid) { //combine the apt date and time from view inside the apt date appDetailsVM.Appointment.AppointmentDate = appDetailsVM.Appointment.AppointmentDate .AddHours(appDetailsVM.Appointment.AppointmentTime.Hour) .AddMinutes(appDetailsVM.Appointment.AppointmentTime.Minute); //grab apt obj from db var appointmentFromDb = _db.Appointments.Where(a => a.Id == appDetailsVM.Appointment.Id).FirstOrDefault(); appointmentFromDb.CustomerName = appDetailsVM.Appointment.CustomerName; appointmentFromDb.CustomerEmail = appDetailsVM.Appointment.CustomerEmail; appointmentFromDb.CustomerPhoneNumber = appDetailsVM.Appointment.CustomerPhoneNumber; appointmentFromDb.AppointmentDate = appDetailsVM.Appointment.AppointmentDate; appointmentFromDb.IsConfirmed = appDetailsVM.Appointment.IsConfirmed; //update sales associate if super admin if (User.IsInRole(StaticDetails.SuperAdminEndUser)) { appointmentFromDb.SalesAssociateId = appDetailsVM.Appointment.SalesAssociateId; } await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(appDetailsVM)); }
public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var productList2 = (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").Include("Brand"); var productList = (IEnumerable <ProductsSelectedForAppointment>)(from p in _db.Appointments join a in _db.ProductsSelectedForAppointment on p.Id equals a.AppointmentId where a.AppointmentId == id select a); AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = _db.Appointments.Include(a => a.SalesPerson).Where(a => a.Id == id).FirstOrDefault(), SalesPerson = _db.ApplicationUser.ToList(), ProductsSelectedForAppointments = productList.ToList(), Products = productList2.ToList() }; return(View(objAppointmentVM)); }
public async Task <IActionResult> EditUpdate(int?id, AppointmentDetailsViewModel objApplointmentVM) { if (id == null) { return(NotFound()); } if (ModelState.IsValid) { var appointmentDb = await _db.Appointments.Where(a => a.ID == id).FirstOrDefaultAsync(); appointmentDb.CustomerName = objApplointmentVM.Appointment.CustomerName; appointmentDb.CustomerEmail = objApplointmentVM.Appointment.CustomerEmail; appointmentDb.CustomerPhone = objApplointmentVM.Appointment.CustomerPhone; appointmentDb.AppointmentDate = objApplointmentVM.Appointment.AppointmentDate.AddHours(objApplointmentVM.Appointment.AppointmentTime.Hour) .AddMinutes(objApplointmentVM.Appointment.AppointmentTime.Minute); appointmentDb.IsConfirmed = objApplointmentVM.Appointment.IsConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentDb.SalesPersonID = objApplointmentVM.Appointment.SalesPersonID; } await _db.SaveChangesAsync(); return(RedirectToAction("Index")); } else { return(View(objApplointmentVM)); } }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel objAppointmentVM) { if (ModelState.IsValid) { // build the date time from the two fields objAppointmentVM.Appointment.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate .AddHours(objAppointmentVM.Appointment.AppointmentTime.Hour) .AddMinutes(objAppointmentVM.Appointment.AppointmentTime.Minute); // update database with any changed fields from input appointment screen. var appointmentFromDb = _db.Appointments.Where(a => a.Id == objAppointmentVM.Appointment.Id).FirstOrDefault(); appointmentFromDb.CustomerName = objAppointmentVM.Appointment.CustomerName; appointmentFromDb.CustomerEmail = objAppointmentVM.Appointment.CustomerEmail; appointmentFromDb.CustomerPhoneNumber = objAppointmentVM.Appointment.CustomerPhoneNumber; appointmentFromDb.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate; appointmentFromDb.IsConfirmed = objAppointmentVM.Appointment.IsConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentFromDb.SalesPersonId = objAppointmentVM.Appointment.SalesPersonId; } _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } // model status not valid return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(string id, AppointmentDetailsViewModel appDetailsVM) { if (ModelState.IsValid) { appDetailsVM.Appointment.AppointmentDate = appDetailsVM.Appointment.AppointmentDate .AddHours(appDetailsVM.Appointment.AppointmentTime.Hour) .AddMinutes(appDetailsVM.Appointment.AppointmentTime.Minute); var appFromDB = await _db.Appointments .Where(p => p.Id == appDetailsVM.Appointment.Id) .FirstOrDefaultAsync(); appFromDB.CustomerName = appDetailsVM.Appointment.CustomerName; appFromDB.CustomerEmail = appDetailsVM.Appointment.CustomerEmail; appFromDB.CustomerPhoneNumber = appDetailsVM.Appointment.CustomerPhoneNumber; appFromDB.AppointmentDate = appDetailsVM.Appointment.AppointmentDate; appFromDB.isConfirmed = appDetailsVM.Appointment.isConfirmed; if (User.IsInRole(SD.AdminEndUser)) { appFromDB.SalesPersonId = appDetailsVM.Appointment.SalesPersonId; } await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(appDetailsVM)); }
// GET: AppointmentController/Details/5 public ActionResult Details(int?id) { if (id == null) { return(NotFound()); } var AppointmentProducts = db.ProductsSelectedForAppointments .Where(ap => ap.AppointmentId == id) .Include(ap => ap.Products).ThenInclude(p => p.ProductType) .Select(ap => ap.Products).ToList(); //var AppointmentProducts = (from p in db.Products // join ap in db.ProductsSelectedForAppointments // on p.Id equals ap.ProductId // where ap.AppointmentId == id // select p).Include(product => product.ProductType).ToList(); AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = db.Appointments.Include(a => a.SalesPerson).FirstOrDefault(a => a.Id == id), SalesPerson = db.ApplicationUser.ToList(), Products = AppointmentProducts.ToList() }; return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel objAppointmentVM) { if (ModelState.IsValid) { objAppointmentVM.Appointment.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate .AddHours(objAppointmentVM.Appointment.AppointmentTime.Hour) .AddMinutes(objAppointmentVM.Appointment.AppointmentTime.Minute); var appointmentFromDb = _db.Appointments.Where(a => a.Id == objAppointmentVM.Appointment.Id).FirstOrDefault(); appointmentFromDb.CustomerName = objAppointmentVM.Appointment.CustomerName; appointmentFromDb.CustomerEmail = objAppointmentVM.Appointment.CustomerEmail; appointmentFromDb.CustomerPhoneNumber = objAppointmentVM.Appointment.CustomerPhoneNumber; appointmentFromDb.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate; appointmentFromDb.isConfirmed = objAppointmentVM.Appointment.isConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentFromDb.ApplicationUserId = objAppointmentVM.Appointment.ApplicationUserId; } _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(objAppointmentVM)); }
// GET: AppointmentController/Create //public ActionResult Create() //{ // return View(); //} #endregion #region Create Post //// POST: AppointmentController/Create //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Create(IFormCollection collection) //{ // try // { // return RedirectToAction(nameof(Index)); // } // catch // { // return View(); // } //} #endregion // GET: AppointmentController/Edit/5 public async Task <ActionResult> Edit(int id) { if (id == null) { return(NotFound()); } var AppointmentProducts = db.ProductsSelectedForAppointments .Where(ap => ap.AppointmentId == id) .Include(ap => ap.Products).ThenInclude(p => p.ProductType) .Select(ap => ap.Products).ToList(); var users = db.ApplicationUser.ToList(); List <ApplicationUser> salesPersons = new List <ApplicationUser>(); foreach (var item in users) { if (await userManager.IsInRoleAsync(item, SD.AdminEndUser)) { salesPersons.Add(item); } } AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = db.Appointments.Include(a => a.SalesPerson).FirstOrDefault(a => a.Id == id), SalesPerson = salesPersons, //SalesPerson = db.ApplicationUser.ToList(), Products = AppointmentProducts.ToList() }; return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int?id) { if (id == null) { return(this.NotFound()); } Appointment currentApp = this.db.Appointments.Include(a => a.SalesPerson).FirstOrDefault(a => a.Id == id); //Unclude only non-deleted users List <ApplicationUser> salesPeople = this.db.ApplicationUsers.Where(s => s.LockoutEnd == null).ToList(); var productList = (IEnumerable <Product>)(from p in this.db.Products join a in this.db.ProductsSelectedForAppointment on p.Id equals a.ProductId where a.AppointmentId == id select p).Include("ProductTypes"); AppointmentDetailsViewModel appVM = new AppointmentDetailsViewModel() { Appointment = currentApp, SalesPeople = salesPeople, Products = productList.ToList() }; return(this.View(appVM)); }
// Po umówieniu wizyty, Pacjent przechodzi do Podsumowania wizyty - AppointmentDetails public ViewResult AppointmentDetails(int id) { AppointmentDetailsViewModel appointmentDetailsViewModel = new AppointmentDetailsViewModel() { UserID = userManager.GetUserId(User), Appointment = _appointmentRepository.GetAppointment(id), Doctor = _doctorRepository.GetDoctor(id), }; return(View(appointmentDetailsViewModel)); }
public async Task <IActionResult> Delete(int?id) { if (id == null) { return(NotFound()); } // retrieve IEnumerable of Products as List // JOIN Tables var productList = (IEnumerable <Products>)(from p in _colibriDbContext.Products join a in _colibriDbContext.ProductsSelectedForAppointment on p.Id equals a.ProductId where a.AppointmentId == id select p).Include("CategoryTypes"); var userServicesList = (IEnumerable <UserServices>)(from s in _colibriDbContext.UserServices join a in _colibriDbContext.UserServicesSelectedForAppointment on s.Id equals a.UserServiceId where a.AppointmentId == id select s).Include("CategoryTypes"); // use the ViewModel AppointmentDetailsViewModel appointmentViewModel = new AppointmentDetailsViewModel() { // retrieve the Appointment from the DB Appointment = await _colibriDbContext.Appointments .Include(a => a.AppPerson) .Where(a => a.Id == id) .FirstOrDefaultAsync(), // get the Application User List AppPerson = _colibriDbContext.ApplicationUsers.ToList(), // get the List of all Products Products = productList.ToList(), // get the List of all Services UserServices = userServicesList.ToList() }; // i18n ViewData["Delete"] = _localizer["DeleteText"]; ViewData["DeleteAppointment"] = _localizer["DeleteAppointmentText"]; ViewData["CustomerName"] = _localizer["CustomerNameText"]; ViewData["CustomerEmail"] = _localizer["CustomerEmailText"]; ViewData["CustomerPhoneNumber"] = _localizer["CustomerPhoneNumberText"]; ViewData["AppointmentDate"] = _localizer["AppointmentDateText"]; ViewData["AppointmentTime"] = _localizer["AppointmentTimeText"]; ViewData["IsConfirmed"] = _localizer["IsConfirmedText"]; ViewData["UserName"] = _localizer["UserNameText"]; ViewData["Update"] = _localizer["UpdateText"]; ViewData["BackToList"] = _localizer["BackToListText"]; // return the ViewModel return(View(appointmentViewModel)); }
public IActionResult Details(int id) { var details = _unitOfWork.appoinmentRepository.GetAppointmentWithPatients(id); _logger.LogInformation(message: "{details} all details here", details.FirstOrDefault().Patient.Name); var appo = new AppointmentDetailsViewModel { Appointment = details.FirstOrDefault() }; return(View(appo)); }
public IActionResult Invoice(int id) { var productList = (IEnumerable <ProductsSelectedForAppointment>)(from p in _db.Appointments join a in _db.ProductsSelectedForAppointment on p.Id equals a.AppointmentId where a.AppointmentId == id select a); AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = _db.Appointments.Where(a => a.Id == id).FirstOrDefault(), ProductsSelectedForAppointments = productList.ToList() }; //var model = _db.Appointments.SingleOrDefault(i=>i.Id.Equals(id)); return(View(objAppointmentVM)); }
/// <summary> /// Action methos for appointments /// an email will also be sent upon cancellation /// </summary> /// <param name="id"></param> /// <param name="objAppointmentVM"></param> /// <returns></returns> public IActionResult Cancel(int id, AppointmentDetailsViewModel objAppointmentVM) { var appointment = _db.Appointments.FirstOrDefault(a => a.Id == id); objAppointmentVM.Appointment = appointment; objAppointmentVM.Appointment.isCancelled = true; objAppointmentVM.Appointment.isConfirmed = false; _db.SaveChanges(); //await _emailSender.SendEmailAsync(_db.Users.Where(u => u.Id == claim.Value).FirstOrDefault().Email, // "Open Properties - Your Appointment", // "Your appointment was cancelled successfully"); return(RedirectToAction(nameof(Index))); }
public ActionResult CreateAppointment(int patientId, int reservationId) { _appointmentService.Create(reservationId, patientId); var patient = _patientRepo.Get(patientId); var reservation = _reservationRepo.Get(reservationId); var time = _scheduleRepo.GetTime(reservation.DoctorAppointmentDateTimeId); var model = new AppointmentDetailsViewModel { Doctor = _doctorRepo.GetDoctorDetails(time.Schedule.DoctorId), Patient = patient, Date = time.Schedule.Date, Time = _scheduleService.FormatTime(time.Time) }; return(View(model)); }
//GET : Delete public async Task <IActionResult> Delete(int?id) { if (id == null) { return(NotFound()); } var productList = (IEnumerable <Product>)(from p in _db.Products join a in _db.ProductsSelectedForAppointments on p.Id equals a.ProductId where a.AppointmentId == id select p).Include("ProductType"); AppointmentDetailsViewModel appointmentDetailsViewModel = new AppointmentDetailsViewModel() { Appointment = await _db.Appointments.Where(a => a.Id == id).Include(a => a.SalesPerson).FirstOrDefaultAsync(), SalesPersons = await _db.ApplicationUsers.ToListAsync(), Products = productList.ToList() }; return(View(appointmentDetailsViewModel)); }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel objAppointmentVM) { if (ModelState.IsValid) { objAppointmentVM.Appointment.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate .AddHours(objAppointmentVM.Appointment.AppointmentTime.Hour) .AddMinutes(objAppointmentVM.Appointment.AppointmentTime.Minute); var appointmentFromDb = _db.Appointments.Where(a => a.Id == objAppointmentVM.Appointment.Id).FirstOrDefault(); appointmentFromDb.CustomerName = objAppointmentVM.Appointment.CustomerName; appointmentFromDb.CustomerEmail = objAppointmentVM.Appointment.CustomerEmail; appointmentFromDb.AppointmentDate = objAppointmentVM.Appointment.AppointmentDate; appointmentFromDb.CustomerPhoneNumber = objAppointmentVM.Appointment.CustomerPhoneNumber; appointmentFromDb.IsConfirmed = objAppointmentVM.Appointment.IsConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentFromDb.SalesPersonId = objAppointmentVM.Appointment.SalesPersonId; } else { appointmentFromDb.SalesPersonId = ""; } _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } else { 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"); objAppointmentVM.SalesPerson = _db.ApplicationUsers.Where(u => u.LockoutEnd == null || u.LockoutEnd < DateTime.Now).ToList(); objAppointmentVM.Products = productList.ToList(); } return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } var sanhamList = (IEnumerable <ThongTinSanPham>)(from p in _db.ThongTinSanPham join a in _db.ProductsSelectedForAppointment on p.Id equals a.Id where a.AppointmentId == id select p).Include("SanPham"); AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointment = _db.Appointments.Include(a => a.NguoiBanHang).Where(a => a.Id == id).FirstOrDefault(), NguoiBanHang = _db.ApplicationUser.ToList(), SanPham = sanhamList.ToList() }; return(View(objAppointmentVM)); }
public async Task <IActionResult> Edit(int id, AppointmentDetailsViewModel objappoint) { if (ModelState.IsValid) { var appointmentfromdb = _db.Appointments.Where(a => a.Id == objappoint.Appointments.Id).FirstOrDefault(); appointmentfromdb.CustomerName = objappoint.Appointments.CustomerName; appointmentfromdb.CustomerEmail = objappoint.Appointments.CustomerEmail; appointmentfromdb.CustomerPhoneNumber = objappoint.Appointments.CustomerPhoneNumber; appointmentfromdb.AppointmentDate = objappoint.Appointments.AppointmentDate; appointmentfromdb.isConfirmed = objappoint.Appointments.isConfirmed; if (User.IsInRole(SD.SuperAdminEndUser)) { appointmentfromdb.SalesPersonId = objappoint.Appointments.SalesPersonId; } _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(objappoint)); }
//Get action method for appointment public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } var productList = (IEnumerable <Products>)(from p in _context.Products join x in _context.ProductsAppointments on p.Id equals x.ProductId where x.AppointmentId == id select p).Include("ProductTypes"); var appointmentDetailsViewModel = new AppointmentDetailsViewModel { Appointment = _context.Appointments.Include(a => a.SalesPerson).Where(z => z.Id == id).FirstOrDefault(), SalesPerson = _context.ApplicationUser.ToList(), Products = productList.ToList() }; return(View(appointmentDetailsViewModel)); }
// GET: Appointments/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var appointment = await _context.Appointment .Include(a => a.Dependent) .Include(a => a.Doctor) .SingleOrDefaultAsync(m => m.AppointmentId == id); if (appointment == null) { return(NotFound()); } var model = new AppointmentDetailsViewModel(); model.Appointment = appointment; return(View(model)); }
//Get Edit action public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } var productList = (IEnumerable <Products>)(from p in _db.Products join a in _db.ProductSelectedForAppointments on p.Id equals a.ProductsId where a.AppointmentsId == id select p).Include("ProductTypes");//this is a link method that brings the products selected by a particular appointment AppointmentDetailsViewModel objAppointmentVM = new AppointmentDetailsViewModel() { Appointments = _db.Appointments.Include(m => m.SalesPerson).Where(a => a.Id == id).FirstOrDefault(), SalesPerson = _db.ApplicationUser.ToList(), Products = productList.ToList() }; return(View(objAppointmentVM)); }
public ActionResult Edit(int id, AppointmentDetailsViewModel appointmentvm) { //try //{ //} //catch //{ // return View(); //} if (ModelState.IsValid) { appointmentvm.Appointment.AppointmentDate = appointmentvm.Appointment.AppointmentDate .AddHours(appointmentvm.Appointment.AppointmentTime.Hour) .AddMinutes(appointmentvm.Appointment.AppointmentTime.Minute); //var appointmentFromDb = db.Appointments.Where(a => a.Id == appointmentvm.Appointment.Id).FirstOrDefault(); //appointmentFromDb.CustomerName = appointmentvm.Appointment.CustomerName; //appointmentFromDb.CustomerEmail = appointmentvm.Appointment.CustomerEmail; //appointmentFromDb.CustomerPhoneNumber = appointmentvm.Appointment.CustomerPhoneNumber; //appointmentFromDb.AppointmentDate = appointmentvm.Appointment.AppointmentDate; //appointmentFromDb.isConfirmed = appointmentvm.Appointment.isConfirmed; ////if (User.IsInRole(SD.SuperAdminEndUser)) ////{ // appointmentFromDb.SalesPersonId = appointmentvm.Appointment.SalesPersonId; //} db.Entry <Appointment>(appointmentvm.Appointment).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(appointmentvm)); }
//GET Detials public async Task <IActionResult> Details(string id) { if (string.IsNullOrEmpty(id)) { 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"); AppointmentDetailsViewModel appDetailsVM = new AppointmentDetailsViewModel() { Appointment = await _db.Appointments.Include(a => a.SalesPerson).Where(a => a.Id == id).FirstOrDefaultAsync(), SalesPerson = await _db.ApplicationUser.ToListAsync(), Products = productList.ToList() }; return(View(appDetailsVM)); }
public AppointmentDetailsView( AppointmentDetailsViewModel appointmentDetailsViewModel ) : this() { DataContext = appointmentDetailsViewModel; }