public async Task <IActionResult> PrintCuponera([FromBody] PrintCupon parametersPrint)
{
_logger.LogInfo("Metodo Print cupon");
var Result = await _cuponeraService.PrintCupon(parametersPrint);
return(Ok(Result));
}
public async Task <GenerateResponse> PrintCupon(PrintCupon paramPrint)
{
GenerateResponse Cupon = null;
List <TemplateCupon1> template = null;
try
{
var ReciboResult = await _cuponeraRepository.PrintCupon(_mapper.Map <PrintCupon>(paramPrint));
if (ReciboResult == null)
{
return(null);
}
template = _mapper.Map <List <TemplateCupon1> >(ReciboResult);
Cupon =
ConsumeService <GenerateResponse, List <TemplateCupon1> > .PostRequest(_ldapSettings.UrlServicioGestor, "Report/GenerateReport", template);
if (Cupon.P_NCODE == 0 && paramPrint.flgCronograma)
{
GenerateResponse cronoResponse = null;
List <TemplateCupon2> ListCronograma = new List <TemplateCupon2>();
var Cronograma = await _cuponeraRepository.PrintCuponCrono(_mapper.Map <PrintCupon>(paramPrint));
ListCronograma = _mapper.Map <List <TemplateCupon2> >(Cronograma);
cronoResponse =
ConsumeService <GenerateResponse, List <TemplateCupon2> > .PostRequest(_ldapSettings.UrlServicioGestor, "Report/GenerateReportCrono", ListCronograma);
if (cronoResponse.P_NCODE == 0)
{
Cupon.data2 = cronoResponse.data;
}
}
}
catch (Exception ex)
{
_logger.LogError(ex.InnerException.ToString());
}
return(Cupon);
}
public Task <List <TemplateCupon2> > PrintCuponCrono(PrintCupon paramPrint)
{
List <TemplateCupon2> Template = new List <TemplateCupon2>();
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(new OracleParameter("NCUPONERA", OracleDbType.Int32, paramPrint.cuponera, ParameterDirection.Input));
parameters.Add(new OracleParameter("NCUOTA_INI", OracleDbType.Int32, paramPrint.cuponInicial, ParameterDirection.Input));
parameters.Add(new OracleParameter("NCUOTA_FIN", OracleDbType.Int32, paramPrint.cuponFinal, ParameterDirection.Input));
parameters.Add(new OracleParameter("NCOPY", OracleDbType.Int32, paramPrint.copias, ParameterDirection.Input));
parameters.Add(new OracleParameter("CUR_TOUT", OracleDbType.RefCursor, ParameterDirection.Output));
using (OracleDataReader dr = (OracleDataReader)_connectionBase.ExecuteByStoredProcedure("PKG_CRE_CUPONERA.PRINTCOUPONBOOK2", parameters, ConnectionBase.enuTypeDataBase.OracleVTime))
{
while (dr.Read())
{
TemplateCupon2 item = new TemplateCupon2()
{
DesRamo = (dr[":B19"] != null ? Convert.ToString(dr[":B19"]) : string.Empty),
Poliza = (dr[":B18"] != null ? Convert.ToString(dr[":B18"]) : string.Empty),
VigenciaDesde = (dr[":B16"] != null ? Convert.ToDateTime(dr[":B16"]).ToString("dd/MM/yyyy") : string.Empty),
VigenciaHasta = (dr[":B15"] != null ? Convert.ToDateTime(dr[":B15"]).ToString("dd/MM/yyyy") : string.Empty),
Moneda = (dr[":B13"] != null ? Convert.ToString(dr[":B13"]) : string.Empty),
ModalidadPago = (dr[":B12"] != null ? Convert.ToString(dr[":B12"]) : string.Empty),
Fecha = (dr[":B9"] != null ? Convert.ToDateTime(dr[":B9"]).ToString("dd/MM/yyyy") : string.Empty),
Nombres = (dr[":B7"] != null ? Convert.ToString(dr[":B7"]) : string.Empty),
NroDocumento = (dr[":B6"] != null ? Convert.ToString(dr[":B6"]) : string.Empty),
Direccion = (dr["L_NINTERMED"] != null ? Convert.ToString(dr["L_NINTERMED"]) : string.Empty),
NroCupon = (dr["NCOUPON"] != null ? Convert.ToString(dr["NCOUPON"]) : string.Empty),
NroRecibo = (dr["NRECEIPT"] != null ? Convert.ToString(dr["NRECEIPT"]) : string.Empty),
Vencimiento = (dr["DPAYDATE"] != null ? Convert.ToDateTime(dr["DPAYDATE"]).ToString("dd/MM/yyyy") : string.Empty),
Interes = "0",
Importe = (dr["NPREMIUM"] != null ? Convert.ToString(dr["NPREMIUM"]) : string.Empty),
NroPago = (dr["NCUPONERA"] != null ? Convert.ToString(dr["NCUPONERA"]) : string.Empty),
};
Template.Add(item);
}
}
return(Task.FromResult(Template));
}
public Task <List <TemplateCupon1> > PrintCupon(PrintCupon paramPrint)
{
List <TemplateCupon1> Template = new List <TemplateCupon1>();
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(new OracleParameter("NCUPONERA", OracleDbType.Int32, paramPrint.cuponera, ParameterDirection.Input));
parameters.Add(new OracleParameter("NCUOTA_INI", OracleDbType.Int32, paramPrint.cuponInicial, ParameterDirection.Input));
parameters.Add(new OracleParameter("NCUOTA_FIN", OracleDbType.Int32, paramPrint.cuponFinal, ParameterDirection.Input));
parameters.Add(new OracleParameter("NCOPY", OracleDbType.Int32, paramPrint.copias, ParameterDirection.Input));
parameters.Add(new OracleParameter("CUR_TOUT", OracleDbType.RefCursor, ParameterDirection.Output));
using (OracleDataReader dr = (OracleDataReader)_connectionBase.ExecuteByStoredProcedure("PKG_CRE_CUPONERA.PRINTCOUPONBOOK1", parameters, ConnectionBase.enuTypeDataBase.OracleVTime))
{
while (dr.Read())
{
TemplateCupon1 item = new TemplateCupon1()
{
IdRamo = (dr[":B17"] != null ? Convert.ToInt32(dr[":B17"]) : 0),
DesRamo = (dr[":B16"] != null ? Convert.ToString(dr[":B16"]) : string.Empty),
IdMoneda = (dr[":B15"] != null ? Convert.ToInt32(dr[":B15"]) : 0),
DesMoneda = (dr[":B14"] != null ? Convert.ToString(dr[":B14"]) : string.Empty),
Policy = (dr[":B13"] != null ? Convert.ToString(dr[":B13"]) : string.Empty),
VigenciaDesde = (dr[":B11"] != null ? Convert.ToString(dr[":B11"]) : string.Empty),
VigenciaHasta = (dr[":B10"] != null ? Convert.ToString(dr[":B10"]) : string.Empty),
Asegurado = (dr[":B8"] != null ? Convert.ToString(dr[":B8"]) : string.Empty),
Documento = (dr[":B7"] != null ? Convert.ToString(dr[":B7"]) : string.Empty),
Direccion = (dr[":B6"] != null ? Convert.ToString(dr[":B6"]) : string.Empty),
Convenio = (dr[":B5"] != null ? Convert.ToInt32(dr[":B5"]) : 0),
Intermediario = (dr[":B4"] != null ? Convert.ToString(dr[":B4"]) : string.Empty),
Cuponera = (dr["NCUPONERA"] != null ? Convert.ToString(dr["NCUPONERA"]) : string.Empty),
Cupon = (dr["NCOUPON"] != null ? Convert.ToString(dr["NCOUPON"]) : string.Empty),
FechaVencimiento = (dr["DPAYDATE"] != null ? Convert.ToString(dr["DPAYDATE"]) : string.Empty),
Importe = (dr["NPREMIUM"] != null ? Convert.ToDecimal(dr["NPREMIUM"]) : 0)
};
Template.Add(item);
}
}
return(Task.FromResult(Template));
}
