product.cs

Professional C# 2nd Edition

//------------------------------------------------------------------------------
// <autogenerated>
//     This code was generated by a tool.
//     Runtime Version: 1.0.3705.0
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------

// 
// This source code was auto-generated by xsd, Version=1.0.3705.0.
// 
using System;
using System.Data;
using System.Xml;
using System.Runtime.Serialization;


[Serializable()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Diagnostics.DebuggerStepThrough()]
[System.ComponentModel.ToolboxItem(true)]
public class Products : DataSet {
    
    private ProductDataTable tableProduct;
    
    public Products() {
        this.InitClass();
        System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
        this.Tables.CollectionChanged += schemaChangedHandler;
        this.Relations.CollectionChanged += schemaChangedHandler;
    }
    
    protected Products(SerializationInfo info, StreamingContext context) {
        string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
        if ((strSchema != null)) {
            DataSet ds = new DataSet();
            ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema)));
            if ((ds.Tables["Product"] != null)) {
                this.Tables.Add(new ProductDataTable(ds.Tables["Product"]));
            }
            this.DataSetName = ds.DataSetName;
            this.Prefix = ds.Prefix;
            this.Namespace = ds.Namespace;
            this.Locale = ds.Locale;
            this.CaseSensitive = ds.CaseSensitive;
            this.EnforceConstraints = ds.EnforceConstraints;
            this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
            this.InitVars();
        }
        else {
            this.InitClass();
        }
        this.GetSerializationData(info, context);
        System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
        this.Tables.CollectionChanged += schemaChangedHandler;
        this.Relations.CollectionChanged += schemaChangedHandler;
    }
    
    [System.ComponentModel.Browsable(false)]
    [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]
    public ProductDataTable Product {
        get {
            return this.tableProduct;
        }
    }
    
    public override DataSet Clone() {
        Products cln = ((Products)(base.Clone()));
        cln.InitVars();
        return cln;
    }
    
    protected override bool ShouldSerializeTables() {
        return false;
    }
    
    protected override bool ShouldSerializeRelations() {
        return false;
    }
    
    protected override void ReadXmlSerializable(XmlReader reader) {
        this.Reset();
        DataSet ds = new DataSet();
        ds.ReadXml(reader);
        if ((ds.Tables["Product"] != null)) {
            this.Tables.Add(new ProductDataTable(ds.Tables["Product"]));
        }
        this.DataSetName = ds.DataSetName;
        this.Prefix = ds.Prefix;
        this.Namespace = ds.Namespace;
        this.Locale = ds.Locale;
        this.CaseSensitive = ds.CaseSensitive;
        this.EnforceConstraints = ds.EnforceConstraints;
        this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
        this.InitVars();
    }
    
    protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {
        System.IO.MemoryStream stream = new System.IO.MemoryStream();
        this.WriteXmlSchema(new XmlTextWriter(stream, null));
        stream.Position = 0;
        return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);
    }
    
    internal void InitVars() {
        this.tableProduct = ((ProductDataTable)(this.Tables["Product"]));
        if ((this.tableProduct != null)) {
            this.tableProduct.InitVars();
        }
    }
    
    private void InitClass() {
        this.DataSetName = "Products";
        this.Prefix = "";
        this.Namespace = "http://tempuri.org/XMLSchema1.xsd";
        this.Locale = new System.Globalization.CultureInfo("en-GB");
        this.CaseSensitive = false;
        this.EnforceConstraints = true;
        this.tableProduct = new ProductDataTable();
        this.Tables.Add(this.tableProduct);
    }
    
    private bool ShouldSerializeProduct() {
        return false;
    }
    
    private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {
        if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {
            this.InitVars();
        }
    }
    
    public delegate void ProductRowChangeEventHandler(object sender, ProductRowChangeEvent e);
    
    [System.Diagnostics.DebuggerStepThrough()]
    public class ProductDataTable : DataTable, System.Collections.IEnumerable {
        
        private DataColumn columnProductID;
        
        private DataColumn columnProductName;
        
        private DataColumn columnSupplierID;
        
        private DataColumn columnCategoryID;
        
        private DataColumn columnQuantityPerUnit;
        
        private DataColumn columnUnitPrice;
        
        private DataColumn columnUnitsInStock;
        
        private DataColumn columnUnitsOnOrder;
        
        private DataColumn columnReorderLevel;
        
        private DataColumn columnDiscontinued;
        
        internal ProductDataTable() : 
                base("Product") {
            this.InitClass();
        }
        
        internal ProductDataTable(DataTable table) : 
                base(table.TableName) {
            if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
                this.CaseSensitive = table.CaseSensitive;
            }
            if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
                this.Locale = table.Locale;
            }
            if ((table.Namespace != table.DataSet.Namespace)) {
                this.Namespace = table.Namespace;
            }
            this.Prefix = table.Prefix;
            this.MinimumCapacity = table.MinimumCapacity;
            this.DisplayExpression = table.DisplayExpression;
        }
        
        [System.ComponentModel.Browsable(false)]
        public int Count {
            get {
                return this.Rows.Count;
            }
        }
        
        internal DataColumn ProductIDColumn {
            get {
                return this.columnProductID;
            }
        }
        
        internal DataColumn ProductNameColumn {
            get {
                return this.columnProductName;
            }
        }
        
        internal DataColumn SupplierIDColumn {
            get {
                return this.columnSupplierID;
            }
        }
        
        internal DataColumn CategoryIDColumn {
            get {
                return this.columnCategoryID;
            }
        }
        
        internal DataColumn QuantityPerUnitColumn {
            get {
                return this.columnQuantityPerUnit;
            }
        }
        
        internal DataColumn UnitPriceColumn {
            get {
                return this.columnUnitPrice;
            }
        }
        
        internal DataColumn UnitsInStockColumn {
            get {
                return this.columnUnitsInStock;
            }
        }
        
        internal DataColumn UnitsOnOrderColumn {
            get {
                return this.columnUnitsOnOrder;
            }
        }
        
        internal DataColumn ReorderLevelColumn {
            get {
                return this.columnReorderLevel;
            }
        }
        
        internal DataColumn DiscontinuedColumn {
            get {
                return this.columnDiscontinued;
            }
        }
        
        public ProductRow this[int index] {
            get {
                return ((ProductRow)(this.Rows[index]));
            }
        }
        
        public event ProductRowChangeEventHandler ProductRowChanged;
        
        public event ProductRowChangeEventHandler ProductRowChanging;
        
        public event ProductRowChangeEventHandler ProductRowDeleted;
        
        public event ProductRowChangeEventHandler ProductRowDeleting;
        
        public void AddProductRow(ProductRow row) {
            this.Rows.Add(row);
        }
        
        public ProductRow AddProductRow(string ProductName, int SupplierID, int CategoryID, string QuantityPerUnit, System.Decimal UnitPrice, short UnitsInStock, short UnitsOnOrder, short ReorderLevel, bool Discontinued) {
            ProductRow rowProductRow = ((ProductRow)(this.NewRow()));
            rowProductRow.ItemArray = new object[] {
                    null,
                    ProductName,
                    SupplierID,
                    CategoryID,
                    QuantityPerUnit,
                    UnitPrice,
                    UnitsInStock,
                    UnitsOnOrder,
                    ReorderLevel,
                    Discontinued};
            this.Rows.Add(rowProductRow);
            return rowProductRow;
        }
        
        public System.Collections.IEnumerator GetEnumerator() {
            return this.Rows.GetEnumerator();
        }
        
        public override DataTable Clone() {
            ProductDataTable cln = ((ProductDataTable)(base.Clone()));
            cln.InitVars();
            return cln;
        }
        
        internal void InitVars() {
            this.columnProductID = this.Columns["ProductID"];
            this.columnProductName = this.Columns["ProductName"];
            this.columnSupplierID = this.Columns["SupplierID"];
            this.columnCategoryID = this.Columns["CategoryID"];
            this.columnQuantityPerUnit = this.Columns["QuantityPerUnit"];