public Tuple <DbModel, DbModel> CompareDbModels(DbModel source, DbModel destination)
{
//remove all ignored key.
if (source != null)
{
foreach (var key in source.Data.Keys.ToArray().Intersect(this.ignoredColumns))
{
source.Data.Remove(key);
}
}
if (destination != null)
{
foreach (var key in destination.Data.Keys.ToArray().Intersect(this.ignoredColumns))
{
destination.Data.Remove(key);
}
}
var diffSource = new DbModel();
var diffDestination = new DbModel();
Tuple <DbModel, DbModel> compareResult = new Tuple <DbModel, DbModel>(diffSource, diffDestination);
//left to right compare
if (source != null)
{
var sourceKeys = source.Data.Keys.Select(a => a.ToString());
if (destination != null)
{
sourceKeys = sourceKeys.Except(destination.Data.Keys); //source has desti no
}
foreach (var sourceKey in sourceKeys)
{
//var sourceData = source[sourceKey];
var sourceData = (source[sourceKey] is DateTime) ? FormatDateTimeObjectToString((DateTime)source[sourceKey]) : source[sourceKey];
addDiff(sourceKey, sourceData, null, "source");
}
}
//right to left compare
if (destination != null)
{
var xDestinationKeys = destination.Data.Keys.Select(a => a.ToString());
if (source != null)
{
xDestinationKeys = xDestinationKeys.Except(source.Data.Keys, StringComparer.OrdinalIgnoreCase); //desti has source no
}
foreach (var xDestinationKey in xDestinationKeys)
{
//var destinationData = destination[xDestinationKey];
var destinationData = (destination[xDestinationKey] is DateTime) ? FormatDateTimeObjectToString((DateTime)destination[xDestinationKey]) : destination[xDestinationKey];
addDiff(xDestinationKey, null, destinationData, "destination");
}
}
//cross compare for same fields
if (source != null && destination != null)
{
var intersectKeys = source.Data.Keys.Intersect(destination.Data.Keys);
foreach (var intersectKey in intersectKeys)
{
var sourceData = (source[intersectKey] is DateTime) ? FormatDateTimeObjectToString((DateTime)source[intersectKey]) : source[intersectKey];
var destinationData = (destination[intersectKey] is DateTime) ? FormatDateTimeObjectToString((DateTime)destination[intersectKey]) : destination[intersectKey];
if (isDiff(sourceData, destinationData))
{
addDiff(intersectKey, sourceData, destinationData, "both");
}
}
}
#region obsolete
//foreach (var sourcePair in source.Data)
//{
// if (destination.Data.TryGetValue(sourcePair.Key, out object destinationData)) //same key/field
// {
// if (sourcePair.Value is IComparable)
// {
// if (((IComparable)sourcePair.Value).CompareTo(destinationData) != 0) //different value
// {
// diffSource[sourcePair.Key] = sourcePair.Value;
// diffDestination[sourcePair.Key] = destinationData;
// containKeys.Add(sourcePair.Key);
// }
// }
// else if (!sourcePair.Value.Equals(destinationData)) //different value
// {
// diffSource[sourcePair.Key] = sourcePair.Value;
// diffDestination[sourcePair.Key] = destinationData;
// containKeys.Add(sourcePair.Key);
// }
// }
// else
// { //source has a key but destination no such key
// diffSource[sourcePair.Key] = sourcePair.Value;
// diffDestination[sourcePair.Key] = destinationData; //destinationData = null
// containKeys.Add(sourcePair.Key);
// }
//}
//foreach (var destinationPair in destination.Data)
//{
// if (!containKeys.Contains(destinationPair.Key))
// {
// if (source.Data.TryGetValue(destinationPair.Key, out object sourceData)) //same key/field
// {
// if (destinationPair.Value is IComparable)
// {
// if (((IComparable)destinationPair.Value).CompareTo(sourceData) != 0) //different value
// {
// diffDestination[destinationPair.Key] = destinationPair.Value;
// diffSource[destinationPair.Key] = sourceData;
// containKeys.Add(destinationPair.Key);
// }
// }
// else if (!destinationPair.Value.Equals(sourceData)) //different value
// {
// diffDestination[destinationPair.Key] = destinationPair.Value;
// diffSource[destinationPair.Key] = sourceData;
// containKeys.Add(destinationPair.Key);
// }
// }
// else
// { //destination has a key but source no such key
// diffDestination[destinationPair.Key] = destinationPair.Value;
// diffSource[destinationPair.Key] = sourceData; //sourceData = null
// containKeys.Add(destinationPair.Key);
// }
// }
//}
#endregion
return(compareResult);
bool isDiff(object sourceVal, object destVal)
{
if (sourceVal == null && destVal != null)
{
return(true);
}
if (destVal == null && sourceVal != null)
{
return(true);
}
if (destVal == null && sourceVal == null)
{
return(false);
}
if (sourceVal is IComparable)
{
return(((IComparable)sourceVal).CompareTo(destVal) != 0);
}
else
{
if (sourceVal is JToken && destVal is JToken)
{
return(!JToken.DeepEquals((JToken)sourceVal, (JToken)destVal));
}
}
return(!sourceVal.Equals(destVal));
}
void addDiff(string key, object sourceVal, object destVal, string sideToAdd) //oneSideCompare
{
var hasMap = DictMapFields.TryGetValue(key, out Func <object, object> Map);
if (hasMap && sourceVal != null)
{
diffSource[MapField(key)] = Map(sourceVal);
}
else
{ //all cases which no need map here
if (sideToAdd != "destination")
{
diffSource[MapField(key)] = sourceVal;
}
}
if (hasMap && destVal != null)
{
diffDestination[MapField(key)] = Map(destVal);
}
else
{
if (sideToAdd != "source")
{
diffDestination[MapField(key)] = destVal;
}
}
/*
* if (hasMap && sourceVal != null)
* diffSource[MapField(key)] = Map(sourceVal);
* else if(!oneSideCompare)
* diffSource[MapField(key)] = sourceVal;
*
* if (hasMap && destVal != null)
* diffDestination[MapField(key)] = Map(destVal);
* else if (!oneSideCompare)
* diffDestination[MapField(key)] = destVal;
*/
}
}
