/// <summary>
/// Assign a property value. If the property do not exists in the property collection, add the property to the collection
/// </summary>
/// <param name="propertyName">Name of the property</param>
/// <param name="propertyValue">Value of the property</param>
/// <param name="dataType">Data type: used in case of is needed to add the property to the property collection</param>
public void AddProperty(string propertyName, object propertyValue, dao.DataTypeEnum dataType)
{
try {
Properties[propertyName].Value = propertyValue;
} catch (System.Runtime.InteropServices.COMException ex) {
if (ex.ErrorCode == -2146825018) //Property don't exists in the properties collection
{
object[] parameters = new object[] { propertyName, dataType, propertyValue };
//All the dao objects implements a interface with CreateProperty method. But all of them are diferent interfaces: there isn't a common interface
//Calling InvokeMember we can do a generic code to call CreateProperty of al the objects
Properties.Append((dao.Property)(DaoObject.GetType().InvokeMember("CreateProperty", System.Reflection.BindingFlags.InvokeMethod, null, DaoObject, parameters)));
}
else if (ex.ErrorCode == -2146825287) //Argument not valid
//Can't add a property: This will occur with CollatingOrderProperty
//Other properties are excluded from DatabaseDao.gatherProperties method
{
}
else
{
throw;
}
}
}
/// <summary>
/// Adds a MS-Access property to the dao object
/// </summary>
/// <param name="props">List of properties to read to or write to a file</param>
/// <param name="propertyName">property name to add to the dao object</param>
/// <param name="dataType">data type of the property</param>
/// <remarks>
/// Adding a property to a dao object is trickly: if the property is already added we assign de value
/// else, we create the property and add to the properties collection
/// </remarks>
public void AddOptionalProperty(Dictionary <string, object> props, string propertyName, dao.DataTypeEnum dataType)
{
if (props.ContainsKey(propertyName) && props[propertyName] != null)
{
AddProperty(propertyName, props[propertyName], dataType);
}
}