public bool InsertarPlanServ3Play(PlanServ3Play oPlanServ3Play)
{
DAABRequest.Parameter[] arrParam =
{
new DAABRequest.Parameter("P_RESULTADO", DbType.Int32, ParameterDirection.Output),
new DAABRequest.Parameter("P_PLNV_CODIGO", DbType.String, 4,ParameterDirection.Input),
new DAABRequest.Parameter("P_SERVICIOS", DbType.String, 1000,ParameterDirection.Input),
new DAABRequest.Parameter("P_USUARIO_CREA", DbType.String, 10,ParameterDirection.Input)
};
int i = 0;
for (i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[1].Value = oPlanServ3Play.PLNV_CODIGO;
arrParam[2].Value = oPlanServ3Play.SERVV_CODIGO;
arrParam[3].Value = oPlanServ3Play.PSRVV_USUARIO_CREA;
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_INS_PLAN_SERV_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 Insertar en Plan Servicio 3Play. \nMensaje : " + ex.Message;
throw ex;
}
finally
{
obRequest.Factory.Dispose();
}
return(salida);
}
public bool InsertarPlanEqui3Play(PlanServ3Play oPlanServ3Play)
{
PlanServ3PlayDatos oPlanServ3PlayDatos = new PlanServ3PlayDatos();
return(oPlanServ3PlayDatos.InsertarPlanEqui3Play(oPlanServ3Play));
}
