public async Task <IList <repVendorExpense> > GetrepVendorExpense(repVendorExpenseModel model)
{
SqlParameter[] pr = new SqlParameter[]
{
new SqlParameter("@DateStart", Convert.ToDateTime(model.DateStart)),
new SqlParameter("@DateEnd", Convert.ToDateTime(model.DateEnd)),
new SqlParameter("@intClientID", model.intClientID),
new SqlParameter("@strVendor", model.strVendor)
};
var result = await _dbContext.Set <repVendorExpense>().FromSqlRaw("exec repVendorExpense @DateStart,@DateEnd,@intClientID,@strVendor", pr).ToListAsync();
return(result);
}
public async Task <IActionResult> VendorExpenseReport()
{
var model = new repVendorExpenseModel();
model.AvailableVendor.Add(new SelectListItem {
Text = "All", Value = "0"
});
foreach (var item in (await _transactionReports.GetVendorClients((int)_workContext.CurrentCustomer.ClientId)))
{
model.AvailableVendor.Add(new Microsoft.AspNetCore.Mvc.Rendering.SelectListItem
{
Text = item.VName,
Value = item.VName
});
}
return(View(model));
}
public async Task <IActionResult> VendorExpenseReport(repVendorExpenseModel model)
{
if (ModelState.IsValid)
{
model.intClientID = (int)_workContext.CurrentCustomer.ClientId;
var reports = await _transactionReports.GetrepVendorExpense(model);
foreach (var item in reports)
{
model.repVendorExpensesList.Add(new repVendorExpense
{
HVendorName = item.HVendorName,
SumTotalRecd = item.SumTotalRecd,
SumTotalRecdPrice = item.SumTotalRecdPrice,
TotalPrice = item.TotalPrice
});
model.TotalExpense += Convert.ToDecimal(item.TotalPrice) + Convert.ToDecimal(item.SumTotalRecdPrice) + Convert.ToDecimal(item.SumTotalRecd);
}
model.AvailableVendor.Add(new SelectListItem {
Text = "All", Value = "0"
});
foreach (var item in (await _transactionReports.GetVendorClients((int)_workContext.CurrentCustomer.ClientId)))
{
model.AvailableVendor.Add(new SelectListItem
{
Text = item.VName,
Value = item.VName
});
}
}
return(View(model));
}
