//public virtual IActionResult ExportXlsx() //{ // if (!_permissionService.Authorize(StandardPermissionProvider.ManageCategories)) // return AccessDeniedView(); // try // { // var storeScope = _storeContext.ActiveStoreScopeConfiguration; // var bytes = ExportPaymentToXlsx(); // return File(bytes, MimeTypes.TextXlsx, "Configuration.xlsx"); // } // catch (Exception exc) // { // ErrorNotification(exc); // return RedirectToAction("Configure"); // } //} // [HttpPost]d //public virtual IActionResult ImportFromXlsx(IFormFile importexcelfile) //{ // if (!_permissionService.Authorize(StandardPermissionProvider.ManageCategories)) // return AccessDeniedView(); // try // { // if (importexcelfile != null && importexcelfile.Length > 0) // { // _importManager.ImportCategoriesFromXlsx(importexcelfile.OpenReadStream()); // } // else // { // ErrorNotification(_localizationService.GetResource("Admin.Common.UploadFile")); // return RedirectToAction("List"); // } // SuccessNotification(_localizationService.GetResource("Admin.Catalog.Categories.Imported")); // return RedirectToAction("List"); // } // catch (Exception exc) // { // ErrorNotification(exc); // return RedirectToAction("List"); // } //} /// <summary> /// Export payment to XLSX /// </summary> /// <param name="payment">Categories</param> public virtual byte[] ExportPaymentToXlsx(IList <Consolidate> payment) { // var parentCatagories = new List<Consolidate>(); //property manager var manager = new PropertyManager <Consolidate>(new[] { new PropertyByName <Consolidate>("Id", p => p.Id), new PropertyByName <Consolidate>("Fecha Última Actualización", p => p.FechaUltimaActualizacion.ToString("dd/MM/yyyy hh:mm:ss")), new PropertyByName <Consolidate>("Tienda", p => p.Tienda), new PropertyByName <Consolidate>("Metodo Pago", p => p.MetodoPago.Contains("Zelle")? "Zelle": "Transferencia Bancaria"), new PropertyByName <Consolidate>("Orden #", p => p.OrdenId), new PropertyByName <Consolidate>("Referencia", p => p.Referencia), new PropertyByName <Consolidate>("Banco/Email", p => string.IsNullOrEmpty(p.BancoReceptor)? p.EmailEmisor:p.BancoReceptor), new PropertyByName <Consolidate>("Monto Total", p => p.CodigoMoneda.Contains("Bs")? p.CodigoMoneda + p.MontoTotalOrden:"$" + p.MontoTotalOrden), }, _catalogSettings); return(manager.ExportToXlsx(payment)); }
/// <summary> /// Export payment to XLSX /// </summary> /// <param name="payment">Categories</param> public virtual byte[] ExportPaymentToXlsx(IList <ClienteAbonoModel> payment) { // var parentCatagories = new List<Consolidate>(); //property manager var manager = new PropertyManager <ClienteAbonoModel>(new[] { new PropertyByName <ClienteAbonoModel>("Fecha Creacion", p => p.Transaccion.FechaCreacion.ToString("dd/MM/yyyy hh:mm:ss")), new PropertyByName <ClienteAbonoModel>("Emisor", p => p.Nombre), new PropertyByName <ClienteAbonoModel>("Email emisor", p => p.Email), new PropertyByName <ClienteAbonoModel>("R. Paypal", p => p.Transaccion.TransaccionPaypalID), new PropertyByName <ClienteAbonoModel>("R. Sigo club", p => p.Transaccion.TransaccionCreditID.ToString()), new PropertyByName <ClienteAbonoModel>("Cedula Receptor", p => p.Transaccion.CedulaReceptor), new PropertyByName <ClienteAbonoModel>("Receptor", p => p.Transaccion.NombreReceptor), new PropertyByName <ClienteAbonoModel>("Monto Total", p => p.Transaccion.Monto.ToString()), new PropertyByName <ClienteAbonoModel>("Estatus", p => p.Transaccion.Estatus_Operacion ? "Exitoso" : "") }, _catalogSettings); return(manager.ExportToXlsx(payment)); }