/// <summary>
/// Retrieves data for UniqueKeyField field
/// </summary>
/// <param name="field">A unique key field.</param>
/// <param name="fieldNode">XML node for unique key field.</param>
public void GetFieldData(UniqueIdentifierField field, XmlNode fieldNode)
{
}
//zack todo: implement
/// <summary>
/// Insert a UniqueIdentifierField record into the metaFields table.
/// </summary>
/// <param name="field">Unique Key field.</param>
/// <returns>Returns the Id of the last UniqueIdentifierField added.</returns>
public int CreateField(UniqueIdentifierField field)
{
try
{
#region InputValidation
if (field == null)
{
throw new ArgumentNullException("UniqueKeyField");
}
#endregion
Query insertQuery = db.CreateQuery("insert into metaFields([DataTableName], [ViewId], [UniqueId], [FieldTypeId], [Name]) " +
"values (@DataTableName, @ViewId, @UniqueId, @FieldTypeId, @Name)");
insertQuery.Parameters.Add(new QueryParameter("@DataTableName", DbType.String, field.TableName));
insertQuery.Parameters.Add(new QueryParameter("@ViewId", DbType.Int32, field.GetView().Id));
insertQuery.Parameters.Add(new QueryParameter("@UniqueId", DbType.Guid, field.UniqueId));
insertQuery.Parameters.Add(new QueryParameter("@FieldTypeId", DbType.Int32, (int)field.FieldType));
insertQuery.Parameters.Add(new QueryParameter("@Name", DbType.String, field.Name));
db.ExecuteNonQuery(insertQuery);
return GetMaxFieldId(field.GetView().Id);
}
finally
{
}
}
//zack todo: implement
/// <summary>
/// Create UniqueIdentifier field.
/// </summary>
/// <param name="field">UniqueIdentifier field to create.</param>
/// <returns>Id of the newly created field.</returns>
public int CreateField(UniqueIdentifierField field)
{
try
{
#region InputValidation
if (field == null)
{
throw new ArgumentNullException("UniqueKeyField");
}
#endregion
XmlDocument xmlDoc = GetXmlDocument();
XmlNode fieldsNode = GetFieldsNode(field.ViewElement);
View view = field.GetView();
XmlElement fieldElement = xmlDoc.CreateElement("Field");
XmlAttribute fieldIdAttribute = xmlDoc.CreateAttribute("FieldId");
fieldIdAttribute.Value = view.GetFieldId(field.ViewElement).ToString();
fieldElement.Attributes.Append(fieldIdAttribute);
field.Id = Int32.Parse(fieldIdAttribute.Value);
XmlAttribute fieldTypeId = xmlDoc.CreateAttribute("FieldTypeId");
fieldTypeId.Value = field.FieldType.ToString();
fieldElement.Attributes.Append(fieldTypeId);
XmlAttribute fieldNameAttribute = xmlDoc.CreateAttribute("Name");
fieldNameAttribute.Value = field.Name;
fieldElement.Attributes.Append(fieldNameAttribute);
XmlAttribute fieldViewId = xmlDoc.CreateAttribute("ViewId");
fieldViewId.Value = view.Id.ToString();
fieldElement.Attributes.Append(fieldViewId);
XmlAttribute dataTableName = xmlDoc.CreateAttribute("DataTableName");
dataTableName.Value = field.TableName;
fieldElement.Attributes.Append(dataTableName);
fieldsNode.AppendChild(fieldElement);
view.Project.Save();
return field.Id;
}
finally
{
}
}
