Exemplo n.º 1
0
        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));
        }