public void Insertar_Correccion_Nombres(Vista_Correccion_Nombres oItem)
{
DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_TIPO_DOCUMENTO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("P_NRO_DOCUMENTO", DbType.String, 11,ParameterDirection.Input),
new DAABRequest.Parameter("P_NOMBRE_ANTERIOR", DbType.String, 40,ParameterDirection.Input),
new DAABRequest.Parameter("P_AP_PAT_ANTERIOR", DbType.String, 40,ParameterDirection.Input),
new DAABRequest.Parameter("P_AP_MAT_ANTERIOR", DbType.String, 40,ParameterDirection.Input),
new DAABRequest.Parameter("P_NOMBRE_NUEVO", DbType.String, 40,ParameterDirection.Input),
new DAABRequest.Parameter("P_AP_PAT_NUEVO", DbType.String, 40,ParameterDirection.Input),
new DAABRequest.Parameter("P_AP_MAT_NUEVO", DbType.String, 40,ParameterDirection.Input),
new DAABRequest.Parameter("P_SOLIN_CODIGO", DbType.Int64, ParameterDirection.Input),
new DAABRequest.Parameter("P_TERMINAL", DbType.String, 20,ParameterDirection.Input),
new DAABRequest.Parameter("P_USU_CREA", DbType.String, 10,ParameterDirection.Input),
new DAABRequest.Parameter("P_CLIED_FEC_NAC", DbType.Date, ParameterDirection.Input) };
int i = 0;
for (i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[0].Value = oItem.SIVNC_TIPO_DOCUMENTO;
arrParam[1].Value = oItem.SIVNV_NUM_DOCUMENTO;
arrParam[2].Value = oItem.SIVNV_NOMBRE_ANTERIOR;
arrParam[3].Value = oItem.SIVNV_APE_PATERNO_ANT;
arrParam[4].Value = oItem.SIVNV_APE_MATERNO_ANT;
arrParam[5].Value = oItem.SIVNV_NOMBRE_NUEVO;
arrParam[6].Value = oItem.SIVNV_APE_PATERNO_NUEVO;
arrParam[7].Value = oItem.SIVNV_APE_MATERNO_NUEVO;
arrParam[8].Value = oItem.SIVNV_SOLIN_CODIGO;
arrParam[9].Value = oItem.SIVNV_TERMINAL;
arrParam[10].Value = oItem.SIVNV_USUARIO_CREACION;
arrParam[11].Value = oItem.FECHA_NACIMIENTO;
BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest obRequest = obj.CreaRequest();
obRequest.CommandType = CommandType.StoredProcedure;
obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_CONS_2 + ".SP_ACTUALIZAR_NOMBRES_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();
}
}
public void Insertar_Correccion_Nombres(Vista_Correccion_Nombres vista)
{
new SolicitudDC_ReporteDatos().Insertar_Correccion_Nombres(vista);
}
