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)); }