public List<FormField> GetAll() { FormFieldDAC _formFieldComponent = new FormFieldDAC(); IDataReader reader = _formFieldComponent.GetAllFormField().CreateDataReader(); List<FormField> _formFieldList = new List<FormField>(); while(reader.Read()) { if(_formFieldList == null) _formFieldList = new List<FormField>(); FormField _formField = new FormField(); if(reader["FormFieldId"] != DBNull.Value) _formField.FormFieldId = Convert.ToInt32(reader["FormFieldId"]); if(reader["FormDocumentId"] != DBNull.Value) _formField.FormDocumentId = Convert.ToInt32(reader["FormDocumentId"]); if(reader["FormFieldTypeId"] != DBNull.Value) _formField.FormFieldTypeId = Convert.ToInt32(reader["FormFieldTypeId"]); if(reader["FieldParentId"] != DBNull.Value) _formField.FieldParentId = Convert.ToInt32(reader["FieldParentId"]); if(reader["Title"] != DBNull.Value) _formField.Title = Convert.ToString(reader["Title"]); if(reader["HelpText"] != DBNull.Value) _formField.HelpText = Convert.ToString(reader["HelpText"]); if(reader["FormFieldOrder"] != DBNull.Value) _formField.FormFieldOrder = Convert.ToInt32(reader["FormFieldOrder"]); if(reader["FieldDegree"] != DBNull.Value) _formField.FieldDegree = Convert.ToInt32(reader["FieldDegree"]); if(reader["HasOther"] != DBNull.Value) _formField.HasOther = Convert.ToBoolean(reader["HasOther"]); if(reader["DefaultValue"] != DBNull.Value) _formField.DefaultValue = Convert.ToString(reader["DefaultValue"]); if(reader["IsRequired"] != DBNull.Value) _formField.IsRequired = Convert.ToBoolean(reader["IsRequired"]); if(reader["RegularExpValidation"] != DBNull.Value) _formField.RegularExpValidation = Convert.ToString(reader["RegularExpValidation"]); if(reader["ErrorText"] != DBNull.Value) _formField.ErrorText = Convert.ToString(reader["ErrorText"]); if(reader["IsContactEmail"] != DBNull.Value) _formField.IsContactEmail = Convert.ToBoolean(reader["IsContactEmail"]); if(reader["IsContactMobile"] != DBNull.Value) _formField.IsContactMobile = Convert.ToBoolean(reader["IsContactMobile"]); if(reader["ColumnCount"] != DBNull.Value) _formField.ColumnCount = Convert.ToInt32(reader["ColumnCount"]); if(reader["IsSection"] != DBNull.Value) _formField.IsSection = Convert.ToBoolean(reader["IsSection"]); if(reader["IsPageBreak"] != DBNull.Value) _formField.IsPageBreak = Convert.ToBoolean(reader["IsPageBreak"]); _formField.NewRecord = false; _formFieldList.Add(_formField); } reader.Close(); return _formFieldList; }
public bool Update(FormField formfield ,int old_formFieldId) { FormFieldDAC formfieldComponent = new FormFieldDAC(); return formfieldComponent.UpdateFormField( formfield.FormDocumentId, formfield.FormFieldTypeId, formfield.FieldParentId, formfield.Title, formfield.HelpText, formfield.FormFieldOrder, formfield.FieldDegree, formfield.HasOther, formfield.DefaultValue, formfield.IsRequired, formfield.RegularExpValidation, formfield.ErrorText, formfield.IsContactEmail, formfield.IsContactMobile, formfield.ColumnCount, formfield.IsSection, formfield.IsPageBreak, old_formFieldId); }
public bool Insert(FormField formfield) { int autonumber = 0; FormFieldDAC formfieldComponent = new FormFieldDAC(); bool endedSuccessfuly = formfieldComponent.InsertNewFormField( ref autonumber, formfield.FormDocumentId, formfield.FormFieldTypeId, formfield.FieldParentId, formfield.Title, formfield.HelpText, formfield.FormFieldOrder, formfield.FieldDegree, formfield.HasOther, formfield.DefaultValue, formfield.IsRequired, formfield.RegularExpValidation, formfield.ErrorText, formfield.IsContactEmail, formfield.IsContactMobile, formfield.ColumnCount, formfield.IsSection, formfield.IsPageBreak); if(endedSuccessfuly) { formfield.FormFieldId = autonumber; } return endedSuccessfuly; }