示例#1
0
        public ActionResult _SubscriptionDueReportList(DateTime?tillDate, int pageNo = 1, int pageSize = 10, string Location = "")
        {
            try
            {
                MainViewModel.SubscriberDueViewModel subscriptionViewModel = new MainViewModel.SubscriberDueViewModel();
                var suscriberList       = reportService.getSuscriberList(tillDate, pageNo, pageSize, Location);
                var totalsubscriberList = reportService.getSingleTotalSuscriberList(tillDate, Location);
                ViewBag.DebitSum   = totalsubscriberList.SumDebit;
                ViewBag.CreditSum  = totalsubscriberList.SumCredit;
                ViewBag.AdvanceSum = totalsubscriberList.SumAdvance;
                ViewBag.DueBalance = totalsubscriberList.SumDueBalance;

                subscriptionViewModel.suscriberPagedList = new StaticPagedList <MainViewModel.SubscriberDueViewModel>(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;
            }
        }
示例#2
0
        public FileContentResult SubscriptionDueExportToExcel(DateTime?tillDate, int pageNo = 1, int pageSize = 0, string Location = "")
        {
            MainViewModel.SubscriberDueViewModel subscriptionViewModel = new MainViewModel.SubscriberDueViewModel();
            var suscriberList            = reportService.getSuscriberList(tillDate, pageNo, pageSize, Location);
            var totalsubscriberList      = reportService.getSingleTotalSuscriberList(tillDate, Location);
            var subscriptionDueExcelList = suscriberList.Select(x => new ExcelViewModel.SubscriberDueExcelViewModel()
            {
                custNo       = x.CustNo,
                Subsno       = x.Subsno,
                CustomerName = x.CustomerName,
                CustomerType = x.CustomerType,
                LocationName = x.LocationName,
                LedgerName   = x.LedgerName,
                Debit        = x.Debit,
                Credit       = x.Credit,
                Advance      = x.Advance,
                DueBalance   = x.DueBalance,

                Status = x.Status
            }).ToList();

            //var totalsubscriptionDueExcelList = totalsubscriberList.Select(x => new ExcelViewModel.SubscriberDueExcelViewModel()
            //{

            //    SumCredit=x.SumCredit,
            //    SumDebit=x.SumDebit,
            //    SumAdvance=x.SumAdvance,
            //    SumDueBalance=x.SumDueBalance

            //}).();
            //  var DebitSum = totalsubscriberList.SumDebit;
            // var CreditSum = totalsubscriberList.SumCredit;
            //var AdvanceSum = totalsubscriberList.SumAdvance;
            // var DueBalance = totalsubscriberList.SumDueBalance;
            decimal[] totals = { totalsubscriberList.SumDebit, totalsubscriberList.SumCredit, totalsubscriberList.SumAdvance, totalsubscriberList.SumDueBalance };

            string[] columns         = { "Customer No.", "Subscription No.", "Customer Name", "Customer Type", "Location Name", "Ledger Name", "Debit", "Credit", "Advance", "DueBalance", "Status" };
            string[] parameterSearch = { "Location.:  " + Location, "Effective Date:  " + tillDate };
            byte[]   fileContent     = ExcelExportHelper.ExportExcel(subscriptionDueExcelList, parameterSearch, totals, "Subscription Due Report", columns);
            return(File(fileContent, ExcelExportHelper.ExcelContentType, "Subscription Due  Report.xlsx"));
        }