public ActionResult Index(int?SelectedMonth, int?SelectedYear, string SelectedCategory)
{
int getMonth, getYear;
getMonth = SelectedMonth.GetValueOrDefault();
getYear = SelectedYear.GetValueOrDefault();
ViewData["ListSeriesPrice"] = GetDataExpense(getMonth, getYear, SelectedCategory);
GetDataList();
FilterExpense filterExpense = new FilterExpense(getMonth, getYear, SelectedCategory);
return(View(filterExpense));
}
// GET: Expenses
public ActionResult Index()
{
List <Series> listSeries = new List <Series>();
int currentMonth = DateTime.Today.Month;
int currentYear = DateTime.Today.Year;
ViewData["ListSeriesPrice"] = GetDataExpense(currentMonth, currentYear, "");
GetDataList();
FilterExpense filterExpense = new FilterExpense(currentMonth, currentYear, "");
return(View(filterExpense));
}
public IActionResult Filter(FilterExpense filter)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@userId", User.GetUserId());
parameters.Add("@dateFrom", filter.From);
parameters.Add("@dateTo", filter.To);
parameters.Add("@categoryId", filter.CategoryId);
parameters.Add("@clientId", filter.ClientId);
var expenses = _sp.ExecuteReturnScaler <decimal>(SP.spFilterExpenses, parameters);
return(Json(expenses));
}
