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