public ActionResult MonthlyDueReport()
{
try
{
MainViewModel.MonthlyDueViewModel subscriptionViewModel = new MainViewModel.MonthlyDueViewModel();
ViewBag.Year = reportService.YearList();
return(PartialView(subscriptionViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult _MonthlyDueReport(int?Month, int?Year, string Location, int pageNo = 1, int pageSize = 10)
{
try
{
MainViewModel.MonthlyDueViewModel MonthlyModel = new MainViewModel.MonthlyDueViewModel();
var monthlyList = reportService.getMonthlyDueList(Month, Year, Location, pageNo, pageSize);
MonthlyModel.monthlyDuePagedList = new StaticPagedList <MainViewModel.MonthlyDueViewModel>(monthlyList, pageNo, pageSize, (monthlyList.Count == 0) ? 0 : monthlyList.FirstOrDefault().TotalCount);
return(PartialView(MonthlyModel));
}
catch (Exception ex)
{
throw ex;
}
}
public FileContentResult MonthlyDueReportExportToExcel(int?Month, int?Year, string Location, int pageNo = 1, int pageSize = 0, string Monthtext = "")
{
MainViewModel.MonthlyDueViewModel subscriptionViewModel = new MainViewModel.MonthlyDueViewModel();
var monthlyList = reportService.getMonthlyDueList(Month, Year, Location, pageNo, pageSize);
var monthlyExcelList = monthlyList.Select(x => new ExcelViewModel.MonthlyDueExcelViewModel()
{
custNo = x.Custno,
Subsno = x.Subsno,
CustomerName = x.CustomerName,
CustomerType = x.CustomerType,
LocationName = x.LocationName,
MonthlyDue = x.MonthlyDue,
PostedOn = x.PostedOn
}).ToList();
string[] columns = { "Customer No", "Subscription No.", "Customer Name", "Customer Type", "Location Name", "Monthly Due", "PostedOn" };
string[] parameterSearch = { "Year.: " + Year, "MonthText.: " + Monthtext, "Location.: " + Location };
byte[] fileContent = ExcelExportHelper.ExportExcel(monthlyExcelList, parameterSearch, null, "Monthly Due Report", columns);
return(File(fileContent, ExcelExportHelper.ExcelContentType, "Monthly Due Report.xlsx"));
}
