public ActionResult _collectionReportList(DateTime?collectionDate, int pageNo = 1, int pageSize = 10, string customerName = "", string collector = "", string Location = "", int verified = 1, string EntryTypeList = "")
{
try
{
MainViewModel.CollectionReport collectorViewModel = new MainViewModel.CollectionReport();
var collectorList = reportService.getCollectorReportList(collectionDate, pageNo, pageSize, customerName, collector, Location, verified, EntryTypeList);
collectorViewModel.collectorPagedList = new StaticPagedList <MainViewModel.CollectionReport>(collectorList, pageNo, pageSize, (collectorList.Count == 0) ? 0 : collectorList.FirstOrDefault().TotalCount);
return(PartialView(collectorViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult collectionReportList()
{
try
{
MainViewModel.CollectionReport collectorViewModel = new MainViewModel.CollectionReport();
var suscriberList = reportService.getCollectorReportList(null, 1, 10, "", "", "", 1);
collectorViewModel.collectorPagedList = new StaticPagedList <MainViewModel.CollectionReport>(suscriberList, 1, 10, (suscriberList.Count == 0) ? 0 : suscriberList.FirstOrDefault().TotalCount);
//foreach (var item in customerList)
//{
// customerViewModel.customerViewModelList.Add(item);
//}
return(PartialView(collectorViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public FileContentResult CollectionExportToExcel(DateTime?collectionDate, int pageNo = 1, int pageSize = 0, string customerName = "", string collector = "", string Location = "", int verified = 1, string statustext = "", string EntryTypeList = "")
{
MainViewModel.CollectionReport collectorViewModel = new MainViewModel.CollectionReport();
var collectorList = reportService.getCollectorReportList(collectionDate, pageNo, pageSize, customerName, collector, Location, verified, EntryTypeList);
var collectorExcelList = collectorList.Select(x => new ExcelViewModel.CollectorExcelViewModel()
{
CustomerNo = x.CustomerNo,
Subsno = x.Subsno,
CustomerName = x.CustomerName,
CustomerType = x.CustomerType,
LocationName = x.LocationName,
CollectionAmt = x.CollectionAmt,
CollectionDate = x.CollectionDate,
CollectorName = x.CollectorName,
DiscountAmt = x.DiscountAmt,
CollectionTYpe = x.CollectionType
}).ToList();
string[] columns = { "Customer No", "Subscription No.", "Customer Name", "Customer Type", "Location Name", "Collector Name", "Collection Date", "Collection Amount", "Discount Amount", "CollectionType" };
string[] parameterSearch = { "Customer Name.: " + customerName, "Collector.: " + collector, "Collection Date: " + collectionDate, "Location: " + Location, "Status: " + statustext, "CollectionType :" + EntryTypeList };
byte[] fileContent = ExcelExportHelper.ExportExcel(collectorExcelList, parameterSearch, null, "Collector Report", columns);
return(File(fileContent, ExcelExportHelper.ExcelContentType, "Collector Report.xlsx"));
}
