public JsonResponse Create(User user)
 {
     if (user == null)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Create requires an instance of User"
         }
     }
     ;
     if (!ModelState.IsValid)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Model state is invalid. See data.",
                    Error   = ModelState
         }
     }
     ;
     db.Users.Add(user);
     db.SaveChanges();
     return(new JsonResponse {
         Message = "Create successful.",
         Data = user
     });
 }
 public JsonResponse Create(Product product)
 {
     if (product == null)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Create requires an instance of Product"
         }
     }
     ;
     if (!ModelState.IsValid)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Model state is invalid. See data.",
                    Error   = ModelState
         }
     }
     ;
     db.Products.Add(product);
     db.SaveChanges();
     return(new JsonResponse {
         Message = "Create successful.",
         Data = product
     });
 }
        //CALCULATES LINE ITEM TOTAL
        private void RecalcLineItemTotal(int purchaseRequestId)
        {
            var pr = db.PurchaseRequests.Find(purchaseRequestId);

            if (pr == null)
            {
                return;
            }
            var lines = db.PurchaseRequestLineItems
                        .Where(li => li.PurchaseRequestId == purchaseRequestId);

            pr.Total = lines.Sum(li => li.Quantity * li.Product.Price);
            db.SaveChanges();
        }