public virtual IActionResult ExportXlsxSinAbonar() { if (!_permissionService.Authorize(StandardPermissionProvider.ManageCategories)) { return(AccessDeniedView()); } try { ClienteAbonoModel payment = new ClienteAbonoModel { Transaccion = new TransaccionModel { Estatus_Operacion = false, } }; var transferList = _SigoCreditosPayPalService.SearchAbonosClientes(payment); var xml = ExportPaymentToXlsx(transferList); return(File(xml, MimeTypes.TextXlsx, "AbonosExitosos.xlsx")); } catch (Exception exc) { ErrorNotification(exc); return(RedirectToAction("List")); } }
public IActionResult ListAbonoClientes(ClienteAbonoModel search, DataSourceRequest command) { try { if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings)) { return(AccessDeniedKendoGridJson()); } if (search == null) { throw new ArgumentNullException(nameof(search)); } var ListaClientesAbonos = _SigoCreditosPayPalService.SearchAbonosClientes(search, pageIndex: command.Page - 1, pageSize: command.PageSize); return(Json(new DataSourceResult { Data = ListaClientesAbonos, Total = ListaClientesAbonos.TotalCount })); } catch (Exception ex) { throw new NopException(ex.Message, ex); } }
//[HttpPost] //[AdminAntiForgery] //public IActionResult AbonarGiftCard(SigoCreditosGiftCardModel model) //{ // if (!_permissionService.Authorize(StandardPermissionProvider.ManagePaymentMethods)) // return AccessDeniedView(); // if (!ModelState.IsValid) // return Configure(); // //load settings for a chosen store scope // bool result = CRMContext.CRMContext.EnviarGiftCard(model); // if (result) // { // var cliente = CRMContext.CRMContext.ObtenerPuntosxCliente(model.DocumentType, model.DocumentValue); // return RedirectToRoute("CustomerSigoCreditos"); // //return View("~/Plugins/Payments.SigoCreditos/Views/SigoCreditosInfo.cshtml", cliente); // // return View("~/Plugins/Payments.SigoCreditos/Views/SigoCreditosInfo.cshtml", null); // } // else // { // return Configure(); // } // //now clear settings cache //} #endregion #endregion #region Abonos Sigo Creditos // Admin public IActionResult ConfigureAbonosClientes() { if (!_permissionService.Authorize(StandardPermissionProvider.ManagePaymentMethods)) { return(AccessDeniedView()); } var AbonosClientes = new ClienteAbonoModel(); //load settings for a chosen store scope return(View("~/Plugins/Payments.SigoCreditos/Views/ConfigureAbonosClientes.cshtml", AbonosClientes)); }
public IPagedList <ClienteAbonoModel> SearchAbonosClientes(ClienteAbonoModel payment, int storeId = 0, int pageIndex = 0, int pageSize = int.MaxValue) { try { List <ClienteAbonoModel> ListaClientesaAbonos = new List <ClienteAbonoModel>(); List <TransaccionModel> ListaTransacciones = new List <TransaccionModel>(); SigoCreditosPaypal scp = new SigoCreditosPaypal(); var ListaSigoCreditosPayPal = _SigoCreditosPaypalRepository.Table; if (ListaSigoCreditosPayPal != null && ListaSigoCreditosPayPal.Count() > 0) { //foreach (var SCPaypal in ListaSigoCreditosPayPal.Where(x => x.CustomerID == CurrentCustomerId).OrderByDescending(x => x.FechaCreacion)) foreach (var SCPaypal in ListaSigoCreditosPayPal.OrderByDescending(x => x.FechaCreacion)) { var cliente = _customerService.GetCustomerById(SCPaypal.CustomerID); ClienteAbonoModel ClienteAbono = new ClienteAbonoModel { EcommerceId = SCPaypal.CustomerID, //Nombre = cliente.Addresses != null ? cliente.Addresses.FirstOrDefault(x => x.FirstName != null).FirstName : Nombre = (cliente.Addresses.FirstOrDefault(x => x.FirstName != null).FirstName ?? "S/D") + " " + (cliente.Addresses.FirstOrDefault(x => x.LastName != null).LastName ?? "S/D"), Apellido = cliente.Addresses.FirstOrDefault(x => x.LastName != null).LastName != null?cliente.Addresses.FirstOrDefault(x => x.LastName != null).LastName : "S/D", Telefono = cliente.Addresses.FirstOrDefault(x => x.PhoneNumber != null).PhoneNumber != null?cliente.Addresses.FirstOrDefault(x => x.PhoneNumber != null).PhoneNumber : "S/D", Email = cliente.Email != null ? cliente.Email : "S/D", Transaccion = new TransaccionModel { TransaccionPaypalID = !string.IsNullOrWhiteSpace(SCPaypal.TransaccionPaypalID) ? SCPaypal.TransaccionPaypalID : "S/D", Monto = SCPaypal.Monto, CedulaReceptor = !string.IsNullOrWhiteSpace(SCPaypal.CedulaReceptor) ? SCPaypal.CedulaReceptor : "S/D", NombreReceptor = !string.IsNullOrWhiteSpace(SCPaypal.NombreReceptor) ? SCPaypal.NombreReceptor : "S/D", Estatus_Operacion = SCPaypal.Estatus_Operacion, TransaccionCreditID = SCPaypal.TransaccionCreditID, CustomerID = SCPaypal.CustomerID, FechaCreacion = SCPaypal.FechaCreacion, IndGiftCard = SCPaypal.EsGiftCard, CodigoGiftCard = !string.IsNullOrWhiteSpace(SCPaypal.CodigoGiftCard) ? SCPaypal.CodigoGiftCard : "S/D" } }; ListaClientesaAbonos.Add(ClienteAbono); } } if (!string.IsNullOrWhiteSpace(payment.Nombre)) { ListaClientesaAbonos = ListaClientesaAbonos.Where(b => b.Nombre.ToUpper().Contains(payment.Nombre.ToUpper())).ToList(); } if (!string.IsNullOrWhiteSpace(payment.Email)) { ListaClientesaAbonos = ListaClientesaAbonos.Where(b => b.Email.Contains(payment.Email)).ToList(); } if (!string.IsNullOrWhiteSpace(payment.Transaccion.TransaccionPaypalID)) { ListaClientesaAbonos = ListaClientesaAbonos.Where(b => b.Transaccion.TransaccionPaypalID.Contains(payment.Transaccion.TransaccionPaypalID)).ToList(); } //if (payment.Transaccion.TransaccionCreditID > 0) // ListaClientesaAbonos = ListaClientesaAbonos.Where(b => b.Transaccion.TransaccionCreditID == payment.Transaccion.TransaccionCreditID).ToList(); if (!string.IsNullOrWhiteSpace(payment.Transaccion.NombreReceptor)) { ListaClientesaAbonos = ListaClientesaAbonos.Where(b => b.Transaccion.NombreReceptor.ToUpper().Contains(payment.Transaccion.NombreReceptor.ToUpper())).ToList(); } // if(payment.Transaccion.Estatus_Operacion != null) ListaClientesaAbonos = ListaClientesaAbonos.Where(b => b.Transaccion.Estatus_Operacion == payment.Transaccion.Estatus_Operacion).ToList(); return(new PagedList <ClienteAbonoModel>(ListaClientesaAbonos.ToList(), pageIndex: pageIndex - 1, pageSize: pageSize));; } catch (Exception ex) { throw new NopException("Error al obtener los pagos:: " + ex.Message, ex); } }