public async Task <ActionResult <VaultOrder> > PostVaultOrder(VaultOrder vaultOrder) { _context.VaultOrder.Add(vaultOrder); await _context.SaveChangesAsync(); return(CreatedAtAction("GetVaultOrder", new { id = vaultOrder.VaultOrderId }, vaultOrder)); }
public async Task <IActionResult> PutVaultOrder(int id, VaultOrder vaultOrder) { if (id != vaultOrder.VaultOrderId) { return(BadRequest()); } _context.Entry(vaultOrder).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!VaultOrderExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Create([Bind("VaultOrderId,strFuneralDate,FuneralDate," + "CemetaryTime,strCemeteryTime,Location,GraveLocationSection,OrderingPlantId," + "OrderingPlantName,DeliveringPlantId,DeliveringPlantName,ZipCode,FuneralHomeId," + "NewFuneralHome,FuneralDirector,NewFuneralDirector,CemetaryId,Status,Category,VaultId," + "VenetianCarapace,TentWith6Chairs,ExtraChairs,RegisterStand,MilitarySetup,AwningOverCasket," + "Fdrequest,VaultOrderNotes,PlantId,ContactId," + "Salutation,FirstName,MiddleName,LastName,FullName,Suffix,BornDate,DiedDate")] VaultOrder vaultOrder) { if (ModelState.IsValid) { if (vaultOrder.OrderingPlantId != 0) { var ordPlant = new Plant(); ordPlant = await _context.Plants.FindAsync(vaultOrder.OrderingPlantId); vaultOrder.OrderingPlantName = ordPlant.PlantName; } if (vaultOrder.DeliveringPlantId != 0) { var delPlant = new Plant(); delPlant = await _context.Plants.FindAsync(vaultOrder.DeliveringPlantId); vaultOrder.DeliveringPlantName = delPlant.PlantName; } if (vaultOrder.FuneralHomeId != 0) { vaultOrder.funeralhome = (from f in _context.FuneralHomes.Where(i => i.FuneralHomeId == vaultOrder.FuneralHomeId) select f.Name).FirstOrDefault(); } if (vaultOrder.FuneralHomeContactId != 0) { vaultOrder.FuneralDirector = (from f in _context.FuneralHomeContacts.Where(i => i.FuneralHomeContactId == vaultOrder.FuneralHomeContactId) select f.FullName).FirstOrDefault(); } _context.Add(vaultOrder); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(vaultOrder)); }
public async Task <IActionResult> Edit(int id, [Bind("VaultOrderId,strFuneralDate,FuneralDate," + "CemetaryTime,strCemeteryTime,Location,GraveLocationSection,OrderingPlantId," + "OrderingPlantName,DeliveringPlantId,DeliveringPlantName,ZipCode,FuneralHomeId," + "FuneralHomeContactId,FuneralDirector,NewFuneralDirector,CemetaryId,Status,Category,VaultId," + "VenetianCarapace,TentWith6Chairs,ExtraChairs,RegisterStand,MilitarySetup,AwningOverCasket," + "Fdrequest,VaultOrderNotes,PlantId,ContactId," + "Salutation,FirstName,MiddleName,LastName,FullName,Suffix,BornDate,DiedDate")] VaultOrder vaultOrder) { if (id != vaultOrder.VaultOrderId) { return(NotFound()); } if (ModelState.IsValid) { if (vaultOrder.OrderingPlantId != 0) { var ordPlant = new Plant(); ordPlant = await _context.Plants.FindAsync(vaultOrder.OrderingPlantId); vaultOrder.OrderingPlantName = ordPlant.PlantName; } if (vaultOrder.DeliveringPlantId != 0) { var delPlant = new Plant(); delPlant = await _context.Plants.FindAsync(vaultOrder.DeliveringPlantId); vaultOrder.DeliveringPlantName = delPlant.PlantName; } if (vaultOrder.FuneralHomeId != 0) { vaultOrder.funeralhome = (from f in _context.FuneralHomes.Where(i => i.FuneralHomeId == vaultOrder.FuneralHomeId) select f.Name).FirstOrDefault(); } if (vaultOrder.FuneralHomeContactId != 0) { vaultOrder.FuneralDirector = (from f in _context.FuneralHomeContacts.Where(i => i.FuneralHomeContactId == vaultOrder.FuneralHomeContactId) select f.FullName).FirstOrDefault(); } try { _context.Update(vaultOrder); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!VaultOrderExists(vaultOrder.VaultOrderId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["FuneralHomeId"] = new SelectList(_context.FuneralHomes, "FuneralHomeId", "FuneralHomeId", vaultOrder.FuneralHomeId); return(View(vaultOrder)); }
// GET: VaultOrders/Create // GET: VaultOrders/Create public IActionResult Create() { var VO = new VaultOrder(); var dateNow = DateTime.Now; VO.FuneralDate = DateTime.Now; VO.CemetaryTime = DateTime.Now; VO.BornDate = DateTime.Now; VO.DiedDate = DateTime.Now; //Ordering plant List <Plant> lstPlants = _context.Plants.ToList(); VO.OrderingPlant.Add(new Plant() { PlantName = "-Select-", PlantId = 0 }); foreach (var item in lstPlants) { VO.OrderingPlant.Add(new Plant() { PlantName = item.PlantName, PlantId = item.PlantId }); } //Delivering plant VO.DeliveringPlant.Add(new Plant() { PlantName = "-Select-", PlantId = 0 }); foreach (var item in lstPlants) { VO.DeliveringPlant.Add(new Plant() { PlantName = item.PlantName, PlantId = item.PlantId }); } //Funeral Home var fhs = _context.FuneralHomes.ToList().OrderBy(fh => fh.Name); VO.FuneralHomes.Add(new FuneralHome() { Name = "-Select-", FuneralHomeId = 0 }); foreach (var item in fhs) { VO.FuneralHomes.Add(new FuneralHome() { Name = item.Name, FuneralHomeId = item.FuneralHomeId }); } //Funeral Home Contact (Funeral Director). TODO: Take the id of the selected funeral home and look up the contacts who are funeral directors and put them //in the select list List <FuneralHomeContact> fhcts = _context.FuneralHomeContacts.ToList(); VO.Contacts.Add(new FuneralHomeContact() { FullName = "-Select-", FuneralHomeContactId = 0 }); foreach (var item in fhcts) { VO.Contacts.Add(new FuneralHomeContact() { FullName = item.FullName, FuneralHomeContactId = item.FuneralHomeContactId }); } //Cemetery List <Cemetary> cems = _context.Cemetary.ToList(); VO.lstCemetaries.Add(new Cemetary() { Name = "-Select-", CemetaryId = 0 }); foreach (var item in cems) { VO.lstCemetaries.Add(new Cemetary { Name = item.Name, CemetaryId = item.CemetaryId }); } return(View(VO)); }