public List <StandardInventoryDto> GetStandardInventories()
{
var standardInventory = istandardInventoryDataService.GetStandardInventories();
var unitOfMeasures = unitOfMeasureBusinessEntity.GetUnitOfMeasure();
var inventoryItemCategories = inventoryItemCategoriesBusinessEntity.GetInventoryItemCategories();
var inventoryItemSubCategories = inventoryItemSubCategoryBusinessEntity.GetAllActiveInventoryItemSubCategory();
var standardInventoryDtoList = standardInventory.Select(p => new StandardInventoryDto()
{
ID = p.ID,
ItemName = p.ItemName,
InventoryItemCategoryId = p.InventoryItemCategoryId,
InventoryItemSubCategoryId = p.InventoryItemSubCategoryId,
QuantityUnitOfMesureId = p.QuantityUnitOfMesureId,
Seasonality = p.Seasonality,
MinimumInventory = p.MinimumInventory,
FileID = p.FileServerDetailID
}).ToList();
var fileDetails = fileServerBusinessEntity.GetFileDetails(standardInventory.Select(p => p.FileServerDetailID));
standardInventoryDtoList.ForEach(p =>
{
var unitOfMeasure = unitOfMeasures.FirstOrDefault(s => s.ID == p.QuantityUnitOfMesureId);
if (unitOfMeasure != null)
{
p.QuantityUnitOfMeasureName = unitOfMeasure.Name;
}
var fileDto = fileDetails.FirstOrDefault(f => f.ID == p.FileID);
if (fileDto != null)
{
var url = FileServerUtility.GetPresignedUrl(fileDto.BucketName, fileDto.Key).Result;
p.FileUrl = url;
}
var inventoryItemCategory = inventoryItemCategories.FirstOrDefault(i => i.ID == p.InventoryItemCategoryId);
if (inventoryItemCategory != null)
{
p.InventoryItemCategoryName = inventoryItemCategory.Name;
}
var inventoryItemSubCategory = inventoryItemSubCategories.FirstOrDefault(c => c.ID == p.InventoryItemSubCategoryId);
if (inventoryItemSubCategory != null)
{
p.InventoryItemSubCategoryName = inventoryItemSubCategory.Name;
}
});
return(standardInventoryDtoList);
}
public List <SupplierInventoryDto> GetSupplierInventories()
{
var sandardInventory = standardInventoryBusinessEntity.GetStandardInventories();
var suppliers = this.userService.GetUsers().Where(p => p.UserType == "Supplier");
var supplierInventoryList = supplierInventoryDataService.GetSupplierInventoriesBySupplierIds(suppliers.Select(p => p.ID).ToList());
var supplierInventoryDtoList = supplierInventoryList.Select(r => new SupplierInventoryDto()
{
ID = r.Id,
SupplierStandardInventoryId = r.SupplierStandardInventoryId,
Qty = r.Qty,
UnitPrice = r.UnitPrice,
AvailableQty = r.AvailableQty,
ProcessingQty = r.ProcessingQty,
InventoryDate = r.InventoryDate,
SupplierName = suppliers.FirstOrDefault(p => p.ID == r.SupplierStandardInventory.SupplierId).Name,
InventoryItemName = r.SupplierStandardInventory.StandardInventory == null ? "" : r.SupplierStandardInventory.StandardInventory.ItemName
}).ToList();
//supplierInventoryDtoList.ForEach(p =>
//{
// var supplierInventoryItem = supplierInventoryList.FirstOrDefault(s => s.Id == p.ID);
// var standardInventory = sandardInventory.FirstOrDefault(i => i.ID == supplierInventoryItem.SupplierStandardInventory.StandardInventoryId);
// if (standardInventory != null)
// p.InventoryItemName = standardInventory.ItemName;
//});
return(supplierInventoryDtoList.OrderBy(p => p.SupplierName).ToList());
}