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