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