public async Task <List <POLineItems> > GetLineItemsDetails(int PO_id, int limit)
        {
            List <POLineItems> LineITemsDetails = new List <POLineItems>();

            try
            {
                LineITemsDetails = await _PurchaseOrdersRepo.GetOpenPOLineItemDetails(PO_id, limit);

                List <Items> items = await _ItemsHelper.GetItemsByOrder(PO_id);

                List <Items> skuItems = new List <Items>();
                foreach (POLineItems LineItems in LineITemsDetails)
                {
                    var ItemList = items.Where(x => x.sku == LineItems.sku).ToList();
                    LineItems.EndItems = ItemList;
                }
            }
            catch (Exception ex)
            {
                var logger = _loggerFactory.CreateLogger("internal_error_log");
                logger.LogInformation("Problem happened in selecting the data for GetLineItemsDetails for PO : " + PO_id.ToString() + " with message" + ex.Message);
            }

            return(LineITemsDetails);
        }
Esempio n. 2
0
        public async Task <object> GetItemsByPurchaseOrderStatusCountResponse(int poid)
        {
            dynamic countData   = new ExpandoObject();
            dynamic ProductList = new object();

            int CountRaStatusOne       = 0;
            int CountRaStatusZero      = 0;
            int CountItemStatusDefault = 0;
            int CountItemStatus        = 0;

            int rastatus   = 0;
            int itemstatus = 0;

            try
            {
                ProductList = await _ItemsHelper.GetItemsByOrder(poid);

                int TotalItemCount = ProductList.Count;
                for (var i = 0; i < (TotalItemCount - 1); i++)
                {
                    rastatus   = ProductList[i].ra_status;
                    itemstatus = ProductList[i].item_status_id;
                    if (rastatus == 0)
                    {
                        CountRaStatusZero++;
                    }
                    if (rastatus > 0)
                    {
                        CountRaStatusOne++;
                    }

                    if (itemstatus == 1)
                    {
                        CountItemStatusDefault++;
                    }

                    if (itemstatus > 1)
                    {
                        CountItemStatus++;
                    }
                }
                countData.rastatuszero      = CountRaStatusZero;
                countData.rastatusone       = CountRaStatusOne;
                countData.itemstatusdefault = CountItemStatusDefault;
                countData.itemstatus        = CountItemStatus;
            }
            catch (Exception ex)
            {
                var logger = _loggerFactory.CreateLogger("internal_error_log");
                logger.LogInformation("Problem happened in selecting the data for GetAsync with message" + ex.Message);
            }
            return(countData);
        }