} //END getFormFieldColumns method
//===================================================================================
/// <summary>
/// This method appends the column objects for a list of form fields.
/// </summary>
/// <param name="Field">Evado.Digital.Model.EvFormField object</param>
/// <param name="ResultData"> Evado.Integration.Model.EiData object</param>
/// <param name="Row"> Evado.Integration.Model.EiDataRow object</param>
//-----------------------------------------------------------------------------------
private void getCheckBoxFieldColumnValues(
Evado.Digital.Model.EdRecordField Field,
Evado.Integration.Model.EiData ResultData,
Evado.Integration.Model.EiDataRow Row)
{
this.LogMethod("getCheckBoxFieldColumnValues method.");
//
// Iterate through the list of checkbox options
//
for (int count = 0; count < Field.Design.OptionList.Count; count++)
{
//
// get the option
//
Evado.Model.EvOption option = Field.Design.OptionList [count];
string fieldId = Field.FieldId + "_" + count + "_" + option.Value;
//
// Set the checkbox listing output.
//
int column = ResultData.getColumnNo(fieldId);
this.writeProcessLog("Column: " + column + ",\t FieldId: " + fieldId + ", Type: " + Field.TypeId + ", Value: " + Field.ItemValue);
if (column > -1)
{
if (Field.ItemValue.Contains(option.Value) == true)
{
Row.updateValue(column, "True");
}
else
{
Row.updateValue(column, "False");
}
}
} //END option iteration loop.
} //END getFormFieldColumns method
} //END getFormFieldColumns
//===================================================================================
/// <summary>
/// This method appends the column objects for a list of form fields.
/// </summary>
/// <param name="Field">Evado.Digital.Model.EvFormField object</param>
/// <param name="ResultData"> Evado.Integration.Model.EiData object</param>
//-----------------------------------------------------------------------------------
//private void getCheckBoxFieldColumn (
public void getCheckBoxFieldColumn(
Evado.Digital.Model.EdRecordField Field,
Evado.Integration.Model.EiData ResultData)
{
this.LogMethod("getCheckBoxFieldColumn method.");
//
// Iterate through the list of checkbox options
//
for (int count = 0; count < Field.Design.OptionList.Count; count++)
{
//
// get the option
//
Evado.Model.EvOption option = Field.Design.OptionList [count];
//
//The default data type is text.
//
ResultData.AddColumn(
Evado.Integration.Model.EiDataTypes.Boolean,
Field.FieldId + "_" + count + "_" + option.Value);
} //END option iteration loop.
} //END getFormFieldColumns method
}//END static convertEvOptionsList method
// =================================================================================
/// <summary>
/// This static method convert a list of EvFormField into a list of ClientClientDataObjectFields
/// </summary>
/// <param name="FormField">The list of EvFormField objects.</param>
/// <returns>List of ClientClientDataObjectFields</returns>
// ---------------------------------------------------------------------------------
private static Evado.UniForm.Model.Field generateTableField(Evado.Digital.Model.EdRecordField FormField)
{
//
// Initialise the method variables and objects.
//
Evado.UniForm.Model.Field groupField = new Evado.UniForm.Model.Field(
FormField.FieldId,
FormField.Title,
Evado.Model.EvDataTypes.Table);
//
// Initialise the field object.
//
if (FormField.Design.Instructions != String.Empty)
{
groupField.Description = FormField.Design.Instructions;
}
groupField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "100");
groupField.EditAccess = Evado.UniForm.Model.EditAccess.Inherited;
groupField.Type = Evado.Model.EvDataTypes.Table;
groupField.Table = new Evado.UniForm.Model.Table( );
//
// Initialise the table header
//
if (FormField.Table != null)
{
for (int column = 0; column < FormField.Table.Header.Length; column++)
{
groupField.Table.Header [column].No = FormField.Table.Header [column].No;
groupField.Table.Header [column].Text = FormField.Table.Header [column].Text;
groupField.Table.Header [column].TypeId = FormField.Table.Header [column].TypeId;
groupField.Table.Header [column].Width = FormField.Table.Header [column].Width;
//
// Proces the Options or Unit field value.
//
if (groupField.Table.Header [column].TypeId == Evado.Model.EvDataTypes.Numeric)
{
groupField.Table.Header [column].OptionsOrUnit = FormField.Table.Header [column].OptionsOrUnit;
}
if (groupField.Table.Header [column].TypeId == Evado.Model.EvDataTypes.Radio_Button_List ||
groupField.Table.Header [column].TypeId == Evado.Model.EvDataTypes.Selection_List)
{
groupField.Table.Header [column].OptionList = Evado.UniForm.Model.EuStatics.getStringAsOptionList(
FormField.Table.Header [column].OptionsOrUnit);
}
}//END Column interation loop
//
// transfer the table values to the pagefield table object.
//
for (int inRow = 0; inRow < FormField.Table.Rows.Count; inRow++)
{
Evado.UniForm.Model.TableRow row = new Evado.UniForm.Model.TableRow( );
for (int inColumn = 0; inColumn < FormField.Table.ColumnCount; inColumn++)
{
row.Column [inColumn] = FormField.Table.Rows [inRow].Column [inColumn];
}
groupField.Table.Rows.Add(row);
}
}
//
// returnt the page field object.
//
return(groupField);
} //END generateTableField method.
}//END static convertEvOptionsList method
// =================================================================================
/// <summary>
/// This static method convert a list of EvFormField into a list of ClientClientDataObjectFields
/// </summary>
/// <param name="FormField">The list of EvFormField objects.</param>
/// <returns>List of ClientClientDataObjectFields</returns>
// ---------------------------------------------------------------------------------
public static Evado.UniForm.Model.Field convertEvFormfield(Evado.Digital.Model.EdRecordField FormField)
{
//
// Initialise the method variables and objects.
//
Evado.UniForm.Model.Field pageField = new Evado.UniForm.Model.Field(
FormField.FieldId,
FormField.Title,
Evado.Model.EvDataTypes.Null);
pageField.Layout = Evado.UniForm.Model.FieldLayoutCodes.Left_Justified;
if (FormField.Design.Instructions != String.Empty)
{
pageField.Description = FormField.Design.Instructions;
}
switch (FormField.TypeId)
{
case Evado.Model.EvDataTypes.Text:
{
pageField.Type = Evado.Model.EvDataTypes.Text;
pageField.Value = FormField.ItemValue;
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "50");
break;
}
case Evado.Model.EvDataTypes.Free_Text:
{
pageField.Type = Evado.Model.EvDataTypes.Free_Text;
pageField.Value = FormField.ItemText;
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "50");
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Height, "5");
break;
}
case Evado.Model.EvDataTypes.Date:
{
pageField.Type = Evado.Model.EvDataTypes.Date;
pageField.Value = FormField.ItemValue;
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "12");
break;
}
case Evado.Model.EvDataTypes.Time:
{
pageField.Type = Evado.Model.EvDataTypes.Time;
pageField.Value = FormField.ItemValue;
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "6");
break;
}
case Evado.Model.EvDataTypes.Numeric:
{
pageField.Type = Evado.Model.EvDataTypes.Numeric;
pageField.Value = FormField.ItemValue;
pageField.AddParameter(
Evado.UniForm.Model.FieldParameterList.Min_Value,
FormField.Design.ValidationLowerLimit.ToString( ));
pageField.AddParameter(
Evado.UniForm.Model.FieldParameterList.Max_Value,
FormField.Design.ValidationUpperLimit.ToString( ));
pageField.AddParameter(
Evado.UniForm.Model.FieldParameterList.Width, "10");
break;
}
case Evado.Model.EvDataTypes.Selection_List:
case Evado.Model.EvDataTypes.External_Selection_List:
{
pageField.Type = Evado.Model.EvDataTypes.Selection_List;
pageField.Value = FormField.ItemValue;
pageField.OptionList = EuConversions.convertEvOptionsList(FormField.Design.OptionList, true);
pageField.AddParameter(
Evado.UniForm.Model.FieldParameterList.Width, "50");
break;
}
case Evado.Model.EvDataTypes.Radio_Button_List:
// case Evado.Model.EvDataTypes.Horizontal_Radio_Buttons:
{
pageField.Type = Evado.Model.EvDataTypes.Radio_Button_List;
pageField.Value = FormField.ItemValue;
pageField.OptionList = EuConversions.convertEvOptionsList(FormField.Design.OptionList, true);
pageField.AddParameter(
Evado.UniForm.Model.FieldParameterList.Width, "50");
break;
}
case Evado.Model.EvDataTypes.Boolean:
{
pageField.Type = Evado.Model.EvDataTypes.Boolean;
pageField.Value = FormField.ItemValue;
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "50");
break;
}
case Evado.Model.EvDataTypes.Check_Box_List:
{
pageField.Type = Evado.Model.EvDataTypes.Check_Box_List;
pageField.Value = FormField.ItemValue;
pageField.OptionList = EuConversions.convertEvOptionsList(FormField.Design.OptionList, true);
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "50");
break;
}
case Evado.Model.EvDataTypes.Analogue_Scale:
case Evado.Model.EvDataTypes.Horizontal_Radio_Buttons:
{
pageField.Type = Evado.Model.EvDataTypes.Read_Only_Text;
pageField.Value = FormField.ItemValue;
pageField.AddParameter(Evado.UniForm.Model.FieldParameterList.Width, "50");
break;
}
case Evado.Model.EvDataTypes.Table:
case Evado.Model.EvDataTypes.Special_Matrix:
{
pageField = generateTableField(FormField);
break;
}
default:
{
pageField = null;
break;
}
}
//
// return the device option list.
//
return(pageField);
}//END static convertEvOptionsList method
} //END getTableFieldColumn method.
//===================================================================================
/// <summary>
/// This method appends the column objects for a list of form fields.
/// </summary>
/// <param name="Field">Evado.Digital.Model.EvFormField object</param>
/// <param name="ResultData"> Evado.Integration.Model.EiData object</param>
/// <param name="Row"> Evado.Integration.Model.EiDataRow object</param>
//-----------------------------------------------------------------------------------
//private void getTableFieldColumnValues (
public void getTableFieldColumnValues(
Evado.Digital.Model.EdRecordField Field,
Evado.Integration.Model.EiData ResultData,
Evado.Integration.Model.EiDataRow Row)
{
this.LogMethod("getTableFieldColumnValues method.");
//
// Iterate through the table columns
//
for (int tableRow = 0; tableRow < Field.Table.Rows.Count; tableRow++)
{
int row = tableRow + 1;
//
// Iterate through the table columns
//
for (int tableColumn = 0; tableColumn < Field.Table.Header.Length; tableColumn++)
{
int column = tableColumn + 1;
//
// Skip empty header text.
//
if (Field.Table.Header [tableColumn].Text == String.Empty)
{
continue;
}
//
// Define the output field identifier.
//
string fieldId = Field.FieldId + "_" + row + "_" + column + "_" + Field.Table.Header [tableColumn].Text;
//
// Set the checkbox listing output.
//
int headerColumn = ResultData.getColumnNo(fieldId);
//
// Header column found
//
if (headerColumn > -1)
{
string value = Field.Table.Rows [tableRow].Column [tableColumn];
this.LogDebug("Column: " + headerColumn + ",\t FieldId: " + fieldId + ", Type: " + Field.TypeId + ", Value: " + value);
//
// data type switch to handle boolean values.
//
switch (Field.Table.Header [tableColumn].TypeId)
{
case Evado.Model.EvDataTypes.Yes_No:
case Evado.Model.EvDataTypes.Boolean:
{
if (value == "yes" || value == "1" || value == "true")
{
Row.updateValue(headerColumn, "True");
}
else
{
Row.updateValue(headerColumn, "False");
}
break;
}
default:
{
Row.updateValue(headerColumn, value);
break;
}
} //END data type switch
} //END header column index found
} //END table column header iteration loop
} //END table row iteration loop
} //END getTableFieldColumn method.
} //END getFormFieldColumns method
//===================================================================================
/// <summary>
/// This method appends the column objects for a list of form fields.
/// </summary>
/// <param name="Field">Evado.Digital.Model.EvFormField object</param>
/// <param name="ResultData"> Evado.Integration.Model.EiData object</param>
//-----------------------------------------------------------------------------------
//private void getTableFieldColumn (
public void getTableFieldColumn(
Evado.Digital.Model.EdRecordField Field,
Evado.Integration.Model.EiData ResultData)
{
this.LogMethod("getTableFieldColumn method.");
//
// Iterate through the table columns
//
for (int tableRow = 0; tableRow < Field.Table.Header.Length; tableRow++)
{
int row = tableRow + 1;
//
// Iterate through the table columns
//
for (int tableColumn = 0; tableColumn < Field.Table.Header.Length; tableColumn++)
{
int column = tableColumn + 1;
//
// get the column text header.
//
String title = Field.Table.Header [tableColumn].Text;
//
// Skip empty header text.
//
if (title == String.Empty)
{
continue;
}
//
// Defne the parameter.
//
Evado.Integration.Model.EiColumnParameters parameter = new Evado.Integration.Model.EiColumnParameters(
Evado.Integration.Model.EiDataTypes.Text,
Field.FieldId + "_" + row + "_" + column + "_" + title);
switch (Field.Table.Header [tableColumn].TypeId)
{
case Evado.Model.EvDataTypes.Numeric:
{
parameter.DataType = Evado.Integration.Model.EiDataTypes.Floating_Point;
break;
}
case Evado.Model.EvDataTypes.Date:
{
parameter.DataType = Evado.Integration.Model.EiDataTypes.Date;
break;
}
case Evado.Model.EvDataTypes.Yes_No:
case Evado.Model.EvDataTypes.Boolean:
{
parameter.DataType = Evado.Integration.Model.EiDataTypes.Boolean;
break;
}
}//END data type switch
//
//The default data type is text.
//
ResultData.Columns.Add(parameter);
} //END table column header iteration loop
} //END table row iteration loop
} //END getTableFieldColumn method.
