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