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 }); }
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"))); }
//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.")); }
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." } }); }
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 }); }
//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") }); ; }
// 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."))); }
//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 }); }
//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."))); }
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); }
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)); }
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(); }
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)); }