' <fileinfo name="OrdersRow_Base.vb">
'       <copyright>
'           All rights reserved.
'       </copyright>
'       <remarks>
'           Do not change this source code manually. Changes to this file may 
'           cause incorrect behavior and will be lost if the code is regenerated.
'       </remarks>
'       <generator rewritefile="True" infourl="http://www.SharpPower.com">RapTier</generator>
' </fileinfo>

Option Strict Off
Option Explicit On

Imports System

''' <summary>
''' The base class for <see cref="OrdersRow"/> that 
''' represents a record in the <c>Orders</c> table.
''' </summary>
''' <remarks>
''' Do not change this source code manually. Update the <see cref="OrdersRow"/>
''' class if you need to add or change some functionality.
''' </remarks>
Public MustInherit Class OrdersRow_Base
    Private _orderID As Integer
    Private _customerID As String
    Private _employeeID As Integer
    Private _employeeIDNull As Boolean = True
    Private _orderDate As Date
    Private _orderDateNull As Boolean = True
    Private _requiredDate As Date
    Private _requiredDateNull As Boolean = True
    Private _shippedDate As Date
    Private _shippedDateNull As Boolean = True
    Private _shipVia As Integer
    Private _shipViaNull As Boolean = True
    Private _freight As Decimal
    Private _freightNull As Boolean = True
    Private _shipName As String
    Private _shipAddress As String
    Private _shipCity As String
    Private _shipRegion As String
    Private _shipPostalCode As String
    Private _shipCountry As String

    ''' <summary>
    ''' Initializes a new instance of the <see cref="OrdersRow_Base"/> class.
    ''' </summary>
    Public Sub New()
        MyBase.New()
        ' EMPTY
    End Sub

        ''' <summary>
        ''' Gets or sets the <c>OrderID</c> column value.
        ''' </summary>
        ''' <value>The <c>OrderID</c> column value.</value>
    Public Property OrderID As Integer
        Get
            Return _orderID
        End Get
        Set
            _orderID = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>CustomerID</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>CustomerID</c> column value.</value>
    Public Property CustomerID As String
        Get
            Return _customerID
        End Get
        Set
            _customerID = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>EmployeeID</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>EmployeeID</c> column value.</value>
    Public Property EmployeeID As Integer
        Get
            If IsEmployeeIDNull Then
                Throw New InvalidOperationException("Cannot get value because it is DBNull.")
            End If
            Return _employeeID
        End Get
        Set
            _employeeIDNull = false
            _employeeID = value
        End Set
    End Property

    ''' <summary>
    ''' Indicates whether the <see cref="EmployeeID"/>
    ''' property value is null.
    ''' </summary>
    ''' <value>true if the property value is null, otherwise false.</value>
    Public Property IsEmployeeIDNull As Boolean
        Get
            Return _employeeIDNull
        End Get
        Set
            _employeeIDNull = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>OrderDate</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>OrderDate</c> column value.</value>
    Public Property OrderDate As Date
        Get
            If IsOrderDateNull Then
                Throw New InvalidOperationException("Cannot get value because it is DBNull.")
            End If
            Return _orderDate
        End Get
        Set
            _orderDateNull = false
            _orderDate = value
        End Set
    End Property

    ''' <summary>
    ''' Indicates whether the <see cref="OrderDate"/>
    ''' property value is null.
    ''' </summary>
    ''' <value>true if the property value is null, otherwise false.</value>
    Public Property IsOrderDateNull As Boolean
        Get
            Return _orderDateNull
        End Get
        Set
            _orderDateNull = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>RequiredDate</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>RequiredDate</c> column value.</value>
    Public Property RequiredDate As Date
        Get
            If IsRequiredDateNull Then
                Throw New InvalidOperationException("Cannot get value because it is DBNull.")
            End If
            Return _requiredDate
        End Get
        Set
            _requiredDateNull = false
            _requiredDate = value
        End Set
    End Property

    ''' <summary>
    ''' Indicates whether the <see cref="RequiredDate"/>
    ''' property value is null.
    ''' </summary>
    ''' <value>true if the property value is null, otherwise false.</value>
    Public Property IsRequiredDateNull As Boolean
        Get
            Return _requiredDateNull
        End Get
        Set
            _requiredDateNull = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShippedDate</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShippedDate</c> column value.</value>
    Public Property ShippedDate As Date
        Get
            If IsShippedDateNull Then
                Throw New InvalidOperationException("Cannot get value because it is DBNull.")
            End If
            Return _shippedDate
        End Get
        Set
            _shippedDateNull = false
            _shippedDate = value
        End Set
    End Property

    ''' <summary>
    ''' Indicates whether the <see cref="ShippedDate"/>
    ''' property value is null.
    ''' </summary>
    ''' <value>true if the property value is null, otherwise false.</value>
    Public Property IsShippedDateNull As Boolean
        Get
            Return _shippedDateNull
        End Get
        Set
            _shippedDateNull = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipVia</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipVia</c> column value.</value>
    Public Property ShipVia As Integer
        Get
            If IsShipViaNull Then
                Throw New InvalidOperationException("Cannot get value because it is DBNull.")
            End If
            Return _shipVia
        End Get
        Set
            _shipViaNull = false
            _shipVia = value
        End Set
    End Property

    ''' <summary>
    ''' Indicates whether the <see cref="ShipVia"/>
    ''' property value is null.
    ''' </summary>
    ''' <value>true if the property value is null, otherwise false.</value>
    Public Property IsShipViaNull As Boolean
        Get
            Return _shipViaNull
        End Get
        Set
            _shipViaNull = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>Freight</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>Freight</c> column value.</value>
    Public Property Freight As Decimal
        Get
            If IsFreightNull Then
                Throw New InvalidOperationException("Cannot get value because it is DBNull.")
            End If
            Return _freight
        End Get
        Set
            _freightNull = false
            _freight = value
        End Set
    End Property

    ''' <summary>
    ''' Indicates whether the <see cref="Freight"/>
    ''' property value is null.
    ''' </summary>
    ''' <value>true if the property value is null, otherwise false.</value>
    Public Property IsFreightNull As Boolean
        Get
            Return _freightNull
        End Get
        Set
            _freightNull = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipName</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipName</c> column value.</value>
    Public Property ShipName As String
        Get
            Return _shipName
        End Get
        Set
            _shipName = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipAddress</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipAddress</c> column value.</value>
    Public Property ShipAddress As String
        Get
            Return _shipAddress
        End Get
        Set
            _shipAddress = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipCity</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipCity</c> column value.</value>
    Public Property ShipCity As String
        Get
            Return _shipCity
        End Get
        Set
            _shipCity = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipRegion</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipRegion</c> column value.</value>
    Public Property ShipRegion As String
        Get
            Return _shipRegion
        End Get
        Set
            _shipRegion = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipPostalCode</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipPostalCode</c> column value.</value>
    Public Property ShipPostalCode As String
        Get
            Return _shipPostalCode
        End Get
        Set
            _shipPostalCode = value
        End Set
    End Property

        ''' <summary>
        ''' Gets or sets the <c>ShipCountry</c> column value.
        ''' This column is nullable.
        ''' </summary>
        ''' <value>The <c>ShipCountry</c> column value.</value>
    Public Property ShipCountry As String
        Get
            Return _shipCountry
        End Get
        Set
            _shipCountry = value
        End Set
    End Property

    ''' <summary>
    ''' Returns the string representation of this instance.
    ''' </summary>
    ''' <returns>The string representation of this instance.</returns>
    Public Overrides Function ToString() As String
        Dim dynStr As System.Text.StringBuilder = New System.Text.StringBuilder(Me.GetType().Name)
        dynStr.Append(":")
        dynStr.Append("  OrderID=")
        dynStr.Append(Me.OrderID)
        dynStr.Append("  CustomerID=")
        dynStr.Append(Me.CustomerID)
        dynStr.Append("  EmployeeID=")
        If IsEmployeeIDNull Then
            dynStr.Append("<NULL>")
        Else
            dynStr.Append(Me.EmployeeID)
        End If
        dynStr.Append("  OrderDate=")
        If IsOrderDateNull Then
            dynStr.Append("<NULL>")
        Else
            dynStr.Append(Me.OrderDate)
        End If
        dynStr.Append("  RequiredDate=")
        If IsRequiredDateNull Then
            dynStr.Append("<NULL>")
        Else
            dynStr.Append(Me.RequiredDate)
        End If
        dynStr.Append("  ShippedDate=")
        If IsShippedDateNull Then
            dynStr.Append("<NULL>")
        Else
            dynStr.Append(Me.ShippedDate)
        End If
        dynStr.Append("  ShipVia=")
        If IsShipViaNull Then
            dynStr.Append("<NULL>")
        Else
            dynStr.Append(Me.ShipVia)
        End If
        dynStr.Append("  Freight=")
        If IsFreightNull Then
            dynStr.Append("<NULL>")
        Else
            dynStr.Append(Me.Freight)
        End If
        dynStr.Append("  ShipName=")
        dynStr.Append(Me.ShipName)
        dynStr.Append("  ShipAddress=")
        dynStr.Append(Me.ShipAddress)
        dynStr.Append("  ShipCity=")
        dynStr.Append(Me.ShipCity)
        dynStr.Append("  ShipRegion=")
        dynStr.Append(Me.ShipRegion)
        dynStr.Append("  ShipPostalCode=")
        dynStr.Append(Me.ShipPostalCode)
        dynStr.Append("  ShipCountry=")
        dynStr.Append(Me.ShipCountry)
        Return dynStr.ToString()
    End Function
End Class