}//END hasColumn method
//=======================================================
/// <summary>
/// This method adds a query parameter value to the query parameter list
/// </summary>
/// <returns>EiDataRow</returns>
//-----------------------------------------------------------------------------------
public EiColumnParameters AddColumn( )
{
//
// If DataRows is null initialise it.
//
if (this.Columns == null)
{
this.Columns = new List <EiColumnParameters> ( );
}
//
// Create the data row
//
EiColumnParameters column = new EiColumnParameters( );
//
// Append the data row to the DataRows list.
//
this.Columns.Add(column);
//
// return the data row object.
//
return(column);
}
//==================================================================================
/// <summary>
/// This method adds a query parameter value to the query parameter list
/// </summary>
/// <param name="Datatype"> Date Type enumerated vlaue</param>
/// <param name="EvadoFieldId">object Evado Field identifier</param>
/// <returns>EiDataRow</returns>
//-----------------------------------------------------------------------------------
public EiColumnParameters AddColumn(
EiDataTypes Datatype,
object EvadoFieldId)
{
EiColumnParameters parameters = new EiColumnParameters(
Datatype,
EvadoFieldId,
false);
this.Columns.Add(parameters);
return(parameters);
}
//==================================================================================
/// <summary>
/// This method adds a query parameter value to the query parameter list
/// </summary>
/// <param name="Datatype"> Date Type enumerated vlaue</param>
/// <param name="EvadoFieldId">object Evado Field identifier</param>
/// <param name="Index">Bool: True column is the index</param>
/// <returns>EiDataRow</returns>
//-----------------------------------------------------------------------------------
public EiColumnParameters AddColumn(
EiDataTypes Datatype,
String EvadoFieldId,
bool Index)
{
EiColumnParameters parameters = new EiColumnParameters(
Datatype,
EvadoFieldId,
Index);
this.Columns.Add(parameters);
return(parameters);
}
//==================================================================================
/// <summary>
/// This method adds a query parameter value to the query parameter list
/// </summary>
/// <param name="Parameters">EiDataRow object</param>
/// <returns>EiDataRow</returns>
//-----------------------------------------------------------------------------------
public void AddColumn(EiColumnParameters Parameters)
{
this.Columns.Add(Parameters);
}
} //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.