public async Task <IActionResult> UsageReportItemExpense()
{
var model = new UsageReportItemListModel();
model.AvailableVendors.Add(new SelectListItem {
Text = "All", Value = "0"
});
foreach (var item in (await _selectItemsServices.GetVendorList((int)_workContext.CurrentCustomer.ClientId)))
{
model.AvailableVendors.Add(new SelectListItem {
Text = item.Vname, Value = item.Vname
});
}
model.AvailableShip.Add(new SelectListItem {
Text = "All", Value = "0"
});
foreach (var item in (await _costCenterService.SelectCostCenter((int)_workContext.CurrentCustomer.ClientId,
(int)_workContext.CurrentCustomer.UserType,
_workContext.CurrentCustomer.LogonId)))
{
model.AvailableShip.Add(new SelectListItem {
Text = item.Both, Value = item.SName
});
}
return(View(model));
}
public async Task <IList <UsageReportItemModel> > PrepareUsageExpenseReport(UsageReportItemListModel model)
{
try
{
SqlParameter[] pr = new SqlParameter[]
{
new SqlParameter("@DateStart", model.DateStart),
new SqlParameter("@DateEnd", model.DateEnd),
new SqlParameter("@intClientID", (int)_workContext.CurrentCustomer.ClientId),
new SqlParameter("@intSort", model.intSort),
new SqlParameter("@intCore", model.intCore),
new SqlParameter("@strVendor", model.strVendor),
new SqlParameter("@strItem", model.strVendor),
new SqlParameter("@strCostCenter", model.strVendor)
};
var result = await _dbContext.Set <UsageItemFirst>().FromSqlRaw("exec UsageItemFirst @DateStart,@DateEnd,@intClientID,@intSort,@intCore,@strVendor,@strItem,@strCostCenter", pr).ToListAsync();
var usageItem = new List <UsageReportItemModel>();
foreach (var item in result)
{
usageItem.Add(new UsageReportItemModel
{
AvgPrice = item.TotalPrice,
Description = item.HDescription,
Item = item.HOItem,
Vendor = item.HVendorName,
TotalQty = item.SumQty,
TotalExpense = item.CountPO
});
}
return(usageItem);
}
catch (Exception ex)
{
}
return(null);
}
public async Task <IActionResult> UsageReportItemExpenseList(UsageReportItemListModel model)
{
var result = await _transactionReports.PrepareUsageExpenseReport(model);
return(new JsonResult(result));
}
