public FileContentResult SubscriptionStatementExportToExcel(DateTime?FromDate, DateTime?ToDate, int?subsid, string substext = "")
{
int pageNo = 1;
int pageSize = 0;
MainViewModel.SubscriptionReport subscriptionViewModel = new MainViewModel.SubscriptionReport();
var suscriberList = reportService.getSubscriberStatementList(subsid, FromDate, ToDate, pageNo, pageSize);
var subscriptionExcelList = suscriberList.Select(x => new ExcelViewModel.SubscriptionReportExcel()
{
custNo = x.CustNo,
SubsNo = x.SubsNo,
Custname = x.Custname,
Debit = x.Debit,
Credit = x.Credit,
Balance = x.Balance,
PostedOnAd = x.PostedOnAd,
PostedOnBs = x.PostedOnBs,
Sources = x.Sources
}).ToList();
string[] columns = { "Customer No", "Subscription No.", "Customer Name", "Debit", "Credit", "Balance", "Posted On Ad", "Posted On Bst", "Sources" };
string[] parameterSearch = { "From Date.: " + FromDate, "To Date.: " + ToDate, "Customer Name: " + substext };
byte[] fileContent = ExcelExportHelper.ExportExcel(subscriptionExcelList, parameterSearch, null, "Subscription Report", columns);
return(File(fileContent, ExcelExportHelper.ExcelContentType, "Subscription Report.xlsx"));
}
public ActionResult _SubscriberStatement(int?subsid, DateTime?FromDate, DateTime?ToDate, int pageNo = 1, int pageSize = 10)
{
try
{
MainViewModel.SubscriptionReport subscriptionViewModel = new MainViewModel.SubscriptionReport();
var suscriberList = reportService.getSubscriberStatementList(subsid, FromDate, ToDate, pageNo, pageSize);
subscriptionViewModel.subscriptionPagedList = new StaticPagedList <MainViewModel.SubscriptionReport>(suscriberList, pageNo, pageSize, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
return(PartialView(subscriptionViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
