public ActionResult GetByPurchaseRequestId(int?id) { if (id == null) { return(Json(new Msg { Result = "Failure", Message = "Id is null" }, JsonRequestBehavior.AllowGet)); } var purchaseRequest = db.PurchaseRequests.Find(id); if (purchaseRequest == null) { return(Json(new Msg { Result = "Failure", Message = "Purchase Request Id not found" }, JsonRequestBehavior.AllowGet)); } var purchaseRequestLineItems = db.PurchaseRequestLineItems.Where(pr => pr.PurchaseRequestId == purchaseRequest.Id); var prl = new prliType { PurchaseRequest = purchaseRequest, PurchaseRequestLineItems = purchaseRequestLineItems }; return(new JsonNetResult { Data = prl }); }
public ActionResult GetByPurchaseRequestId(int?id) //wanting to retrieve a single line of a purchase request { if (id == null) { return(Json(new Msg { Result = "Failure", Message = "Id is null" }, JsonRequestBehavior.AllowGet)); } var purchaseRequest = db.PurchaseRequests.Find(id); //finding the purchase request by id if (purchaseRequest == null) { return(Json(new Msg { Result = "Failure", Message = "Purchase Request Id not found" }, JsonRequestBehavior.AllowGet)); } var purchaseRequestLineItems = db.PurchaseRequestLineItems.Where(pr => pr.PurchaseRequestId == purchaseRequest.ID); //retrieving the line items of a purchase request via the ID var prl = new prliType { PurchaseRequest = purchaseRequest, PurchaseRequestLineItems = purchaseRequestLineItems }; //combining the data found and placing in a variable return(new JsonNetResult { Data = prl }); //all data is placed in variable "prl" }
//Unlike the above Get(), which retrieves a single purchaserequestlineitem, //GetById() retrieves every purchaserequestlineitem that belong to a specified //purchaseRequest. public ActionResult GetById(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 var purchaseRequest = db.PurchaseRequests.Find(id); //If the id used for the purchaserequestlineitem variable is incorrect, return an error message saying so if (purchaseRequest == null) { return(Json(new Msg { Result = "Failure", Message = $"The entered purchase request id, {id}, was not found." }, JsonRequestBehavior.AllowGet)); } else { //lineitems is "every line item that belongs to the purchase request" var lineitems = db.PurchaseRequestLineItems.Where(p => p.PurchaseRequestId == id).ToList(); var prli = new prliType { PurchaseRequest = purchaseRequest, PurchaseRequestLineItems = lineitems }; return(new JsonNetResult { Data = prli }); } } }