private static T RowToType <T>(DataRow row, int _currentLevelCursor, T returnObject) where T : BusinessLogicBase, new()
{
Type type = typeof(T);
List <PropertyInfo> properties;
//get cached properties otherwise cache them if they aren't cached.
if (!_cachedProperties.TryGetValue(type, out properties))
{
properties = type.GetProperties().ToList();
_cachedProperties[type] = properties;
}
if (returnObject == null)
{
returnObject = new T();
}
foreach (PropertyInfo property in properties)
{
string path = type.Namespace + "." + type.Name + "." + property.Name;
#region Do DynamicPropery's
List <object> attrs = null;
try
{
//get cached attributes otherwise cache them if they aren't cached.
if (!_cachedDynamicPropertyAttributes.TryGetValue(path, out attrs))
{
//get custom attributes to see if this property has a DynamicProperty associated
attrs = property.GetCustomAttributes(typeof(DynamicProperty), false).ToList();
_cachedDynamicPropertyAttributes[path] = attrs;
}
}
catch (Exception)
{
//do nothing. if it fails just continue.
}
if (attrs != null && attrs.Any())
{
DynamicProperty attr = attrs[0] as DynamicProperty;
if (attr != null && row.Table != null && row.Table.Columns.Contains(attr.ColumnName))
{
SetPropertyValue <T>(returnObject, row, property, attr);
continue; //skip to the next property. A property can't be both a SQLDBType and a dynamic class
}
}
#endregion
//if the DynamicProperty failed or did not exist then check for DynamicClass Attribute
#region Do DynamicClass'
List <object> typeAttrs = null;
try
{
//get cached attributes otherwise cache them if they aren't cached.
if (!_cachedDynamicClassAttributes.TryGetValue(path, out typeAttrs))
{
//get custom attributes to see if this property has a DynamicProperty associated
typeAttrs = property.GetCustomAttributes(typeof(DynamicClass), false).ToList();
_cachedDynamicClassAttributes[path] = typeAttrs;
}
}
catch (Exception)
{
continue;
}
if (typeAttrs != null && typeAttrs.Any())
{
DynamicClass attr = typeAttrs[0] as DynamicClass;
if (attr != null)
{
//to avoid possible endless loops, limit the level ob child objects.
if (_currentLevelCursor >= _maxLevelCounter)
{
continue;
}
MethodInfo genericMethod = null;
//get cached generic methods instead of creating it every time. Otherwise cache it if it isn't cached.
if (!_cachedGenericMethods.TryGetValue(attr.Type, out genericMethod))
{
genericMethod = typeof(DynamicResultSet).GetMethod("RowToType", BindingFlags.NonPublic | BindingFlags.Static).MakeGenericMethod(attr.Type);
_cachedGenericMethods[attr.Type] = genericMethod;
}
object newChildObject = genericMethod.Invoke(null, new object[] { row, _currentLevelCursor + 1, null });
if (newChildObject != null && !(newChildObject as BusinessLogicBase).IsEmpty())
{
property.SetValue(returnObject, newChildObject, null);
}
}
}
#endregion
}
if (returnObject != null && !returnObject.IsEmpty())
{
returnObject.OnLoaded();
return(returnObject);
}
else
{
return(null);
}
}
private static void SetPropertyValue <T>(T newObject, DataRow row, PropertyInfo property, DynamicProperty attr) where T : BusinessLogicBase, new()
{
object value = row[attr.ColumnName];
if (System.DBNull.Value.Equals(value))
{
value = null;
}
else
{
#region switch
switch (attr.DatabaseType)
{
case SqlDbType.BigInt:
value = Convert.ToInt64(value);
break;
case SqlDbType.Binary:
case SqlDbType.Image:
case SqlDbType.Timestamp:
case SqlDbType.VarBinary:
//May need to properly convert. Testing required.
value = (byte[])value;
break;
case SqlDbType.Bit:
value = Convert.ToBoolean(value);
break;
case SqlDbType.Char:
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
case SqlDbType.Text:
case SqlDbType.VarChar:
case SqlDbType.Xml:
value = value.ToString();
break;
case SqlDbType.DateTime:
case SqlDbType.SmallDateTime:
case SqlDbType.Date:
case SqlDbType.Time:
case SqlDbType.DateTime2:
value = Convert.ToDateTime(value);
break;
case SqlDbType.Decimal:
case SqlDbType.Money:
case SqlDbType.SmallMoney:
value = Convert.ToDecimal(value);
break;
case SqlDbType.Float:
value = Convert.ToDouble(value);
break;
case SqlDbType.Int:
value = Convert.ToInt32(value);
break;
case SqlDbType.Real: value = Convert.ToSingle(value);
break;
case SqlDbType.UniqueIdentifier:
Guid guid = new Guid(value.ToString());
value = guid;
break;
case SqlDbType.SmallInt: value = Convert.ToInt16(value);
break;
case SqlDbType.TinyInt: value = Convert.ToByte(value);
break;
case SqlDbType.Variant:
case SqlDbType.Udt:
break;
case SqlDbType.Structured:
//May need to properly convert. Testing required.
value = (DataTable)value;
break;
case SqlDbType.DateTimeOffset:
//May need to properly convert. Testing required.
value = (DateTimeOffset?)value;
break;
default:
throw new ArgumentOutOfRangeException("DatabaseType");
}
#endregion
}
property.SetValue(newObject, value, null);
}