public async Task <IDataReader> ExecuteStoredProcedureAsync(string name, params ParameterDefinition[] parametersDefinitions)
{
LogExecuteProc(name);
ISqlConnection connection = connectionProvider.Provide <ISqlConnection>();
await connection.OpenAsync();
IDataReader dataReader1;
using (ISqlCommand command = connection.CreateCommand(null))
{
command.CommandTimeout = 300000;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = name;
ParameterDefinition[] parameterDefinitionArray = parametersDefinitions;
for (int index = 0; index < parameterDefinitionArray.Length; ++index)
{
ParameterDefinition parameterDefinition = parameterDefinitionArray[index];
command.Parameters.AddWithValue(parameterDefinition.Name, parameterDefinition.Value, parameterDefinition.IsNullable, parameterDefinition.DbType, parameterDefinition.Size, parameterDefinition.Direction);
parameterDefinition = null;
}
parameterDefinitionArray = null;
if (parametersDefinitions.Where(m => m.Direction > ParameterDirection.Input).Count() > 0)
{
command.ExecuteNonQuery();
GetParameterCollection(command.Parameters.GetParameter(), parametersDefinitions);
}
IDataReader dataReader = await command.ExecuteReaderAsync(CommandBehavior.CloseConnection);
dataReader1 = dataReader;
}
return(dataReader1);
}
public int ExecuteNonQuery(string sql)
{
LogQuery(sql);
ISqlConnection sqlConnection = connectionProvider.Provide <ISqlConnection>();
sqlConnection.Open();
using (ISqlCommand command = sqlConnection.CreateCommand(connectionProvider.GetDbTransaction))
{
command.CommandTimeout = 300000;
command.CommandType = CommandType.Text;
command.CommandText = sql;
return(command.ExecuteNonQuery());
}
}
public int ExecuteNonQueryStoredProcedure(string name, params ParameterDefinition[] parameterDefinitions)
{
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 parameterDefinition in parameterDefinitions)
{
command.Parameters.AddWithValue(parameterDefinition.Name, parameterDefinition.Value, parameterDefinition.IsNullable, parameterDefinition.DbType, parameterDefinition.Size, parameterDefinition.Direction);
}
int num = command.ExecuteNonQuery();
GetParameterCollection(command.Parameters.GetParameter(), parameterDefinitions);
return(num);
}
}
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));
}
}
