public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
//Override values for created by and date
Address.CreatedDate = DateTime.Now;
Address.CreatedBy = Identity.GetUserId(User, _context);
_context.Address.Add(Address);
await _context.SaveChangesAsync();
await Audit.AddAuditRecord(_context, 'C', "Address", "AddressID", Address.AddressID, Identity.GetUserId(User, _context), "Address Created");
//return RedirectToPage("./Index");
JObject jsonItem = JObject.FromObject(Address);
//objectID added for form.js
jsonItem.Add("objectID", Address.AddressID);
return(Content(jsonItem.ToString(), "application/json"));
//return new JsonResult(Address);
}
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
_context.Attach(AuditTrail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AuditTrailExists(AuditTrail.AuditTrailID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
//Original details
var originalAddress = await _context.Address
.AsNoTracking()
.FirstOrDefaultAsync(a => a.AddressID == Address.AddressID);
_context.Attach(Address).State = EntityState.Modified;
//Override values for updated by and date
Address.CreatedBy = originalAddress.CreatedBy;
Address.CreatedDate = originalAddress.CreatedDate;
Address.UpdatedDate = DateTime.Now;
Address.UpdatedBy = Shared.Identity.GetUserId(User, _context);
var customerToUpdate = await _context.Customer
.Include(c => c.Address)
.FirstOrDefaultAsync(c => c.CustomerID == Address.CustomerID);
try
{
UpdateCustomerPrimaryAddress(_context, Address, customerToUpdate);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AddressExists(Address.AddressID))
{
return(NotFound());
}
else
{
throw;
}
}
object originalObj = new object();
originalObj = originalAddress;
object newObj = new object();
newObj = Address;
string changes = Shared.Audit.WhatChanged(originalObj, newObj, "");
await Shared.Audit.AddAuditRecord(_context, 'E', "Address", "AddressID", Address.AddressID, Shared.Identity.GetUserId(User, _context), changes);
//return RedirectToPage("./Index");
return(new JsonResult(Address));
}
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
_context.AuditTrail.Add(AuditTrail);
await _context.SaveChangesAsync();
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AuditTrail = await _context.AuditTrail.FindAsync(id);
if (AuditTrail != null)
{
_context.AuditTrail.Remove(AuditTrail);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Note = await _context.Note.FindAsync(id);
if (Note != null)
{
_context.Note.Remove(Note);
await _context.SaveChangesAsync();
await Shared.Audit.AddAuditRecord(_context, 'D', "Note", "NoteID", Note.NoteID, Shared.Identity.GetUserId(User, _context), "Note Deleted: Note: " + Note.NoteText);
}
//return RedirectToPage("./Index");
return(new JsonResult(Note));
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Customer = await _context.Customer.FindAsync(id);
if (Customer != null)
{
_context.Customer.Remove(Customer);
await _context.SaveChangesAsync();
await Shared.Audit.AddAuditRecord(_context, 'D', "Customer", "CustomerID", Customer.CustomerID, Shared.Identity.GetUserId(User, _context), "Customer Deleted: Forename: " + Customer.Forename + ", Surname: " + Customer.Surname);
}
//return RedirectToPage("./Index");
return(new JsonResult(Customer));
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Address = await _context.Address.FindAsync(id);
if (Address != null)
{
_context.Address.Remove(Address);
await _context.SaveChangesAsync();
await Shared.Audit.AddAuditRecord(_context, 'D', "Address", "AddressID", Address.AddressID, Shared.Identity.GetUserId(User, _context), "Address Deleted: Address1: " + Address.Address1 + ", Post Code: " + Address.PostcodeOut + " " + Address.PostcodeIn);
}
//return RedirectToPage("./Index");
return(new JsonResult(Address));
}
public async Task <IActionResult> OnPostAsync(string[] selectedAreas)
{
if (!ModelState.IsValid)
{
return(Page());
}
//Override values for created by and date
Customer.CreatedDate = DateTime.Now;
Customer.CreatedBy = Identity.GetUserId(User, _context);
if (selectedAreas != null)
{
Customer.CustomerArea = new List <CustomerArea>();
foreach (var area in selectedAreas)
{
var areaToAdd = new CustomerArea
{
AreaID = int.Parse(area)
};
Customer.CustomerArea.Add(areaToAdd);
}
}
_context.Customer.Add(Customer);
await _context.SaveChangesAsync();
await Audit.AddAuditRecord(_context, 'C', "Customer", "CustomerID", Customer.CustomerID, Identity.GetUserId(User, _context), "Customer Created");
//return RedirectToPage("./Index");
JObject jsonItem = JObject.FromObject(Customer);
//objectID added for form.js
jsonItem.Add("objectID", Customer.CustomerID);
return(Content(jsonItem.ToString(), "application/json"));
//return new JsonResult(Customer);
}
public async Task <IActionResult> OnPostAsync(int?id, string[] selectedAreas)
{
if (!ModelState.IsValid)
{
return(Page());
}
//Original details
var originalCustomer = await _context.Customer
.Include(c => c.CustomerArea)
.ThenInclude(c => c.Area)
.AsNoTracking()
.FirstOrDefaultAsync(c => c.CustomerID == id);
_context.Attach(Customer).State = EntityState.Modified;
//Override values for updated by and date
Customer.CreatedBy = originalCustomer.CreatedBy;
Customer.CreatedDate = originalCustomer.CreatedDate;
Customer.UpdatedDate = DateTime.Now;
Customer.UpdatedBy = Identity.GetUserId(User, _context);
var customerToUpdate = await _context.Customer
.Include(c => c.CustomerArea)
.ThenInclude(c => c.Area)
.FirstOrDefaultAsync(c => c.CustomerID == id);
try
{
UpdateCustomerAreas(_context, selectedAreas, customerToUpdate);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(customerToUpdate.CustomerID))
{
return(NotFound());
}
else
{
throw;
}
}
object originalCustomerObj = new object();
originalCustomerObj = originalCustomer;
object newCustomerObj = new object();
newCustomerObj = customerToUpdate;
object originalCustomerAreasObj = new object();
originalCustomerAreasObj = originalCustomer.CustomerArea;
object newCustomerAreasObj = new object();
newCustomerAreasObj = customerToUpdate.CustomerArea;
string changes = "";
changes = Audit.WhatChanged(originalCustomerObj, newCustomerObj, changes);
changes = Audit.ElementsChanged(originalCustomerAreasObj, newCustomerAreasObj, "AreaID", changes);
await Audit.AddAuditRecord(_context, 'E', "Customer", "CustomerID", Customer.CustomerID, Identity.GetUserId(User, _context), changes);
//return RedirectToPage("./Index");
return(new JsonResult(Customer));
}