}//End getConfigurationRecordSelectionList method.
// =====================================================================================
/// <summary>
/// This method gets a list of record for the record table QueryType
/// </summary>
/// <param name="Application">String: (Mandatory) The trial identifier.</param>
/// <param name="EntityId">String: the milestone identifier</param>
/// <param name="RecordTable">EvDataChange.DataChangeTableNames: The table name</param>
/// <returns>List of EvOption: the list of selection options</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Switch the table name and execute the method for retrieving the option list
///
/// 2. Return the list of options.
/// </remarks>
// -------------------------------------------------------------------------------------
public List <EvOption> getRecordSelectionList(
String EntityId,
EvDataChange.DataChangeTableNames RecordTable)
{
//
// Initialise the methods objects and variables.
//
this._DebugLog.AppendLine(Evado.Digital.Model.EvcStatics.CONST_METHOD_START
+ "Evado.Digital.Bll.Clinical.EvDataChanges.getRecordSelectionList");
this._DebugLog.AppendLine("EntityId: " + EntityId);
this._DebugLog.AppendLine("RecordTable: " + RecordTable);
//
// Fill the testReport selection list
//
switch (RecordTable)
{
case EvDataChange.DataChangeTableNames.EvRecords:
{
return(this.GetRecordList(EntityId));
}
case EvDataChange.DataChangeTableNames.EvAncilliaryRecords:
{
return(this.GetSubjectRecordsList(EntityId));
}
}
return(new List <EvOption> ( ));
}//End getRecordSelectionList method.
}//End getRecordList method.
#endregion
#region get Table name lists
// =====================================================================================
/// <summary>
/// This class returns a list of record for the configuration records
/// </summary>
/// <param name="ProjectId">String: (Mandatory) The trial identifier.</param>
/// <param name="VersionGuid">Guid: The version's global unique identifier</param>
/// <param name="ArmIndex">EvTrialArm.ArmIndexes: The Arm Index</param>
/// <param name="RecordTable">EvDataChange.DataChangeTableNames: The table name</param>
/// <returns>List of EvOption: the list of selection options</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Switch the table name to execute the method for retrieving the associated options list.
///
/// 2. Return the new options list.
/// </remarks>
// -------------------------------------------------------------------------------------
public List <EvOption> getConfigurationRecordSelectionList(
String ProjectId,
Guid VersionGuid,
int ArmIndex,
EvDataChange.DataChangeTableNames RecordTable)
{
//
// Initialise the methods objects and variables.
//
this._DebugLog.AppendLine(Evado.Digital.Model.EvcStatics.CONST_METHOD_START
+ "Evado.Digital.Bll.Clinical.EvDataChanges.getConfigurationRecordSelectionList method. ");
this._DebugLog.AppendLine("ProjectId: " + ProjectId);
this._DebugLog.AppendLine("ScheduleGuid: " + VersionGuid);
this._DebugLog.AppendLine("ArmIndex: " + ArmIndex);
this._DebugLog.AppendLine("RecordTable: " + RecordTable);
//
// Fill the testReport selection list
//
switch (RecordTable)
{
case EvDataChange.DataChangeTableNames.EvAlerts:
{
return(this.GetTrialAlerts(ProjectId));
}
case EvDataChange.DataChangeTableNames.EvForms:
{
return(this.GetFormsList( ));
}
case EvDataChange.DataChangeTableNames.EvUserProfiles:
{
return(this.GetUserList( ));
}
}
this._DebugLog.AppendLine("No matching list.");
return(new List <EvOption> ( ));
}//End getConfigurationRecordSelectionList method.
}//End getRecordSelectionList method.
// =====================================================================================
/// <summary>
/// This method gets a list of record for the record table QueryType
/// </summary>
/// <param name="ProjectId">String: (Mandatory) The trial identifier.</param>
/// <param name="RecordTable">EvDataChange.DataChangeTableNames: The table name</param>
/// <returns>List of EvOption: the list of selection options</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Switch the table name and execute the method for retrieving the option list
///
/// 2. Return the list of options.
/// </remarks>
// -------------------------------------------------------------------------------------
public List <EvOption> getItemRecordSelectionList(
EvDataChange.DataChangeTableNames RecordTable)
{
//
// Initialise the methods objects and variables.
//
this._DebugLog.AppendLine(Evado.Digital.Model.EvcStatics.CONST_METHOD_START
+ "Evado.Digital.Bll.Clinical.EvDataChanges.getItemRecordSelectionList. ");
this._DebugLog.AppendLine("RecordTable: " + RecordTable);
//
// Fill the testReport selection list
//
switch (RecordTable)
{
case EvDataChange.DataChangeTableNames.EvFormFields:
{
return(this.GetFormsList( ));
}
}
return(new List <EvOption> ( ));
}//End getItemRecordSelectionList method.
// =====================================================================================
/// <summary>
/// This class returns a list of datachange object based on the RecordGuid and tableName.
/// </summary>
/// <param name="RecordGuid">Guid: (Mandatory) The record's global unique identifier.</param>
/// <param name="TableName">EvDataChange.DataChangeTableNames: the table name .</param>
/// <returns>List of EvDataChange: a list of ResultData change objects.</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Execute the method for retrieving the list of datachange objects based on Guid and table name
///
/// 2. Return the list of ResultData change object.
/// </remarks>
// -------------------------------------------------------------------------------------
public List <EvDataChange> GetDataChangeList(
Guid RecordGuid,
EvDataChange.DataChangeTableNames TableName)
{
//
// Initialise the methods objects and variables.
//
this._DebugLog.AppendLine(Evado.Digital.Model.EvcStatics.CONST_METHOD_START
+ "Evado.Digital.Bll.Clinical.EvDataChanges.GetView");
this._DebugLog.AppendLine("RecordGuid: " + RecordGuid);
this._DebugLog.AppendLine("Record Type: " + TableName);
//
// Query the database
//
List <EvDataChange> view = this._dalChanges.GetView(RecordGuid, TableName);
this._DebugLog.AppendLine(this._dalChanges.Log);
this._DebugLog.AppendLine("current schedule count: " + view.Count);
return(view);
}//End getRecordList method.
}//END getRowData method.
// +++++++++++++++++++++++++++ END RECORD READER SECTION ++++++++++++++++++++++++++++++
#endregion
#region DataChange Queries
// =====================================================================================
/// <summary>
/// This method queries the data changes for a record.
/// </summary>
/// <param name="RecordGuid">Guid: (Mandatory) Record global Unique identifier.</param>
/// <param name="TableName">EvDataChange.DataChangeTableNames: (Mandatory) table name.</param>
/// <returns>List of EvDataChange: a list of data change items</returns>
/// <remarks>
/// This method consists of the following steps:
///
/// 1. Defines the sql query parameters and the sql query string.
///
/// 2. Execute the sql query string with parameters and store the results on datatable.
///
/// 3. Loop through the table and extract data row to the data change object.
///
/// 4. Add the object to the Datachanges list.
///
/// 5. Return the Datachanges list.
/// </remarks>
// -------------------------------------------------------------------------------------
public List <EvDataChange> GetView(
Guid RecordGuid,
EvDataChange.DataChangeTableNames TableName)
{
//
// Initialize the status and the return data change list
//
this.LogMethod("GetView method. ");
this.LogDebug("SiteGuid: " + EvDataChanges._SiteGuid);
this.LogDebug("RecordGuid: " + RecordGuid);
this.LogDebug("Record Type: " + TableName);
List <EvDataChange> View = new List <EvDataChange> ( );
//
// If the site guid is empty exit.
//
if (EvDataChanges._SiteGuid == Guid.Empty)
{
return(new List <EvDataChange> ( ));
}
//
// Define the SQL query parameters.
//
SqlParameter [] cmdParms = new SqlParameter []
{
new SqlParameter(_parmRecordGuid, SqlDbType.UniqueIdentifier),
new SqlParameter(_parmTableName, SqlDbType.NVarChar, 50)
};
cmdParms [0].Value = RecordGuid;
cmdParms [1].Value = TableName.ToString( );
//
// Define the query string.
//
_sqlQueryString = _sqlQueryView + " WHERE (DC_RecordGuid = @RecordGuid) "
+ " AND (DC_TableName = @TableName) "
+ " ORDER BY DC_DateStamp;";
this.LogClass(_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];
//
// Read the row data.
//
EvDataChange Item = this.getRowData(row);
//
// Append the new Change object to the array.
//
View.Add(Item);
} //END record iteration loop.
} //END Using statement
this.LogDebug("Record Count: " + View.Count);
//
// Pass back the result arrray.
//
return(View);
} // Close GetView method.
