/// <summary> /// Constructor for the class /// </summary> /// <param name="frm">The parent form</param> /// <param name="field">The fied to be edited</param> public CommandButtonFieldDefinition(MainForm frm, CommandButtonField field) : base(frm) { InitializeComponent(); this.mode = FormMode.Edit; this.field = field; this.page = field.Page; LoadFormData(); }
private List<Control> GetControls(CommandButtonField field, Size canvasSize) { Button button = new Button(); SetControlProperties(button, field, canvasSize); button.Text = field.PromptText; button.UseMnemonic = false; button.FlatStyle = FlatStyle.Standard;//flatStyle; List<Control> controls = new List<Control>(); controls.Add(button); if (!fieldControls.ContainsKey(field)) { fieldControls.Add(field, controls); } else { fieldControls.Remove(field); fieldControls.Add(field, controls); } return controls; }
/// <summary> /// Insert a CommandButtonField record into the metaFields table. /// </summary> /// <param name="field">Command button field.</param> /// <returns>Returns the Id of the last CommandButtonField added.</returns> public int CreateField(CommandButtonField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("CommandButtonField"); } #endregion Query insertQuery = db.CreateQuery("insert into metaFields([ViewId], [UniqueId], [CheckCodeAfter], [ControlFontFamily], [ControlFontStyle], [ControlFontSize], [ControlHeightPercentage], [ControlLeftPositionPercentage], [ControlTopPositionPercentage], [ControlWidthPercentage], [FieldTypeId], [HasTabStop], [Name], [PageId], [PromptText], [TabIndex]) " + "values (@ViewId, @UniqueId, @CheckCodeAfter, @ControlFontFamily, @ControlFontStyle, @ControlFontSize, @ControlHeightPercentage, @ControlLeftPositionPercentage, @ControlTopPositionPercentage, @ControlWidthPercentage, @FieldTypeId, @HasTabStop, @Name, @PageId, @PromptText, @TabIndex)"); insertQuery.Parameters.Add(new QueryParameter("@ViewId", DbType.Int32, field.GetView().Id)); insertQuery.Parameters.Add(new QueryParameter("@UniqueId", DbType.Guid, field.UniqueId)); if (string.IsNullOrEmpty(field.CheckCodeClick)) insertQuery.Parameters.Add(new QueryParameter("@CheckCodeAfter", DbType.String, DBNull.Value)); else insertQuery.Parameters.Add(new QueryParameter("@CheckCodeAfter", DbType.String, field.CheckCodeClick)); insertQuery.Parameters.Add(new QueryParameter("@ControlFontFamily", DbType.String, field.ControlFont.Name)); insertQuery.Parameters.Add(new QueryParameter("@ControlFontStyle", DbType.String, field.ControlFont.Style.ToString())); insertQuery.Parameters.Add(new QueryParameter("@ControlFontSize", DbType.Double, field.ControlFont.Size)); insertQuery.Parameters.Add(new QueryParameter("@ControlHeightPercentage", DbType.Double, field.ControlHeightPercentage)); insertQuery.Parameters.Add(new QueryParameter("@ControlLeftPositionPercentage", DbType.Double, field.ControlLeftPositionPercentage)); insertQuery.Parameters.Add(new QueryParameter("@ControlTopPositionPercentage", DbType.Double, field.ControlTopPositionPercentage)); insertQuery.Parameters.Add(new QueryParameter("@ControlWidthPercentage", DbType.Double, field.ControlWidthPercentage)); insertQuery.Parameters.Add(new QueryParameter("@FieldTypeId", DbType.Int32, (int)field.FieldType)); insertQuery.Parameters.Add(new QueryParameter("@HasTabStop", DbType.Boolean, field.HasTabStop)); insertQuery.Parameters.Add(new QueryParameter("@Name", DbType.String, field.Name)); insertQuery.Parameters.Add(new QueryParameter("@PageId", DbType.Int32, field.Page.Id)); insertQuery.Parameters.Add(new QueryParameter("@PromptText", DbType.String, field.PromptText)); insertQuery.Parameters.Add(new QueryParameter("@TabIndex", DbType.Int32, field.TabIndex)); db.ExecuteNonQuery(insertQuery); return GetMaxFieldId(field.GetView().Id); } catch (Exception ex) { throw new GeneralException("Could not create CommandButton field in the database", ex); } finally { } }
/// <summary> /// Update Command button field. /// </summary> /// <param name="field">Command button field to update.</param> public void UpdateField(CommandButtonField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("CommandButtonField"); } #endregion Query updateQuery = db.CreateQuery("update metaFields set [CheckCodeAfter] = @CheckCodeAfter, [ControlFontFamily] = @ControlFontFamily, " + "[ControlFontStyle] = @ControlFontStyle, [ControlFontSize] = @ControlFontSize, [ControlHeightPercentage] = @ControlHeightPercentage, " + "[ControlLeftPositionPercentage] = @ControlLeftPositionPercentage, [ControlTopPositionPercentage] = @ControlTopPositionPercentage, " + "[ControlWidthPercentage] = @ControlWidthPercentage, [FieldTypeId] = @FieldTypeId, [HasTabStop] = @HasTabStop, [Name] = @Name, " + "[PageId] = @PageId, [PromptText] = @PromptText, [TabIndex] = @TabIndex where [UniqueId] = @UniqueId"); updateQuery.Parameters.Add(new QueryParameter("@CheckCodeAfter", DbType.String, field.CheckCodeClick)); updateQuery.Parameters.Add(new QueryParameter("@ControlFontFamily", DbType.String, field.ControlFont.Name)); updateQuery.Parameters.Add(new QueryParameter("@ControlFontStyle", DbType.String, field.ControlFont.Style.ToString())); updateQuery.Parameters.Add(new QueryParameter("@ControlFontSize", DbType.Double, field.ControlFont.Size)); updateQuery.Parameters.Add(new QueryParameter("@ControlHeightPercentage", DbType.Double, field.ControlHeightPercentage)); updateQuery.Parameters.Add(new QueryParameter("@ControlLeftPositionPercentage", DbType.Double, field.ControlLeftPositionPercentage)); updateQuery.Parameters.Add(new QueryParameter("@ControlTopPositionPercentage", DbType.Double, field.ControlTopPositionPercentage)); updateQuery.Parameters.Add(new QueryParameter("@ControlWidthPercentage", DbType.Double, field.ControlWidthPercentage)); updateQuery.Parameters.Add(new QueryParameter("@FieldTypeId", DbType.Int32, (int)field.FieldType)); updateQuery.Parameters.Add(new QueryParameter("@HasTabStop", DbType.Boolean, field.HasTabStop)); updateQuery.Parameters.Add(new QueryParameter("@Name", DbType.String, field.Name)); updateQuery.Parameters.Add(new QueryParameter("@PageId", DbType.Int32, field.Page.Id)); updateQuery.Parameters.Add(new QueryParameter("@PromptText", DbType.String, field.PromptText)); updateQuery.Parameters.Add(new QueryParameter("@TabIndex", DbType.Int32, field.TabIndex)); updateQuery.Parameters.Add(new QueryParameter("@UniqueId", DbType.Guid, field.UniqueId)); db.ExecuteNonQuery(updateQuery); } catch (Exception ex) { throw new GeneralException("Could not update CommandButtonField in the database", ex); } finally { } }
/// <summary> /// Gets all the fields in a view /// </summary> /// <param name="view">A view object</param> /// <returns>A collection of fields</returns> public virtual FieldCollectionMaster GetFields(View view) { FieldCollectionMaster fields = new FieldCollectionMaster(); try { DataTable table = GetFieldsAsDataTable(view); foreach (DataRow row in table.Rows) { MetaFieldType fieldTypeId = (MetaFieldType)row[ColumnNames.FIELD_TYPE_ID]; Field field = null; switch (fieldTypeId) { case MetaFieldType.Text: field = new SingleLineTextField(view); field.LoadFromRow(row); break; case MetaFieldType.LabelTitle: field = new LabelField(view); field.LoadFromRow(row); break; case MetaFieldType.TextUppercase: field = new UpperCaseTextField(view); field.LoadFromRow(row); break; case MetaFieldType.Multiline: field = new MultilineTextField(view); field.LoadFromRow(row); break; case MetaFieldType.Number: field = new NumberField(view); field.LoadFromRow(row); break; case MetaFieldType.PhoneNumber: field = new PhoneNumberField(view); field.LoadFromRow(row); break; case MetaFieldType.Date: field = new DateField(view); field.LoadFromRow(row); break; case MetaFieldType.Time: field = new TimeField(view); field.LoadFromRow(row); break; case MetaFieldType.DateTime: field = new DateTimeField(view); field.LoadFromRow(row); break; case MetaFieldType.Checkbox: field = new CheckBoxField(view); field.LoadFromRow(row); break; case MetaFieldType.YesNo: field = new YesNoField(view); field.LoadFromRow(row); break; case MetaFieldType.Option: field = new OptionField(view); field.LoadFromRow(row); break; case MetaFieldType.CommandButton: field = new CommandButtonField(view); field.LoadFromRow(row); break; case MetaFieldType.Image: field = new ImageField(view); field.LoadFromRow(row); break; case MetaFieldType.Mirror: field = new MirrorField(view); field.LoadFromRow(row); break; case MetaFieldType.Grid: field = new GridField(view); field.LoadFromRow(row); break; case MetaFieldType.Group: field = new GroupField(view); field.LoadFromRow(row); break; case MetaFieldType.GUID: field = new GUIDField(view); field.LoadFromRow(row); break; case MetaFieldType.LegalValues: field = new DDLFieldOfLegalValues(view); field.LoadFromRow(row); break; case MetaFieldType.Codes: field = new DDLFieldOfCodes(view); ((DDLFieldOfCodes)field).LoadFromRow(row); //zack break; case MetaFieldType.List: field = new DDListField(view); ((DDListField)field).LoadFromRow(row); break; case MetaFieldType.CommentLegal: field = new DDLFieldOfCommentLegal(view); field.LoadFromRow(row); break; case MetaFieldType.Relate: field = new RelatedViewField(view); field.LoadFromRow(row); break; case MetaFieldType.RecStatus: field = new RecStatusField(view); field.LoadFromRow(row); break; case MetaFieldType.UniqueKey: field = new UniqueKeyField(view); field.LoadFromRow(row); break; case MetaFieldType.ForeignKey: field = new ForeignKeyField(view); field.LoadFromRow(row); break; case MetaFieldType.GlobalRecordId: field = new GlobalRecordIdField(view); field.LoadFromRow(row); break; default: throw new ApplicationException("Invalid Field Type"); } // Note: This check ideally shouldn't be necessary, but Epi 3.5.1 and previous versions actually do allow duplicate field names for group fields. if (fields.Contains(field)) { Logger.Log(DateTime.Now + ": " + string.Format("The {0} field with name \"{1}\" already exists in {2}. This field has not been imported.", field.GetType().ToString(), field.Name, view.Name)); } else { fields.Add(field); } } } catch (Exception ex) { } return (fields); }
/// <summary> /// Retrieves data for command button field from xml metadata. /// </summary> /// <param name="field">A command button field</param> /// <param name="fieldNode">XML node for command button field.</param> public void GetFieldData(CommandButtonField field, XmlNode fieldNode) { }
/* private void UpdateField(CodeField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("CodeField"); } #endregion DbQuery updateQuery = db.CreateQuery("update metaFields set [ControlFontFamily] = @ControlFontFamily, [ControlFontStyle] = @ControlFontStyle, " + "[ControlFontSize] = @ControlFontSize, [ControlHeight] = @ControlHeight, [ControlLeftPosition] = @ControlLeftPosition, " + "[ControlTopPosition] = @ControlTopPosition, [ControlWidth] = @ControlWidth, [HasTabStop] = @HasTabStop, [Name] = @Name, " + "[PageId] = @PageId, [PromptFontFamily] = @PromptFontFamily, [PromptFontStyle] = @PromptFontStyle, [PromptFontSize] = @PromptFontSize, " + "[PromptLeftPosition] = @PromptLeftPosition, [PromptText] = @PromptText, [PromptTopPosition] = @PromptTopPosition, " + "[TabIndex] = @TabIndex where [FieldId] = @FieldId"); updateQuery.Parameters.Add(new DbParameter("@ControlFontFamily", DbType.String, field.ControlFont.Name)); updateQuery.Parameters.Add(new DbParameter("@ControlFontStyle", DbType.String, field.ControlFont.Style.ToString())); updateQuery.Parameters.Add(new DbParameter("@ControlFontSize", DbType.Double, field.ControlFont.Size)); updateQuery.Parameters.Add(new DbParameter("@ControlHeight", DbType.Double, field.ControlHeightPercentage)); updateQuery.Parameters.Add(new DbParameter("@ControlLeftPosition", DbType.Double, field.ControlLeftPositionPercentage)); updateQuery.Parameters.Add(new DbParameter("@ControlTopPosition", DbType.Double, field.ControlTopPositionPercentage)); updateQuery.Parameters.Add(new DbParameter("@ControlWidth", DbType.Double, field.ControlWidthPercentage)); updateQuery.Parameters.Add(new DbParameter("@HasTabStop", DbType.Boolean, field.HasTabStop)); updateQuery.Parameters.Add(new DbParameter("@Name", DbType.String, field.Name)); updateQuery.Parameters.Add(new DbParameter("@PageId", DbType.Int32, field.Page.Id)); updateQuery.Parameters.Add(new DbParameter("@PromptFontFamily", DbType.String, field.PromptFont.Name)); updateQuery.Parameters.Add(new DbParameter("@PromptFontStyle", DbType.String, field.PromptFont.Style.ToString())); updateQuery.Parameters.Add(new DbParameter("@PromptFontSize", DbType.Double, field.PromptFont.Size)); updateQuery.Parameters.Add(new DbParameter("@PromptLeftPosition", DbType.Double, field.PromptLeftPositionPercentage)); updateQuery.Parameters.Add(new DbParameter("@PromptText", DbType.String, field.PromptText)); updateQuery.Parameters.Add(new DbParameter("@PromptTopPosition", DbType.Double, field.PromptTopPositionPercentage)); updateQuery.Parameters.Add(new DbParameter("@TabIndex", DbType.Int32, field.TabIndex)); updateQuery.Parameters.Add(new DbParameter("@FieldId", DbType.Int32, field.Id)); db.ExecuteNonQuery(updateQuery); } catch (Exception ex) { throw new GeneralException("Could not update CodeField in the database", ex); } finally { } } */ /// <summary> /// Update Command Button field. /// </summary> /// <param name="field">Command Button field to update.</param> /// <returns>Id of the updated field.</returns> public void UpdateField(CommandButtonField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("CommandButtonField"); } #endregion XmlDocument xmlDoc = GetXmlDocument(); XmlNode fieldsNode = GetFieldsNode(GetFieldViewElement(field)); View view = field.GetView(); string fieldId = field.Id.ToString(); XmlNode fieldNode = fieldsNode.SelectSingleNode("//Field[@FieldId= '" + fieldId + "']"); fieldNode.Attributes["Name"].Value = field.Name.ToString(); fieldNode.Attributes["PromptText"].Value = field.PromptText.ToString(); fieldNode.Attributes["ControlFontFamily"].Value = field.ControlFont.ToString(); fieldNode.Attributes["ControlFontStyle"].Value = field.ControlFont.Style.ToString(); fieldNode.Attributes["ControlFontSize"].Value = field.ControlFont.Size.ToString(); fieldNode.Attributes["ControlTopPositionPercentage"].Value = field.ControlTopPositionPercentage.ToString(); fieldNode.Attributes["ControlLeftPositionPercentage"].Value = field.ControlLeftPositionPercentage.ToString(); fieldNode.Attributes["ControlHeightPercentage"].Value = field.ControlHeightPercentage.ToString(); fieldNode.Attributes["ControlWidthPercentage"].Value = field.ControlWidthPercentage.ToString(); fieldNode.Attributes["TabIndex"].Value = field.TabIndex.ToString(); fieldNode.Attributes["HasTabStop"].Value = (bool.Parse(field.HasTabStop.ToString())).ToString(); fieldNode.Attributes["PromptFontFamily"].Value = field.PromptFont.FontFamily.Name.ToString(); fieldNode.Attributes["PromptFontStyle"].Value = field.PromptFont.Style.ToString(); fieldNode.Attributes["PromptFontSize"].Value = field.PromptFont.Size.ToString(); fieldNode.Attributes["PromptScriptName"].Value = field.PromptFont.Name.ToString(); fieldNode.Attributes["ControlScriptName"].Value = field.ControlFont.Name.ToString(); //fieldNode.Attributes["ShouldRetainImageSize"].Value = (bool.Parse(field.IsControlResizable)).ToString(); view.Project.Save(); } catch (Exception ex) { throw new GeneralException("Could not update CommandButtonField in the database", ex); } finally { } }
/// <summary> /// Gets all the fields in a view /// </summary> /// <param name="view">the view object</param> /// <returns>A collection of fields</returns> public virtual FieldCollectionMaster GetFields(View view) { try { FieldCollectionMaster fields = new FieldCollectionMaster(); //DataTable table = GetFieldsAsDataTable(view); //foreach (DataRow row in table.Rows) //{ // MetaFieldType fieldTypeId = (MetaFieldType)row[ColumnNames.FIELD_TYPE_ID]; // Field field = null; XmlNode fieldsNode = view.ViewElement.SelectSingleNode("Fields"); foreach (XmlNode fieldNode in fieldsNode.ChildNodes) { //MetaFieldType fieldTypeId = (MetaFieldType)(int.Parse(fieldNode.Attributes["FieldTypeId"].Value.ToString())); MetaFieldType fieldTypeId = (MetaFieldType)Enum.Parse(typeof(MetaFieldType), fieldNode.Attributes["FieldTypeId"].Value.ToString()); Field field = null; switch (fieldTypeId) { case MetaFieldType.Text: field = new SingleLineTextField(view, fieldNode); break; case MetaFieldType.LabelTitle: field = new LabelField(view, fieldNode); break; case MetaFieldType.TextUppercase: field = new UpperCaseTextField(view, fieldNode); break; case MetaFieldType.Multiline: field = new MultilineTextField(view, fieldNode); break; case MetaFieldType.Number: field = new NumberField(view, fieldNode); break; case MetaFieldType.PhoneNumber: field = new PhoneNumberField(view, fieldNode); break; case MetaFieldType.Date: field = new DateField(view, fieldNode); break; case MetaFieldType.Time: field = new TimeField(view, fieldNode); break; case MetaFieldType.DateTime: field = new DateTimeField(view, fieldNode); break; case MetaFieldType.Checkbox: field = new CheckBoxField(view, fieldNode); break; case MetaFieldType.YesNo: field = new YesNoField(view, fieldNode); break; case MetaFieldType.Option: field = new OptionField(view, fieldNode); break; case MetaFieldType.CommandButton: field = new CommandButtonField(view, fieldNode); break; case MetaFieldType.Image: field = new ImageField(view, fieldNode); break; case MetaFieldType.Mirror: field = new MirrorField(view, fieldNode); break; case MetaFieldType.Grid: field = new GridField(view, fieldNode); break; case MetaFieldType.LegalValues: field = new DDLFieldOfLegalValues(view, fieldNode); break; case MetaFieldType.Codes: field = new DDLFieldOfCodes(view, fieldNode); break; case MetaFieldType.List: field = new DDListField(view, fieldNode); break; case MetaFieldType.CommentLegal: field = new DDLFieldOfCommentLegal(view, fieldNode); break; case MetaFieldType.Relate: field = new RelatedViewField(view, fieldNode); break; case MetaFieldType.RecStatus: field = new RecStatusField(view); break; case MetaFieldType.UniqueKey: field = new UniqueKeyField(view); break; case MetaFieldType.ForeignKey: field = new ForeignKeyField(view); break; default: throw new GeneralException("Invalid Field Type"); } //field.LoadFromRow(row); fields.Add(field); } return (fields); } finally { } }
/// <summary> /// Retrieves data for command button field from xml metadata /// </summary> /// <param name="field">A command button field</param> /// <param name="fieldNode">The field node in the Xml metadata file</param> public void GetFieldData(CommandButtonField field, XmlNode fieldNode) { field.Id = Int32.Parse(fieldNode.Attributes["FieldId"].Value); field.Name = fieldNode.Attributes["Name"].Value; field.PromptText = fieldNode.Attributes["PromptText"].Value; //field.ControlFont = System.Drawing.Font(fieldNode.Attributes["ControlFontFamily"].Value); //field.ControlFont.Style = fieldNode.Attributes["ControlFontStyle"].Value; //field.ControlFont.Size = float.Parse(fieldNode.Attributes["ControlFontSize"].Value); field.ControlTopPositionPercentage = Double.Parse(fieldNode.Attributes["ControlTopPositionPercentage"].Value); field.ControlLeftPositionPercentage = Double.Parse(fieldNode.Attributes["ControlLeftPositionPercentage"].Value); field.ControlHeightPercentage = Double.Parse(fieldNode.Attributes["ControlHeightPercentage"].Value); field.ControlWidthPercentage = Double.Parse(fieldNode.Attributes["ControlWidthPercentage"].Value); field.TabIndex = Int32.Parse(fieldNode.Attributes["TabIndex"].Value); field.HasTabStop = bool.Parse(fieldNode.Attributes["HasTabStop"].Value); //field.PromptFont.FontFamily.Name = fieldNode.Attributes["PromptFontFamily"].Value; //field.PromptFont.Style = fieldNode.Attributes["PromptFontStyle"].Value; //field.PromptFont.Size = fieldNode.Attributes["PromptFontSize"].Value; //field.PromptFont.Name = fieldNode.Attributes["PromptScriptName"].Value; //field.ControlFont.Name = fieldNode.Attributes["ControlScriptName"].Value; //field.IsControlResizable = bool.Parse(fieldNode.Attributes["ShouldRetainImageSize"].Value); //field.TableName = fieldNode.Attributes["DataTableName"].Value; //field. = fieldNode.Attributes["FieldTypeId"].Value; field.Page = new Page(field.GetView()); //field.Page.Name = field.Page.Id = int.Parse(fieldNode.Attributes["PageId"].Value); }
/* /// <summary> /// Creates a code field in the database /// </summary> /// <param name="field">A CodeField object</param> /// <returns>Id of the newly created field</returns> public int CreateField(CodeField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("CodeField"); } #endregion DbQuery insertQuery = db.CreateQuery("insert into metaFields([ControlFontFamily], [ControlFontStyle], [ControlFontSize], [ControlHeight], [ControlLeftPosition], [ControlTopPosition], [ControlWidth], [HasTabStop], [Name], [PageId], [PromptFontFamily], [PromptFontStyle], [PromptFontSize], [PromptLeftPosition], [PromptText], [PromptTopPosition], [TabIndex]) " + "values (@ControlFontFamily, @ControlFontStyle, @ControlFontSize, @ControlHeight, @ControlLeftPosition, @ControlTopPosition, @ControlWidth, @HasTabStop, @Name, @PageId, @PromptFontFamily, @PromptFontStyle, @PromptFontSize, @PromptLeftPosition, @PromptText, @PromptTopPosition, @TabIndex)"); insertQuery.Parameters.Add(new DbParameter("@ControlFontFamily", DbType.String, field.ControlFont.Name)); insertQuery.Parameters.Add(new DbParameter("@ControlFontStyle", DbType.String, field.ControlFont.Style.ToString())); insertQuery.Parameters.Add(new DbParameter("@ControlFontSize", DbType.Double, field.ControlFont.Size)); insertQuery.Parameters.Add(new DbParameter("@ControlHeight", DbType.Double, field.ControlHeightPercentage)); insertQuery.Parameters.Add(new DbParameter("@ControlLeftPosition", DbType.Double, field.ControlLeftPositionPercentage)); insertQuery.Parameters.Add(new DbParameter("@ControlTopPosition", DbType.Double, field.ControlTopPositionPercentage)); insertQuery.Parameters.Add(new DbParameter("@ControlWidth", DbType.Double, field.ControlWidthPercentage)); insertQuery.Parameters.Add(new DbParameter("@HasTabStop", DbType.Boolean, field.HasTabStop)); insertQuery.Parameters.Add(new DbParameter("@Name", DbType.String, field.Name)); insertQuery.Parameters.Add(new DbParameter("@PageId", DbType.Int32, field.Page.Id)); insertQuery.Parameters.Add(new DbParameter("@PromptFontFamily", DbType.String, field.PromptFont.Name)); insertQuery.Parameters.Add(new DbParameter("@PromptFontStyle", DbType.String, field.PromptFont.Style.ToString())); insertQuery.Parameters.Add(new DbParameter("@PromptFontSize", DbType.Double, field.PromptFont.Size)); insertQuery.Parameters.Add(new DbParameter("@PromptLeftPosition", DbType.Double, field.PromptLeftPositionPercentage)); insertQuery.Parameters.Add(new DbParameter("@PromptText", DbType.String, field.PromptText)); insertQuery.Parameters.Add(new DbParameter("@PromptTopPosition", DbType.Double, field.PromptTopPositionPercentage)); insertQuery.Parameters.Add(new DbParameter("@TabIndex", DbType.Int32, field.TabIndex)); DbQuery selectQuery = db.CreateQuery("select MAX(FieldId) from metaFields where PageId = @PageId"); selectQuery.Parameters.Add(new DbParameter("@PageId", DbType.Int32, field.Page.Id)); db.ExecuteNonQuery(insertQuery); DataTable result = db.Select(selectQuery); return (int)result.Rows[0][0]; } // catch (Exception ex) // { // throw new GeneralException("Could not create field in the database", ex); // } finally { } } */ /* /// <summary> /// Create a strongly typed field. /// </summary> /// <param name="field">Field to create</param> /// <returns>Id of the newly created field.</returns> public int CreateField(Field field) { if (field is CommandButtonField) { return CreateField((CommandButtonField)field); } else if (field is DateField) { return CreateField((DateField)field); } else if (field is DateTimeField) { return CreateField((DateTimeField)field); } else if (field is DDLFieldOfCodes) { return CreateField((DDLFieldOfCodes)field); } else if (field is DDLFieldOfCommentLegal) { return CreateField((DDLFieldOfCommentLegal)field); } else if (field is DDLFieldOfLegalValues) { return CreateField((DDLFieldOfLegalValues)field); } else if (field is GridField) { return CreateField((GridField)field); } else if (field is ImageField) { return CreateField((ImageField)field); } else if (field is LabelField) { return CreateField((LabelField)field); } else if (field is MirrorField) { return CreateField((MirrorField)field); } else if (field is MultilineTextField) { return CreateField((MultilineTextField)field); } else if (field is NumberField) { return CreateField((NumberField)field); } else if (field is OptionField) { return CreateField((OptionField)field); } else if (field is PhoneNumberField) { return CreateField((PhoneNumberField)field); } else if (field is RelatedViewField) { return CreateField((RelatedViewField)field); } else if (field is SingleLineTextField) { return CreateField((SingleLineTextField)field); } else if (field is TimeField) { return CreateField((TimeField)field); } else if (field is UpperCaseTextField) { return CreateField((UpperCaseTextField)field); } else if (field is YesNoField) { return CreateField((YesNoField)field); } else return 0; } */ /// <summary> /// Create Command Button field. /// </summary> /// <param name="field">Command Button field to create.</param> /// <returns>Id of the newly created field.</returns> public int CreateField(CommandButtonField field) { try { 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 fieldNameAttribute = xmlDoc.CreateAttribute("Name"); fieldNameAttribute.Value = field.Name; fieldElement.Attributes.Append(fieldNameAttribute); XmlAttribute fieldPromptText = xmlDoc.CreateAttribute("PromptText"); fieldPromptText.Value = field.PromptText; fieldElement.Attributes.Append(fieldPromptText); XmlAttribute fieldControlFontFamily = xmlDoc.CreateAttribute("ControlFontFamily"); fieldControlFontFamily.Value = field.ControlFont.FontFamily.Name; fieldElement.Attributes.Append(fieldControlFontFamily); XmlAttribute controlFontStyle = xmlDoc.CreateAttribute("ControlFontStyle"); controlFontStyle.Value = field.ControlFont.Style.ToString(); fieldElement.Attributes.Append(controlFontStyle); XmlAttribute controlFontSize = xmlDoc.CreateAttribute("ControlFontSize"); controlFontSize.Value = field.ControlFont.Size.ToString(); fieldElement.Attributes.Append(controlFontSize); XmlAttribute controlTopPositionPercentage = xmlDoc.CreateAttribute("ControlTopPositionPercentage"); controlTopPositionPercentage.Value = field.ControlTopPositionPercentage.ToString(); fieldElement.Attributes.Append(controlTopPositionPercentage); XmlAttribute controlLeftPositionPercentage = xmlDoc.CreateAttribute("ControlLeftPositionPercentage"); controlLeftPositionPercentage.Value = field.ControlLeftPositionPercentage.ToString(); fieldElement.Attributes.Append(controlLeftPositionPercentage); XmlAttribute controlHeightPercentage = xmlDoc.CreateAttribute("ControlHeightPercentage"); controlHeightPercentage.Value = field.ControlHeightPercentage.ToString(); fieldElement.Attributes.Append(controlHeightPercentage); XmlAttribute controlWidthPercentage = xmlDoc.CreateAttribute("ControlWidthPercentage"); controlWidthPercentage.Value = field.ControlWidthPercentage.ToString(); fieldElement.Attributes.Append(controlWidthPercentage); XmlAttribute tabIndex = xmlDoc.CreateAttribute("TabIndex"); tabIndex.Value = field.TabIndex.ToString(); fieldElement.Attributes.Append(tabIndex); XmlAttribute hasTabStop = xmlDoc.CreateAttribute("HasTabStop"); hasTabStop.Value = (bool.Parse(field.HasTabStop.ToString())).ToString(); fieldElement.Attributes.Append(hasTabStop); XmlAttribute promptFontFamily = xmlDoc.CreateAttribute("PromptFontFamily"); promptFontFamily.Value = field.PromptFont.FontFamily.Name; fieldElement.Attributes.Append(promptFontFamily); XmlAttribute promptFontStyle = xmlDoc.CreateAttribute("PromptFontStyle"); promptFontStyle.Value = field.PromptFont.Style.ToString(); fieldElement.Attributes.Append(promptFontStyle); XmlAttribute promptFontSize = xmlDoc.CreateAttribute("PromptFontSize"); promptFontSize.Value = field.PromptFont.Size.ToString(); fieldElement.Attributes.Append(promptFontSize); XmlAttribute promptScriptName = xmlDoc.CreateAttribute("PromptScriptName"); promptScriptName.Value = field.PromptFont.Name; fieldElement.Attributes.Append(promptScriptName); XmlAttribute controlScriptName = xmlDoc.CreateAttribute("ControlScriptName"); controlScriptName.Value = field.ControlFont.Name; fieldElement.Attributes.Append(controlScriptName); XmlAttribute shouldRetainImageSize = xmlDoc.CreateAttribute("ShouldRetainImageSize"); //shouldRetainImageSize.Value = (bool.Parse(field.IsControlResizable.ToString())).ToString(); fieldElement.Attributes.Append(shouldRetainImageSize); //XmlAttribute dataTableName = xmlDoc.CreateAttribute("DataTableName"); //dataTableName.Value = this.TableName; //fieldElement.Attributes.Append(dataTableName); XmlAttribute fieldTypeId = xmlDoc.CreateAttribute("FieldTypeId"); fieldTypeId.Value = field.FieldType.ToString(); fieldElement.Attributes.Append(fieldTypeId); XmlAttribute pageId = xmlDoc.CreateAttribute("PageId"); pageId.Value = field.Page.Id.ToString(); fieldElement.Attributes.Append(pageId); fieldsNode.AppendChild(fieldElement); view.Project.Save(); return field.Id; } finally { } }