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));
}
