public virtual void Update(TEntity entity)
{
ICondition criteria = IdentityInsert
? Conditions.IsEqual(Entity.ID, new SqlNumber(entity.Id.ToString()))
: Conditions.IsEqual(Entity.ID, new SqlString(entity.Id.ToString()));
var current = GetOne(criteria);
if (current == null)
{
return;
}
bool hasChanges = false;
foreach (var item in _metadata.Columns)
{
if (current[item.Name] != entity[item.Name])
{
hasChanges = true;
break;
}
}
if (hasChanges)
{
var update = SqlUtils.CreateUpdateStatement(_metadata);
update.ConnectionStringName = _connectionStringName;
foreach (var item in _metadata.Columns)
{
update.SetParamValue(item.Name, entity[item.Name]);
}
update.Execute();
}
if (_hasManyAssociations.Count() == 0)
{
return;
}
foreach (IAssociationMapping hma in _hasManyAssociations)
{
var items = entity[hma.Name] as IEnumerable <ValueObject>;
if (items == null)
{
continue;
}
var storedItems = current[hma.Name] as IEnumerable <ValueObject>;
// if (storedItems == null)
// continue;
var omapping = MappingFactory.GetMapping(hma.OtherMappingType);
//var primKeys = omapping.Columns.Where(o => o.IsPrimaryKey || o.IsDbGenerated).ToList();
DeleteStatement deleteStament = SqlUtils.CreateDeleteStatement(omapping, true);
deleteStament.ConnectionStringName = _connectionStringName;
InsertStatement insertStament = SqlUtils.CreateInsertStatement(omapping);
insertStament.ConnectionStringName = _connectionStringName;
if (storedItems != null)
{
// Delete non existent
foreach (ValueObject storedItem in storedItems)
{
var itemFound = items.FirstOrDefault(ci => ci.Equals(storedItem));
if (itemFound == null)
{
foreach (ColumnMapping cm in omapping.Columns)
{
deleteStament.SetParamValue(cm.Name, storedItem[cm.Name]);
}
deleteStament.Execute();
}
}
// Insert non existent
foreach (ValueObject item in items)
{
var itemFound = storedItems.FirstOrDefault(si => si.Equals(item));
if (itemFound == null)
{
foreach (ColumnMapping cm in omapping.Columns)
{
insertStament.SetParamValue(cm.Name, item[cm.Name]);
}
insertStament.Execute();
}
}
}
else
{
foreach (ValueObject item in items)
{
foreach (ColumnMapping cm in omapping.Columns)
{
insertStament.SetParamValue(cm.Name, item[cm.Name]);
}
insertStament.Execute();
}
}
}
}
