Exemple #1
0
    public ActionResult Update(PurchaseRequestLineItem purchaseRequestLineItem)
    {
        if (purchaseRequestLineItem == null)
        {
            return(BadRequest(new Msg {
                Result = "Error", Message = "Update: prli cannot be null."
            }));
        }

        PurchaseRequestLineItem?dbPurchaseRequest = _dbContext.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id);

        if (dbPurchaseRequest == null)
        {
            return(BadRequest(new Msg {
                Result = "Error", Message = $"Update: invalid id: {purchaseRequestLineItem.Id}"
            }));
        }
        dbPurchaseRequest.Copy(purchaseRequestLineItem);

        int numChanges = 0;

        if (ModelState.IsValid)
        {
            numChanges = _dbContext.SaveChanges();
            UpdateTotal(purchaseRequestLineItem.PurchaseRequestId);
            return(Ok(new Msg {
                Result = "Success", Message = $"{numChanges} record(s) updated."
            }));
        }

        return(BadRequest(new Msg {
            Result = "Error", Message = $"ModelState invalid; {numChanges} record(s) updated."
        }));
    }
        public JsonResponse Remove(PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem == null)
            {
                return(new JsonResponse {
                    Result = "Failed",
                    Message = "Create requires an instance of PurchaseRequestLineItem"
                });
            }
            if (!ModelState.IsValid)
            {
                return(new JsonResponse {
                    Result = "Failed",
                    Message = "Model state is invalid. See data.",
                    Error = ModelState
                });
            }
            db.Entry(purchaseRequestLineItem).State = System.Data.Entity.EntityState.Deleted;
            db.SaveChanges();

            RecalcLineItemTotal(purchaseRequestLineItem.PurchaseRequestId);
            return(new JsonResponse {
                Message = "Remove successful.",
                Data = purchaseRequestLineItem
            });
        }
Exemple #3
0
        public ActionResult Remove(PurchaseRequestLineItem prli)
        {
            PurchaseRequestLineItem existingPRLI = db.PurchaseRequestLineItems.Find(prli.Id);

            if (existingPRLI == null)
            {
                return(Failure("Unable to locate Purchase Request line item ID."));
            }

            int id = existingPRLI.PurchaseRequestID;

            db.PurchaseRequestLineItems.Remove(existingPRLI);

            if (!Save())
            {
                return(BadSaveResult());
            }

            UpdateTotalForPurchaseRequest(id);

            if (!Save())
            {
                return(BadSaveResult());
            }

            return(Success("Removed Purchase Request line item id " + prli.Id));
        }
 public JSONResponse Create(PurchaseRequestLineItem purchaserequestlineitem)
 {
     if (purchaserequestlineitem == null)
     {
         return(new JSONResponse {
             Result = "failed",
             Message = "Failed to create becasue null"
         });
     }
     if (!ModelState.IsValid)
     {
         return(new JSONResponse {
             Result = "failed",
             Message = "Model state is invalid, see error",
             Error = ModelState
         });
     }
     purchaserequestlineitem.Product         = null;
     purchaserequestlineitem.PurchaseRequest = null;
     db.PurchaseRequestLineItems.Add(purchaserequestlineitem);
     db.SaveChanges();
     return(new JSONResponse {
         Message = "Success",
         Data = purchaserequestlineitem
     });
 }
 public JsonResponse Change(PurchaseRequestLineItem purchaseRequestLineItem)
 {
     if (purchaseRequestLineItem == null)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Change requires an instance of PurchaseRequestLineItem"
         }
     }
     ;
     if (!ModelState.IsValid)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Model state is invalid. See data.",
                    Error   = ModelState
         }
     }
     ;
     db.Entry(purchaseRequestLineItem).State = System.Data.Entity.EntityState.Modified;
     db.SaveChanges();
     return(new JsonResponse {
         Message = "Change successful.",
         Data = purchaseRequestLineItem
     });
 }
        // [POST] /PurchaseRequestLineItems/Create
        public ActionResult Create([FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem.Quantity == 0)
            {
                return(new EmptyResult());
            }
            if (!ModelState.IsValid)
            {
                return(Js(new JsonMessage("Failure", "ModelState is not valid")));
            }
            db.PurchaseRequestLineItems.Add(purchaseRequestLineItem);

            try
            {
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
            }

            CalculateTotal(purchaseRequestLineItem);

            db.SaveChanges();

            return(Json(new JsonMessage("Success", "Purchase Request Line Item was created")));
        }
Exemple #7
0
        //Returns a specific, valid purchaserequestlineitem
        public ActionResult Get(int?id)
        {
            //If the id is a null value, return an error message saying so
            if (id == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Id is null."
                }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                //The id was not null, time to set up a purchaserequestlineitem variable
                PurchaseRequestLineItem purchaserequestlineitem = db.PurchaseRequestLineItems.Find(id);

                //If the id used for the purchaserequestlineitem variable is incorrect, return an error message saying so
                if (purchaserequestlineitem == null)
                {
                    return(Json(new Msg {
                        Result = "Failure", Message = $"The entered id, {id}, was not found."
                    }, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    //Now that we have made it past the if checks, let's return the purchaserequestlineitem
                    //return Json(purchaserequestlineitem, JsonRequestBehavior.AllowGet);
                    return(new JsonNetResult {
                        Data = purchaserequestlineitem
                    });
                }
            }
        }
        // [POST] /PurchaseRequestLineItems/Change
        public ActionResult Change([FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem.Quantity == 0)
            {
                return(new EmptyResult());
            }

            PurchaseRequestLineItem tempPurchaseRequestLineItem = db.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id);

            if (tempPurchaseRequestLineItem == null)
            {
                return(Js(new JsonMessage("Failure", "Record of Purchase Request Line Item to be changed does not exist")));
            }
            tempPurchaseRequestLineItem.PurchaseRequestId = purchaseRequestLineItem.PurchaseRequestId;
            tempPurchaseRequestLineItem.ProductId         = purchaseRequestLineItem.ProductId;
            tempPurchaseRequestLineItem.Quantity          = purchaseRequestLineItem.Quantity;

            try
            {
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
            }

            CalculateTotal(tempPurchaseRequestLineItem);

            return(TrySave("changed."));
        }
Exemple #9
0
        public ActionResult Add([FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Parameter is missing or invalid"
                }, JsonRequestBehavior.AllowGet));
            }
            PurchaseRequest purchaseRequest = db.PurchaseRequests.Find(purchaseRequestLineItem.PurchaseRequestId);

            if (purchaseRequest == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "PurchaseRequest Id not found"
                }, JsonRequestBehavior.AllowGet));
            }
            Product product = db.Products.Find(purchaseRequestLineItem.ProductId);

            if (product == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "ProductId not found"
                }, JsonRequestBehavior.AllowGet));
            }
            db.PurchaseRequestLineItems.Add(purchaseRequestLineItem);
            db.SaveChanges();
            UpdatePurchaseRequestTotal(purchaseRequestLineItem.PurchaseRequestId);
            return(Json(new Msg {
                Result = "Success", Message = "Add successful"
            }, JsonRequestBehavior.AllowGet));
        }
        // /PurchaseRequestLineItems/Remove/# [POST]
        public ActionResult Remove([FromBody] PurchaseRequestLineItem prli)
        {
            if (prli.Product == null)
            {
                return(new EmptyResult());
            }
            PurchaseRequestLineItem prli2 = db.PurchaseRequestLineItems.Find(prli.Id);

            db.PurchaseRequestLineItems.Remove(prli2);
            prli2.Quantity = 0;
            TotalCalculationv2(prli.Id);

            try
            {
                db.SaveChanges();
                TotalCalculationv2(prli.Id);
            }
            catch (Exception ex)
            {
                return(new JsonNetResult {
                    Data = new Msg {
                        Result = "Failed", Message = ex.Message
                    }
                });
            }

            return(new JsonNetResult {
                Data = new Msg {
                    Result = "Success", Message = "Removed."
                }
            });
        }
        public ActionResult Add([FromBody] PurchaseRequestLineItem purchaseRequestLineItem) //use FromBody instead of bind - install Microsoft.aspnet.webapi.core in PM
        {
            if (purchaseRequestLineItem == null)                                            //error if nothing is passed in for purchase request line item
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Parameter is missing or invalid"
                }, JsonRequestBehavior.AllowGet));
            }
            //**Foreign key issue:
            PurchaseRequest purchaseRequest = db.PurchaseRequests.Find(purchaseRequestLineItem.PurchaseRequestId); //returns a user for the ID or null if not found

            if (purchaseRequest == null)                                                                           //this is true if the id is not found
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "PurchaseRequest Id not found"
                }, JsonRequestBehavior.AllowGet));
            }
            Product product = db.Products.Find(purchaseRequestLineItem.ProductId);

            if (product == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "ProductId not found"
                }, JsonRequestBehavior.AllowGet));
            }

            //if we get here, just add the purchase request
            db.PurchaseRequestLineItems.Add(purchaseRequestLineItem);
            db.SaveChanges(); //actually makes the data persistent in the database
            UpdatePurchaseRequestTotal(purchaseRequestLineItem.PurchaseRequestId);
            return(Json(new Msg {
                Result = "Success", Message = "Add successful"
            }, JsonRequestBehavior.AllowGet));
        }
        // /PurchasRequestLineItems/Change/# [POST]
        public ActionResult Change([FromBody] PurchaseRequestLineItem prli)
        {
            if (prli.Product == null)
            {
                return(new EmptyResult());
            }
            PurchaseRequestLineItem prli2 = db.PurchaseRequestLineItems.Find(prli.Id);

            prli2.PurchaseRequestId = prli.PurchaseRequestId;
            prli2.ProductId         = prli.ProductId;
            prli2.Quantity          = prli.Quantity;
            prli2.Active            = prli.Active;
            //prli2.DateUpdated = DateTime.Now;
            try
            {
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                return(new JsonNetResult {
                    Data = new Msg {
                        Result = "Failed", Message = ex.Message
                    }
                });
            }
            TotalCalculationv2(prli.Id);
            return(new JsonNetResult {
                Data = new Msg {
                    Result = "Success", Message = "Changed."
                }
            });
        }
Exemple #13
0
        public ActionResult Update(PurchaseRequestLineItem prli)
        {
            PurchaseRequestLineItem oldPRLI = db.PurchaseRequestLineItems.Find(prli.Id);

            if (prli == null)
            {
                return(Failure("Unable to find this Purchase Request line item ID"));
            }

            int id = oldPRLI.ProductID;

            oldPRLI.Copy(prli);
            oldPRLI.UpdateTime();

            if (!Save())
            {
                return(BadSaveResult());
            }

            UpdateTotalForPurchaseRequest(id);

            if (!Save())
            {
                return(BadSaveResult());
            }

            return(Success("Succesfully changed Purchase Request line item id " + prli.Id));
        }
 public JsonResponse Create(PurchaseRequestLineItem purchaseRequestLineItem)
 {
     if (purchaseRequestLineItem == null)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Create requires an instance of PurchaseRequestLineItem"
         }
     }
     ;
     if (!ModelState.IsValid)
     {
         return new JsonResponse {
                    Result  = "Failed",
                    Message = "Model state is invalid. See data.",
                    Error   = ModelState
         }
     }
     ;
     db.PurchaseRequestLineItems.Add(purchaseRequestLineItem);
     db.SaveChanges();
     return(new JsonResponse {
         Message = "Create successful.",
         Data = purchaseRequestLineItem
     });
 }
Exemple #15
0
        //PurchaseRequestLineItems/Remove
        public ActionResult Remove([FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem.Product == null)
            {
                return(new EmptyResult());
            }
            PurchaseRequestLineItem purchaseRequestLineItem2 = db.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id);

            db.PurchaseRequestLineItems.Remove(purchaseRequestLineItem2);
            try
            {
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                return(new JsonNetResult {
                    Data = new JsonMessage("Failure", ex.Message)
                });
            }
            UpdateTotal(purchaseRequestLineItem.PurchaseRequestId);

            return(new JsonNetResult {
                Data = new JsonMessage("Success", "Purchase Request line item " + purchaseRequestLineItem2.Id + " was deleted successfully")
            });

            ;
        }
Exemple #16
0
        // PurchaseRequestLineItem/Change [POST]
        public ActionResult Change([System.Web.Http.FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem.Quantity == 0)
            {
                return(new EmptyResult());
            }
            PurchaseRequestLineItem purchaseRequestLineItem2 = db.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id);

            purchaseRequestLineItem2.PurchaseRequestId = purchaseRequestLineItem.PurchaseRequestId;
            purchaseRequestLineItem2.ProductId         = purchaseRequestLineItem.ProductId;
            purchaseRequestLineItem2.Quantity          = purchaseRequestLineItem.Quantity;
            purchaseRequestLineItem2.Active            = purchaseRequestLineItem.Active;
            //purchaseRequestLineItem2.DateCreated = purchaseRequestLineItem.DateCreated;
            purchaseRequestLineItem2.DateUpdated   = purchaseRequestLineItem.DateUpdated;
            purchaseRequestLineItem2.UpdatedByUser = purchaseRequestLineItem.UpdatedByUser;
            try
            {
                db.SaveChanges();
                CalculatePurchaseRequestTotal(purchaseRequestLineItem.PurchaseRequestId);
            }
            catch (Exception ex)
            {
                return(Json(new JsonMessage("Failure", ex.Message), JsonRequestBehavior.AllowGet));
            }
            return(Json(new JsonMessage("Success", "PurchaseRequestLineItem was changed.")));
        }
Exemple #17
0
        //PurchaseRequestLineItems/Get/2
        public ActionResult Get(int?id)
        {
            if (id == null)
            {
                return(new JsonNetResult {
                    Data = new JsonMessage("Failure", "Id is null")
                });
            }
            PurchaseRequestLineItem purchaseRequestLineItem = db.PurchaseRequestLineItems.Find(id);

            if (purchaseRequestLineItem == null)
            {
                return(new JsonNetResult {
                    Data = new JsonMessage("Failure", "Id is not found")
                });
            }
            UpdateTotal(purchaseRequestLineItem.PurchaseRequestId);



            //return Json(purchaseRequestLineItem, JsonRequestBehavior.AllowGet);
            return(new JsonNetResult {
                Data = purchaseRequestLineItem
            });
        }
Exemple #18
0
        //To maintain consistency with the above methods, we are going to pass in the whole
        //purchaserequestlineitem (instead of just the purchaserequestlineitem.Id, which is all we really need to delete).
        public ActionResult Remove([FromBody] PurchaseRequestLineItem purchaserequestlineitem)
        {
            //This being a way of deleting information, we do not care about the UserName
            //like we did in the above methods, so let's make sure that the PurchaseRequestLineItem.Id is valid.
            if (purchaserequestlineitem == null || purchaserequestlineitem.Id <= 0)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "The entered purchase request line item was invalid."
                }, JsonRequestBehavior.AllowGet));
            }

            //As with the Change(), we want to make sure entity framework is keeping
            //track of the purchaserequestlineitem we want to delete (and we do just want the Id here).
            PurchaseRequestLineItem temppurchaserequestlineitem = db.PurchaseRequestLineItems.Find(purchaserequestlineitem.Id);

            if (temppurchaserequestlineitem == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "The entered purchase request line item was invalid."
                }, JsonRequestBehavior.AllowGet));
            }

            //Time to save the changes, and remove that purchaserequestlineitem!
            db.PurchaseRequestLineItems.Remove(temppurchaserequestlineitem);
            db.SaveChanges();

            //Ok, we removed the item(s), let's Calculate the Total.
            CalcuateTotal(purchaserequestlineitem.PurchaseRequestId);
            return(Json(new Msg {
                Result = "Success", Message = "The entered purchase request line item was removed from the table."
            }, JsonRequestBehavior.AllowGet));
        }
 // /PurchaseRequestLineItems/Create [POST]
 public ActionResult Create([FromBody] PurchaseRequestLineItem prli)
 {
     //prli.DateCreated = DateTime.Now; // date created
     //prli.DateUpdated = DateTime.Now; // updated
     if (!ModelState.IsValid)
     {
         return(new JsonNetResult {
             Data = new Msg {
                 Result = "Failed", Message = "ModelState invalid.", Data = ModelState
             }
         });
     }
     db.PurchaseRequestLineItems.Add(prli);
     try
     {
         db.SaveChanges();
         TotalCalculationv2(prli.Id);
     }
     catch (Exception ex)
     {
         return(new JsonNetResult {
             Data = new Msg {
                 Result = "Failed", Message = ex.Message
             }
         });
     }
     return(Json(new JsonMessage("Sucess", "PRLI was created.")));
 }
Exemple #20
0
        public ActionResult Create(PurchaseRequestLineItem prli)
        {
            prli.DateCreated = DateTime.UtcNow;
            prli.UpdateTime();
            PurchaseRequestLineItem newPRLI = db.PurchaseRequestLineItems.Add(prli);

            if (newPRLI == null)
            {
                return(Failure("Unable to create new product."));
            }

            int newid = newPRLI.Id;
            int id    = newPRLI.PurchaseRequestID;

            if (!Save())
            {
                return(BadSaveResult());
            }

            UpdateTotalForPurchaseRequest(id);

            if (!Save())
            {
                return(BadSaveResult());
            }
            return(Success("New Purchase Request line item created."));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            PurchaseRequestLineItem purchaseRequestLineItem = db.PurchaseRequestLineItems.Find(id);

            db.PurchaseRequestLineItems.Remove(purchaseRequestLineItem);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public void Copy(PurchaseRequestLineItem lineItem)
 {
     Id = lineItem.Id;
     PurchaseRequestId = lineItem.PurchaseRequestId;
     ProductId         = lineItem.ProductId;
     Quantity          = lineItem.Quantity;
     IsFulfilled       = lineItem.IsFulfilled;
 }
        //TODO: Compound Linq statement in place of foreach loop
        public decimal CalculateTotal(PurchaseRequestLineItem prli)
        {
            db = new PRSDbContext(); // refresh the context
            var purchaseRequest = db.PurchaseRequests.Find(prli.PurchaseRequestId);

            purchaseRequest.Total = purchaseRequest.PurchaseRequestLineItems.Sum(p => p.Product.Price * p.Quantity); // Using the virtual List<PurchaseRequestLineItems> we don't need a .Where(linq expression)

            return(purchaseRequest.Total);
        }
Exemple #24
0
 public ActionResult Edit([Bind(Include = "Id,PurchaseRequestId,ProductId,Quantity")] PurchaseRequestLineItem purchaseRequestLineItem)
 {
     if (ModelState.IsValid)
     {
         db.Entry(purchaseRequestLineItem).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(purchaseRequestLineItem));
 }
 public ActionResult Edit([Bind(Include = "Id,Quantity,PurhaseRequestId,ProductId")] PurchaseRequestLineItem purchaseRequestLineItem)
 {
     if (ModelState.IsValid)
     {
         db.Entry(purchaseRequestLineItem).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ProductId = new SelectList(db.Products, "Id", "VendorPartNumber", purchaseRequestLineItem.ProductId);
     return(View(purchaseRequestLineItem));
 }
Exemple #26
0
        public ActionResult Create([Bind(Include = "Id,PurchaseRequestId,ProductId,Quantity")] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (ModelState.IsValid)
            {
                db.PurchaseRequestLineItems.Add(purchaseRequestLineItem);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(purchaseRequestLineItem));
        }
        //Total Calculation Function
        public void TotalCalculation(int id)
        {
            Product                 product = new Product();                        // new product
            PurchaseRequest         pr      = new PurchaseRequest();                // new PR
            PurchaseRequestLineItem prli    = db.PurchaseRequestLineItems.Find(id); // GET ID OF PURCHASE REQUEST LINE ITEM (single)

            product  = db.Products.Find(prli.ProductId);
            pr       = db.PurchaseRequests.Find(prli.PurchaseRequestId); // problem line
            pr.Total = product.Price * prli.Quantity;
            db.SaveChanges();
            // P_Price * PRLI_Quantity = PR_Total
        }
        public ActionResult Change([FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Purchase request  is null"
                }, JsonRequestBehavior.AllowGet));
            }
            //**Foreign key issue:
            PurchaseRequest purchaseRequest = db.PurchaseRequests.Find(purchaseRequestLineItem.PurchaseRequestId); //returns a user for the ID or null if not found

            if (purchaseRequest == null)                                                                           //this is true if the id is not found
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "PurchaseRequest Id not found"
                }, JsonRequestBehavior.AllowGet));
            }

            Product product = db.Products.Find(purchaseRequestLineItem.ProductId);

            if (product == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "ProductId not found"
                }, JsonRequestBehavior.AllowGet));
            }

            if (purchaseRequestLineItem.Quantity < 0)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Quantity is invalid"
                }, JsonRequestBehavior.AllowGet));
            }

            var tempPurchaseRequestLineItem = db.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id);

            if (tempPurchaseRequestLineItem == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Purchase Request Line Item Id not found"
                }, JsonRequestBehavior.AllowGet));
            }

            tempPurchaseRequestLineItem.Quantity          = purchaseRequestLineItem.Quantity;
            tempPurchaseRequestLineItem.ProductId         = purchaseRequestLineItem.ProductId;
            tempPurchaseRequestLineItem.PurchaseRequestId = purchaseRequestLineItem.PurchaseRequestId;

            db.SaveChanges(); //actually makes the data persistent in the database
            UpdatePurchaseRequestTotal(purchaseRequestLineItem.PurchaseRequestId);
            return(Json(new Msg {
                Result = "Success", Message = "Add successful"
            }, JsonRequestBehavior.AllowGet));
        }
        static void Main(string[] args)
        {
            var hmmm = new PurchaseRequestLineItem {
                ProductId        = db.Products.SingleOrDefault(p => p.Name == "Computer").Id,
                PurchasRequestID = db.PurchaseRequests.SingleOrDefault(pr => pr.Description == "New computer").Id,
                Quantity         = 9,
                Price            = 9 * db.Products.SingleOrDefault(p => p.Name == "Computer").Price
            };

            db.PurchaseRequestLineItems.Add(hmmm);
            db.SaveChanges();
        }
Exemple #30
0
        public ActionResult Change([FromBody] PurchaseRequestLineItem purchaseRequestLineItem)
        {
            if (purchaseRequestLineItem == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Purchase request  is null"
                }, JsonRequestBehavior.AllowGet));
            }
            PurchaseRequest purchaseRequest = db.PurchaseRequests.Find(purchaseRequestLineItem.PurchaseRequestId);

            if (purchaseRequest == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "PurchaseRequest Id not found"
                }, JsonRequestBehavior.AllowGet));
            }

            Product product = db.Products.Find(purchaseRequestLineItem.ProductId);

            if (product == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "ProductId not found"
                }, JsonRequestBehavior.AllowGet));
            }

            if (purchaseRequestLineItem.Quantity < 0)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Quantity is invalid"
                }, JsonRequestBehavior.AllowGet));
            }

            var tempPurchaseRequestLineItem = db.PurchaseRequestLineItems.Find(purchaseRequestLineItem.Id);

            if (tempPurchaseRequestLineItem == null)
            {
                return(Json(new Msg {
                    Result = "Failure", Message = "Purchase Request Line Item Id not found"
                }, JsonRequestBehavior.AllowGet));
            }

            tempPurchaseRequestLineItem.Quantity          = purchaseRequestLineItem.Quantity;
            tempPurchaseRequestLineItem.ProductId         = purchaseRequestLineItem.ProductId;
            tempPurchaseRequestLineItem.PurchaseRequestId = purchaseRequestLineItem.PurchaseRequestId;

            db.SaveChanges();
            UpdatePurchaseRequestTotal(purchaseRequestLineItem.PurchaseRequestId);
            return(Json(new Msg {
                Result = "Success", Message = "Add successful"
            }, JsonRequestBehavior.AllowGet));
        }