public bool ActualizarPaquete3Play(Paquete3Play oPaquete3Play)
{
DAABRequest.Parameter[] arrParam =
{
new DAABRequest.Parameter("P_PAQTV_CODIGO", DbType.String, 5, ParameterDirection.Input),
new DAABRequest.Parameter("P_PAQTV_DESCRIPCION", DbType.String, 50, ParameterDirection.Input),
new DAABRequest.Parameter("P_TPAQTV_CODIGO", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2, ParameterDirection.Input),
new DAABRequest.Parameter("P_PLANC_CODIGO", DbType.String, 3, ParameterDirection.Input),
new DAABRequest.Parameter("P_TPDOC_CODIGO", DbType.String, 2, ParameterDirection.Input),
new DAABRequest.Parameter("P_PRDC_CODIGO", DbType.String, 2, ParameterDirection.Input),
new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output),
new DAABRequest.Parameter("P_ESTADO", DbType.String, 1, ParameterDirection.Input)
};
int i = 0;
for (i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[0].Value = oPaquete3Play.PAQTV_CODIGO;
arrParam[1].Value = oPaquete3Play.PAQTV_DESCRIPCION;
arrParam[2].Value = oPaquete3Play.TPAQTV_CODIGO;
arrParam[3].Value = oPaquete3Play.TPROC_CODIGO;
arrParam[4].Value = oPaquete3Play.PLANC_CODIGO;
arrParam[5].Value = oPaquete3Play.TPDOC_CODIGO;
arrParam[6].Value = oPaquete3Play.PRDC_CODIGO;
arrParam[8].Value = oPaquete3Play.PAQTC_ESTADO;
bool salida = false;
BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest obRequest = oBDSISACT.CreaRequest();
obRequest.CommandType = CommandType.StoredProcedure;
obRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SISACT_UPD_PAQUETE_3PLAY";
obRequest.Parameters.AddRange(arrParam);
obRequest.Transactional = true;
try
{
obRequest.Factory.ExecuteNonQuery(ref obRequest);
obRequest.Factory.CommitTransaction();
salida = true;
}
catch (Exception ex)
{
obRequest.Factory.RollBackTransaction();
string rMsg = "Error al Modificar en Paquete 3Play. \nMensaje : " + ex.Message;
throw ex;
}
finally
{
obRequest.Factory.Dispose();
}
return(salida);
}
public bool ActualizarPaquete3Play(Paquete3Play oPaquete3Play)
{
Paquete3PlayDatos oPaquete3PlayDatos = new Paquete3PlayDatos();
return(oPaquete3PlayDatos.ActualizarPaquete3Play(oPaquete3Play));
}
public bool InsertarPaquete3Play(Paquete3Play oPaquete3Play, ref string sEstado, ref string rMsg)
{
Paquete3PlayDatos oPaquete3PlayDatos = new Paquete3PlayDatos();
return(oPaquete3PlayDatos.InsertarPaquete3Play(oPaquete3Play, ref sEstado, ref rMsg));
}
