//Renovacion
public void Insertar_DC_Reporte(Vista_SolicitudDC_Reporte vista)
{
DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_DCREV_NUM_OPERACION", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREN_SOLIN_CODIGO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREV_OVEN_CODIGO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREN_USUARIO_REG", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREC_TIPO_DOCUMENTO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREV_NUM_DOCUMENTO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREV_APELLIDO_PAT", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREV_APELLIDO_MAT", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREV_NOMBRE", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREN_CANT_INTENTOS", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("P_DCREC_VALIDAR_CLIENTE", DbType.String, ParameterDirection.Input) };
int intCont = 0;
for (intCont = 0; intCont < arrParam.Length; intCont++)
{
arrParam[intCont].Value = DBNull.Value;
}
if (!vista.DCREV_NUM_OPERACION.Equals(""))
{
arrParam[0].Value = vista.DCREV_NUM_OPERACION;
}
if (!vista.DCREN_SOLIN_CODIGO.Equals(""))
{
arrParam[1].Value = vista.DCREN_SOLIN_CODIGO;
}
if (!vista.DCREV_OVEN_CODIGO.Equals(""))
{
arrParam[2].Value = vista.DCREV_OVEN_CODIGO;
}
if (!vista.DCREN_USUARIO_REG.Equals(""))
{
arrParam[3].Value = vista.DCREN_USUARIO_REG;
}
if (!vista.DCREC_TIPO_DOCUMENTO.Equals(""))
{
arrParam[4].Value = vista.DCREC_TIPO_DOCUMENTO;
}
if (!vista.DCREV_NUM_DOCUMENTO.Equals(""))
{
arrParam[5].Value = vista.DCREV_NUM_DOCUMENTO;
}
if (!vista.DCREV_APELLIDO_PAT.Equals(""))
{
arrParam[6].Value = vista.DCREV_APELLIDO_PAT;
}
if (!vista.DCREV_APELLIDO_MAT.Equals(""))
{
arrParam[7].Value = vista.DCREV_APELLIDO_MAT;
}
if (!vista.DCREV_NOMBRE.Equals(""))
{
arrParam[8].Value = vista.DCREV_NOMBRE;
}
if (!vista.DCREN_CANT_INTENTOS.Equals(-1))
{
arrParam[9].Value = vista.DCREN_CANT_INTENTOS;
}
if (!vista.DCREC_VALIDAR_CLIENTE.Equals(""))
{
arrParam[10].Value = vista.DCREC_VALIDAR_CLIENTE;
}
BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest obRequest = obj.CreaRequest();
obRequest.CommandType = CommandType.StoredProcedure;
obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_CONS_2 + ".SISACT_INSERTAR_REPORTE_DC";
obRequest.Parameters.AddRange(arrParam);
obRequest.Transactional = true;
try
{
obRequest.Factory.ExecuteNonQuery(ref obRequest);
obRequest.Factory.CommitTransaction();
}
catch (Exception e)
{
obRequest.Factory.RollBackTransaction();
throw e;
}
finally
{
obRequest.Factory.Dispose();
obRequest.Parameters.Clear();
}
}
//Renovacion
public void Insertar_DC_Reporte(Vista_SolicitudDC_Reporte vista)
{
new SolicitudDC_ReporteDatos().Insertar_DC_Reporte(vista);
}
