// <fileinfo name="SalesbyCategoryRow_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="SalesbyCategoryRow"/> that 
    /// represents a record in the <c>Sales by Category</c> view.
    /// </summary>
    /// <remarks>
    /// Do not change this source code manually. Update the <see cref="SalesbyCategoryRow"/>
    /// class if you need to add or change some functionality.
    /// </remarks>
    public abstract class SalesbyCategoryRow_Base
    {
        private int _categoryID;
        private string _categoryName;
        private string _productName;
        private decimal _productSales;
        private bool _productSalesNull = true;

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

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

        /// <summary>
        /// Gets or sets the <c>CategoryName</c> column value.
        /// </summary>
        /// <value>The <c>CategoryName</c> column value.</value>
        public string CategoryName
        {
            get { return _categoryName; }
            set { _categoryName = 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>ProductSales</c> column value.
        /// This column is nullable.
        /// </summary>
        /// <value>The <c>ProductSales</c> column value.</value>
        public decimal ProductSales
        {
            get
            {
                if(IsProductSalesNull)
                    throw new InvalidOperationException("Cannot get value because it is DBNull.");
                return _productSales;
            }
            set
            {
                _productSalesNull = false;
                _productSales = value;
            }
        }

        /// <summary>
        /// Indicates whether the <see cref="ProductSales"/>
        /// property value is null.
        /// </summary>
        /// <value>true if the property value is null, otherwise false.</value>
        public bool IsProductSalesNull
        {
            get { return _productSalesNull; }
            set { _productSalesNull = 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("  CategoryID=");
            dynStr.Append(CategoryID);
            dynStr.Append("  CategoryName=");
            dynStr.Append(CategoryName);
            dynStr.Append("  ProductName=");
            dynStr.Append(ProductName);
            dynStr.Append("  ProductSales=");
            dynStr.Append(IsProductSalesNull ? (object)"<NULL>" : ProductSales);
            return dynStr.ToString();
        }
    } // End of SalesbyCategoryRow_Base class
} // End of namespace