public static bool Insert(Users user)
{
if (user == null)
{
throw new Exception("User must not be null!");
}
user.Id = 0;
context.Users.Add(user);
return(context.SaveChanges() == 1);
}
public static bool Insert(Products product)
{
if (product == null)
{
throw new Exception("Product cannot be null!");
}
product.Id = 0;
context.Products.Add(product);
return(context.SaveChanges() == 1);
}
public static bool Insert(Requests request)
{
if (request == null)
{
throw new Exception("Request must not be null!");
}
request.Id = 0;
context.Requests.Add(request);
return(context.SaveChanges() == 1);
}
public static bool Insert(Vendors vendor)
{
if (vendor == null)
{
throw new Exception("Vendor cannot be null!");
}
vendor.Id = 0;
context.Vendors.Add(vendor);
return(context.SaveChanges() == 1);
}
public static bool Insert(RequestLines requestline)
{
if (requestline == null)
{
throw new Exception("Request line cannot be null!");
}
context.RequestLines.Add(requestline);
RecalcReqTotal(requestline.Id);
return(context.SaveChanges() == 1);
}
public async Task <ActionResult <IEnumerable <Requests> > > GetRequests()
{
var requests = await _context.Requests.ToListAsync();
foreach (var item in requests)
{
RecalcuateRequestTotal(item.Id);
}
_context.SaveChanges();
return(requests);
}
// Try Catch exception message for SaveChanges()
private ActionResult TrySave(string actionResult)
{
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
}
return(Json(new JsonMessage("Success", "Purchase Request Line Item was " + actionResult)));
}
public async Task <ActionResult <Request> > SetStatusToReview(int id)
{
var request = await _context.Requests.FindAsync(id);
if (request == null)
{
return(NotFound());
}
request.Status = "REVIEW";
_context.Requests.Update(request);
_context.SaveChanges();
return(request);
}
private static void AttemptToSave()
{
try {
context.SaveChanges();
} catch (Exception) {
throw;
}
}
private static void AttemptToSave()
{
try {
context.SaveChanges();
} catch (DbUpdateException ex) {
throw new Exception("Username must be unique.", ex);
} catch (Exception) {
throw;
}
}
private bool RecalcuateRequestTotal(int requestId)
{
var request = _context.Requests.SingleOrDefault(r => r.Id == requestId);
if (request == null)
{
return(false);
}
request.Total = _context.RequestLines.Include(l => l.Product)
.Where(l => l.RequestId == requestId)
.Sum(l => l.Quantity * l.Product.Price);
_context.SaveChanges();
return(true);
}
