// <fileinfo name="InvoicesRow_Base.cs">
//      <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>

using System;

namespace MyCompany.MyProject.Db
{
    /// <summary>
    /// The base class for <see cref="InvoicesRow"/> that 
    /// represents a record in the <c>Invoices</c> view.
    /// </summary>
    /// <remarks>
    /// Do not change this source code manually. Update the <see cref="InvoicesRow"/>
    /// class if you need to add or change some functionality.
    /// </remarks>
    public abstract class InvoicesRow_Base
    {
        private string _shipName;
        private string _shipAddress;
        private string _shipCity;
        private string _shipRegion;
        private string _shipPostalCode;
        private string _shipCountry;
        private string _customerID;
        private string _customerName;
        private string _address;
        private string _city;
        private string _region;
        private string _postalCode;
        private string _country;
        private string _salesperson;
        private int _orderID;
        private System.DateTime _orderDate;
        private bool _orderDateNull = true;
        private System.DateTime _requiredDate;
        private bool _requiredDateNull = true;
        private System.DateTime _shippedDate;
        private bool _shippedDateNull = true;
        private string _shipperName;
        private int _productID;
        private string _productName;
        private decimal _unitPrice;
        private short _quantity;
        private float _discount;
        private decimal _extendedPrice;
        private bool _extendedPriceNull = true;
        private decimal _freight;
        private bool _freightNull = true;

        /// <summary>
        /// Initializes a new instance of the <see cref="InvoicesRow_Base"/> class.
        /// </summary>
        public InvoicesRow_Base()
        {
            // EMPTY
        }

        /// <summary>
        /// Gets or sets the <c>ShipName</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShipName</c> column value.</value>
        public string ShipName
        {
            get { return _shipName; }
            set { _shipName = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShipAddress</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShipAddress</c> column value.</value>
        public string ShipAddress
        {
            get { return _shipAddress; }
            set { _shipAddress = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShipCity</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShipCity</c> column value.</value>
        public string ShipCity
        {
            get { return _shipCity; }
            set { _shipCity = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShipRegion</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShipRegion</c> column value.</value>
        public string ShipRegion
        {
            get { return _shipRegion; }
            set { _shipRegion = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShipPostalCode</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShipPostalCode</c> column value.</value>
        public string ShipPostalCode
        {
            get { return _shipPostalCode; }
            set { _shipPostalCode = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShipCountry</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShipCountry</c> column value.</value>
        public string ShipCountry
        {
            get { return _shipCountry; }
            set { _shipCountry = value; }
        }

        /// <summary>
        /// Gets or sets the <c>CustomerID</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>CustomerID</c> column value.</value>
        public string CustomerID
        {
            get { return _customerID; }
            set { _customerID = value; }
        }

        /// <summary>
        /// Gets or sets the <c>CustomerName</c> column value.
        /// </summary>
        /// <value>The <c>CustomerName</c> column value.</value>
        public string CustomerName
        {
            get { return _customerName; }
            set { _customerName = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Address</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>Address</c> column value.</value>
        public string Address
        {
            get { return _address; }
            set { _address = value; }
        }

        /// <summary>
        /// Gets or sets the <c>City</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>City</c> column value.</value>
        public string City
        {
            get { return _city; }
            set { _city = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Region</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>Region</c> column value.</value>
        public string Region
        {
            get { return _region; }
            set { _region = value; }
        }

        /// <summary>
        /// Gets or sets the <c>PostalCode</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>PostalCode</c> column value.</value>
        public string PostalCode
        {
            get { return _postalCode; }
            set { _postalCode = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Country</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>Country</c> column value.</value>
        public string Country
        {
            get { return _country; }
            set { _country = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Salesperson</c> column value.
        /// </summary>
        /// <value>The <c>Salesperson</c> column value.</value>
        public string Salesperson
        {
            get { return _salesperson; }
            set { _salesperson = value; }
        }

        /// <summary>
        /// Gets or sets the <c>OrderID</c> column value.
        /// </summary>
        /// <value>The <c>OrderID</c> column value.</value>
        public int OrderID
        {
            get { return _orderID; }
            set { _orderID = value; }
        }

        /// <summary>
        /// Gets or sets the <c>OrderDate</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>OrderDate</c> column value.</value>
        public System.DateTime OrderDate
        {
            get
            {
                if(IsOrderDateNull)
                    throw new InvalidOperationException("Cannot get value because it is DBNull.");
                return _orderDate;
            }
            set
            {
                _orderDateNull = false;
                _orderDate = value;
            }
        }

        /// <summary>
        /// Indicates whether the <see cref="OrderDate"/>
        /// property value is null.
        /// </summary>
        /// <value>true if the property value is null, otherwise false.</value>
        public bool IsOrderDateNull
        {
            get { return _orderDateNull; }
            set { _orderDateNull = value; }
        }

        /// <summary>
        /// Gets or sets the <c>RequiredDate</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>RequiredDate</c> column value.</value>
        public System.DateTime RequiredDate
        {
            get
            {
                if(IsRequiredDateNull)
                    throw new InvalidOperationException("Cannot get value because it is DBNull.");
                return _requiredDate;
            }
            set
            {
                _requiredDateNull = false;
                _requiredDate = value;
            }
        }

        /// <summary>
        /// Indicates whether the <see cref="RequiredDate"/>
        /// property value is null.
        /// </summary>
        /// <value>true if the property value is null, otherwise false.</value>
        public bool IsRequiredDateNull
        {
            get { return _requiredDateNull; }
            set { _requiredDateNull = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShippedDate</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ShippedDate</c> column value.</value>
        public System.DateTime ShippedDate
        {
            get
            {
                if(IsShippedDateNull)
                    throw new InvalidOperationException("Cannot get value because it is DBNull.");
                return _shippedDate;
            }
            set
            {
                _shippedDateNull = false;
                _shippedDate = value;
            }
        }

        /// <summary>
        /// Indicates whether the <see cref="ShippedDate"/>
        /// property value is null.
        /// </summary>
        /// <value>true if the property value is null, otherwise false.</value>
        public bool IsShippedDateNull
        {
            get { return _shippedDateNull; }
            set { _shippedDateNull = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ShipperName</c> column value.
        /// </summary>
        /// <value>The <c>ShipperName</c> column value.</value>
        public string ShipperName
        {
            get { return _shipperName; }
            set { _shipperName = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ProductID</c> column value.
        /// </summary>
        /// <value>The <c>ProductID</c> column value.</value>
        public int ProductID
        {
            get { return _productID; }
            set { _productID = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ProductName</c> column value.
        /// </summary>
        /// <value>The <c>ProductName</c> column value.</value>
        public string ProductName
        {
            get { return _productName; }
            set { _productName = value; }
        }

        /// <summary>
        /// Gets or sets the <c>UnitPrice</c> column value.
        /// </summary>
        /// <value>The <c>UnitPrice</c> column value.</value>
        public decimal UnitPrice
        {
            get { return _unitPrice; }
            set { _unitPrice = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Quantity</c> column value.
        /// </summary>
        /// <value>The <c>Quantity</c> column value.</value>
        public short Quantity
        {
            get { return _quantity; }
            set { _quantity = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Discount</c> column value.
        /// </summary>
        /// <value>The <c>Discount</c> column value.</value>
        public float Discount
        {
            get { return _discount; }
            set { _discount = value; }
        }

        /// <summary>
        /// Gets or sets the <c>ExtendedPrice</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ExtendedPrice</c> column value.</value>
        public decimal ExtendedPrice
        {
            get
            {
                if(IsExtendedPriceNull)
                    throw new InvalidOperationException("Cannot get value because it is DBNull.");
                return _extendedPrice;
            }
            set
            {
                _extendedPriceNull = false;
                _extendedPrice = value;
            }
        }

        /// <summary>
        /// Indicates whether the <see cref="ExtendedPrice"/>
        /// property value is null.
        /// </summary>
        /// <value>true if the property value is null, otherwise false.</value>
        public bool IsExtendedPriceNull
        {
            get { return _extendedPriceNull; }
            set { _extendedPriceNull = value; }
        }

        /// <summary>
        /// Gets or sets the <c>Freight</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>Freight</c> column value.</value>
        public decimal Freight
        {
            get
            {
                if(IsFreightNull)
                    throw new InvalidOperationException("Cannot get value because it is DBNull.");
                return _freight;
            }
            set
            {
                _freightNull = false;
                _freight = value;
            }
        }

        /// <summary>
        /// Indicates whether the <see cref="Freight"/>
        /// property value is null.
        /// </summary>
        /// <value>true if the property value is null, otherwise false.</value>
        public bool IsFreightNull
        {
            get { return _freightNull; }
            set { _freightNull = value; }
        }

        /// <summary>
        /// Returns the string representation of this instance.
        /// </summary>
        /// <returns>The string representation of this instance.</returns>
        public override string ToString()
        {
            System.Text.StringBuilder dynStr = new System.Text.StringBuilder(GetType().Name);
            dynStr.Append(':');
            dynStr.Append("  ShipName=");
            dynStr.Append(ShipName);
            dynStr.Append("  ShipAddress=");
            dynStr.Append(ShipAddress);
            dynStr.Append("  ShipCity=");
            dynStr.Append(ShipCity);
            dynStr.Append("  ShipRegion=");
            dynStr.Append(ShipRegion);
            dynStr.Append("  ShipPostalCode=");
            dynStr.Append(ShipPostalCode);
            dynStr.Append("  ShipCountry=");
            dynStr.Append(ShipCountry);
            dynStr.Append("  CustomerID=");
            dynStr.Append(CustomerID);
            dynStr.Append("  CustomerName=");
            dynStr.Append(CustomerName);
            dynStr.Append("  Address=");
            dynStr.Append(Address);
            dynStr.Append("  City=");
            dynStr.Append(City);
            dynStr.Append("  Region=");
            dynStr.Append(Region);
            dynStr.Append("  PostalCode=");
            dynStr.Append(PostalCode);
            dynStr.Append("  Country=");
            dynStr.Append(Country);
            dynStr.Append("  Salesperson=");
            dynStr.Append(Salesperson);
            dynStr.Append("  OrderID=");
            dynStr.Append(OrderID);
            dynStr.Append("  OrderDate=");
            dynStr.Append(IsOrderDateNull ? (object)"<NULL>" : OrderDate);
            dynStr.Append("  RequiredDate=");
            dynStr.Append(IsRequiredDateNull ? (object)"<NULL>" : RequiredDate);
            dynStr.Append("  ShippedDate=");
            dynStr.Append(IsShippedDateNull ? (object)"<NULL>" : ShippedDate);
            dynStr.Append("  ShipperName=");
            dynStr.Append(ShipperName);
            dynStr.Append("  ProductID=");
            dynStr.Append(ProductID);
            dynStr.Append("  ProductName=");
            dynStr.Append(ProductName);
            dynStr.Append("  UnitPrice=");
            dynStr.Append(UnitPrice);
            dynStr.Append("  Quantity=");
            dynStr.Append(Quantity);
            dynStr.Append("  Discount=");
            dynStr.Append(Discount);
            dynStr.Append("  ExtendedPrice=");
            dynStr.Append(IsExtendedPriceNull ? (object)"<NULL>" : ExtendedPrice);
            dynStr.Append("  Freight=");
            dynStr.Append(IsFreightNull ? (object)"<NULL>" : Freight);
            return dynStr.ToString();
        }
    } // End of InvoicesRow_Base class
} // End of namespace