public static void Check(bool condition, ParameterError parameterError) { if (condition != true) { throw new ParameterException(parameterError); } }
public DataSet ExecuteDataSet(string query, CommandType commandtype, ConnectionState connectionstate, ParameterError parameterError, CleanParameters cleanParameters) { DbDataAdapter adapter = objFactory.CreateDataAdapter(); if (parameterError == ParameterError.include) { addParameterError(); } objCommand.CommandText = query; objCommand.CommandType = commandtype; adapter.SelectCommand = objCommand; DataSet ds = new DataSet(); try { adapter.Fill(ds); if (parameterError == ParameterError.include) { string error = objCommand.Parameters[DBHelper.MENSAJE_ERROR].Value.ToString(); if (error != string.Empty) { throw new ValidatorException(error); } } } catch (Exception ex) { HandleExceptions(ex); } finally { if (cleanParameters == CleanParameters.clean) { objCommand.Parameters.Clear(); } if (connectionstate == ConnectionState.CloseOnExit) { if (objConnection.State == System.Data.ConnectionState.Open) { objConnection.Close(); } } } return(ds); }
public DbDataReader ExecuteReader(string query, CommandType commandtype, ConnectionState connectionstate, ParameterError parameterError, CleanParameters cleanParameters) { objCommand.CommandText = query; objCommand.CommandType = commandtype; DbDataReader reader = null; try { if (parameterError == ParameterError.include) { addParameterError(); } if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } if (connectionstate == ConnectionState.CloseOnExit) { reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection); } else { reader = objCommand.ExecuteReader(); } if (parameterError == ParameterError.include) { string error = objCommand.Parameters[DBHelper.MENSAJE_ERROR].Value.ToString(); if (error != string.Empty) { throw new ValidatorException(error); } } } catch (Exception ex) { HandleExceptions(ex); } finally { if (cleanParameters == CleanParameters.clean) { objCommand.Parameters.Clear(); } } return(reader); }
public int ExecuteNonQuery(string query, CommandType commandtype, ConnectionState connectionstate, ParameterError parameterError, CleanParameters cleanParameters) { objCommand.CommandText = query; objCommand.CommandType = commandtype; if (parameterError == ParameterError.include) { addParameterError(); } int i = -1; try { if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } i = objCommand.ExecuteNonQuery(); if (parameterError == ParameterError.include) { string error = objCommand.Parameters[DBHelper.MENSAJE_ERROR].Value.ToString(); if (error != string.Empty) { throw new ValidatorException(error); } } } catch (Exception ex) { HandleExceptions(ex); } finally { if (cleanParameters == CleanParameters.clean) { objCommand.Parameters.Clear(); } if (connectionstate == ConnectionState.CloseOnExit) { //objConnection.Close(); } } return(i); }
public bool OnParameterError(ITemplateParameter parameter, string receivedValue, string message, out string newValue) { newValue = null; return(ParameterError?.Invoke(parameter, receivedValue, message, out newValue) ?? false); }
public bool OnParameterError(ITemplateParameter parameter, string receivedValue, string message, out string?newValue) { newValue = null; Console.WriteLine($"[{HostIdentifier}][{nameof(OnParameterError)}] {message}; parameter '{parameter.Name}', received value '{receivedValue}'"); return(ParameterError?.Invoke(parameter, receivedValue, message, out newValue) ?? false); }
public ParameterException(ParameterError parameterError) : base($"Fail to get parameter. {nameof(ParameterError)} : {parameterError}") { ParameterError = parameterError; }