private void FillQueryResultList(IDataReader reader, DataTableHandler tableHandler, ElementBinding[] columns, ElementBinding primary, List <IList <DataObject> > resultList)
{
var list = new List <DataObject>();
var data = new object[reader.FieldCount];
while (reader.Read())
{
reader.GetValues(data);
var obj = Activator.CreateInstance(tableHandler.ObjectType) as DataObject;
// Fill Object
var current = 0;
foreach (var column in columns)
{
DatabaseSetValue(obj, column, data[current]);
current++;
}
// Set Primary Key
if (primary != null)
{
obj.ObjectId = primary.GetValue(obj).ToString();
}
list.Add(obj);
obj.Dirty = false;
obj.IsPersisted = true;
}
resultList.Add(list.ToArray());
}
/// <summary>
/// Set Value to DataObject Field according to ElementBinding
/// </summary>
/// <param name="obj">DataObject to Fill</param>
/// <param name="bind">ElementBinding for the targeted Member</param>
/// <param name="value">Object Value to Fill</param>
protected virtual void DatabaseSetValue(DataObject obj, ElementBinding bind, object value)
{
if (value == null || value.GetType().IsInstanceOfType(DBNull.Value))
{
return;
}
try
{
if (bind.ValueType == typeof(bool))
{
bind.SetValue(obj, Convert.ToBoolean(value));
}
else if (bind.ValueType == typeof(char))
{
bind.SetValue(obj, Convert.ToChar(value));
}
else if (bind.ValueType == typeof(sbyte))
{
bind.SetValue(obj, Convert.ToSByte(value));
}
else if (bind.ValueType == typeof(short))
{
bind.SetValue(obj, Convert.ToInt16(value));
}
else if (bind.ValueType == typeof(int))
{
bind.SetValue(obj, Convert.ToInt32(value));
}
else if (bind.ValueType == typeof(long))
{
bind.SetValue(obj, Convert.ToInt64(value));
}
else if (bind.ValueType == typeof(byte))
{
bind.SetValue(obj, Convert.ToByte(value));
}
else if (bind.ValueType == typeof(ushort))
{
bind.SetValue(obj, Convert.ToUInt16(value));
}
else if (bind.ValueType == typeof(uint))
{
bind.SetValue(obj, Convert.ToUInt32(value));
}
else if (bind.ValueType == typeof(ulong))
{
bind.SetValue(obj, Convert.ToUInt64(value));
}
else if (bind.ValueType == typeof(DateTime))
{
bind.SetValue(obj, Convert.ToDateTime(value));
}
else if (bind.ValueType == typeof(float))
{
bind.SetValue(obj, Convert.ToSingle(value));
}
else if (bind.ValueType == typeof(double))
{
bind.SetValue(obj, Convert.ToDouble(value));
}
else if (bind.ValueType == typeof(string))
{
bind.SetValue(obj, Convert.ToString(value));
}
else
{
bind.SetValue(obj, value);
}
}
catch (Exception e)
{
if (Log.IsErrorEnabled)
{
Log.ErrorFormat("{0}: {1} = {2} doesnt fit to {3}\n{4}", obj.TableName, bind.ColumnName, value.GetType().FullName, bind.ValueType, e);
}
}
}
/// <summary>
/// Populate or Refresh Object Relation Implementation
/// </summary>
/// <param name="relationBind">Element Binding for Relation Field</param>
/// <param name="localBind">Local Binding for Value Match</param>
/// <param name="remoteBind">Remote Binding for Column Match</param>
/// <param name="remoteHandler">Remote Table Handler for Cache Retrieving</param>
/// <param name="dataObjects">DataObjects to Populate</param>
protected virtual void FillObjectRelationsImpl(ElementBinding relationBind, ElementBinding localBind, ElementBinding remoteBind, DataTableHandler remoteHandler, IEnumerable <DataObject> dataObjects)
{
var type = relationBind.ValueType;
var isElementType = false;
if (type.HasElementType)
{
type = type.GetElementType();
isElementType = true;
}
var objects = dataObjects.ToArray();
IEnumerable <IEnumerable <DataObject> > objsResults = null;
// Handle Cache Search if relevent or use a Select Query
if (remoteHandler.UsesPreCaching)
{
// Search with Primary Key or use a Where Clause
if (remoteHandler.PrimaryKeys.All(pk => pk.ColumnName.Equals(remoteBind.ColumnName, StringComparison.OrdinalIgnoreCase)))
{
objsResults = objects.Select(obj => {
var local = localBind.GetValue(obj);
if (local == null)
{
return(new DataObject[0]);
}
var retrieve = remoteHandler.GetPreCachedObject(local);
if (retrieve == null)
{
return(new DataObject[0]);
}
return(new [] { retrieve });
});
}
else
{
objsResults = objects
.Select(obj => remoteHandler.SearchPreCachedObjects(rem => {
var local = localBind.GetValue(obj);
var remote = remoteBind.GetValue(rem);
if (local == null || remote == null)
{
return(false);
}
if (localBind.ValueType == typeof(string) || remoteBind.ValueType == typeof(string))
{
return(remote.ToString().Equals(local.ToString(), StringComparison.OrdinalIgnoreCase));
}
return(remote == local);
}));
}
}
else
{
var whereClauses = objects.Select(obj => DB.Column(remoteBind.ColumnName).IsEqualTo(localBind.GetValue(obj)));
objsResults = MultipleSelectObjectsImpl(remoteHandler, whereClauses);
}
var resultByObjs = objsResults.Select((obj, index) => new { DataObject = objects[index], Results = obj }).ToArray();
// Store Relations
foreach (var result in resultByObjs)
{
if (isElementType)
{
if (result.Results.Any())
{
MethodInfo castMethod = typeof(Enumerable).GetMethod("OfType").MakeGenericMethod(type);
MethodInfo methodToArray = typeof(Enumerable).GetMethod("ToArray").MakeGenericMethod(type);
relationBind.SetValue(result.DataObject, methodToArray.Invoke(null, new object[] { castMethod.Invoke(null, new object[] { result.Results }) }));
}
else
{
relationBind.SetValue(result.DataObject, null);
}
}
else
{
relationBind.SetValue(result.DataObject, result.Results.SingleOrDefault());
}
}
// Fill Sub Relations
FillObjectRelations(resultByObjs.SelectMany(result => result.Results), false);
}
