public IHttpActionResult GetRequestedItemsByRequestPKPrepared(int requestPK) { List <Client_RequestedItem> client_RequestedItemDetails = new List <Client_RequestedItem>(); IssuingDAO issuingDAO = new IssuingDAO(); try { Request request = db.Requests.Find(requestPK); if (request == null) { return(Content(HttpStatusCode.Conflict, "YÊU CẦU XUẤT KHÔNG TỒN TẠI!")); } 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); List <Client_Box_Shelf_Row> client_Boxes = issuingDAO.StoredBox_ItemPK_IsRestoredOfEntries(accessory); client_RequestedItemDetails.Add(new Client_RequestedItem(requestedItem, accessory, issuingDAO.InStoredQuantity(accessory.AccessoryPK), client_Boxes)); } } catch (Exception e) { return(Content(HttpStatusCode.Conflict, new Content_InnerException(e).InnerMessage())); } return(Content(HttpStatusCode.OK, client_RequestedItemDetails)); }