/// <summary> /// Insert a OptionField record into the metaFields table. /// </summary> /// <param name="field">Option button field.</param> /// <returns>Returns the Id of the last OptionField added.</returns> public int CreateField(OptionField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("OptionField"); } #endregion Query insertQuery = db.CreateQuery("insert into metaFields([DataTableName], [ViewId], [UniqueId], [CheckCodeAfter], [ControlFontFamily], [ControlFontStyle], [ControlFontSize], [ControlHeightPercentage], [ControlLeftPositionPercentage], [ControlTopPositionPercentage], [ControlWidthPercentage], [FieldTypeId], [HasTabStop], [IsReadOnly], [IsRequired], [Name], [PageId], [PromptFontFamily], [PromptFontStyle], [PromptFontSize], [PromptText], [List], [ShouldRepeatLast], [ShowTextOnRight], [TabIndex]) " + "values (@DataTableName, @ViewId, @UniqueId, @CheckCodeAfter, @ControlFontFamily, @ControlFontStyle, @ControlFontSize, @ControlHeightPercentage, @ControlLeftPositionPercentage, @ControlTopPositionPercentage, @ControlWidthPercentage, @FieldTypeId, @HasTabStop, @IsReadOnly, @IsRequired, @Name, @PageId, @PromptFontFamily, @PromptFontStyle, @PromptFontSize, @PromptText, @List, @ShouldRepeatLast, @ShowTextOnRight, @TabIndex)"); 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)); if (field.CheckCodeAfter == null) insertQuery.Parameters.Add(new QueryParameter("@CheckCodeAfter", DbType.String, DBNull.Value)); else insertQuery.Parameters.Add(new QueryParameter("@CheckCodeAfter", DbType.String, field.CheckCodeAfter)); 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("@IsReadOnly", DbType.Boolean, field.IsReadOnly)); insertQuery.Parameters.Add(new QueryParameter("@IsRequired", DbType.Boolean, field.IsRequired)); 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("@PromptFontFamily", DbType.String, field.PromptFont.Name)); insertQuery.Parameters.Add(new QueryParameter("@PromptFontStyle", DbType.String, field.PromptFont.Style.ToString())); insertQuery.Parameters.Add(new QueryParameter("@PromptFontSize", DbType.Double, field.PromptFont.Size)); insertQuery.Parameters.Add(new QueryParameter("@PromptText", DbType.String, field.PromptText)); insertQuery.Parameters.Add(new QueryParameter("@List", DbType.String, field.GetOptionsString())); insertQuery.Parameters.Add(new QueryParameter("@ShouldRepeatLast", DbType.Boolean, field.ShouldRepeatLast)); insertQuery.Parameters.Add(new QueryParameter("@ShowTextOnRight", DbType.Boolean, field.ShowTextOnRight)); 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 field in the database", ex); } }
/// <summary> /// Create Option field. /// </summary> /// <param name="field">Option field to create.</param> /// <returns>Id of the newly created field.</returns> public int CreateField(OptionField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("OptionField"); } #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 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 shouldRepeatLast = xmlDoc.CreateAttribute("ShouldRepeatLast"); shouldRepeatLast.Value = bool.Parse(field.ShouldRepeatLast.ToString()).ToString(); fieldElement.Attributes.Append(shouldRepeatLast); XmlAttribute isRequired = xmlDoc.CreateAttribute("IsRequired"); isRequired.Value = (bool.Parse(field.IsRequired.ToString()).ToString()); fieldElement.Attributes.Append(isRequired); XmlAttribute isReadOnly = xmlDoc.CreateAttribute("IsReadOnly"); isReadOnly.Value = (bool.Parse(field.IsReadOnly.ToString())).ToString(); fieldElement.Attributes.Append(isReadOnly); XmlAttribute shouldRetainImageSize = xmlDoc.CreateAttribute("ShouldRetainImageSize"); //shouldRetainImageSize.Value = (bool.Parse(field.IsControlResizable.ToString())).ToString(); fieldElement.Attributes.Append(shouldRetainImageSize); XmlAttribute showTextOnRight = xmlDoc.CreateAttribute("ShowTextOnRight"); showTextOnRight.Value = (bool.Parse(field.ShowTextOnRight.ToString())).ToString(); fieldElement.Attributes.Append(showTextOnRight); XmlAttribute dataTableName = xmlDoc.CreateAttribute("DataTableName"); dataTableName.Value = field.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); XmlElement checkCodeAfterElement = xmlDoc.CreateElement("CheckCodeAfter"); XmlAttribute checkCodeAfter = xmlDoc.CreateAttribute("CheckCodeAfter"); checkCodeAfter.Value = field.CheckCodeAfter.ToString(); checkCodeAfterElement.Attributes.Append(checkCodeAfter); fieldElement.AppendChild(checkCodeAfterElement); fieldsNode.AppendChild(fieldElement); view.Project.Save(); return field.Id; //TODO: Save option items in xml project file - EJ } finally { } }
/// <summary> /// Retrieves data for option field from xml metadata /// </summary> /// <param name="field">An option field</param> /// <param name="fieldNode">The field node in the Xml metadata file</param> public void GetFieldData(OptionField 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.ShouldRepeatLast = bool.Parse(fieldNode.Attributes["ShouldRepeatLast"].Value); field.IsRequired = bool.Parse(fieldNode.Attributes["IsRequired"].Value); field.IsReadOnly = bool.Parse(fieldNode.Attributes["IsReadOnly"].Value); field.ShowTextOnRight = bool.Parse(fieldNode.Attributes["ShowTextOnRight"].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); //field.CheckCodeAfter = fieldNode.Attributes["CheckCodeAfter"].Value.ToString(); }
/// <summary> /// Update Option field. /// </summary> /// <param name="field">Option field to update.</param> /// <returns>Id of the updated field.</returns> public void UpdateField(OptionField field) { try { #region InputValidation if (field == null) { throw new ArgumentNullException("OptionField"); } #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; fieldNode.Attributes["PromptText"].Value = field.PromptText; fieldNode.Attributes["ControlFontFamily"].Value = field.ControlFont.FontFamily.Name; 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; fieldNode.Attributes["PromptFontStyle"].Value = field.PromptFont.Style.ToString(); fieldNode.Attributes["PromptFontSize"].Value = field.PromptFont.Size.ToString(); fieldNode.Attributes["PromptScriptName"].Value = field.PromptFont.Name; fieldNode.Attributes["ControlScriptName"].Value = field.ControlFont.Name; fieldNode.Attributes["ShouldRepeatLast"].Value = bool.Parse(field.ShouldRepeatLast.ToString()).ToString(); fieldNode.Attributes["IsRequired"].Value = (bool.Parse(field.IsRequired.ToString()).ToString()); fieldNode.Attributes["IsReadOnly"].Value = (bool.Parse(field.IsReadOnly.ToString())).ToString(); fieldNode.Attributes["ShowTextOnRight"].Value = (bool.Parse(field.ShowTextOnRight.ToString())).ToString(); //field.IsControlResizable = bool.Parse(fieldNode.Attributes["ShouldRetainImageSize"].Value); fieldNode.Attributes["DataTableName"].Value = field.TableName; fieldNode.LastChild.Attributes["CheckCodeAfter"].Value = field.CheckCodeAfter; view.Project.Save(); } catch (Exception ex) { throw new GeneralException("Could not update OptionField in the database", ex); } finally { } }