#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:4.0.30319.1
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace WebScraper
{
	using System.Data.Linq;
	using System.Data.Linq.Mapping;
	using System.Data;
	using System.Collections.Generic;
	using System.Reflection;
	using System.Linq;
	using System.Linq.Expressions;
	using System.ComponentModel;
	using System;
	
	
	[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="PXCAN")]
	public partial class PXCANDataContext : System.Data.Linq.DataContext
	{
		
		private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
		
    #region Extensibility Method Definitions
    partial void OnCreated();
    partial void InsertCompany(Company instance);
    partial void UpdateCompany(Company instance);
    partial void DeleteCompany(Company instance);
        //feb 1,2012
    partial void insertCompanyService(CompanyService instance);
    partial void UpdateCompanyService(CompanyService instance);
    partial void DeleteCompanyService(CompanyService instance);
//end
    #endregion
		
		public PXCANDataContext() : 
				base(global::WebScraper.Properties.Settings.Default.PXCANConnectionString, mappingSource)
		{
			OnCreated();
		}
		
		public PXCANDataContext(string connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public PXCANDataContext(System.Data.IDbConnection connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public PXCANDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public PXCANDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public System.Data.Linq.Table<CompanyService> CompanyServices
		{
			get
			{
				return this.GetTable<CompanyService>();
			}
		}
		
		public System.Data.Linq.Table<Company> Companies
		{
			get
			{
				return this.GetTable<Company>();
			}
		}
	}
	
	[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.CompanyService")]
	public partial class CompanyService
	{
        private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
		private decimal _CompanyId;
		
		private string _CompanyServiceDescription;


        partial void OnLoaded();
        partial void OnValidate(System.Data.Linq.ChangeAction action);
        partial void OnCreated();
        partial void OnCompanyIdChanging(decimal value);
        partial void OnCompanyIdChanged();
        partial void OnCompanyServiceDescriptionChanging(string value);
        partial void OnCompanyServiceDescriptioneChanged();
		public CompanyService()
		{
            OnCreated();
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CompanyId", DbType="Decimal(18,0) NOT NULL")]
		public decimal CompanyId
		{
			get
			{
				return this._CompanyId;
			}
			set
			{
				if ((this._CompanyId != value))
				{
                    this.OnCompanyIdChanging(value);
                    this.SendPropertyChanging();
                    this._CompanyId = value;
                    this.SendPropertyChanged("CompanyId");
                    this.OnCompanyIdChanged();
                    //this._CompanyId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CompanyServiceDescription", DbType="NVarChar(MAX)")]
		public string CompanyServiceDescription
		{
			get
			{
				return this._CompanyServiceDescription;
			}
			set
			{
				if ((this._CompanyServiceDescription != value))
				{
                    this._CompanyServiceDescription = value;
                    this.OnCompanyServiceDescriptionChanging(value);
                    this.SendPropertyChanging();

                    this.SendPropertyChanged("CompanyServiceDescription");
                    this.OnCompanyIdChanged();
					
				}
			}
		}
        public event PropertyChangingEventHandler PropertyChanging;

        public event PropertyChangedEventHandler PropertyChanged;

        protected virtual void SendPropertyChanging()
        {
            if ((this.PropertyChanging != null))
            {
                this.PropertyChanging(this, emptyChangingEventArgs);
            }
        }

        protected virtual void SendPropertyChanged(String propertyName)
        {
            if ((this.PropertyChanged != null))
            {
                this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
            }
        }
	}
	
	[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Company")]
	public partial class Company : INotifyPropertyChanging, INotifyPropertyChanged
	{
		
		private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
		
		private decimal _CompanyId;
		
		private string _LegalName;
		
		private string _OperatingName;
		
		private string _MailingAddress;
		
		private string _LocationAddress;
		
		private string _Telephone;
		
		private string _Fax;
		
		private string _Email;
		
		private string _Website;
		
		private string _ContactPerson;
		
		private string _CPTitle;
		
		private string _CPAreaOfResponsibility;
		
		private string _CPTelephone;
		
		private string _CPFax;
		
		private string _CPEmail;
		
		private string _CountryOfOwnership;
		
		private string _YearEstablished;
		
		private System.Nullable<bool> _Exporting;
		
		private string _PrimaryIndustry;
		
		private string _PrimaryBusinessActivity;
		
		private string _TotalSales;
		
		private string _ExportSales;
		
		private System.Nullable<int> _NoOfEmployees;
		
		private string _SourceUrl;
		
    #region Extensibility Method Definitions
    partial void OnLoaded();
    partial void OnValidate(System.Data.Linq.ChangeAction action);
    partial void OnCreated();
    partial void OnCompanyIdChanging(decimal value);
    partial void OnCompanyIdChanged();
    partial void OnLegalNameChanging(string value);
    partial void OnLegalNameChanged();
    partial void OnOperatingNameChanging(string value);
    partial void OnOperatingNameChanged();
    partial void OnMailingAddressChanging(string value);
    partial void OnMailingAddressChanged();
    partial void OnLocationAddressChanging(string value);
    partial void OnLocationAddressChanged();
    partial void OnTelephoneChanging(string value);
    partial void OnTelephoneChanged();
    partial void OnFaxChanging(string value);
    partial void OnFaxChanged();
    partial void OnEmailChanging(string value);
    partial void OnEmailChanged();
    partial void OnWebsiteChanging(string value);
    partial void OnWebsiteChanged();
    partial void OnContactPersonChanging(string value);
    partial void OnContactPersonChanged();
    partial void OnCPTitleChanging(string value);
    partial void OnCPTitleChanged();
    partial void OnCPAreaOfResponsibilityChanging(string value);
    partial void OnCPAreaOfResponsibilityChanged();
    partial void OnCPTelephoneChanging(string value);
    partial void OnCPTelephoneChanged();
    partial void OnCPFaxChanging(string value);
    partial void OnCPFaxChanged();
    partial void OnCPEmailChanging(string value);
    partial void OnCPEmailChanged();
    partial void OnCountryOfOwnershipChanging(string value);
    partial void OnCountryOfOwnershipChanged();
    partial void OnYearEstablishedChanging(string value);
    partial void OnYearEstablishedChanged();
    partial void OnExportingChanging(System.Nullable<bool> value);
    partial void OnExportingChanged();
    partial void OnPrimaryIndustryChanging(string value);
    partial void OnPrimaryIndustryChanged();
    partial void OnPrimaryBusinessActivityChanging(string value);
    partial void OnPrimaryBusinessActivityChanged();
    partial void OnTotalSalesChanging(string value);
    partial void OnTotalSalesChanged();
    partial void OnExportSalesChanging(string value);
    partial void OnExportSalesChanged();
    partial void OnNoOfEmployeesChanging(System.Nullable<int> value);
    partial void OnNoOfEmployeesChanged();
    partial void OnSourceUrlChanging(string value);
    partial void OnSourceUrlChanged();
    #endregion
		
		public Company()
		{
			OnCreated();
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CompanyId", AutoSync=AutoSync.OnInsert, DbType="Decimal(18,0) NOT NULL IDENTITY",  IsPrimaryKey=true, IsDbGenerated=true)]
		public decimal CompanyId
		{
			get
			{
				return this._CompanyId;
			}
			set
			{
				if ((this._CompanyId != value))
				{
					this.OnCompanyIdChanging(value);
					this.SendPropertyChanging();
					this._CompanyId = value;
					this.SendPropertyChanged("CompanyId");
					this.OnCompanyIdChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_LegalName", DbType="NVarChar(500)")]
		public string LegalName
		{
			get
			{
				return this._LegalName;
			}
			set
			{
				if ((this._LegalName != value))
				{
					this.OnLegalNameChanging(value);
					this.SendPropertyChanging();
					this._LegalName = value;
					this.SendPropertyChanged("LegalName");
					this.OnLegalNameChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_OperatingName", DbType="NVarChar(500)")]
		public string OperatingName
		{
			get
			{
				return this._OperatingName;
			}
			set
			{
				if ((this._OperatingName != value))
				{
					this.OnOperatingNameChanging(value);
					this.SendPropertyChanging();
					this._OperatingName = value;
					this.SendPropertyChanged("OperatingName");
					this.OnOperatingNameChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_MailingAddress", DbType="NVarChar(MAX)")]
		public string MailingAddress
		{
			get
			{
				return this._MailingAddress;
			}
			set
			{
				if ((this._MailingAddress != value))
				{
					this.OnMailingAddressChanging(value);
					this.SendPropertyChanging();
					this._MailingAddress = value;
					this.SendPropertyChanged("MailingAddress");
					this.OnMailingAddressChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_LocationAddress", DbType="NVarChar(MAX)")]
		public string LocationAddress
		{
			get
			{
				return this._LocationAddress;
			}
			set
			{
				if ((this._LocationAddress != value))
				{
					this.OnLocationAddressChanging(value);
					this.SendPropertyChanging();
					this._LocationAddress = value;
					this.SendPropertyChanged("LocationAddress");
					this.OnLocationAddressChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Telephone", DbType="NVarChar(MAX)")]
		public string Telephone
		{
			get
			{
				return this._Telephone;
			}
			set
			{
				if ((this._Telephone != value))
				{
					this.OnTelephoneChanging(value);
					this.SendPropertyChanging();
					this._Telephone = value;
					this.SendPropertyChanged("Telephone");
					this.OnTelephoneChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Fax", DbType="NVarChar(max)")]
		public string Fax
		{
			get
			{
				return this._Fax;
			}
			set
			{
				if ((this._Fax != value))
				{
					this.OnFaxChanging(value);
					this.SendPropertyChanging();
					this._Fax = value;
					this.SendPropertyChanged("Fax");
					this.OnFaxChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Email", DbType="NVarChar(255)")]
		public string Email
		{
			get
			{
				return this._Email;
			}
			set
			{
				if ((this._Email != value))
				{
					this.OnEmailChanging(value);
					this.SendPropertyChanging();
					this._Email = value;
					this.SendPropertyChanged("Email");
					this.OnEmailChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Website", DbType="NVarChar(255)")]
		public string Website
		{
			get
			{
				return this._Website;
			}
			set
			{
				if ((this._Website != value))
				{
					this.OnWebsiteChanging(value);
					this.SendPropertyChanging();
					this._Website = value;
					this.SendPropertyChanged("Website");
					this.OnWebsiteChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ContactPerson", DbType="NVarChar(100)")]
		public string ContactPerson
		{
			get
			{
				return this._ContactPerson;
			}
			set
			{
				if ((this._ContactPerson != value))
				{
					this.OnContactPersonChanging(value);
					this.SendPropertyChanging();
					this._ContactPerson = value;
					this.SendPropertyChanged("ContactPerson");
					this.OnContactPersonChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CPTitle", DbType="NVarChar(max)")]
		public string CPTitle
		{
			get
			{
				return this._CPTitle;
			}
			set
			{
				if ((this._CPTitle != value))
				{
					this.OnCPTitleChanging(value);
					this.SendPropertyChanging();
					this._CPTitle = value;
					this.SendPropertyChanged("CPTitle");
					this.OnCPTitleChanged();
				}
			}
		}
	
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CPAreaOfResponsibility", DbType="NVarChar(max)")]
		public string CPAreaOfResponsibility
		{
			get
			{
				return this._CPAreaOfResponsibility;
			}
			set
			{
				if ((this._CPAreaOfResponsibility != value))
				{
					this.OnCPAreaOfResponsibilityChanging(value);
					this.SendPropertyChanging();
					this._CPAreaOfResponsibility = value;
					this.SendPropertyChanged("CPAreaOfResponsibility");
					this.OnCPAreaOfResponsibilityChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CPTelephone", DbType="NVarChar(20)")]
		public string CPTelephone
		{
			get
			{
				return this._CPTelephone;
			}
			set
			{
				if ((this._CPTelephone != value))
				{
					this.OnCPTelephoneChanging(value);
					this.SendPropertyChanging();
					this._CPTelephone = value;
					this.SendPropertyChanged("CPTelephone");
					this.OnCPTelephoneChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CPFax", DbType="NVarChar(20)")]
		public string CPFax
		{
			get
			{
				return this._CPFax;
			}
			set
			{
				if ((this._CPFax != value))
				{
					this.OnCPFaxChanging(value);
					this.SendPropertyChanging();
					this._CPFax = value;
					this.SendPropertyChanged("CPFax");
					this.OnCPFaxChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CPEmail", DbType="NVarChar(255)")]
		public string CPEmail
		{
			get
			{
				return this._CPEmail;
			}
			set
			{
				if ((this._CPEmail != value))
				{
					this.OnCPEmailChanging(value);
					this.SendPropertyChanging();
					this._CPEmail = value;
					this.SendPropertyChanged("CPEmail");
					this.OnCPEmailChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CountryOfOwnership", DbType="NVarChar(100)")]
		public string CountryOfOwnership
		{
			get
			{
				return this._CountryOfOwnership;
			}
			set
			{
				if ((this._CountryOfOwnership != value))
				{
					this.OnCountryOfOwnershipChanging(value);
					this.SendPropertyChanging();
					this._CountryOfOwnership = value;
					this.SendPropertyChanged("CountryOfOwnership");
					this.OnCountryOfOwnershipChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_YearEstablished", DbType="NVarChar(MAX)")]
		public string YearEstablished
		{
			get
			{
				return this._YearEstablished;
			}
			set
			{
				if ((this._YearEstablished != value) )
				{
					this.OnYearEstablishedChanging(value);
					this.SendPropertyChanging();
					this._YearEstablished = value;
					this.SendPropertyChanged("YearEstablished");
					this.OnYearEstablishedChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Exporting", DbType="Bit")]
		public System.Nullable<bool> Exporting
		{
			get
			{
				return this._Exporting;
			}
			set
			{
				if ((this._Exporting != value))
				{
					this.OnExportingChanging(value);
					this.SendPropertyChanging();
					this._Exporting = value;
					this.SendPropertyChanged("Exporting");
					this.OnExportingChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PrimaryIndustry", DbType="NVarChar(400)")]
		public string PrimaryIndustry
		{
			get
			{
				return this._PrimaryIndustry;
			}
			set
			{
				if ((this._PrimaryIndustry != value))
				{
					this.OnPrimaryIndustryChanging(value);
					this.SendPropertyChanging();
					this._PrimaryIndustry = value;
					this.SendPropertyChanged("PrimaryIndustry");
					this.OnPrimaryIndustryChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PrimaryBusinessActivity", DbType="NVarChar(400)")]
		public string PrimaryBusinessActivity
		{
			get
			{
				return this._PrimaryBusinessActivity;
			}
			set
			{
				if ((this._PrimaryBusinessActivity != value))
				{
					this.OnPrimaryBusinessActivityChanging(value);
					this.SendPropertyChanging();
					this._PrimaryBusinessActivity = value;
					this.SendPropertyChanged("PrimaryBusinessActivity");
					this.OnPrimaryBusinessActivityChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalSales", DbType="NVarChar(100)")]
		public string TotalSales
		{
			get
			{
				return this._TotalSales;
			}
			set
			{
				if ((this._TotalSales != value))
				{
					this.OnTotalSalesChanging(value);
					this.SendPropertyChanging();
					this._TotalSales = value;
					this.SendPropertyChanged("TotalSales");
					this.OnTotalSalesChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ExportSales", DbType="NVarChar(100)")]
		public string ExportSales
		{
			get
			{
				return this._ExportSales;
			}
			set
			{
				if ((this._ExportSales != value))
				{
					this.OnExportSalesChanging(value);
					this.SendPropertyChanging();
					this._ExportSales = value;
					this.SendPropertyChanged("ExportSales");
					this.OnExportSalesChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_NoOfEmployees", DbType="Int")]
		public System.Nullable<int> NoOfEmployees
		{
			get
			{
				return this._NoOfEmployees;
			}
			set
			{
				if ((this._NoOfEmployees != value))
				{
					this.OnNoOfEmployeesChanging(value);
					this.SendPropertyChanging();
					this._NoOfEmployees = value;
					this.SendPropertyChanged("NoOfEmployees");
					this.OnNoOfEmployeesChanged();
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_SourceUrl", DbType="NVarChar(255)")]
		public string SourceUrl
		{
			get
			{
				return this._SourceUrl;
			}
			set
			{
				if ((this._SourceUrl != value))
				{
					this.OnSourceUrlChanging(value);
					this.SendPropertyChanging();
					this._SourceUrl = value;
					this.SendPropertyChanged("SourceUrl");
					this.OnSourceUrlChanged();
				}
			}
		}
		
		public event PropertyChangingEventHandler PropertyChanging;
		
		public event PropertyChangedEventHandler PropertyChanged;
		
		protected virtual void SendPropertyChanging()
		{
			if ((this.PropertyChanging != null))
			{
				this.PropertyChanging(this, emptyChangingEventArgs);
			}
		}
		
		protected virtual void SendPropertyChanged(String propertyName)
		{
			if ((this.PropertyChanged != null))
			{
				this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
			}
		}
	}
}
#pragma warning restore 1591