}//END processNotAvailableValues method
#endregion
#region Record field list Queries
// =====================================================================================
/// <summary>
/// This class returns a list of formfield object retrieved by the record Guid.
/// </summary>
/// <param name="Record">EvForm: (Mandatory) The record object.</param>
/// <param name="IncludeComments">bool: true = include field comments.</param>
/// <returns>List of EvFormField: a formfield object.</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Return an empty formfield object if the record's Guid is empty
///
/// 2. Define the sql query parameters and sql query string
///
/// 3. Execute the sql query string with parameters and store the results on data table.
///
/// 4. Iterate through the table and extract the data row to the formfield object.
///
/// 5. Add object result to the formfields list.
///
/// 6. Return the formfields list.
/// </remarks>
// -------------------------------------------------------------------------------------
public List <EdRecordField> getRecordFieldList(
EdRecord Record)
{
this.LogMethod("getRecordFieldList method. ");
this.LogDebug("Record.Guid: " + Record.Guid);
//
// Initialise the methods variables and objects.
//
List <EdRecordField> recordFieldList = new List <EdRecordField> ( );
EdRecordField recordField = new EdRecordField( );
Guid previousValueGuid = Guid.Empty;
//
// Validate whether the record Guid is not empty.
//
if (Record.Guid == Guid.Empty)
{
return(recordFieldList);
}
//
// Define the SQL query parameters.
//
SqlParameter [] cmdParms = new SqlParameter []
{
new SqlParameter(PARM_RECORD_GUID, SqlDbType.UniqueIdentifier),
};
cmdParms [0].Value = Record.Guid;
//
// Define the query string.
//
_Sql_QueryString = SQL_QUERY_VALUES_VIEW + " WHERE ( " + EdRecordValues.DB_RECORD_GUID + " =" + EdRecordValues.PARM_RECORD_GUID + ") "
+ "ORDER BY " + EdRecordFields.DB_ORDER + "; ";
this.LogDebug(_Sql_QueryString);
//
// Execute the query against the database.
//
using (DataTable table = EvSqlMethods.RunQuery(_Sql_QueryString, cmdParms))
{
if (table.Rows.Count == 0)
{
return(recordFieldList);
}
//
// 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];
Guid recordValueGuid = EvSqlMethods.getGuid(row, EdRecordValues.DB_VALUES_GUID);
this.LogDebug("previousValueGuid: {0}, recordValueGuid: {1}.", previousValueGuid, recordValueGuid);
//
// Empty fields are skipped.
//
if (recordValueGuid == Guid.Empty)
{
this.LogDebug("Skip the value Guid is empty.");
continue;
}
// If the field guid has changed then it is a new field.
// So add the previous field then get the data for the new field.
//
if (previousValueGuid != recordValueGuid)
{
this.LogDebug("Change of recordValueGuid.");
//
// Add the last field to the list.
//
if (recordField.Guid != Guid.Empty)
{
this.LogDebug("Add field to record field list.");
recordFieldList.Add(recordField);
}
//
// Get the object data from the row.
//
recordField = this.getRowData(row);
//
// skip all non summary field if summary fields is selected.
//
if (Record.Design.LinkContentSetting != EdRecord.LinkContentSetting.First_Text_Field &&
Record.SelectOnlySummaryFields == true &&
recordField.Design.IsSummaryField == false)
{
this.LogDebug("{0} is a summary field so SKIPPED.", recordField.FieldId);
continue;
}
//
// skip all non summary field if summary fields is selected.
//
if (Record.Design.LinkContentSetting != EdRecord.LinkContentSetting.First_Text_Field &&
count > 1)
{
this.LogDebug("{0} first field retrieved so SKIPPED.", recordField.FieldId);
continue;
}
//
// Update the lst field guid to enable the other field values to be collected.
//
previousValueGuid = recordField.Guid;
}//END create new field object.
this.LogDebug("Read in value data.");
switch (recordField.TypeId)
{
case Evado.Model.EvDataTypes.Special_Matrix:
case Evado.Model.EvDataTypes.Table:
{
this.getTableCellValue(row, recordField);
break;
}
case Evado.Model.EvDataTypes.Check_Box_List:
{
this.getCheckBoxValue(row, recordField);
break;
}
case Evado.Model.EvDataTypes.Numeric:
{
recordField.ItemValue = EvSqlMethods.getString(row, EdRecordValues.DB_VALUES_NUMERIC);
this.LogDebug("recordField.ItemValue: {0}.", recordField.ItemValue);
break;
}
case Evado.Model.EvDataTypes.Boolean:
case Evado.Model.EvDataTypes.Yes_No:
{
bool bValue = EvSqlMethods.getBool(row, EdRecordValues.DB_VALUES_NUMERIC);
this.LogDebug("bValue: {0}.", bValue);
recordField.ItemValue = "No";
if (bValue == true)
{
recordField.ItemValue = "Yes";
}
this.LogDebug("recordField.ItemValue: {0} bool.", recordField.ItemValue);
break;
}
case Evado.Model.EvDataTypes.Date:
{
var dtValue = EvSqlMethods.getDateTime(row, EdRecordValues.DB_VALUES_DATE);
recordField.ItemValue = EvStatics.getDateAsString(dtValue);
this.LogDebug("recordField.ItemValue: {0}.", recordField.ItemValue);
break;
}
case Evado.Model.EvDataTypes.Free_Text:
{
recordField.ItemText = EvSqlMethods.getString(row, EdRecordValues.DB_VALUES_TEXT);
this.LogDebug("recordField.ItemValue: {0}.", recordField.ItemText);
break;
}
default:
{
if (recordField.isReadOnly == true)
{
break;
}
recordField.ItemValue = EvSqlMethods.getString(row, EdRecordValues.DB_VALUES_STRING);
this.LogDebug("recordField.ItemValue: {0}.", recordField.ItemValue);
break;
}
}
} //ENR record iteration loop.
} //ENd using statement
//
// Add the last field to the list.
//
if (recordField.Guid != Guid.Empty)
{
recordFieldList.Add(recordField);
}
//
// Return the formfields list.
//
return(recordFieldList);
}//END getRecordFieldList method.