' This class is "generated" and will be overwritten. ' Your customizations should be made in PersonalEducationRecord.vb Imports System.Data.SqlTypes Imports BaseClasses Imports BaseClasses.Data Imports BaseClasses.Data.SqlProvider Namespace Persons.Business ''' ''' The generated superclass for the class. ''' ''' ''' This class is not intended to be instantiated directly. To obtain an instance of this class, ''' use the methods of the class. ''' ''' ''' Public Class BasePersonalEducationRecord Inherits PrimaryKeyRecord Public Shared Shadows ReadOnly TableUtils As PersonalEducationTable = PersonalEducationTable.Instance ' Constructors Protected Sub New() MyBase.New(TableUtils) End Sub Protected Sub New(ByVal record As PrimaryKeyRecord) MyBase.New(record, TableUtils) End Sub 'Evaluates Initialize when->Inserting record formulas specified at the data access layer Public Overridable Sub PersonalEducationRecord_InsertingRecord(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles Me.InsertingRecord 'Apply Initialize->Inserting record formula only if validation is successful. Dim PersonalEducationRec As PersonalEducationRecord = CType(sender,PersonalEducationRecord) Validate_Inserting() If Not PersonalEducationRec Is Nothing AndAlso Not PersonalEducationRec.IsReadOnly Then End If End Sub 'Evaluates Initialize when->Updating record formulas specified at the data access layer Public Overridable Sub PersonalEducationRecord_UpdatingRecord(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles Me.UpdatingRecord 'Apply Initialize->Updating record formula only if validation is successful. Dim PersonalEducationRec As PersonalEducationRecord = CType(sender,PersonalEducationRecord) Validate_Updating() If Not PersonalEducationRec Is Nothing AndAlso Not PersonalEducationRec.IsReadOnly Then End If End Sub 'Evaluates Initialize when->Reading record formulas specified at the data access layer Public Overridable Sub PersonalEducationRecord_ReadRecord(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.ReadRecord 'Apply Initialize->Reading record formula only if validation is successful. Dim PersonalEducationRec As PersonalEducationRecord = CType(sender,PersonalEducationRecord) If Not PersonalEducationRec Is Nothing AndAlso Not PersonalEducationRec.IsReadOnly Then End If End Sub 'Evaluates Validate when->Inserting formulas specified at the data access layer Public Overridable Sub Validate_Inserting () Dim fullValidationMessage As String = "" Dim validationMessage As String = "" dim formula as String = "" If validationMessage <> "" AndAlso validationMessage.ToLower() <> "true" Then fullValidationMessage &= validationMessage & vbCrLf End If If fullValidationMessage <> "" Then Throw New Exception(fullValidationMessage) End If End Sub 'Evaluates Validate when->Updating formulas specified at the data access layer Public Overridable Sub Validate_Updating () Dim fullValidationMessage As String = "" Dim validationMessage As String = "" dim formula as String = "" If validationMessage <> "" AndAlso validationMessage.ToLower() <> "true" Then fullValidationMessage &= validationMessage & vbCrLf End If If fullValidationMessage <> "" Then Throw New Exception(fullValidationMessage) End If End Sub Public Overridable Function EvaluateFormula(ByVal formula As String, Optional ByVal dataSourceForEvaluate As BaseClasses.Data.BaseRecord = Nothing, Optional ByVal format As String = Nothing) As String Dim e As Data.BaseFormulaEvaluator = New Data.BaseFormulaEvaluator() ' All variables referred to in the formula are expected to be ' properties of the DataSource. For example, referring to ' UnitPrice as a variable will refer to DataSource.UnitPrice e.DataSource = dataSourceForEvaluate Dim resultObj As Object = e.Evaluate(formula) If resultObj Is Nothing Then Return "" End If Return resultObj.ToString() End Function #Region "Convenience methods to get/set values of fields" ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EducationId field. ''' Public Function GetEducationIdValue() As ColumnValue Return Me.GetValue(TableUtils.EducationIdColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EducationId field. ''' Public Function GetEducationIdFieldValue() As Int32 Return CType(Me.GetValue(TableUtils.EducationIdColumn).ToInt32(), Int32) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.PersonalId field. ''' Public Function GetPersonalIdValue() As ColumnValue Return Me.GetValue(TableUtils.PersonalIdColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.PersonalId field. ''' Public Function GetPersonalIdFieldValue() As String Return CType(Me.GetValue(TableUtils.PersonalIdColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.PersonalId field. ''' Public Sub SetPersonalIdFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.PersonalIdColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.PersonalId field. ''' Public Sub SetPersonalIdFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.PersonalIdColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.StartDate field. ''' Public Function GetStartDateValue() As ColumnValue Return Me.GetValue(TableUtils.StartDateColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.StartDate field. ''' Public Function GetStartDateFieldValue() As DateTime Return CType(Me.GetValue(TableUtils.StartDateColumn).ToDateTime(), DateTime) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.StartDate field. ''' Public Sub SetStartDateFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.StartDateColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.StartDate field. ''' Public Sub SetStartDateFieldValue(ByVal val As String) Me.SetString(val, TableUtils.StartDateColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.StartDate field. ''' Public Sub SetStartDateFieldValue(ByVal val As DateTime) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.StartDateColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EndDate field. ''' Public Function GetEndDateValue() As ColumnValue Return Me.GetValue(TableUtils.EndDateColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EndDate field. ''' Public Function GetEndDateFieldValue() As DateTime Return CType(Me.GetValue(TableUtils.EndDateColumn).ToDateTime(), DateTime) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EndDate field. ''' Public Sub SetEndDateFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.EndDateColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EndDate field. ''' Public Sub SetEndDateFieldValue(ByVal val As String) Me.SetString(val, TableUtils.EndDateColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EndDate field. ''' Public Sub SetEndDateFieldValue(ByVal val As DateTime) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EndDateColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Course field. ''' Public Function GetCourseValue() As ColumnValue Return Me.GetValue(TableUtils.CourseColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Course field. ''' Public Function GetCourseFieldValue() As String Return CType(Me.GetValue(TableUtils.CourseColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Course field. ''' Public Sub SetCourseFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.CourseColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Course field. ''' Public Sub SetCourseFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.CourseColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.CourseAbbr field. ''' Public Function GetCourseAbbrValue() As ColumnValue Return Me.GetValue(TableUtils.CourseAbbrColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.CourseAbbr field. ''' Public Function GetCourseAbbrFieldValue() As String Return CType(Me.GetValue(TableUtils.CourseAbbrColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CourseAbbr field. ''' Public Sub SetCourseAbbrFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.CourseAbbrColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CourseAbbr field. ''' Public Sub SetCourseAbbrFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.CourseAbbrColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Institue field. ''' Public Function GetInstitueValue() As ColumnValue Return Me.GetValue(TableUtils.InstitueColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Institue field. ''' Public Function GetInstitueFieldValue() As String Return CType(Me.GetValue(TableUtils.InstitueColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Institue field. ''' Public Sub SetInstitueFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.InstitueColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Institue field. ''' Public Sub SetInstitueFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.InstitueColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Facultry field. ''' Public Function GetFacultryValue() As ColumnValue Return Me.GetValue(TableUtils.FacultryColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Facultry field. ''' Public Function GetFacultryFieldValue() As String Return CType(Me.GetValue(TableUtils.FacultryColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Facultry field. ''' Public Sub SetFacultryFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.FacultryColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Facultry field. ''' Public Sub SetFacultryFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.FacultryColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.LevelId field. ''' Public Function GetLevelIdValue() As ColumnValue Return Me.GetValue(TableUtils.LevelIdColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.LevelId field. ''' Public Function GetLevelIdFieldValue() As Int16 Return CType(Me.GetValue(TableUtils.LevelIdColumn).ToInt16(), Int16) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.LevelId field. ''' Public Sub SetLevelIdFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.LevelIdColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.LevelId field. ''' Public Sub SetLevelIdFieldValue(ByVal val As String) Me.SetString(val, TableUtils.LevelIdColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.LevelId field. ''' Public Sub SetLevelIdFieldValue(ByVal val As Double) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.LevelIdColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.LevelId field. ''' Public Sub SetLevelIdFieldValue(ByVal val As Decimal) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.LevelIdColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.LevelId field. ''' Public Sub SetLevelIdFieldValue(ByVal val As Int64) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.LevelIdColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EdYear field. ''' Public Function GetEdYearValue() As ColumnValue Return Me.GetValue(TableUtils.EdYearColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EdYear field. ''' Public Function GetEdYearFieldValue() As String Return CType(Me.GetValue(TableUtils.EdYearColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EdYear field. ''' Public Sub SetEdYearFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.EdYearColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EdYear field. ''' Public Sub SetEdYearFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EdYearColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Function GetEducationPeriodValue() As ColumnValue Return Me.GetValue(TableUtils.EducationPeriodColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Function GetEducationPeriodFieldValue() As Byte Return CType(Me.GetValue(TableUtils.EducationPeriodColumn).ToByte(), Byte) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Sub SetEducationPeriodFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.EducationPeriodColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Sub SetEducationPeriodFieldValue(ByVal val As String) Me.SetString(val, TableUtils.EducationPeriodColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Sub SetEducationPeriodFieldValue(ByVal val As Double) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationPeriodColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Sub SetEducationPeriodFieldValue(ByVal val As Decimal) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationPeriodColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Sub SetEducationPeriodFieldValue(ByVal val As Int64) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationPeriodColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EducationType field. ''' Public Function GetEducationTypeValue() As ColumnValue Return Me.GetValue(TableUtils.EducationTypeColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.EducationType field. ''' Public Function GetEducationTypeFieldValue() As Byte Return CType(Me.GetValue(TableUtils.EducationTypeColumn).ToByte(), Byte) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationType field. ''' Public Sub SetEducationTypeFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.EducationTypeColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationType field. ''' Public Sub SetEducationTypeFieldValue(ByVal val As String) Me.SetString(val, TableUtils.EducationTypeColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationType field. ''' Public Sub SetEducationTypeFieldValue(ByVal val As Double) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationTypeColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationType field. ''' Public Sub SetEducationTypeFieldValue(ByVal val As Decimal) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationTypeColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.EducationType field. ''' Public Sub SetEducationTypeFieldValue(ByVal val As Int64) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationTypeColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.COUNTRY field. ''' Public Function GetCOUNTRYValue() As ColumnValue Return Me.GetValue(TableUtils.COUNTRYColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.COUNTRY field. ''' Public Function GetCOUNTRYFieldValue() As Int16 Return CType(Me.GetValue(TableUtils.COUNTRYColumn).ToInt16(), Int16) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.COUNTRY field. ''' Public Sub SetCOUNTRYFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.COUNTRYColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.COUNTRY field. ''' Public Sub SetCOUNTRYFieldValue(ByVal val As String) Me.SetString(val, TableUtils.COUNTRYColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.COUNTRY field. ''' Public Sub SetCOUNTRYFieldValue(ByVal val As Double) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.COUNTRYColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.COUNTRY field. ''' Public Sub SetCOUNTRYFieldValue(ByVal val As Decimal) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.COUNTRYColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.COUNTRY field. ''' Public Sub SetCOUNTRYFieldValue(ByVal val As Int64) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.COUNTRYColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.CourseNo field. ''' Public Function GetCourseNoValue() As ColumnValue Return Me.GetValue(TableUtils.CourseNoColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.CourseNo field. ''' Public Function GetCourseNoFieldValue() As String Return CType(Me.GetValue(TableUtils.CourseNoColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CourseNo field. ''' Public Sub SetCourseNoFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.CourseNoColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CourseNo field. ''' Public Sub SetCourseNoFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.CourseNoColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.ScoreNo field. ''' Public Function GetScoreNoValue() As ColumnValue Return Me.GetValue(TableUtils.ScoreNoColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.ScoreNo field. ''' Public Function GetScoreNoFieldValue() As String Return CType(Me.GetValue(TableUtils.ScoreNoColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.ScoreNo field. ''' Public Sub SetScoreNoFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.ScoreNoColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.ScoreNo field. ''' Public Sub SetScoreNoFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.ScoreNoColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.NoAll field. ''' Public Function GetNoAllValue() As ColumnValue Return Me.GetValue(TableUtils.NoAllColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.NoAll field. ''' Public Function GetNoAllFieldValue() As String Return CType(Me.GetValue(TableUtils.NoAllColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.NoAll field. ''' Public Sub SetNoAllFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.NoAllColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.NoAll field. ''' Public Sub SetNoAllFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.NoAllColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Score field. ''' Public Function GetScoreValue() As ColumnValue Return Me.GetValue(TableUtils.ScoreColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Score field. ''' Public Function GetScoreFieldValue() As String Return CType(Me.GetValue(TableUtils.ScoreColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Score field. ''' Public Sub SetScoreFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.ScoreColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Score field. ''' Public Sub SetScoreFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.ScoreColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Command field. ''' Public Function GetCommandValue() As ColumnValue Return Me.GetValue(TableUtils.CommandColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.Command field. ''' Public Function GetCommandFieldValue() As String Return CType(Me.GetValue(TableUtils.CommandColumn).ToString(), String) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Command field. ''' Public Sub SetCommandFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.CommandColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.Command field. ''' Public Sub SetCommandFieldValue(ByVal val As String) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.CommandColumn) End Sub ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.CommandDate field. ''' Public Function GetCommandDateValue() As ColumnValue Return Me.GetValue(TableUtils.CommandDateColumn) End Function ''' ''' This is a convenience method that provides direct access to the value of the record's PersonalEducation_.CommandDate field. ''' Public Function GetCommandDateFieldValue() As DateTime Return CType(Me.GetValue(TableUtils.CommandDateColumn).ToDateTime(), DateTime) End Function ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CommandDate field. ''' Public Sub SetCommandDateFieldValue(ByVal val As ColumnValue) Me.SetValue(val, TableUtils.CommandDateColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CommandDate field. ''' Public Sub SetCommandDateFieldValue(ByVal val As String) Me.SetString(val, TableUtils.CommandDateColumn) End Sub ''' ''' This is a convenience method that allows direct modification of the value of the record's PersonalEducation_.CommandDate field. ''' Public Sub SetCommandDateFieldValue(ByVal val As DateTime) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.CommandDateColumn) End Sub #End Region #Region "Convenience methods to get field names" ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.EducationId field. ''' Public Property EducationId() As Int32 Get Return CType(Me.GetValue(TableUtils.EducationIdColumn).ToInt32(), Int32) End Get Set (ByVal val As Int32) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationIdColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property EducationIdSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.EducationIdColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property EducationIdDefault() As String Get Return TableUtils.EducationIdColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.PersonalId field. ''' Public Property PersonalId() As String Get Return CType(Me.GetValue(TableUtils.PersonalIdColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.PersonalIdColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property PersonalIdSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.PersonalIdColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property PersonalIdDefault() As String Get Return TableUtils.PersonalIdColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.StartDate field. ''' Public Property StartDate() As DateTime Get Return CType(Me.GetValue(TableUtils.StartDateColumn).ToDateTime(), DateTime) End Get Set (ByVal val As DateTime) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.StartDateColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property StartDateSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.StartDateColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property StartDateDefault() As String Get Return TableUtils.StartDateColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.EndDate field. ''' Public Property EndDate() As DateTime Get Return CType(Me.GetValue(TableUtils.EndDateColumn).ToDateTime(), DateTime) End Get Set (ByVal val As DateTime) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EndDateColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property EndDateSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.EndDateColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property EndDateDefault() As String Get Return TableUtils.EndDateColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.Course field. ''' Public Property Course() As String Get Return CType(Me.GetValue(TableUtils.CourseColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.CourseColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property CourseSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.CourseColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property CourseDefault() As String Get Return TableUtils.CourseColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.CourseAbbr field. ''' Public Property CourseAbbr() As String Get Return CType(Me.GetValue(TableUtils.CourseAbbrColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.CourseAbbrColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property CourseAbbrSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.CourseAbbrColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property CourseAbbrDefault() As String Get Return TableUtils.CourseAbbrColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.Institue field. ''' Public Property Institue() As String Get Return CType(Me.GetValue(TableUtils.InstitueColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.InstitueColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property InstitueSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.InstitueColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property InstitueDefault() As String Get Return TableUtils.InstitueColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.Facultry field. ''' Public Property Facultry() As String Get Return CType(Me.GetValue(TableUtils.FacultryColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.FacultryColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property FacultrySpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.FacultryColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property FacultryDefault() As String Get Return TableUtils.FacultryColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.LevelId field. ''' Public Property LevelId() As Int16 Get Return CType(Me.GetValue(TableUtils.LevelIdColumn).ToInt16(), Int16) End Get Set (ByVal val As Int16) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.LevelIdColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property LevelIdSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.LevelIdColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property LevelIdDefault() As String Get Return TableUtils.LevelIdColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.EdYear field. ''' Public Property EdYear() As String Get Return CType(Me.GetValue(TableUtils.EdYearColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.EdYearColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property EdYearSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.EdYearColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property EdYearDefault() As String Get Return TableUtils.EdYearColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.EducationPeriod field. ''' Public Property EducationPeriod() As Byte Get Return CType(Me.GetValue(TableUtils.EducationPeriodColumn).ToByte(), Byte) End Get Set (ByVal val As Byte) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationPeriodColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property EducationPeriodSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.EducationPeriodColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property EducationPeriodDefault() As String Get Return TableUtils.EducationPeriodColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.EducationType field. ''' Public Property EducationType() As Byte Get Return CType(Me.GetValue(TableUtils.EducationTypeColumn).ToByte(), Byte) End Get Set (ByVal val As Byte) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.EducationTypeColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property EducationTypeSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.EducationTypeColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property EducationTypeDefault() As String Get Return TableUtils.EducationTypeColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.COUNTRY field. ''' Public Property COUNTRY() As Int16 Get Return CType(Me.GetValue(TableUtils.COUNTRYColumn).ToInt16(), Int16) End Get Set (ByVal val As Int16) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.COUNTRYColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property COUNTRYSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.COUNTRYColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property COUNTRYDefault() As String Get Return TableUtils.COUNTRYColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.CourseNo field. ''' Public Property CourseNo() As String Get Return CType(Me.GetValue(TableUtils.CourseNoColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.CourseNoColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property CourseNoSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.CourseNoColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property CourseNoDefault() As String Get Return TableUtils.CourseNoColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.ScoreNo field. ''' Public Property ScoreNo() As String Get Return CType(Me.GetValue(TableUtils.ScoreNoColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.ScoreNoColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property ScoreNoSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.ScoreNoColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property ScoreNoDefault() As String Get Return TableUtils.ScoreNoColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.NoAll field. ''' Public Property NoAll() As String Get Return CType(Me.GetValue(TableUtils.NoAllColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.NoAllColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property NoAllSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.NoAllColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property NoAllDefault() As String Get Return TableUtils.NoAllColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.Score field. ''' Public Property Score() As String Get Return CType(Me.GetValue(TableUtils.ScoreColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.ScoreColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property ScoreSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.ScoreColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property ScoreDefault() As String Get Return TableUtils.ScoreColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.Command field. ''' Public Property Command() As String Get Return CType(Me.GetValue(TableUtils.CommandColumn).ToString(), String) End Get Set (ByVal Value As String) Me.SetString(value, TableUtils.CommandColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property CommandSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.CommandColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property CommandDefault() As String Get Return TableUtils.CommandColumn.DefaultValue End Get End Property ''' ''' This is a convenience property that provides direct access to the value of the record's PersonalEducation_.CommandDate field. ''' Public Property CommandDate() As DateTime Get Return CType(Me.GetValue(TableUtils.CommandDateColumn).ToDateTime(), DateTime) End Get Set (ByVal val As DateTime) Dim colValue As ColumnValue = New ColumnValue(val) Me.SetValue(colValue, TableUtils.CommandDateColumn) End Set End Property ''' ''' This is a convenience method that can be used to determine that the column is set. ''' Public ReadOnly Property CommandDateSpecified() As Boolean Get Dim val As ColumnValue = Me.GetValue(TableUtils.CommandDateColumn) If val Is Nothing OrElse val.IsNull Then Return False End If Return True End Get End Property ''' ''' This is a convenience method that can be used to get the default value of a column. ''' Public ReadOnly Property CommandDateDefault() As String Get Return TableUtils.CommandDateColumn.DefaultValue End Get End Property #End Region End Class End Namespace