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