// // GET: /Finance/Export public FileContentResult Export(PagingModel pm, CustomSearchModel csm, string type = "billing") { string csv = ""; string filename = string.Format("{0}-{1}.csv", type.ToUpperInvariant(), DateTime.Now.ToString("yyyy_MM_dd_HH_mm")); pm.Skip = 0; pm.Take = int.MaxValue; switch (type) { case "billing": #region Billing csv = string.Format("Statement Date,Statement Number,PSP Name,Product Name,Statement Amount,Invoice Amount,Tax Amount,Payment Date,Reference Number,Nominated Account {0}", Environment.NewLine); using (PSPBillingService bservice = new PSPBillingService()) { List <PSPBillingCustomModel> billing = bservice.List1(pm, csm); if (billing.NullableAny()) { foreach (PSPBillingCustomModel item in billing) { csv = string.Format("{0} {1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11} {12}", csv, "\"" + item.StatementDate + "\"", "\"" + item.StatementNumber + "\"", "\"" + item.CreatedOn + "\"", "\"" + item.PSPName + "\"", "\"" + item.ProductName + "\"", "\"" + item.PaymentAmount + "\"", "\"" + item.InvoiceAmount + "\"", "\"" + item.TaxAmount + "\"", "\"" + item.PaymentDate + "\"", "\"" + item.ReferenceNumber + "\"", "\"" + item.NominatedAccount + "\"", Environment.NewLine); } } } #endregion break; } return(File(new System.Text.UTF8Encoding().GetBytes(csv), "text/csv", filename)); }
// // GET: /Finance/Billing public ActionResult Billing(PagingModel pm, CustomSearchModel csm, bool givecsm = false) { using (PSPBillingService bservice = new PSPBillingService()) { if (givecsm) { ViewBag.ViewName = "Billing"; return(PartialView("_BillingCustomSearch", new CustomSearchModel("Billing"))); } List <PSPBillingCustomModel> model = bservice.List1(pm, csm); int total = (model.Count < pm.Take && pm.Skip == 0) ? model.Count : bservice.Total1(pm, csm); PagingExtension paging = PagingExtension.Create(model, total, pm.Skip, pm.Take, pm.Page); return(PartialView("_Billing", paging)); } }