/// <summary>
///
/// </summary>
/// <param name="daScopeContext"></param>
/// <param name="dataAdapterCommand"></param>
/// <param name="commandWrappersDataAdapter"></param>
/// <returns></returns>
internal static DbCommand GetDbCommand(DaScopeContext daScopeContext, DataAdapterCommand dataAdapterCommand, Dictionary <DataAdapterCommand, DbCommandWrapper> commandWrappersDataAdapter)
{
if (commandWrappersDataAdapter.ContainsKey(dataAdapterCommand))
{
DbCommandWrapper commandWrapper = commandWrappersDataAdapter[dataAdapterCommand];
return(commandWrapper.GetDbCommand(daScopeContext));
}
return(null);
}
private void ConfigCommand(DataAdapterCommand dataAdapterCommand, string commandText, CommandType commandType, int commandTimeout)
{
DbCommandWrapper commandWrapper;
if (!_commandWrappersDataAdapter.ContainsKey(dataAdapterCommand))
{
commandWrapper = new DbCommandWrapper(commandText, commandType);
_commandWrappersDataAdapter.Add(dataAdapterCommand, commandWrapper);
}
else
{
commandWrapper = _commandWrappersDataAdapter[dataAdapterCommand];
commandWrapper.CommandText = commandText;
commandWrapper.CommandType = commandType;
commandWrapper.CommandTimeout = commandTimeout;
}
UpdateCommandOfDataAdapter(dataAdapterCommand, commandWrapper);
}
/// <summary>
/// Update commands of DataAdater if the instance already exists
/// </summary>
/// <param name="dataAdapterCommand"></param>
/// <param name="commandWrapper"></param>
private void UpdateCommandOfDataAdapter(DataAdapterCommand dataAdapterCommand, DbCommandWrapper commandWrapper)
{
if (_dataAdapter != null)
{
switch (dataAdapterCommand)
{
case DataAdapterCommand.Select:
DataAdapter.SelectCommand = commandWrapper.GetDbCommand(DaScopeContext);
break;
case DataAdapterCommand.Insert:
DataAdapter.InsertCommand = commandWrapper.GetDbCommand(DaScopeContext);
break;
case DataAdapterCommand.Update:
DataAdapter.UpdateCommand = commandWrapper.GetDbCommand(DaScopeContext);
break;
case DataAdapterCommand.Delete:
DataAdapter.DeleteCommand = commandWrapper.GetDbCommand(DaScopeContext);
break;
}
}
}
public DbCommandUtil(DataAdapterCommand _dataAdapterCommand)
{
_commandWrappersDataAdapter = new Dictionary <DataAdapterCommand, DbCommandWrapper>();
_daScopeContextIsCreatedInThisInstance = false;
this._dataAdapterCommand = _dataAdapterCommand;
}
public DbCommandUtil(string commandText, string connectionStringSettingName, DataAdapterCommand _dataAdapterCommand)
: this(commandText, CommandType.Text)
{
_daScopeContext = new DaScopeContext(connectionStringSettingName);
this._dataAdapterCommand = _dataAdapterCommand;
}
public DbCommandUtil(string commandText, DataAdapterCommand dataAdapterCommand)
: this(commandText, CommandType.Text)
{
_dataAdapterCommand = dataAdapterCommand;
}
public DbCommandUtil(string commandText, CommandType commandType, DataAdapterCommand dataAdapterCommand)
: this()
{
ChangeToDataAdaterCommand(DataAdapterCommand.Select, commandText, commandType);
_dataAdapterCommand = dataAdapterCommand;
}
/// <summary>
///
/// </summary>
public void ChangeToDataAdaterCommand(DataAdapterCommand value)
{
_dataAdapterCommand = value;
}
public void ChangeToDataAdaterCommand(DataAdapterCommand value, string commandText, CommandType commandType)
{
_dataAdapterCommand = value;
CommandText = commandText;
CommandType = commandType;
}
public void ChangeDataAdaterCommand(DataAdapterCommand value, string commandText)
{
ChangeToDataAdaterCommand(value, commandText, CommandType.Text);
}
private void ConfigCommand(DataAdapterCommand dataAdapterCommand, string commandText, CommandType commandType)
{
ConfigCommand(dataAdapterCommand, commandText, commandType, DbCommandWrapper.DEFAULT_COMMAND_TIMEOUT);
}
private void ConfigCommand(DataAdapterCommand dataAdapterCommand, string commandText)
{
ConfigCommand(dataAdapterCommand, commandText, CommandType.Text);
}
