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