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