public List<FormFieldColumn> GetAllByFormFieldId(int FormFieldId)
{
FormFieldColumnDAC _formFieldColumnComponent = new FormFieldColumnDAC();
IDataReader reader = _formFieldColumnComponent.GetAllFormFieldColumn("FormFieldId = " + FormFieldId).CreateDataReader();
List<FormFieldColumn> _formFieldColumnList = new List<FormFieldColumn>();
while (reader.Read())
{
if (_formFieldColumnList == null)
_formFieldColumnList = new List<FormFieldColumn>();
FormFieldColumn _formFieldColumn = new FormFieldColumn();
if (reader["FormFieldColumnId"] != DBNull.Value)
_formFieldColumn.FormFieldColumnId = Convert.ToInt32(reader["FormFieldColumnId"]);
if (reader["FormFieldId"] != DBNull.Value)
_formFieldColumn.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
if (reader["FieldColumnValue"] != DBNull.Value)
_formFieldColumn.FieldColumnValue = Convert.ToString(reader["FieldColumnValue"]);
if (reader["FieldColumnHelp"] != DBNull.Value)
_formFieldColumn.FieldColumnHelp = Convert.ToString(reader["FieldColumnHelp"]);
if (reader["FieldColumnGrade"] != DBNull.Value)
_formFieldColumn.FieldColumnGrade = Convert.ToInt32(reader["FieldColumnGrade"]);
_formFieldColumn.NewRecord = false;
_formFieldColumnList.Add(_formFieldColumn);
} reader.Close();
return _formFieldColumnList;
}
public FormFieldColumn GetByID(int _formFieldColumnId)
{
FormFieldColumnDAC _formFieldColumnComponent = new FormFieldColumnDAC();
IDataReader reader = _formFieldColumnComponent.GetByIDFormFieldColumn(_formFieldColumnId);
FormFieldColumn _formFieldColumn = null;
while(reader.Read())
{
_formFieldColumn = new FormFieldColumn();
if(reader["FormFieldColumnId"] != DBNull.Value)
_formFieldColumn.FormFieldColumnId = Convert.ToInt32(reader["FormFieldColumnId"]);
if(reader["FormFieldId"] != DBNull.Value)
_formFieldColumn.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
if(reader["FieldColumnValue"] != DBNull.Value)
_formFieldColumn.FieldColumnValue = Convert.ToString(reader["FieldColumnValue"]);
if(reader["FieldColumnHelp"] != DBNull.Value)
_formFieldColumn.FieldColumnHelp = Convert.ToString(reader["FieldColumnHelp"]);
if(reader["FieldColumnGrade"] != DBNull.Value)
_formFieldColumn.FieldColumnGrade = Convert.ToInt32(reader["FieldColumnGrade"]);
_formFieldColumn.NewRecord = false; } reader.Close();
return _formFieldColumn;
}
public bool Update(FormFieldColumn formfieldcolumn ,int old_formFieldColumnId)
{
FormFieldColumnDAC formfieldcolumnComponent = new FormFieldColumnDAC();
return formfieldcolumnComponent.UpdateFormFieldColumn( formfieldcolumn.FormFieldId, formfieldcolumn.FieldColumnValue, formfieldcolumn.FieldColumnHelp, formfieldcolumn.FieldColumnGrade, old_formFieldColumnId);
}
public bool Insert(FormFieldColumn formfieldcolumn)
{
int autonumber = 0;
FormFieldColumnDAC formfieldcolumnComponent = new FormFieldColumnDAC();
bool endedSuccessfuly = formfieldcolumnComponent.InsertNewFormFieldColumn( ref autonumber, formfieldcolumn.FormFieldId, formfieldcolumn.FieldColumnValue, formfieldcolumn.FieldColumnHelp, formfieldcolumn.FieldColumnGrade);
if(endedSuccessfuly)
{
formfieldcolumn.FormFieldColumnId = autonumber;
}
return endedSuccessfuly;
}
