public JsonResult GetToolingInfo(Guid partId)
{
var model = new PartViewModel();
var projectPart = _projectPartRepository.GetProjectPart(partId);
if (projectPart != null)
{
var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderParts().FirstOrDefault(x => x.ProjectPartId == partId);
if (foundryOrderPart != null)
{
var toolingOrder = _foundryOrderRepository.GetFoundryOrders().FirstOrDefault(x => x.FoundryOrderId == foundryOrderPart.FoundryOrderId &&
x.IsTooling);
model.PartNumber = (projectPart != null && !string.IsNullOrEmpty(projectPart.Number)) ? projectPart.Number : "N/A";
model.ToolingDescription = (projectPart != null && !string.IsNullOrEmpty(projectPart.ToolingDescription)) ? projectPart.ToolingDescription : "N/A";
model.ToolingOrderNumber = (toolingOrder != null && !string.IsNullOrEmpty(toolingOrder.Number)) ? toolingOrder.Number : "N/A";
model.Notes = (projectPart != null && !string.IsNullOrEmpty(projectPart.Notes)) ? projectPart.Notes : "N/A";
}
}
else
{
var part = _partRepository.GetPart(partId);
if (part != null)
{
var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderParts().FirstOrDefault(x => x.PartId == partId);
if (foundryOrderPart != null)
{
var toolingOrder = _foundryOrderRepository.GetFoundryOrders().FirstOrDefault(x => x.FoundryOrderId == foundryOrderPart.FoundryOrderId &&
x.IsTooling);
model.PartNumber = (part != null && !string.IsNullOrEmpty(part.Number)) ? part.Number : "N/A";
model.ToolingDescription = (part != null && !string.IsNullOrEmpty(part.ToolingDescription)) ? part.ToolingDescription : "N/A";
model.ToolingOrderNumber = (toolingOrder != null && !string.IsNullOrEmpty(toolingOrder.Number)) ? toolingOrder.Number : "N/A";
model.Notes = (part != null && !string.IsNullOrEmpty(part.Notes)) ? part.Notes : "N/A";
}
}
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
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);
}
