}//END getWidthList method
// =====================================================================================
/// <summary>
/// This class returns the Option list for the item.
///
/// Written by: Ross Anderson
/// Date: 24/08/2005
/// </summary>
/// <returns>ArrayList: a list of options</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Initialize a return list
///
/// 2. Add a null option as first item for a selection list.
///
/// 3. Loop ten rounds to add the width to the return list.
/// </remarks>
// -------------------------------------------------------------------------------------
public static List <Evado.Model.EvOption> getRowLengthList( )
{
//
// Initialize a return list.
//
List <Evado.Model.EvOption> List = new List <Evado.Model.EvOption> ( );
Evado.Model.EvOption Option = new Evado.Model.EvOption( );
//
// Loop five rounds to add the width to the return list.
//
for (int count = 0; count < 10; count++)
{
string stRow = count.ToString( );
Option = new Evado.Model.EvOption(stRow, stRow);
List.Add(Option);
}
//
// Loop ten rounds to add the width to the return list.
//
for (int Count = 0; Count < 20; Count++)
{
string sWidth = (Count * 2 + 10).ToString( );
Option = new Evado.Model.EvOption(sWidth, sWidth);
List.Add(Option);
}
//
//Return the completed Array List.
//
return(List);
}//END getWidthList method
// =====================================================================================
/// <summary>
/// This class provides a list of trial types.
///
/// </summary>
/// <returns>IList containing selection List for items in record table</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Initialize a return list of record item table name
///
/// 2. Create an option list
///
/// 3. Add items from the option list to the return list
/// </remarks>
// ------------------------------------------------------------------------------------
public static List <Evado.Model.EvOption> getRecordItemTablesNameList( )
{
//
// Initialize a return list of record item table name
//
List <Evado.Model.EvOption> list = new List <Evado.Model.EvOption>();
//
// Create an option list
//
Evado.Model.EvOption option = new Evado.Model.EvOption();
list.Add(option);
//
// Add items from the option list to the return list
//
option = Evado.Model.EvStatics.getOption(DataChangeTableNames.EvFormFields);
list.Add(option);
//
// Return the list.
//
return(list);
}
}//END getTypeList method
// =====================================================================================
/// <summary>
/// This class returns the Option list for the item.
///
/// Written by: Ross Anderson
/// Date: 24/08/2005
/// </summary>
/// <returns>ArrayList: a list of options</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Initialize a return list
///
/// 2. Add a null option as first item for a selection list.
///
/// 3. Loop ten rounds to add the width to the return list.
/// </remarks>
// -------------------------------------------------------------------------------------
public static List <Evado.Model.EvOption> getWidthList( )
{
//
// Initialize a return list.
//
List <Evado.Model.EvOption> List = new List <Evado.Model.EvOption> ( );
//
// Add a null option as first item for a selection list.
//
Evado.Model.EvOption Option = new Evado.Model.EvOption("0", String.Empty);
List.Add(Option);
//
// Loop ten rounds to add the width to the return list.
//
for (int Count = 0; Count < 10; Count++)
{
string sWidth = (Count * 5 + 5).ToString();
Option = new Evado.Model.EvOption(sWidth, sWidth);
List.Add(Option);
}
//
//Return the completed Array List.
//
return(List);
}//END getWidthList method
}//END getAsHtml method
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#endregion
#region static methods
// =====================================================================================
/// <summary>
/// This class provides a list of trial types.
///
/// </summary>
/// <returns>List: containing selection List for configuration table</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Initilize a return list of Configuration table name
///
/// 2. Create an option list
///
/// 3. Add items from option list to the return list
/// </remarks>
// ------------------------------------------------------------------------------------
public static List <Evado.Model.EvOption> getConfigurationTablesNameList( )
{
//
// Initilize a return list of Configuration table name object
//
List <Evado.Model.EvOption> list = new List <Evado.Model.EvOption>();
//
// Create an option list
//
Evado.Model.EvOption option = new Evado.Model.EvOption();
list.Add(option);
//
// Add items from option list to the return list
//
option = Evado.Model.EvStatics.getOption(DataChangeTableNames.EvAlerts);
list.Add(option);
option = Evado.Model.EvStatics.getOption(DataChangeTableNames.EvForms);
list.Add(option);
option = Evado.Model.EvStatics.getOption(DataChangeTableNames.EdApplicationSettings);
list.Add(option);
option = Evado.Model.EvStatics.getOption(DataChangeTableNames.EvUserProfiles);
list.Add(option);
//
// Return the list.
//
return(list);
}//END getConfigurationTablesNameList method
// ==================================================================================
/// <summary>
/// This method creates a list of selection options for the passed category.
/// If category is empty then all options are returned.
/// </summary>
/// <param name="Category">String selection option category</param>
/// <returns>List of Evado.Model.EvOption objects</returns>
// ----------------------------------------------------------------------------------
public List <Evado.Model.EvOption> GetOptionList(String Category, bool ForSelectionList)
{
//
// Initialise the methods variables and objecs.
//
List <Evado.Model.EvOption> optionList = new List <Evado.Model.EvOption> ( );
//
// Add an empty selection option. 'Null' indicated that nothing is selected.
//
if (ForSelectionList == true)
{
optionList.Add(new Evado.Model.EvOption("Null", ""));
}
//
// iterate through the list creating the list categories.
//
foreach (Item item in this.Items)
{
//
// skip non matching categories.
//
if (item.Category != Category &&
Category != String.Empty)
{
continue;
}
//
// define the option
//
Evado.Model.EvOption option = new Evado.Model.EvOption(item.Value, item.Description);
//
// append the option if it not aready in the list.
//
if (optionList.Contains(option) == false)
{
optionList.Add(new Evado.Model.EvOption(item.Category));
}
}
//
// Return category option list.
//
return(optionList);
}
}//End getOptionsFromEnum method
// ==============================================================================================
/// <summary>
/// This class obtains a list of selection options made of the names of the enumeration.
/// </summary>
/// <param name="enumObject">Object: an enumeration object</param>
/// <returns>Object: a selection option object</returns>
/// <remarks>
/// This class consists of the following steps:
///
/// 1. Create a string name of enumObject
///
/// 2. Initialize an option object with a replacing of "_" character with a blank character
/// </remarks>
// ------------------------------------------------------------------------------------------------
public static Evado.Model.EvOption getOption(Object enumObject)
{
//
// Create a string name of enumeObject
//
String name = enumObject.ToString();
//
// Initialize a return option object
//
Evado.Model.EvOption option = new Evado.Model.EvOption(name, name.Replace("_", " "));
//
// Return a selection option object.
//
return(option);
}//END getEvOption method
// =====================================================================================
/// <summary>
/// This method returns the Option list for the item.
///
/// Written by: Ross Anderson
/// Date: 24/08/2005
/// </summary>
/// <returns>List of Evado.Model.EvOptions</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Initialize a return list
///
/// 2. Add a null option as first item for a selection list.
///
/// 3. Add items from option object to the return list.
/// </remarks>
// -------------------------------------------------------------------------------------
public static List <Evado.Model.EvOption> getTypeList(Evado.Model.EvDataTypes Datatype)
{
//
// Initialize a return list
//
List <Evado.Model.EvOption> List = new List <Evado.Model.EvOption> ( );
//
// Add a null option as first item for a selection list.
//
Evado.Model.EvOption Option = new Evado.Model.EvOption();
List.Add(Option);
//
// Add items from option object to the return list.
//
Option = new Evado.Model.EvOption("YN", "Boolean Column");
List.Add(Option);
Option = new Evado.Model.EvOption("TXT", "Text Column");
List.Add(Option);
Option = new Evado.Model.EvOption("NUM", "Numeric Column");
List.Add(Option);
Option = new Evado.Model.EvOption("DT", "Date Column");
List.Add(Option);
Option = new Evado.Model.EvOption("RBL", "Radio Button Column");
List.Add(Option);
Option = new Evado.Model.EvOption("SL", "Selection List Column");
List.Add(Option);
if (Datatype == Evado.Model.EvDataTypes.Special_Matrix)
{
Option = new Evado.Model.EvOption("RO", "Read Only");
List.Add(Option);
}
//
//Return the completed Array List.
//
return(List);
}//END getTypeList method
}//ENdc QueryOptionList method
//==================================================================================
/// <summary>
/// This method creates a list of query options.
/// </summary>
/// <param name="IsSelectionList">bool: true if a selection list.</param>
/// <returns>List of Evado.Model.EvOption objects.</returns>
//-----------------------------------------------------------------------------------
public List <Evado.Model.EvOption> ColumnOptionList(bool IsSelectionList)
{
//
// Initialise local variables and objects.
//
List <Evado.Model.EvOption> optionList = new List <Evado.Model.EvOption> ( );
Evado.Model.EvOption option = new Evado.Model.EvOption( );
//
// exit if query list is null.
//
if (ColumnList == null)
{
return(optionList);
}
//
// Add an empty option for a selection lists.
//
if (IsSelectionList == true)
{
optionList.Add(option);
}
//
// Create the option list.
//
foreach (EdReportColumn column in ColumnList)
{
option = new Evado.Model.EvOption(column.ColumnId, column.HeaderText);
if (column.DataType != EdReport.DataTypes.Text)
{
option.Description += " (" + column.DataType + ")";
}
optionList.Add(option);
}
return(optionList);
}//END ColumnOptionList method
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#endregion
#region Class methods
//==================================================================================
/// <summary>
/// This method creates a list of query options.
/// </summary>
/// <param name="IsSelectionList">bool: true if a selection list.</param>
/// <returns>List of Evado.Model.EvOption objects.</returns>
//-----------------------------------------------------------------------------------
public List <Evado.Model.EvOption> QueryOptionList(bool IsSelectionList)
{
//
// Initialise local variables and objects.
//
List <Evado.Model.EvOption> optionList = new List <Evado.Model.EvOption> ( );
Evado.Model.EvOption option = new Evado.Model.EvOption( );
//
// exit if query list is null.
//
if (QueryList == null)
{
return(optionList);
}
//
// Add an empty option for a selection lists.
//
if (IsSelectionList == true)
{
optionList.Add(option);
}
//
// Create the option list.
//
foreach (EdReportQuery query in QueryList)
{
option = new Evado.Model.EvOption(query.QueryId, query.QueryTitle);
if (query.DataType != EdReport.DataTypes.Text)
{
option.Description += " (" + query.DataType + ")";
}
optionList.Add(option);
}
return(optionList);
}//ENdc QueryOptionList method
// =====================================================================================
/// <summary>
/// This class returns the Yes No Selection list for the item.
/// </summary>
/// <returns>ArrayList: a Yes No list</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Initialize a return list and an option object.
///
/// 2. Add Yes/No options into a return list.
/// </remarks>
// -------------------------------------------------------------------------------------
public static List <Evado.Model.EvOption> getYesNoList( )
{
//
// Initialise a return list and an option object.
//
List <Evado.Model.EvOption> list = new List <Evado.Model.EvOption> ( );
Evado.Model.EvOption option = new Evado.Model.EvOption( );
list.Add(option);
//
// Add Yes/No option into a return array list
//
option = new Evado.Model.EvOption("Yes", "Yes");
list.Add(option);
option = new Evado.Model.EvOption("No", "No");
list.Add(option);
//
//Return the completed Array List.
//
return(list);
}//END getOptionList 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>
/// <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
} // Close getView method.
// ==================================================================================
/// <summary>
/// This class gets a ArrayList containing a selectionList of Menus data identifiers.
/// </summary>
/// <param name="PlatformId">string: (Optional) The Site identifier.</param>
/// <returns>List of Evado.Model.EvOption: a list of groups</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Define the SQL query parameters and a query string.
///
/// 2. Execute the query and store the results on datatable.
///
/// 3. Loop through the table and extract data row to the Option object.
///
/// 4. Add Option object's values to the Options list.
///
/// 5. Return the Option list.
///
/// </remarks>
// ----------------------------------------------------------------------------------
public List <Evado.Model.EvOption> getGroupList(
String PlatformId)
{
this.LogMethod("getGroupList, ");
this.LogDebug(" PlatformId: " + PlatformId);
//
// Initialize a debug log, a return list of options, an option object, site 1 and site 2
//
List <Evado.Model.EvOption> List = new List <Evado.Model.EvOption> ( );
Evado.Model.EvOption option = new Evado.Model.EvOption( );
//
// Define the SQL query parameters.
//
SqlParameter [] cmdParms = new SqlParameter []
{
new SqlParameter(PARM_PLATFORM, SqlDbType.VarChar, 10),
};
cmdParms [0].Value = PlatformId;
//
// Define the query string.
//
_sqlQueryString = _sqlQuery_View + " WHERE ( MNU_PLATFORM = @PLATFORM)"
+ " AND (MNU_GROUP_HEADER = 1) ORDER BY MNU_ORDER";
this.LogDebug(_sqlQueryString);
//
// Execute the query against the database.
//
using (DataTable table = EvSqlMethods.RunQuery(_sqlQueryString, cmdParms))
{
//
// Iterate through the results extracting the role information.
//
for (int Count = 0; Count < table.Rows.Count; Count++)
{
//
// Extract the table row
//
DataRow row = table.Rows [Count];
//
// Process the results into the visitSchedule.
//
String stGroup = EvSqlMethods.getString(row, "MNU_GROUP");
String stTitle = EvSqlMethods.getString(row, "MNU_TITLE");
//
// if the group does not exist add it to the list.
//
if (GroupExists(List, stGroup) == false)
{
//
// Append the new Menus object to the array.
//
List.Add(new Evado.Model.EvOption(stGroup, stTitle));
}
}
}
//
// Pass back the result arrray.
//
return(List);
}//END getGroupList method.
/// <summary>
/// This method initialises the report quety object.
/// </summary>
public EdReportQuery( )
{
SelectionList [0] = new Evado.Model.EvOption( );
}
