private RowObjectAdapter Bind(Selector columnNames)
{
foreach (PropertyInfo propertyInfo in Reflex.GetColumnProperties(obj))
{
ColumnAttribute attribute = Reflex.GetColumnAttribute(propertyInfo);
if (attribute != null && this.Row.Table.Columns.Contains(attribute.ColumnNameSaved))
{
DataField field = this.fields.Add(attribute.ColumnNameSaved, attribute.Type);
ColumnAdapter column = new ColumnAdapter(field);
this.Bind(column);
column.Field.Identity = attribute.Identity;
column.Field.Primary = attribute.Primary;
if (attribute.Identity || attribute.Computed || !columnNames.Exists(attribute.ColumnNameSaved))
{
column.Field.Saved = false;
}
else
{
column.Field.Saved = attribute.Saved;
}
}
}
//in case of ColumnAttribute not setup Identity and Primary Keys
fields.UpdatePrimaryIdentity(obj.Primary, obj.Identity);
return(this);
}
/// <summary>
/// Create Empty System.Data.DataTable from ColumnAttribute of DPO fields
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private static DataTable GetEmptyDataTable(Type type)
{
DataTable dt = new DataTable();
foreach (PropertyInfo propertyInfo in Reflex.GetColumnProperties(type))
{
ColumnAttribute a = Reflex.GetColumnAttribute(propertyInfo);
if (a == null)
{
continue;
}
Type ty = propertyInfo.PropertyType.InnullableType();
DataColumn column = new DataColumn(a.ColumnName, ty);
column.AllowDBNull = a.Nullable;
column.AutoIncrement = a.Identity;
column.Caption = a.Caption;
//may need complicated logic for differentg type
if (ty == typeof(string))
{
column.MaxLength = a.Length;
}
dt.Columns.Add(column);
}
return(dt);
}
public static object FillField(object instance, PropertyInfo propertyInfo, DataRow dataRow, bool defaultValueUsed)
{
ColumnAttribute a = Reflex.GetColumnAttribute(dataRow, propertyInfo);
if (a != null)
{
object value = dataRow[a.ColumnName];
if (value == System.DBNull.Value)
{
if (a.DefaultValue != null)
{
value = a.DefaultValue;
}
else if (defaultValueUsed)
{
Type dataType = dataRow.Table.Columns[a.ColumnName].DataType;
value = DefaultRowValue.SystemDefaultValue(dataType);
}
else
{
value = null;
}
}
propertyInfo.SetValue(instance, value, null);
}
return(a);
}
/// <summary>
/// Collect property values and save to DataRow
/// </summary>
/// <param name="dataRow"></param>
public virtual void UpdateRow(DataRow dataRow)
{
foreach (PropertyInfo propertyInfo in Reflex.GetColumnProperties(this))
{
ColumnAttribute attribute = Reflex.GetColumnAttribute(dataRow, propertyInfo);
if (attribute != null && dataRow.Table.Columns.Contains(attribute.ColumnNameSaved))
{
if (propertyInfo.GetValue(this, null) == null)
{
dataRow[attribute.ColumnNameSaved] = System.DBNull.Value;
}
else
{
dataRow[attribute.ColumnNameSaved] = propertyInfo.GetValue(this, null);
}
}
}
}
public void Apply()
{
foreach (PropertyInfo propertyInfo in Reflex.GetColumnProperties(obj))
{
ColumnAttribute a = Reflex.GetColumnAttribute(propertyInfo);
if (a != null && this.Row.Table.Columns.Contains(a.ColumnNameSaved))
{
if (propertyInfo.GetValue(obj, null) == null)
{
this.Row[a.ColumnNameSaved] = System.DBNull.Value;
}
else
{
this.Row[a.ColumnNameSaved] = propertyInfo.GetValue(obj, null);
}
}
}
this.Fill();
}
private void Apply(RowAdapter d)
{
foreach (PropertyInfo propertyInfo in this.columnProperties)
{
ColumnAttribute a = Reflex.GetColumnAttribute(propertyInfo);
if (a != null && d.Row.Table.Columns.Contains(a.ColumnNameSaved))
{
if (propertyInfo.GetValue(this, null) == null)
{
d.Row[a.ColumnNameSaved] = System.DBNull.Value;
}
else
{
d.Row[a.ColumnNameSaved] = propertyInfo.GetValue(this, null);
}
}
}
d.Fill();
}
