internal object ExecuteScalar(string strQuery, IDataParameter[] param, CommandType typeCommand) { this.ExistError = false; this.MsgError = ""; object obj = null; try { try { ProviderSQL providerSQL = new ProviderSQL() { TipoDB = base.TypeDB }; base.IConnection = providerSQL.Connection; base.IConnection.ConnectionString = this.StringConexion; base.ICommand = providerSQL.Command; base.IConnection.Open(); base.ICommand = base.IConnection.CreateCommand(); this.AddParameters(base.ICommand, param); base.ICommand.CommandType = typeCommand; base.ICommand.CommandText = strQuery; obj = base.ICommand.ExecuteScalar(); } catch (Exception exception1) { Exception exception = exception1; this.ExistError = true; this.msgError = exception.Message.Replace("\"", "'").Replace("\r", "").Replace("\n", "\\n"); } } finally { base.ICommand = null; if ((base.IConnection == null ? false : base.IConnection.State == ConnectionState.Open)) { base.IConnection.Close(); } base.IConnection = null; } return obj; }
internal IDataReader ExecuteReader(string strQuery) { IDataReader dataReader; this.ExistError = false; this.MsgError = ""; try { ProviderSQL providerSQL = new ProviderSQL() { TipoDB = base.TypeDB }; base.IConnection = providerSQL.Connection; base.IConnection.ConnectionString = this.StringConexion; base.IConnection.Open(); base.ICommand = base.IConnection.CreateCommand(); base.ICommand.CommandText = strQuery; dataReader = base.ICommand.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception exception1) { Exception exception = exception1; this.ExistError = true; this.msgError = exception.Message.Replace("\"", "'").Replace("\r", "").Replace("\n", "\\n"); dataReader = null; } return dataReader; }
internal int ExecuteNonQuery(string strQuery) { this.ExistError = false; this.MsgError = ""; int num = -1; try { try { ProviderSQL providerSQL = new ProviderSQL() { TipoDB = base.TypeDB }; base.IConnection = providerSQL.Connection; base.IConnection.ConnectionString = this.StringConexion; base.ICommand = providerSQL.Command; base.IConnection.Open(); base.ICommand = base.IConnection.CreateCommand(); base.ICommand.CommandText = strQuery; num = base.ICommand.ExecuteNonQuery(); } catch (Exception exception1) { Exception exception = exception1; this.ExistError = true; this.msgError = exception.Message.Replace("\"", "'").Replace("\r", "").Replace("\n", "\\n"); } } finally { base.ICommand = null; if ((base.IConnection == null ? false : base.IConnection.State == ConnectionState.Open)) { base.IConnection.Close(); } base.IConnection = null; } return num; }
internal IDataAdapter DataAdapter(string strQuery) { IDataAdapter dataAdapter; this.ExistError = false; this.MsgError = ""; IDataAdapter adapter = null; try { try { ProviderSQL providerSQL = new ProviderSQL() { TipoDB = base.TypeDB }; base.IConnection = providerSQL.Connection; base.IConnection.ConnectionString = this.StringConexion; base.IConnection.Open(); base.ICommand = base.IConnection.CreateCommand(); base.ICommand.CommandText = strQuery; providerSQL.Command = base.ICommand; adapter = providerSQL.Adapter; dataAdapter = adapter; return dataAdapter; } catch (Exception exception1) { Exception exception = exception1; this.ExistError = true; this.msgError = exception.Message.Replace("\"", "'").Replace("\r", "").Replace("\n", "\\n"); } } finally { base.ICommand = null; if ((base.IConnection == null ? false : base.IConnection.State == ConnectionState.Open)) { base.IConnection.Close(); } base.IConnection = null; } dataAdapter = adapter; return dataAdapter; }
internal IDataParameter[] AddParameters(IDataParameter[] Parameters, DbType TypeObject, ParameterDirection Direction, string ParameterName, object Value) { ProviderSQL providerSQL = new ProviderSQL(); if (Parameters != null) { providerSQL.ParameterLenght = (int)Parameters.Length + 1; providerSQL.Parameters = new IDataParameter[providerSQL.ParameterLenght]; int i = 0; for (i = 0; i < (int)Parameters.Length; i++) { providerSQL.Parameters[i] = Parameters[i]; } providerSQL.Parameters[i].DbType = TypeObject; providerSQL.Parameters[i].Direction = Direction; providerSQL.Parameters[i].ParameterName = ParameterName; providerSQL.Parameters[i].Value = Value; } else { providerSQL.ParameterLenght = 1; providerSQL.Parameters = new IDataParameter[providerSQL.ParameterLenght]; providerSQL.Parameters[0].DbType = TypeObject; providerSQL.Parameters[0].Direction = Direction; providerSQL.Parameters[0].ParameterName = ParameterName; providerSQL.Parameters[0].Value = Value; } Parameters = providerSQL.Parameters; return Parameters; }
internal IDbTransaction BaseBeginTransaction(string strConnection) { if ((this.IConnection == null ? false : this.IConnection.State == ConnectionState.Open)) { this.IConnection.Close(); } ProviderSQL providerSQL = new ProviderSQL() { TipoDB = this.TypeDB }; this.IConnection = providerSQL.Connection; this.IConnection.ConnectionString = strConnection; this.IConnection.Open(); this.ITransaction = this.IConnection.BeginTransaction(); return this.ITransaction; }