private DbCommand CreateChangeCommand(
EntityRecord entityRecord,
EntityChangeType changeType,
string keyValue,
Func <string> changeDescriber = null)
{
if (changeType == EntityChangeType.Insert)
{
entityRecord.SetKeyValue(keyValue);
}
var cmd = DB.CreateCommand(_admin.ConnectionStringName);
var changeEntity = _admin.ChangeEntity;
var table = changeEntity.Table;
var entityNameColumn = changeEntity["EntityName"].Column;
var entityKeyColumn = changeEntity["EntityKey"].Column;
var changeTypeColumn = changeEntity["ChangeType"].Column;
var recordDisplayColumn = changeEntity["RecordDisplayName"].Column;
var descriptionColumn = changeEntity["Description"].Column;
var changedOnColumn = changeEntity["ChangedOn"].Column;
var changedByColumn = changeEntity["ChangedBy"].Column;
var sql =
$@"INSERT INTO {table} ({entityNameColumn}, {entityKeyColumn}, {changeTypeColumn}, {recordDisplayColumn}, {descriptionColumn}, {changedOnColumn}, {changedByColumn})
VALUES (@0,@1,@2,@3,@4,@5,@6);";
cmd.AddParam(entityRecord.Entity.Name);
cmd.AddParam(keyValue);
cmd.AddParam(changeType);
cmd.AddParam(entityRecord.ToString());
cmd.AddParam(changeDescriber == null ? null : changeDescriber());
cmd.AddParam(DateTime.UtcNow);
cmd.AddParam(_user.CurrentUserName());
cmd.CommandText = sql;
return(cmd);
}
private DbCommand CreateChangeCommand(
EntityRecord entityRecord,
EntityChangeType changeType,
string keyValue,
Func<string> changeDescriber = null)
{
if(changeType == EntityChangeType.Insert)
{
entityRecord.SetKeyValue(keyValue);
}
var cmd = DB.CreateCommand(_admin.ConnectionStringName);
var changeEntity = _admin.ChangeEntity;
var table = changeEntity.Table;
var entityNameColumn = changeEntity["EntityName"].Column;
var entityKeyColumn = changeEntity["EntityKey"].Column;
var changeTypeColumn = changeEntity["ChangeType"].Column;
var recordDisplayColumn = changeEntity["RecordDisplayName"].Column;
var descriptionColumn = changeEntity["Description"].Column;
var changedOnColumn = changeEntity["ChangedOn"].Column;
var changedByColumn = changeEntity["ChangedBy"].Column;
var sql =
$@"INSERT INTO {table} ({entityNameColumn}, {entityKeyColumn}, {changeTypeColumn}, {recordDisplayColumn}, {descriptionColumn}, {changedOnColumn}, {changedByColumn})
VALUES (@0,@1,@2,@3,@4,@5,@6);";
cmd.AddParam(entityRecord.Entity.Name);
cmd.AddParam(keyValue);
cmd.AddParam(changeType);
cmd.AddParam(entityRecord.ToString());
cmd.AddParam(changeDescriber == null ? null : changeDescriber());
cmd.AddParam(DateTime.UtcNow);
cmd.AddParam(_user.CurrentUserName());
cmd.CommandText = sql;
return cmd;
}