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 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);
}
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 bool Update(FormFieldColumn formfieldcolumn, int old_formFieldColumnId)
{
FormFieldColumnDAC formfieldcolumnComponent = new FormFieldColumnDAC();
return(formfieldcolumnComponent.UpdateFormFieldColumn(formfieldcolumn.FormFieldId, formfieldcolumn.FieldColumnValue, formfieldcolumn.FieldColumnHelp, formfieldcolumn.FieldColumnGrade, old_formFieldColumnId));
}
