public JsonResult FilterPartPlanning(InventoryViewModel model)
{
var parts = new List <PartInventoryViewModel>();
var tempParts = _partRepository.GetParts().Where(x => x.IsActive).ToList();
if (tempParts != null && tempParts.Count > 0)
{
foreach (var tempPart in tempParts)
{
PartInventoryViewModel convertedModel = new PartInventoryConverter().ConvertToListView(tempPart);
parts.Add(convertedModel);
}
}
if (model.CustomerId != null && model.CustomerId != string.Empty)
{
parts = parts.Where(x => x.CustomerId.Replace(" ", string.Empty).ToLower() == model.CustomerId.Replace(" ", string.Empty).ToLower()).ToList();
}
if (model.FoundryId != null && model.FoundryId != string.Empty)
{
parts = parts.Where(x => x.FoundryId.Replace(" ", string.Empty).ToLower() == model.FoundryId.Replace(" ", string.Empty).ToLower()).ToList();
}
if (!string.IsNullOrEmpty(model.PartNumber))
{
parts = parts.Where(x => x.PartNumber.ToLower() == model.PartNumber.ToLower()).ToList();
}
parts = CalculateReorderStatus(parts);
if (model.ZeroOnHand)
{
parts = parts.Where(x => x.QuantityOnHand < 1).ToList();
}
if (model.BelowMinimum)
{
parts = parts.Where(x => x.QuantityOnHand < x.MinimumQuantity).ToList();
}
if (model.BelowReorderPoint)
{
parts = parts.Where(x => x.QuantityOnHand < x.ReorderPoint).ToList();
}
parts = parts.OrderBy(x => x.PartNumber).ToList();
var jsonResult = Json(parts, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public JsonResult SearchStatus(InventoryViewModel model)
{
var parts = new List <PartInventoryViewModel>();
var tempParts = _partRepository.GetParts().Where(x => x.IsActive).ToList();
if (tempParts != null && tempParts.Count > 0)
{
foreach (var tempPart in tempParts)
{
PartInventoryViewModel convertedModel = new PartInventoryConverter().ConvertToListView(tempPart);
parts.Add(convertedModel);
}
}
if (model.CustomerId != "--Select Customer--")
{
parts = parts.Where(x => x.CustomerId.Replace(" ", string.Empty).ToLower() == model.CustomerId.Replace(" ", string.Empty).ToLower()).ToList();
}
if (model.FoundryId != "--Select Foundry--")
{
parts = parts.Where(x => x.FoundryId.Replace(" ", string.Empty).ToLower() == model.FoundryId.Replace(" ", string.Empty).ToLower()).ToList();
}
if (!string.IsNullOrEmpty(model.PartNumber))
{
parts = parts.Where(x => x.PartNumber.Replace(" ", string.Empty).ToLower() == model.PartNumber.Replace(" ", string.Empty).ToLower()).ToList();
}
parts = parts.OrderBy(x => x.PartNumber).ToList();
var jsonResult = Json(parts, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
