public async Task <IActionResult> PackingSlips(PackingSlipModel model)
{
model = await _inventoryManagementService.PreparePackingSlipModel(model);
return(View(model));
}
public async Task <PackingSlipModel> PreparePackingSlipModel(PackingSlipModel model)
{
var packing = new PackingSlipModel();
var query = _historyRepository.Table.Where(h => h.HclientId == (int)_workContext.CurrentCustomer.ClientId);
if (!string.IsNullOrEmpty(model.DateStart))
{
query = query.Where(h => h.Hdate >= (Convert.ToDateTime(model.DateStart)));
}
if (!string.IsNullOrEmpty(model.DateEnd))
{
query = query.Where(h => h.Hdate <= (Convert.ToDateTime(model.DateEnd)));
}
if (!string.IsNullOrEmpty(model.PO))
{
query = query.Where(h => h.Hpo.Contains(model.PO.Trim()));
}
if (!string.IsNullOrEmpty(model.Department))
{
query = query.Where(h => h.HshipName.Contains(model.Department.Trim()));
}
//Sorting
if (model.intSort == 1)
{
query = query.OrderBy(h => h.HshipName);
}
if (model.intSort == 2)
{
query = query.OrderBy(h => h.Hoitem);
}
var shipTo = _shipToRepository.Table.ToList();
var histories = query.ToList();
foreach (var history in histories)
{
var items = new List <PackingSlipModel.PackInfo.ItemList>();
var totalItems = histories.Where(h => h.Hpo == history.Hpo).ToList();
foreach (var t in totalItems)
{
items.Add(new PackingSlipModel.PackInfo.ItemList
{
Description = t.Hdescription,
HBackOrd = t.HbackOrd,
Item = t.Hoitem,
Location = "",
OrderedFor = t.HorderedFor,
Qty = t.Hqty,
Shipping = t.Hshipping,
Unit = t.Huom
});
}
var IsExit = packing.packInfo.ToList().Any(h => h.PO == history.Hpo);
if (!IsExit)
{
packing.packInfo.Add(new PackingSlipModel.PackInfo
{
HistoryId = history.HistoryId,
PO = history.Hpo,
Vendor = history.HvendorName,
OrderDate = history.Hdate,
CostCenterId = history.HshipId,
CostCenterName = history.HshipName,
OrderedBy = history.Horderedby,
itemLists = items
});
}
}
return(packing);
}
public IActionResult PackingSlips()
{
var model = new PackingSlipModel();
return(View(model));
}
