public bool Insert(FormFieldValue formfieldvalue)
{
int autonumber = 0;
FormFieldValueDAC formfieldvalueComponent = new FormFieldValueDAC();
bool endedSuccessfuly = formfieldvalueComponent.InsertNewFormFieldValue(ref autonumber, formfieldvalue.FormFieldId, formfieldvalue.FieldValue, formfieldvalue.FieldValueHelp, formfieldvalue.FieldGrade, formfieldvalue.IsOther, formfieldvalue.ScaleStart, formfieldvalue.ScaleEnd);
if (endedSuccessfuly)
{
formfieldvalue.FormFieldValueId = autonumber;
}
return(endedSuccessfuly);
}
public List <FormFieldValue> GetAllByFormFieldId(int FormFieldId)
{
FormFieldValueDAC _formFieldValueComponent = new FormFieldValueDAC();
IDataReader reader = _formFieldValueComponent.GetAllFormFieldValue("FormFieldId = " + FormFieldId).CreateDataReader();
List <FormFieldValue> _formFieldValueList = new List <FormFieldValue>();
while (reader.Read())
{
if (_formFieldValueList == null)
{
_formFieldValueList = new List <FormFieldValue>();
}
FormFieldValue _formFieldValue = new FormFieldValue();
if (reader["FormFieldValueId"] != DBNull.Value)
{
_formFieldValue.FormFieldValueId = Convert.ToInt32(reader["FormFieldValueId"]);
}
if (reader["FormFieldId"] != DBNull.Value)
{
_formFieldValue.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
}
if (reader["FieldValue"] != DBNull.Value)
{
_formFieldValue.FieldValue = Convert.ToString(reader["FieldValue"]);
}
if (reader["FieldValueHelp"] != DBNull.Value)
{
_formFieldValue.FieldValueHelp = Convert.ToString(reader["FieldValueHelp"]);
}
if (reader["FieldGrade"] != DBNull.Value)
{
_formFieldValue.FieldGrade = Convert.ToInt32(reader["FieldGrade"]);
}
if (reader["IsOther"] != DBNull.Value)
{
_formFieldValue.IsOther = Convert.ToBoolean(reader["IsOther"]);
}
if (reader["ScaleStart"] != DBNull.Value)
{
_formFieldValue.ScaleStart = Convert.ToDecimal(reader["ScaleStart"]);
}
if (reader["ScaleEnd"] != DBNull.Value)
{
_formFieldValue.ScaleEnd = Convert.ToDecimal(reader["ScaleEnd"]);
}
_formFieldValue.NewRecord = false;
_formFieldValueList.Add(_formFieldValue);
}
reader.Close();
return(_formFieldValueList);
}
public FormFieldValue GetByID(int _formFieldValueId)
{
FormFieldValueDAC _formFieldValueComponent = new FormFieldValueDAC();
IDataReader reader = _formFieldValueComponent.GetByIDFormFieldValue(_formFieldValueId);
FormFieldValue _formFieldValue = null;
while (reader.Read())
{
_formFieldValue = new FormFieldValue();
if (reader["FormFieldValueId"] != DBNull.Value)
{
_formFieldValue.FormFieldValueId = Convert.ToInt32(reader["FormFieldValueId"]);
}
if (reader["FormFieldId"] != DBNull.Value)
{
_formFieldValue.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
}
if (reader["FieldValue"] != DBNull.Value)
{
_formFieldValue.FieldValue = Convert.ToString(reader["FieldValue"]);
}
if (reader["FieldValueHelp"] != DBNull.Value)
{
_formFieldValue.FieldValueHelp = Convert.ToString(reader["FieldValueHelp"]);
}
if (reader["FieldGrade"] != DBNull.Value)
{
_formFieldValue.FieldGrade = Convert.ToInt32(reader["FieldGrade"]);
}
if (reader["IsOther"] != DBNull.Value)
{
_formFieldValue.IsOther = Convert.ToBoolean(reader["IsOther"]);
}
if (reader["ScaleStart"] != DBNull.Value)
{
_formFieldValue.ScaleStart = Convert.ToDecimal(reader["ScaleStart"]);
}
if (reader["ScaleEnd"] != DBNull.Value)
{
_formFieldValue.ScaleEnd = Convert.ToDecimal(reader["ScaleEnd"]);
}
_formFieldValue.NewRecord = false;
}
reader.Close();
return(_formFieldValue);
}
public bool Update(FormFieldValue formfieldvalue, int old_formFieldValueId)
{
FormFieldValueDAC formfieldvalueComponent = new FormFieldValueDAC();
return(formfieldvalueComponent.UpdateFormFieldValue(formfieldvalue.FormFieldId, formfieldvalue.FieldValue, formfieldvalue.FieldValueHelp, formfieldvalue.FieldGrade, formfieldvalue.IsOther, formfieldvalue.ScaleStart, formfieldvalue.ScaleEnd, old_formFieldValueId));
}
