public IHttpActionResult GetRequestedItemsByRequestPK(int requestPK)
{
List <Client_RequestedItemDetail> client_RequestedItemDetails = new List <Client_RequestedItemDetail>();
IssuingDAO issuingDAO = new IssuingDAO();
try
{
Request request = db.Requests.Find(requestPK);
List <RequestedItem> requestedItems = (from rI in db.RequestedItems
where rI.RequestPK == request.RequestPK
select rI).ToList();
foreach (var requestedItem in requestedItems)
{
DemandedItem demandedItem = db.DemandedItems.Find(requestedItem.DemandedItemPK);
Accessory accessory = db.Accessories.Find(demandedItem.AccessoryPK);
double sumOfOtherRequestedItem = issuingDAO.OtherRequestedItem(demandedItem.DemandedItemPK, requestedItem.RequestedItemPK);
client_RequestedItemDetails.Add(new Client_RequestedItemDetail(requestedItem, accessory, demandedItem.DemandedQuantity, sumOfOtherRequestedItem,
issuingDAO.InStoredQuantity(accessory.AccessoryPK) - issuingDAO.InRequestedQuantity(accessory.AccessoryPK)));
}
}
catch (Exception e)
{
return(Content(HttpStatusCode.Conflict, new Content_InnerException(e).InnerMessage()));
}
return(Content(HttpStatusCode.OK, client_RequestedItemDetails));
}
