public ActionResult ExpenditureReport(string companyId, string branchId, string dateFrom, string dateTo, string expenditureCategoryId)
{
try
{
if (!string.IsNullOrEmpty(dateFrom))
{
DateTime?dfrom = Convert.ToDateTime(dateFrom);
dfrom = new DateTime(dfrom.Value.Year, dfrom.Value.Month, dfrom.Value.Day, 0, 0, 0);
dateFrom = dfrom.Value.ToString(CultureInfo.InvariantCulture);
}
if (!string.IsNullOrEmpty(dateTo))
{
DateTime?dto = Convert.ToDateTime(dateTo);
dto = new DateTime(dto.Value.Year, dto.Value.Month, dto.Value.Day, 23, 59, 59);
dateTo = dto.Value.ToString(CultureInfo.InvariantCulture);
}
if (!string.IsNullOrEmpty(companyId))
{
return(View(Mapper.Map <IEnumerable <ExpenditureViewModel> >(_rawSqlService.GetExpenses(companyId, branchId, dateFrom, dateTo, expenditureCategoryId))));
}
return(View());
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
}
