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;
}
