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;
}
