public bool MantenimientoPlan3Play(string strAccion, Plan3Play oPlan) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_ACCION", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_PARAM_GENERALES", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_PLAZOS", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_SERVICIOS", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_ALQUILER", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_USUARIO_CREA", DbType.String, 4000,ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 1; arrParam[i].Value = strAccion; i++; arrParam[i].Value = oPlan.PARAM_GENERALES; i++; arrParam[i].Value = oPlan.PLAZOS; i++; arrParam[i].Value = oPlan.SERVICIOS; i++; arrParam[i].Value = oPlan.ALQUILER; i++; arrParam[i].Value = oPlan.PLNV_USUARIO_CREA; bool blnOK = false; int resultado; BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = oBDSISACT.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SP_MAN_PLAN"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); IDataParameter parSalida1 = (IDataParameter)obRequest.Parameters[0]; resultado = Funciones.CheckInt(parSalida1.Value); if (resultado == 1) { blnOK = true; } } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { obRequest.Factory.Dispose(); } return(blnOK); }
public bool ActualizarPlan3Play(Plan3Play oPlan3Play) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PLNV_CODIGO", DbType.String, 4, ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_DESCRIPCION", DbType.String, 50, ParameterDirection.Input), new DAABRequest.Parameter("P_PLNC_ESTADO", DbType.String, 1, ParameterDirection.Input), new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2, ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_USUARIO_CREA", DbType.String, 10, ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_CODIGO_BSCS", DbType.String, 4, ParameterDirection.Input), new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = oPlan3Play.PLNV_CODIGO; arrParam[1].Value = oPlan3Play.PLNV_DESCRIPCION; arrParam[2].Value = oPlan3Play.PLNC_ESTADO; arrParam[3].Value = oPlan3Play.TPROC_CODIGO; arrParam[4].Value = oPlan3Play.PLNV_USUARIO_CREA; arrParam[5].Value = oPlan3Play.PLNV_CODIGO_BSCS; 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_PLAN_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 Plan 3Play. \nMensaje : " + ex.Message; throw ex; } finally { obRequest.Factory.Dispose(); } return(salida); }
public bool InsertarPlan3Play(Plan3Play oPlan3Play, ref string sCodigoPlan, ref string rMsg) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_PLNV_DESCRIPCION", DbType.String, 50,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNC_ESTADO", DbType.String, 1,ParameterDirection.Input), new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_USUARIO_CREA", DbType.String, 10,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_CODIGO_BSCS", DbType.String, 4,ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 1; arrParam[i].Value = oPlan3Play.PLNV_DESCRIPCION; i++; arrParam[i].Value = oPlan3Play.PLNC_ESTADO; i++; arrParam[i].Value = oPlan3Play.TPROC_CODIGO; i++; arrParam[i].Value = oPlan3Play.PLNV_USUARIO_CREA; i++; arrParam[i].Value = oPlan3Play.PLNV_CODIGO_BSCS; 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_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(); rMsg = "Error al Insertar Plan 3Play. \nMensaje : " + ex.Message; throw ex; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[0]; sCodigoPlan = Funciones.CheckStr(parSalida1.Value); obRequest.Factory.Dispose(); } return(salida); }
public bool MantenimientoPlan3Play(string strAccion, Plan3Play oPlan) { return(new Plan3PlayDatos().MantenimientoPlan3Play(strAccion, oPlan)); }
public bool EliminarPlan3Play(Plan3Play oPlan3Play) { Plan3PlayDatos oPlan3PlayDatos = new Plan3PlayDatos(); return(oPlan3PlayDatos.EliminarPlan3Play(oPlan3Play)); }
public bool ActualizarPlan3Play(Plan3Play oPlan3Play) { Plan3PlayDatos oPlan3PlayDatos = new Plan3PlayDatos(); return(oPlan3PlayDatos.ActualizarPlan3Play(oPlan3Play)); }
public bool InsertarPlan3Play(Plan3Play oPlan3Play, ref string sCodigoPlan, ref string rMsg) { Plan3PlayDatos oPlan3PlayDatos = new Plan3PlayDatos(); return(oPlan3PlayDatos.InsertarPlan3Play(oPlan3Play, ref sCodigoPlan, ref rMsg)); }
public ArrayList ListarPlan3Play(string P_PLNV_CODIGO, string P_PLNV_DESCRIPCION, string P_PLNC_ESTADO) { Plan3Play oPlan3Play = null; DataTable oDataTable = new DataTable(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PLNV_CODIGO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_DESCRIPCION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_PLNC_ESTADO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = P_PLNV_CODIGO; arrParam[1].Value = P_PLNV_DESCRIPCION; arrParam[2].Value = P_PLNC_ESTADO; BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest oDAABRequest = oBDSISACT.CreaRequest(); oDAABRequest.CommandType = CommandType.StoredProcedure; oDAABRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SISACT_SEL_PLAN_3PLAY"; oDAABRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = oDAABRequest.Factory.ExecuteReader(ref oDAABRequest).ReturnDataReader; while (dr.Read()) { oPlan3Play = new Plan3Play(); oPlan3Play.PLNV_CODIGO = Funciones.CheckStr(dr["PLNV_CODIGO"]); oPlan3Play.PLNV_DESCRIPCION = Funciones.CheckStr(dr["PLNV_DESCRIPCION"]); oPlan3Play.PLNC_ESTADO = Funciones.CheckStr(dr["PLNC_ESTADO"]); oPlan3Play.ESTADO_PLAN = Funciones.CheckStr(dr["ESTADO_PLAN"]); oPlan3Play.TVENC_CODIGO = Funciones.CheckStr(dr["TVENC_CODIGO"]); oPlan3Play.TVENV_DESCRIPCION = Funciones.CheckStr(dr["TVENV_DESCRIPCION"]); oPlan3Play.TPROC_CODIGO = Funciones.CheckStr(dr["TPROC_CODIGO"]); oPlan3Play.TPROV_DESCRIPCION = Funciones.CheckStr(dr["TPROV_DESCRIPCION"]); oPlan3Play.PLNN_CARGO_FIJO = Funciones.CheckDecimal(dr["PLNN_CARGO_FIJO"]); oPlan3Play.PLNC_TIPO_PRODUCTO = Funciones.CheckStr(dr["PLNC_TIPO_PRODUCTO"]); oPlan3Play.PRDV_DESCRIPCION = Funciones.CheckStr(dr["PRDV_DESCRIPCION"]); filas.Add(oPlan3Play); } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } oDAABRequest.Parameters.Clear(); oDAABRequest.Factory.Dispose(); } return(filas); }