/// <summary>
/// Generates the update statement for this table.
/// </summary>
/// <param name="context"></param>
/// <param name="queryBuilder"></param>
/// <param name="record"> </param>
/// <param name="modifiedProperties"></param>
protected override void DoToUpdateStatement(IMansionContext context, ModificationQueryBuilder queryBuilder, Record record, IPropertyBag modifiedProperties)
{
// create identity parameter
var idParameterName = queryBuilder.AddParameter("id", record.Id, DbType.Int32);
// loop through all the properties
foreach (var propertyName in Columns.Select(column => column.PropertyName))
{
// check if the property is modified
string rawModifiedValue;
if (!modifiedProperties.TryGet(context, propertyName, out rawModifiedValue))
continue;
// get the current values
var currentValues = GetCurrentValues(queryBuilder.Command, record, propertyName).ToList();
// check if there are new properties
var modifiedValues = (rawModifiedValue ?? string.Empty).Split(new[] {','}, StringSplitOptions.RemoveEmptyEntries).Select(x => x.Trim()).ToArray();
// get the deleted values
var deletedValues = currentValues.Except(modifiedValues, StringComparer.OrdinalIgnoreCase);
var newValues = modifiedValues.Except(currentValues, StringComparer.OrdinalIgnoreCase);
// create property parameter
var propertyParameterName = queryBuilder.AddParameter(propertyName, propertyName, DbType.String);
// generate the delete statements
foreach (var deletedValue in deletedValues)
{
// build the query
var valueModificationQuery = new ModificationQueryBuilder(queryBuilder);
// build clause
var valueParameterName = valueModificationQuery.AddParameter("value", deletedValue, DbType.String);
valueModificationQuery.AppendWhereClause("[id] = " + idParameterName + " AND [name] = " + propertyParameterName + " AND [value] = " + valueParameterName);
// append the query
queryBuilder.AppendQuery(valueModificationQuery.ToDeleteStatement(Name));
}
// generate the insert statements
foreach (var newValue in newValues)
{
// build the query
var valueModificationQuery = new ModificationQueryBuilder(queryBuilder);
// set column values
valueModificationQuery.AddColumnValue("id", idParameterName);
valueModificationQuery.AddColumnValue("name", propertyParameterName);
valueModificationQuery.AddColumnValue("value", newValue, DbType.String);
// append the query
queryBuilder.AppendQuery(valueModificationQuery.ToInsertStatement(Name));
}
}
}