public IHttpActionResult getListaAdjudicaciones(PageResultParam model) { PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); PageResultSP <PartnerListaAdjudicacionResponse> result = new PageResultSP <PartnerListaAdjudicacionResponse>(); result = _partnerDataAccess.getListadoAdjudicacionPartner(model, NroRucEmpresaCurrenUser); return(Ok(result)); }
public ActionResult DescargarPartnerLiquidacionExcel(string operaciones) { PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); BaseResponse <List <PartnerListaAdjudicacionResponse> > result = new BaseResponse <List <PartnerListaAdjudicacionResponse> >(); result = _partnerDataAccess.ListaAdjudicacionExcel(NroRucEmpresaCurrenUser, operaciones); if (result.success) { string plantilla = System.Configuration.ConfigurationManager.AppSettings["AdjudicacionPartner"]; XSSFWorkbook hssfworkbook; string path = AppDomain.CurrentDomain.BaseDirectory + plantilla; using (FileStream file = new FileStream(path, FileMode.Open, FileAccess.Read)) { hssfworkbook = new XSSFWorkbook(file); } ISheet sheet1 = hssfworkbook.GetSheet("Reporte"); IRow row = sheet1.GetRow(7); int i = 7; //CultureInfo culture; //string specifier; //specifier = "N3"; //culture = CultureInfo.CreateSpecificCulture("eu-ES"); foreach (PartnerListaAdjudicacionResponse item in result.data) { row = sheet1.GetRow(i); if (row == null) { row = sheet1.CreateRow(i); } this.SetCellValue(hssfworkbook, row, 1, item.fecha); this.SetCellValue(hssfworkbook, row, 2, item.HoraConfirmacion); this.SetCellValue(hssfworkbook, row, 3, item.idTransaccion); this.SetCellValue(hssfworkbook, row, 4, item.partnersAdjuntado); this.SetCellValue(hssfworkbook, row, 5, item.cliente); this.SetCellValue(hssfworkbook, row, 6, item.quiere); this.SetCellValue(hssfworkbook, row, 7, item.montoUSDventaText); this.SetCellValue(hssfworkbook, row, 8, item.tipoCambioText); this.SetCellValue(hssfworkbook, row, 9, item.montoSolesventaText); this.SetCellValue(hssfworkbook, row, 10, item.estadoSubasta); i++; } MemoryStream stream = new MemoryStream(); hssfworkbook.Write(stream); return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "MisAdjudicaciones.xlsx")); } else { return(RedirectToAction("MisAdjudicaciones")); } }
public IHttpActionResult SaveTipoMercadoDiario(List <TipoCambioMercadoPartner_Response> model) { BaseResponse <string> result = new BaseResponse <string>(); Domain.DataAccess.Admin.PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); result = _partnerDataAccess.guardarTipoCambioMercadoPartner(model, NroRucEmpresaCurrenUser); return(Ok(result)); }
public IHttpActionResult getAllSubastasActivas() { BaseResponse <List <SubastasActivasResponse> > result = new BaseResponse <List <SubastasActivasResponse> >(); Domain.DataAccess.Admin.PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); result = _partnerDataAccess.getSubastasActivas(NroRucEmpresaCurrenUser); return(Ok(result)); }
public IHttpActionResult GetTipoCambioMercadoDelDiaXPartner(FiltroBanco_Response banco) { BaseResponse <List <TipoCambioMercadoPartner_Response> > result = new BaseResponse <List <TipoCambioMercadoPartner_Response> >(); Domain.DataAccess.Admin.PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); result = _partnerDataAccess.getAllTipoCambioMercadoDelDiaPartnert(banco.codBanco); return(Ok(result)); }
public IHttpActionResult GetTipoCambioDelDiaXPartner() { BaseResponse <List <TipoCambioGarantizadoPartner_Response> > result = new BaseResponse <List <TipoCambioGarantizadoPartner_Response> >(); Domain.DataAccess.Admin.PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); result = _partnerDataAccess.getAllTipoCambioGanantizadoDelDiaPartnert(NroRucEmpresaCurrenUser); return(Ok(result)); }
public IHttpActionResult updateTipoCambio_SubastaActiva(dynamic param) { int subasta_ = param.subasta; decimal tipocambio_ = param.tipocambio; BaseResponse <string> result = new BaseResponse <string>(); PartnerDataAccess _partnerDataAccess = new PartnerDataAccess(); _partnerDataAccess.updateTipoCambioSubasta(subasta_, tipocambio_); return(Ok(result)); }