public IDataReader ExecuteReader(string sql)
{
LogQuery(sql);
ISqlConnection sqlConnection = connectionProvider.Provide <ISqlConnection>();
sqlConnection.Open();
using (ISqlCommand command = sqlConnection.CreateCommand(null))
{
command.CommandTimeout = 300000;
command.CommandType = CommandType.Text;
command.CommandText = sql;
return(command.ExecuteReader(CommandBehavior.CloseConnection));
}
}
private void ExecuteButtonClick(object window)
{
try
{
if (Query.Trim().ToLower().StartsWith("select"))
{
var table = SqlCommand.ExecuteReader(Query, Parameters.ToList());
ResultTable = table.DefaultView;
}
else
{
SqlCommand.ExecuteNonQuery(Query, Parameters.ToList());
ResultTable = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public IDataReader ExecuteStoredProcedure(string name, params ParameterDefinition[] parametersDefinitions)
{
LogExecuteProc(name);
ISqlConnection sqlConnection = connectionProvider.Provide <ISqlConnection>();
sqlConnection.Open();
using (ISqlCommand command = sqlConnection.CreateCommand(null))
{
command.CommandTimeout = 300000;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = name;
foreach (ParameterDefinition parametersDefinition in parametersDefinitions)
{
command.Parameters.AddWithValue(parametersDefinition.Name, parametersDefinition.Value, parametersDefinition.IsNullable, parametersDefinition.DbType, parametersDefinition.Size, parametersDefinition.Direction);
}
if (parametersDefinitions.Where(m => m.Direction > ParameterDirection.Input).Count() > 0)
{
command.ExecuteNonQuery();
GetParameterCollection(command.Parameters.GetParameter(), parametersDefinitions);
}
return(command.ExecuteReader(CommandBehavior.CloseConnection));
}
}
