public JsonResult SearchWarehouseInventory(string customerId)
{
var inventory = new List <WarehouseInventoryViewModel>();
var tempParts = _partDynamicsRepository.GetPartQuantityMasters().Where(x => x.QTYONHND > 0.00m).ToList();
if (tempParts != null && tempParts.Count > 0)
{
foreach (var tempPart in tempParts)
{
var parts = _partRepository.GetParts().Where(x => x.Number == tempPart.ITEMNMBR).ToList();
foreach (var part in parts)
{
var foundryOrderParts = _foundryOrderRepository.GetFoundryOrderParts().Where(x => x.PartId == part.PartId).ToList();
foreach (var foundryOrderPart in foundryOrderParts)
{
var containerParts = _containerRepository.GetContainerParts().Where(x => x.FoundryOrderPartId == foundryOrderPart.FoundryOrderPartId).ToList();
foreach (var containerPart in containerParts)
{
WarehouseInventoryViewModel convertedModel = new WarehouseInventoryConverter().ConvertToListView(containerPart);
inventory.Add(convertedModel);
}
}
}
}
}
if (customerId != "--Select Customer--")
{
inventory = inventory.Where(x => x.CustomerId.Replace(" ", string.Empty).ToLower() == customerId.Replace(" ", string.Empty).ToLower()).ToList();
}
inventory = inventory.OrderBy(x => x.ShipCode).ThenBy(y => y.PartNumber).ThenBy(z => z.PalletNumber).ToList();
var jsonResult = Json(inventory, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}