}//END SetParameters class. #endregion #region ExternalSelectionList Reader // ===================================================================================== /// <summary> /// This class extracts the content of the reader to the formfield selectionlist object. /// </summary> /// <param name="Row">DataRow: a data Reader containing the query results</param> /// <returns>EvFormFieldSelectionList: a formfield selectionlist object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Extract the compatible data row values to the formfield selectionlist object. /// /// 2. Return the Formfield selectionlist object. /// </remarks> // --------------------------------------------------------------------------------- private EvSelectionList readDataRow(DataRow Row) { // // Initialise the formfield selectionlist object. // EvSelectionList Item = new EvSelectionList( ); // // Extract the compatible data row values to the formfield selectionlist object items. // Item.Guid = EvSqlMethods.getGuid(Row, EvSelectionLists.DB_GUID); Item.ListId = EvSqlMethods.getString(Row, EvSelectionLists.DB_LIST_ID); Item.Title = EvSqlMethods.getString(Row, EvSelectionLists.DB_TITLE); Item.Description = EvSqlMethods.getString(Row, EvSelectionLists.DB_DESCRIPTION); Item.Version = EvSqlMethods.getInteger(Row, EvSelectionLists.DB_VERSION); string xmlCodeItem = EvSqlMethods.getString(Row, EvSelectionLists.DB_ITEM_LIST); if (xmlCodeItem != String.Empty) { Item.Items = Evado.Digital.Model.EvcStatics.DeserialiseObject <List <EvSelectionList.Item> > (xmlCodeItem); } Item.State = Evado.Model.EvStatics.parseEnumValue <EvSelectionList.SelectionListStates> ( EvSqlMethods.getString(Row, EvSelectionLists.DB_STATE)); Item.UpdatedByUserId = EvSqlMethods.getString(Row, EvSelectionLists.DB_UPDATED_BY_USER_ID); Item.UpdatedBy = EvSqlMethods.getString(Row, EvSelectionLists.DB_UPDATED_BY); Item.UpdatedDate += EvSqlMethods.getDateTime(Row, EvSelectionLists.DB_UPDATED_DATE); // // Return item // return(Item); }//END readDataRow method.
// ===================================================================================== /// <summary> /// This class reads the content of the data reader object into FormField business object. /// </summary> /// <param name="Row">DataRow: an sql data query row</param> /// <returns>EvFormField: a form field object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Update formfield object with the compatible data row items. /// /// 2. If the formfield typeId is table, iterate through the formfield table and set the validation rules /// /// 3. If the selection validation options are missing, add them. /// /// 4. If it is an external coding visitSchedule then add the relevant coding visitSchedule items. /// /// 5. Resolve the numeric 'NA' to negative infinity issue. /// /// 6. Update the instrument type to current enumeration. /// /// 7. If formfield typeId is either analogue scale or horizontal radio buttons, /// select the design by coding value /// /// 8. Return the formfield object. /// </remarks> // ------------------------------------------------------------------------------------- private Evado.Digital.Model.EdRecordSection getRowData(DataRow Row) { // // Initialise xmltable string and a return formfield object. // string xmlTable = String.Empty; Evado.Digital.Model.EdRecordSection formSection = new Evado.Digital.Model.EdRecordSection( ); // // Update formfield object with the compatible data row items. // formSection.LayoutGuid = EvSqlMethods.getGuid(Row, EdRecordSections.DB_LAYOUT_GUID); formSection.No = EvSqlMethods.getInteger(Row, EdRecordSections.DB_NUMBER);; formSection.Title = EvSqlMethods.getString(Row, EdRecordSections.DB_NAME); formSection.Order = EvSqlMethods.getInteger(Row, EdRecordSections.DB_ORDER); formSection.FieldId = EvSqlMethods.getString(Row, EdRecordSections.DB_FIELD_NAME); formSection.Instructions = EvSqlMethods.getString(Row, EdRecordSections.DB_INSTRUCTIONS); formSection.FieldValue = EvSqlMethods.getString(Row, EdRecordSections.DB_FIELD_VALUE); formSection.OnMatchVisible = EvSqlMethods.getBool(Row, EdRecordSections.DB_ON_MATCH_VISIBLE); formSection.OnOpenVisible = EvSqlMethods.getBool(Row, EdRecordSections.DB_VISIBLE); formSection.ReadAccessRoles = EvSqlMethods.getString(Row, EdRecordSections.DB_DEFAULT_DISPLAY_ROLES); formSection.EditAccessRoles = EvSqlMethods.getString(Row, EdRecordSections.DB_DEFAULT_EDIT_ROLES); formSection.PercentWidth = EvSqlMethods.getInteger(Row, EdRecordSections.DB_PERCENT_WIDTH); return(formSection); }//END getRowData method.
}//END SetParameters method #endregion #region Aplication Profile Reader // ===================================================================================== /// <summary> /// This method extracts the data reader values to the Site profile object. /// </summary> /// <param name="Row">DataRow object.</param> /// <returns>EvSiteProfile: A site profile data object.</returns> /// <remarks> /// This method consists of following steps. /// /// 1. Extract the compatible data reader object's values to the Site Profile Object. /// /// 2. Return a Site Profile Object. /// /// </remarks> // ------------------------------------------------------------------------------------ public Evado.Digital.Model.EdAdapterSettings getReaderData(DataRow Row) { //this.LogMethod ( "getReaderData method. " ); // // Initialise method variables and objects. // Evado.Digital.Model.EdAdapterSettings applicationSettings = new Evado.Digital.Model.EdAdapterSettings( ); // // Load the query results into the EvProfile object. // applicationSettings.Guid = EvSqlMethods.getGuid(Row, EdAdapterConfig.DB_FIELD_GUID); applicationSettings.ApplicationId = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_APPLICATION_ID); applicationSettings.HomePageHeaderText = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_HOME_PAGE_HEADER); applicationSettings.HelpUrl = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_HELP_URL); applicationSettings.MaximumSelectionListLength = EvSqlMethods.getInteger(Row, EdAdapterConfig.DB_FIELD_MAX_SELECTION_LENGTH); applicationSettings.SmtpServer = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_SMTP_SERVER); applicationSettings.SmtpServerPort = EvSqlMethods.getInteger(Row, EdAdapterConfig.DB_FIELD_SMTP_PORT); applicationSettings.SmtpUserId = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_SMTP_USER_ID); applicationSettings.SmtpPassword = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_SMTP_PASSWORD); applicationSettings.EmailAlertTestAddress = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_ALERT_EMAIL_ADDRESS); //applicationSettings.ap = EvSqlMethods.getString ( Row, EdAdapterSettings.DB_FIELD_APPLICATION_URL ); applicationSettings.State = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_STATE); applicationSettings.Title = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_TITLE); applicationSettings.HttpReference = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_HTTP_REFERENCE); applicationSettings.Description = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_DESCRIPTION); applicationSettings.UserRoles = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_ROLES); applicationSettings.UpdatedBy = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_UPDATE_USER); applicationSettings.UpdatedByUserId = EvSqlMethods.getString(Row, EdAdapterConfig.DB_FIELD_UPDATE_USER_ID); if (applicationSettings.DemoAccountExpiryDays == 0) { applicationSettings.DemoAccountExpiryDays = 28; } // // Return the object. // return(applicationSettings); }//END getReaderData method
}//END SetParameters class. #endregion #region ancillary record Reader // ===================================================================================== /// <summary> /// This method extracts the data row values to the Subject Record object. /// </summary> /// <param name="Row">DataRow: A data row object</param> /// <returns>EvSubjectRecord: A milestone record object.</returns> /// <remarks> /// This method consists of following steps: /// /// 1. Extract the compatible data row values to the Subject record object. /// /// 2. Return the milestone record object. /// </remarks> // ---------------------------------------------------------------------------------- private EvAncillaryRecord readRowData(DataRow Row) { // // Initialise the method variables and objects. // EvAncillaryRecord record = new EvAncillaryRecord( ); // // Extract the data object values. // record.Guid = EvSqlMethods.getGuid(Row, "TSR_Guid"); record.ProjectId = EvSqlMethods.getString(Row, "TrialId"); record.SubjectId = EvSqlMethods.getString(Row, "SubjectId"); record.RecordId = EvSqlMethods.getString(Row, "RecordId"); record.RecordDate = EvSqlMethods.getDateTime(Row, "TSR_RecordDate"); record.Subject = EvSqlMethods.getString(Row, "TSR_Subject"); record.Record = EvSqlMethods.getString(Row, "TSR_Record"); // // Perform binary object management // record.BinaryLength = EvSqlMethods.getInteger(Row, "TSR_BinaryLength"); if (record.BinaryLength > 0) { record.BinaryObject = EvSqlMethods.getBytes(Row, "TSR_BinaryObject"); record.BinaryType = EvSqlMethods.getString(Row, "TSR_BinaryType"); record.BinaryExtension = EvSqlMethods.getString(Row, "TSR_BinaryExtension"); } record.XmlData = EvSqlMethods.getString(Row, "TSR_XmlData"); record.Researcher = EvSqlMethods.getString(Row, "TSR_Researcher"); record.ResearcherDate = EvSqlMethods.getDateTime(Row, "TSR_ResearcherDate"); record.Reviewer = EvSqlMethods.getString(Row, "TSR_Reviewer"); record.ReviewDate = EvSqlMethods.getDateTime(Row, "TSR_ReviewDate"); record.Approver = EvSqlMethods.getString(Row, "TSR_Approver"); record.ApprovalDate = EvSqlMethods.getDateTime(Row, "TSR_ApprovalDate"); record.State = Evado.Model.EvStatics.parseEnumValue <EdRecordObjectStates> (EvSqlMethods.getString(Row, "TSR_State")); record.UpdatedByUserId = EvSqlMethods.getString(Row, "TSR_UpdatedByUserId"); record.UpdatedBy = EvSqlMethods.getString(Row, "TSR_UpdatedBy"); record.UpdatedDate = EvSqlMethods.getDateTime(Row, "TSR_UpdateDate"); record.BookedOutBy = EvSqlMethods.getString(Row, "TSR_BookedOutBy"); record.Signoffs = Evado.Model.EvStatics.DeserialiseObject <List <EdUserSignoff> > (EvSqlMethods.getString(Row, "TSR_Signoffs")); // // Return an object containing EvSubjectRecord object. // return(record); }//END getRowData
}//END SetParameters class. #endregion #region Data Reader methods // ================================================================================== /// <summary> /// This method reads the content of the data row object containing a query result /// into an ActivityRecord object. /// </summary> /// <param name="Row">DataRow: a retrieving data row object</param> /// <returns>EvBinaryFileMetaData: a readed data row object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Extract the compatible data row values to the Binary file Meta data object /// /// 2. Return the Binary file Meta data object /// </remarks> // ---------------------------------------------------------------------------------- public EvBinaryFileMetaData readDataRow(DataRow Row) { // // Initialise the instrument objects and variables. // EvBinaryFileMetaData binaryFile = new EvBinaryFileMetaData( ); // // Extract the data object values. // binaryFile.Guid = EvSqlMethods.getGuid(Row, EvBinaryFiles.DB_GUID); binaryFile.FileGuid = EvSqlMethods.getGuid(Row, EvBinaryFiles.DB_FILE_GUID); binaryFile.TrialGuid = EvSqlMethods.getGuid(Row, EvBinaryFiles.DB_PROJECT_GUID); binaryFile.GroupGuid = EvSqlMethods.getGuid(Row, EvBinaryFiles.DB_GROUP_GUID); binaryFile.SubGroupGuid = EvSqlMethods.getGuid(Row, EvBinaryFiles.DB_SUB_GROUP_GUID); binaryFile.Language = EvSqlMethods.getString(Row, EvBinaryFiles.DB_LANGUAGE); binaryFile.TrialId = EvSqlMethods.getString(Row, EvBinaryFiles.DB_TRIAL_ID); binaryFile.GroupId = EvSqlMethods.getString(Row, EvBinaryFiles.DB_GROUP_ID); binaryFile.SubGroupId = EvSqlMethods.getString(Row, EvBinaryFiles.DB_SUB_GROUP_ID); binaryFile.FileId = EvSqlMethods.getString(Row, EvBinaryFiles.DB_FILE_ID); binaryFile.Title = EvSqlMethods.getString(Row, EvBinaryFiles.DB_FILE_TITLE); binaryFile.Comments = EvSqlMethods.getString(Row, EvBinaryFiles.DB_FILE_COMMENT); binaryFile.FileName = EvSqlMethods.getString(Row, EvBinaryFiles.DB_FILE_NAME); binaryFile.MimeType = EvSqlMethods.getString(Row, EvBinaryFiles.DB_MIME_TYPE); binaryFile.Status = EvSqlMethods.getString <EvBinaryFileMetaData.FileStatus> ( Row, EvBinaryFiles.DB_FILE_STATUS); binaryFile.UploadDate = EvSqlMethods.getDateTime(Row, EvBinaryFiles.DB_UPLOAD_DATE); binaryFile.ReleaseDate = EvSqlMethods.getDateTime(Row, EvBinaryFiles.DB_RELEASE_DATE); binaryFile.SupersededDate = EvSqlMethods.getDateTime(Row, EvBinaryFiles.DB_SUPERSEDED_DATE); binaryFile.FileExists = EvSqlMethods.getBool(Row, EvBinaryFiles.DB_FILE_EXISTS); binaryFile.FileEncrypted = EvSqlMethods.getBool(Row, EvBinaryFiles.DB_FILE_ENCRYPTED); binaryFile.Version = EvSqlMethods.getInteger(Row, EvBinaryFiles.DB_VERSION); binaryFile.UpdatedByUserId = EvSqlMethods.getString(Row, EvBinaryFiles.DB_UPDATED_BY_USER_ID); binaryFile.UpdatedBy = EvSqlMethods.getString(Row, EvBinaryFiles.DB_UPDATED_BY); binaryFile.UpdatedByDate = EvSqlMethods.getDateTime(Row, EvBinaryFiles.DB_UPDATED_DATE); // // Return the object. // return(binaryFile); }//End readDataRow method.
}//END SetParameters class. #endregion #region PageLayout Reader // ===================================================================================== /// <summary> /// This class extracts the content of the reader to the formfield selectionlist object. /// </summary> /// <param name="Row">DataRow: a data Reader containing the query results</param> /// <returns>EvFormFieldSelectionList: a formfield selectionlist object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Extract the compatible data row values to the formfield selectionlist object. /// /// 2. Return the Formfield selectionlist object. /// </remarks> // --------------------------------------------------------------------------------- private EdPageLayout readDataRow(DataRow Row) { // // Initialise the formfield selectionlist object. // EdPageLayout Item = new EdPageLayout( ); // // Extract the compatible data row values to the formfield selectionlist object items. // Item.Guid = EvSqlMethods.getGuid(Row, EdPageLayouts.DB_GUID); Item.PageId = EvSqlMethods.getString(Row, EdPageLayouts.DB_PAGE_ID); Item.State = EvSqlMethods.getString <EdPageLayout.States> (Row, EdPageLayouts.DB_STATE); Item.UserTypes = EvSqlMethods.getString(Row, EdPageLayouts.DB_USER_TYPES); Item.Title = EvSqlMethods.getString(Row, EdPageLayouts.DB_TITLE); Item.HomePage = EvSqlMethods.getBool(Row, EdPageLayouts.DB_HOME_PAGE); Item.MenuLocation = EvSqlMethods.getString <EdPageLayout.MenuLocations> (Row, EdPageLayouts.DB_MENU_LOCATION); Item.PageCommands = EvSqlMethods.getString(Row, EdPageLayouts.DB_PAGE_COMMANDS); Item.HeaderContent = EvSqlMethods.getString(Row, EdPageLayouts.DB_HEADER_CONTENT); Item.HeaderComponentList = EvSqlMethods.getString(Row, EdPageLayouts.DB_HEADER_COMPONENT_LIST); Item.LeftColumnContent = EvSqlMethods.getString(Row, EdPageLayouts.DB_LEFT_CONTENT); Item.LeftColumnComponentList = EvSqlMethods.getString(Row, EdPageLayouts.DB_LEFT_COMPONENT_LIST); Item.LeftColumnWidth = (short)EvSqlMethods.getInteger(Row, EdPageLayouts.DB_LEFT_COLUMN_WIDTH); Item.CenterColumnContent = EvSqlMethods.getString(Row, EdPageLayouts.DB_CENTER_CONTENT); Item.CenterColumnComponentList = EvSqlMethods.getString(Row, EdPageLayouts.DB_CENTER_COMPONENT_LIST); Item.RightColumnContent = EvSqlMethods.getString(Row, EdPageLayouts.DB_RIGHT_CONTENT); Item.RightColumnComponentList = EvSqlMethods.getString(Row, EdPageLayouts.DB_RIGHT_COMPONENT_LIST); Item.RightColumnWidth = (short)EvSqlMethods.getInteger(Row, EdPageLayouts.DB_RIGHT_COLUMN_WIDTH); Item.Version = EvSqlMethods.getInteger(Row, EdPageLayouts.DB_VERSION); Item.UpdatedByUserId = EvSqlMethods.getString(Row, EdPageLayouts.DB_UPDATED_BY_USER_ID); Item.UpdatedBy = EvSqlMethods.getString(Row, EdPageLayouts.DB_UPDATED_BY); Item.UpdatedDate += EvSqlMethods.getDateTime(Row, EdPageLayouts.DB_UPDATED_DATE); // // Return item // return(Item); }//END readDataRow method.
}//END SetLetterParameters. #endregion #region ReaderData methods // ===================================================================================== /// <summary> /// This class reads the content of the data reader object into Menus business object. /// </summary> /// <param name="Row">DataRow: a sql data row</param> /// <returns>EvMenuItem: a row data of the menu item</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Add page identifier to a menu item object if it exists /// /// 2. Append the row strings of EvSqlMethods object to the menu item object. /// /// 3. Rename the role visitSchedule members and add them to the menu item object. /// /// 4. Return the menu item object /// </remarks> // ------------------------------------------------------------------------------------- public Evado.Digital.Model.EvMenuItem getRowData(DataRow Row) { // // Initialise the menu item object and a page identifier string. // Evado.Digital.Model.EvMenuItem menu = new Evado.Digital.Model.EvMenuItem( ); menu.Guid = EvSqlMethods.getGuid(Row, "MNU_GUID"); menu.PageId = EvSqlMethods.getString(Row, "MNU_PAGE_ID"); menu.Title = EvSqlMethods.getString(Row, "MNU_TITLE"); menu.Order = EvSqlMethods.getInteger(Row, "MNU_ORDER"); menu.Group = EvSqlMethods.getString(Row, "MNU_GROUP"); menu.GroupHeader = EvSqlMethods.getBool(Row, "MNU_GROUP_HEADER"); menu.Platform = EvSqlMethods.getString(Row, "MNU_PLATFORM"); menu.UserTypes = EvSqlMethods.getString(Row, "MNU_USER_TYPES"); menu.RoleList = EvSqlMethods.getString(Row, "MNU_ROLES"); menu.Parameters = EvSqlMethods.getString(Row, "MNU_PARAMETERS"); return(menu); }//END getRowData method.
}//END getCheckBoxValue method // ===================================================================================== /// <summary> /// this method updates a table cell value form the query result set. /// Note: the cell indexes are zero based. /// </summary> /// <param name="Row">The DataRow containing the field</param> /// <param name="FormField"> Evado.Model.Forms.EvFormField object, containg the field data.</param> // ------------------------------------------------------------------------------------- private void getTableCellValue(DataRow Row, Evado.Digital.Model.EdRecordField FormField) { LogMethod("getTableCellValue"); // // Validate that the table exists. // if (FormField.Table == null) { this.LogDebug("FormField.Table is null"); return; } // // Get the field row values. // int row = EvSqlMethods.getInteger(Row, EdRecordValues.DB_VALUES_ROW); String columnId = EvSqlMethods.getString(Row, EdRecordValues.DB_VALUES_COLUMN_ID); // // get the colum no // int col = getHeaderColumnNo(FormField.Table.Header, columnId); // // get the column row value. // string value = this.getTableColumnValue(Row, col, FormField); LogMethodEnd("getTableColumnValue"); // // Add the value to the table. // if (row < FormField.Table.Rows.Count) { FormField.Table.Rows [row].Column [col] = value; } this.LogDebug(" Row: " + row + " col: " + col + ", value: " + FormField.Table.Rows [row].Column [col]); LogMethodEnd("getTableCellValue"); }//END getTableCellValue method
// // Define the class EventId property and variable. // #endregion #region Data Reader section // ================================================================================== /// <summary> /// This class reads the content of the data reader object into ApplicationEvent business object. /// </summary> /// <param name="Row">DataRow: a data row object</param> /// <remarks> /// This method consists of the following step: /// /// 1. Convert the elements from data reader object into the elements /// in application event business object. /// </remarks> // ---------------------------------------------------------------------------------- public EvApplicationEvent getReaderData(DataRow Row) { EvApplicationEvent Event = new EvApplicationEvent( ); // // Convert the elements from data reader object into the elements in application event business object. // Event.Guid = EvSqlMethods.getGuid(Row, DB_GUID); Event.EventId = EvSqlMethods.getInteger(Row, DB_EVENT_ID); Event.DateTime = EvSqlMethods.getDateTime(Row, DB_DATE_TIME); string sType = EvSqlMethods.getString(Row, DB_EVENT_TYPE); if (sType == "A") { sType = "Action"; } if (sType == "I") { sType = "Information"; } if (sType == "W") { sType = "Warning"; } if (sType == "E") { sType = "Error"; } Event.Type = Evado.Model.EvStatics.parseEnumValue <EvApplicationEvent.EventType> (sType); Event.Category = EvSqlMethods.getString(Row, DB_EVENT_CATEGORY); Event.UserId = EvSqlMethods.getString(Row, DB_USER_NAME); Event.Description = EvSqlMethods.getString(Row, DB_DESCRIPTION); Event.PageUrl = EvSqlMethods.getString(Row, DB_PAGE_URL); Event.CustomerId = EvSqlMethods.getString(Row, DB_SITE); return(Event); }//END getRowData method.
// ================================================================================== /// <summary> /// This method reads the content of the data row object containing a query result /// into an Activity Record object. /// </summary> /// <param name="Row">DataRow: a data row record object</param> /// <returns>EvActivityForm: a data row object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Extract the data object values from the data row object and add to the activity form object. /// /// 2. Return the activity form object. /// </remarks> // ---------------------------------------------------------------------------------- private EvObjectParameter readDataRow(DataRow Row) { // // Initialise application parameter object // EvObjectParameter parameter = new EvObjectParameter( ); // // Extract the data object values from the data row object and add to the activity form object. // parameter.Guid = EvSqlMethods.getGuid(Row, "OBJ_GUID"); parameter.Order = EvSqlMethods.getInteger(Row, "OBP_ORDER"); parameter.Name = EvSqlMethods.getString(Row, "OBP_NAME"); parameter.DataType = EvStatics.parseEnumValue <EvDataTypes> (EvSqlMethods.getString(Row, "OBP_TYPE")); parameter.Value = EvSqlMethods.getString(Row, "OBP_VALUE"); parameter.Options = EvSqlMethods.getString(Row, "OBP_OPTIONS"); // // Return the application parameter object. // return(parameter); }// End readDataRow method.
// ================================================================================== /// <summary> /// This class reads the content of the SqlDataReader into the Facility data object. /// </summary> /// <param name="Row">DataRow: a row of data row table</param> /// <returns>EvDataBaseUpdate: an update database</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Initialise an update object. /// /// 2. Extract the data object values and update values to the update object. /// /// 3. Return the update object. /// </remarks> // ---------------------------------------------------------------------------------- public EvDataBaseUpdate readDataRow(DataRow Row) { // // Initialise an update object. // EvDataBaseUpdate update = new EvDataBaseUpdate( ); // // Extract the data object values and update values to the update object. // update.Guid = EvSqlMethods.getGuid(Row, "DBU_Guid"); update.UpdateNo = EvSqlMethods.getInteger(Row, "DBU_Update_No"); update.UpdateDate = EvSqlMethods.getDateTime(Row, "DBU_Update_Date"); update.Version = EvSqlMethods.getString(Row, "DBU_Version"); update.Objects = EvSqlMethods.getString(Row, "DBU_Object"); update.Description = EvSqlMethods.getString(Row, "DBU_Description"); // // Return the update object. // return(update); }// End readDataRow method.
// ===================================================================================== /// <summary> /// This class reads the content of the data reader object into ChecklistItem business object. /// </summary> /// <param name="Row">DataRow: an Sql DataReader object</param> /// <returns>EvFormField: a formfield object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Extract the compatible row data to the formfield object. /// /// 2. Deserialize the xmlData to the formfield design object if it exists. /// /// 3. Deserialize the xmlvalidationRules to the formfield validationRules object if they exist. /// /// 4. Reset the horizontal radion button list enumertion /// /// 5. Ensure that the formfield state is not null. /// /// 6. if skip retrieving comments is selected, fill the comment list and format it /// /// 7. Get the table object and the external selection list object. /// /// 8. Process the NA values in selectionlists. /// /// 9. Update the current formfield state and type object. /// /// 10. Return the formfield object. /// </remarks> // ------------------------------------------------------------------------------------- private EdRecordField getRowData( DataRow Row) { this.LogMethod("getRowData method"); // // Initialise method template table string, a return formfield object and an annotation string. // string stTemplateTable = String.Empty; EdRecordField recordField = new EdRecordField( ); // // Fill the evForm object.l // recordField.Guid = EvSqlMethods.getGuid(Row, EdRecordValues.DB_VALUES_GUID); recordField.RecordGuid = EvSqlMethods.getGuid(Row, EdRecords.DB_RECORD_GUID); recordField.LayoutGuid = EvSqlMethods.getGuid(Row, EdRecordLayouts.DB_LAYOUT_GUID); recordField.FieldGuid = EvSqlMethods.getGuid(Row, EdRecordValues.DB_FIELD_GUID); recordField.FieldId = EvSqlMethods.getString(Row, EdRecordFields.DB_FIELD_ID); String value = EvSqlMethods.getString(Row, EdRecordFields.DB_TYPE_ID); recordField.Design.TypeId = Evado.Model.EvStatics.parseEnumValue <Evado.Model.EvDataTypes> (value); recordField.Design.Title = EvSqlMethods.getString(Row, EdRecordFields.DB_TITLE); recordField.Design.Instructions = EvSqlMethods.getString(Row, EdRecordFields.DB_INSTRUCTIONS); recordField.Design.HttpReference = EvSqlMethods.getString(Row, EdRecordFields.DB_HTTP_REFERENCE); recordField.Design.SectionNo = EvSqlMethods.getInteger(Row, EdRecordFields.DB_SECTION_ID); recordField.Design.Options = EvSqlMethods.getString(Row, EdRecordFields.DB_OPTIONS); recordField.Design.IsSummaryField = EvSqlMethods.getBool(Row, EdRecordFields.DB_SUMMARY_FIELD); recordField.Design.Mandatory = EvSqlMethods.getBool(Row, EdRecordFields.DB_MANDATORY); recordField.Design.AiDataPoint = EvSqlMethods.getBool(Row, EdRecordFields.DB_AI_DATA_POINT); recordField.Design.HideField = EvSqlMethods.getBool(Row, EdRecordFields.DB_HIDDEN); recordField.Design.ExSelectionListId = EvSqlMethods.getString(Row, EdRecordFields.DB_EX_SELECTION_LIST_ID); recordField.Design.ExSelectionListCategory = EvSqlMethods.getString(Row, EdRecordFields.DB_EX_SELECTION_LIST_CATEGORY); recordField.Design.DefaultValue = EvSqlMethods.getString(Row, EdRecordFields.DB_DEFAULT_VALUE); recordField.Design.Unit = EvSqlMethods.getString(Row, EdRecordFields.DB_UNIT); recordField.Design.UnitScaling = EvSqlMethods.getString(Row, EdRecordFields.DB_UNIT_SCALING); recordField.Design.ValidationLowerLimit = EvSqlMethods.getFloat(Row, EdRecordFields.DB_VALIDATION_LOWER_LIMIT); recordField.Design.ValidationUpperLimit = EvSqlMethods.getFloat(Row, EdRecordFields.DB_VALIDATION_UPPER_LIMIT); recordField.Design.AlertLowerLimit = EvSqlMethods.getFloat(Row, EdRecordFields.DB_ALERT_LOWER_LIMIT); recordField.Design.AlertUpperLimit = EvSqlMethods.getFloat(Row, EdRecordFields.DB_ALERT_UPPER_LIMIT); recordField.Design.NormalRangeLowerLimit = EvSqlMethods.getFloat(Row, EdRecordFields.DB_NORMAL_LOWER_LIMITD); recordField.Design.NormalRangeUpperLimit = EvSqlMethods.getFloat(Row, EdRecordFields.DB_NORMAL_UPPER_LIMIT); recordField.Design.FieldCategory = EvSqlMethods.getString(Row, EdRecordFields.DB_FIELD_CATEGORY); recordField.Design.AnalogueLegendStart = EvSqlMethods.getString(Row, EdRecordFields.DB_ANALOGUE_LEGEND_START); recordField.Design.AnalogueLegendFinish = EvSqlMethods.getString(Row, EdRecordFields.DB_ANALOGUE_LEGEND_FINISH); recordField.Design.JavaScript = EvSqlMethods.getString(Row, EdRecordFields.DB_JAVA_SCRIPT); recordField.Design.InitialOptionList = EvSqlMethods.getString(Row, EdRecordFields.DB_INITIAL_OPTION_LIST); recordField.Design.InitialVersion = EvSqlMethods.getInteger(Row, EdRecordFields.DB_INITIAL_VERSION); // // if the field is a signature then decrypt the field. // if (recordField.TypeId == EvDataTypes.Signature) { this.LogDebug("Encrypted Signature string"); EvEncrypt encrypt = new EvEncrypt(this.ClassParameters.AdapterGuid, recordField.Guid); encrypt.ClassParameters = this.ClassParameters; value = encrypt.decryptString(recordField.ItemText); this.LogDebug("clear string: " + value); recordField.ItemText = value; this.LogClass(encrypt.Log); } // // Get the table or matric object. // this.processTableRowObject(Row, recordField); // // Return the formfield object. // this.LogMethodEnd("getRowData"); return(recordField); }//END getRowData method.
// ===================================================================================== /// <summary> /// This class reads the content of the SqlDataReader into the Report data object. /// </summary> /// <param name="Row">DataRow: a data row object.</param> /// <param name="Columns">List of EvReportColumn: a list of report columns</param> /// <returns>EvReportRow: a report row object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Loop through the Report's columns list /// /// 2. Switch data type to update the Report object's column values. /// /// 3. Return the Report object. /// </remarks> // ------------------------------------------------------------------------------------- private EdReportRow readRow(DataRow Row, List <EdReportColumn> Columns) { // // Initialize the return report row object. // EdReportRow reportRow = new EdReportRow(Columns.Count); // // Loop through the report columns list. // for (int columnCount = 0; columnCount < Columns.Count; columnCount++) { // // Switch column's datatype for updating the column values. // switch (Columns [columnCount].DataType) { case EdReport.DataTypes.Bool: { reportRow.ColumnValues [columnCount] = EvSqlMethods.getBool(Row, Columns [columnCount].SourceField).ToString( ); break; } case EdReport.DataTypes.Date: { DateTime dateVal = EvSqlMethods.getDateTime(Row, Columns [columnCount].SourceField); if (dateVal != Evado.Model.EvStatics.CONST_DATE_NULL) { reportRow.ColumnValues [columnCount] = dateVal.ToString("dd MMM yyyy HH:mm:ss"); } else { reportRow.ColumnValues [columnCount] = ""; } break; } case EdReport.DataTypes.Integer: { reportRow.ColumnValues [columnCount] = EvSqlMethods.getInteger(Row, Columns [columnCount].SourceField).ToString( ); break; } case EdReport.DataTypes.Float: case EdReport.DataTypes.Currency: { reportRow.ColumnValues [columnCount] = EvSqlMethods.getFloat(Row, Columns [columnCount].SourceField).ToString( ); break; } default: { String val = EvSqlMethods.getString(Row, Columns [columnCount].SourceField); if (val == "Null") { val = String.Empty; } reportRow.ColumnValues [columnCount] = val; break; } } //END Type switch } //END column interation loop. // // Return the Report object // return(reportRow); }// End readRow method.
}//END SetParameters class. #endregion #region Data Reader methods // ===================================================================================== /// <summary> /// This class extracts the data row values to the report object. /// </summary> /// <param name="Row">DataRow: a data row object</param> /// <returns>EvReport: a report data object</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Extract the compatible data row values to the Report data object. /// /// 2. Set the xml report string, if it is empty. /// /// 3. Return the Report data object. /// </remarks> // ------------------------------------------------------------------------------------- public EdReport readRow(DataRow Row) { // // Initialise the methods variables and objects. // EdReport report = new EdReport( ); // // Set the xml report string, if it is empty. // string xmlReport = EvSqlMethods.getString(Row, "RS_XmlReport"); if (xmlReport != String.Empty) { xmlReport = xmlReport.Replace("utf-8", "utf-16"); xmlReport = xmlReport.Replace("<SelectionSource></SelectionSource>", "<SelectionSource>None</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource />", "<SelectionSource>None</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>SubjectId</SelectionSource>", "<SelectionSource>Subject_Id</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>SiteId</SelectionSource>", "<SelectionSource>Site_Id</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>TrialId</SelectionSource>", "<SelectionSource>Trial_Id</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>Trial_Id</SelectionSource>", "<SelectionSource>Project_Id</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>ScheduleId</SelectionSource>", "<SelectionSource>Arm_Index</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>AllTrialSites</SelectionSource>", "<SelectionSource>All_Trial_Sites</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>CurrentTrial</SelectionSource>", "<SelectionSource>Current_Trial</SelectionSource>"); xmlReport = xmlReport.Replace("<SelectionSource>Current_Trial</SelectionSource>", "<SelectionSource>Current_Project</SelectionSource>"); xmlReport = xmlReport.Replace("<TrialId>", "<ProjectId>"); xmlReport = xmlReport.Replace("</TrialId>", "</ProjectId>"); xmlReport = xmlReport.Replace("<ReportTypeId>", "<ReportType>"); xmlReport = xmlReport.Replace("</ReportTypeId>", "</ReportType>"); report = Evado.Model.EvStatics.DeserialiseObject <EdReport> (xmlReport);; } // // Extract the compatible data row values to the Report object. // report.Guid = EvSqlMethods.getGuid(Row, "RS_Guid"); report.ReportId = EvSqlMethods.getString(Row, "ReportId"); report.ReportTitle = EvSqlMethods.getString(Row, "RS_ReportTitle"); //Report.ReportSubTitle = EvSqlMethods.getString( Row, "RS_ReportSubTitle" ); report.ReportDate = EvSqlMethods.getDateTime(Row, "RS_ReportDate"); report.ReportType = (EdReport.ReportTypeCode)EvSqlMethods.getInteger(Row, "RS_ReportTypeId"); report.ReportNo = EvSqlMethods.getInteger(Row, "RS_ReportNo"); report.UpdateUserId = EvSqlMethods.getString(Row, "RS_UpdatedByUserId"); report.Updated = EvSqlMethods.getString(Row, "RS_UpdatedBy"); report.Updated += " on " + EvSqlMethods.getDateTime(Row, "RS_UpdateDate").ToString("dd MMM yyyy HH:mm"); report.GeneratedBy = EvSqlMethods.getString(Row, "RS_UpdatedBy"); // // Return the Report object // return(report); }// End readRow method.