internal Order_DetailsRow(DataRowBuilder rb) :
base(rb)
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Table));
}
private void InitClass()
{
this.DataSetName = "DataSet1";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/DataSet1.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableOrder_Details = new Order_DetailsDataTable();
this.Tables.Add(this.tableOrder_Details);
this.tableOrders = new OrdersDataTable();
this.Tables.Add(this.tableOrders);
ForeignKeyConstraint fkc;
fkc = new ForeignKeyConstraint("OrdersOrder_x0020_Details", new DataColumn[] {
this.tableOrders.OrderIDColumn
}, new DataColumn[] {
this.tableOrder_Details.OrderIDColumn
});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationOrdersOrder_x0020_Details = new DataRelation("OrdersOrder_x0020_Details", new DataColumn[] {
this.tableOrders.OrderIDColumn
}, new DataColumn[] {
this.tableOrder_Details.OrderIDColumn
}, false);
this.Relations.Add(this.relationOrdersOrder_x0020_Details);
}
public int AddOrderDetails(int orderId,
int productId,
decimal unitPrice,
short quantity,
float discount)
{
var orderDetailsDataTable = new Order_DetailsDataTable();
var orderDetailsRow = orderDetailsDataTable.NewOrder_DetailsRow();
orderDetailsRow.OrderID = orderId;
orderDetailsRow.ProductID = productId;
orderDetailsRow.UnitPrice = unitPrice;
orderDetailsRow.Quantity = quantity;
orderDetailsRow.Discount = discount;
orderDetailsDataTable.AddOrder_DetailsRow(orderDetailsRow);
var rowsAffected = OrderDetailsTableAdapter.Update(orderDetailsDataTable);
if (rowsAffected == 1)
{
return(orderDetailsRow.OrderID);
}
else
{
return(-1);
}
}
public override global::System.Data.DataTable Clone()
{
Order_DetailsDataTable cln = ((Order_DetailsDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
public DataTable Clone()
{
Order_DetailsDataTable cln = ((Order_DetailsDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
internal void InitVars()
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Tables["Order Details"]));
if ((this.tableOrder_Details != null))
{
this.tableOrder_Details.InitVars();
}
}
internal void InitVars(bool initTable) {
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
}
private void InitClass() {
this.DataSetName = "nwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/nwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
}
private void InitClass()
{
this.DataSetName = "DataSet1";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/DataSet1.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableOrder_Details = new Order_DetailsDataTable();
this.Tables.Add(this.tableOrder_Details);
}
internal void InitVars()
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Tables["Order Details"]));
if ((this.tableOrder_Details != null))
{
this.tableOrder_Details.InitVars();
}
this.tableOrders = ((OrdersDataTable)(this.Tables["Orders"]));
if ((this.tableOrders != null))
{
this.tableOrders.InitVars();
}
this.relationOrdersOrder_x0020_Details = this.Relations["OrdersOrder_x0020_Details"];
}
private void OrdersDataGrid_SelectionChanged(object sender, DataGridSelectionChangedEventArgs e)
{
var items = e.AddedItems.ToList();
if (items.Count() > 0)
{
var orderRow = items[0] as OrdersRow;
if (orderRow != null)
{
OrderDetailsDataTable = OrderDetailsBLL.Current.GetOrderDetailsByOrderId(orderRow.OrderID);
}
}
else
{
OrderDetailsDataTable = null;
}
}
internal Order_DetailsRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.relationCustomersOrders = this.Relations["CustomersOrders"];
this.relationOrdersOrder_x0020_Details = this.Relations["OrdersOrder_x0020_Details"];
}
private void InitClass() {
this.DataSetName = "NorthwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCategories = new CategoriesDataTable();
base.Tables.Add(this.tableCategories);
this.tableCustomerCustomerDemo = new CustomerCustomerDemoDataTable();
base.Tables.Add(this.tableCustomerCustomerDemo);
this.tableCustomerDemographics = new CustomerDemographicsDataTable();
base.Tables.Add(this.tableCustomerDemographics);
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
this.tableEmployeeTerritories = new EmployeeTerritoriesDataTable();
base.Tables.Add(this.tableEmployeeTerritories);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.tableRegion = new RegionDataTable();
base.Tables.Add(this.tableRegion);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.tableTerritories = new TerritoriesDataTable();
base.Tables.Add(this.tableTerritories);
this.tableAlphabetical_list_of_products = new Alphabetical_list_of_productsDataTable();
base.Tables.Add(this.tableAlphabetical_list_of_products);
this.tableCategory_Sales_for_1997 = new Category_Sales_for_1997DataTable();
base.Tables.Add(this.tableCategory_Sales_for_1997);
this.tableCurrent_Product_List = new Current_Product_ListDataTable();
base.Tables.Add(this.tableCurrent_Product_List);
this.tableCustomer_and_Suppliers_by_City = new Customer_and_Suppliers_by_CityDataTable();
base.Tables.Add(this.tableCustomer_and_Suppliers_by_City);
this.tableInvoices = new InvoicesDataTable();
base.Tables.Add(this.tableInvoices);
this.tableOrder_Details_Extended = new Order_Details_ExtendedDataTable();
base.Tables.Add(this.tableOrder_Details_Extended);
this.tableOrder_Subtotals = new Order_SubtotalsDataTable();
base.Tables.Add(this.tableOrder_Subtotals);
this.tableOrders_Qry = new Orders_QryDataTable();
base.Tables.Add(this.tableOrders_Qry);
this.tableProduct_Sales_for_1997 = new Product_Sales_for_1997DataTable();
base.Tables.Add(this.tableProduct_Sales_for_1997);
this.tableProducts_Above_Average_Price = new Products_Above_Average_PriceDataTable();
base.Tables.Add(this.tableProducts_Above_Average_Price);
this.tableProducts_by_Category = new Products_by_CategoryDataTable();
base.Tables.Add(this.tableProducts_by_Category);
this.tableQuarterly_Orders = new Quarterly_OrdersDataTable();
base.Tables.Add(this.tableQuarterly_Orders);
this.tableSales_by_Category = new Sales_by_CategoryDataTable();
base.Tables.Add(this.tableSales_by_Category);
this.tableSales_Totals_by_Amount = new Sales_Totals_by_AmountDataTable();
base.Tables.Add(this.tableSales_Totals_by_Amount);
this.tableSummary_of_Sales_by_Quarter = new Summary_of_Sales_by_QuarterDataTable();
base.Tables.Add(this.tableSummary_of_Sales_by_Quarter);
this.tableSummary_of_Sales_by_Year = new Summary_of_Sales_by_YearDataTable();
base.Tables.Add(this.tableSummary_of_Sales_by_Year);
this.tableCustOrderHist = new CustOrderHistDataTable();
base.Tables.Add(this.tableCustOrderHist);
this.tableCustOrdersDetail = new CustOrdersDetailDataTable();
base.Tables.Add(this.tableCustOrdersDetail);
this.tableCustOrdersOrders = new CustOrdersOrdersDataTable();
base.Tables.Add(this.tableCustOrdersOrders);
this.tableEmployee_Sales_by_Country = new Employee_Sales_by_CountryDataTable();
base.Tables.Add(this.tableEmployee_Sales_by_Country);
this.tableSales_by_Year = new Sales_by_YearDataTable();
base.Tables.Add(this.tableSales_by_Year);
this.tableSalesByCategory = new SalesByCategoryDataTable();
base.Tables.Add(this.tableSalesByCategory);
this.tableTen_Most_Expensive_Products = new Ten_Most_Expensive_ProductsDataTable();
base.Tables.Add(this.tableTen_Most_Expensive_Products);
this.relationFK_CustomerCustomerDemo = new System.Data.DataRelation("FK_CustomerCustomerDemo", new System.Data.DataColumn[] {
this.tableCustomerDemographics.CustomerTypeIDColumn}, new System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerTypeIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo);
this.relationFK_CustomerCustomerDemo_Customers = new System.Data.DataRelation("FK_CustomerCustomerDemo_Customers", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo_Customers);
this.relationFK_Employees_Employees = new System.Data.DataRelation("FK_Employees_Employees", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableEmployees.ReportsToColumn}, false);
this.Relations.Add(this.relationFK_Employees_Employees);
this.relationFK_EmployeeTerritories_Employees = new System.Data.DataRelation("FK_EmployeeTerritories_Employees", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableEmployeeTerritories.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Employees);
this.relationFK_EmployeeTerritories_Territories = new System.Data.DataRelation("FK_EmployeeTerritories_Territories", new System.Data.DataColumn[] {
this.tableTerritories.TerritoryIDColumn}, new System.Data.DataColumn[] {
this.tableEmployeeTerritories.TerritoryIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Territories);
this.relationFK_Order_Details_Orders = new System.Data.DataRelation("FK_Order_Details_Orders", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Orders);
this.relationFK_Order_Details_Products = new System.Data.DataRelation("FK_Order_Details_Products", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Products);
this.relationFK_Orders_Customers = new System.Data.DataRelation("FK_Orders_Customers", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Customers);
this.relationFK_Orders_Employees = new System.Data.DataRelation("FK_Orders_Employees", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Employees);
this.relationFK_Orders_Shippers = new System.Data.DataRelation("FK_Orders_Shippers", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationFK_Orders_Shippers);
this.relationFK_Products_Categories = new System.Data.DataRelation("FK_Products_Categories", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Categories);
this.relationFK_Products_Suppliers = new System.Data.DataRelation("FK_Products_Suppliers", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Suppliers);
this.relationFK_Territories_Region = new System.Data.DataRelation("FK_Territories_Region", new System.Data.DataColumn[] {
this.tableRegion.RegionIDColumn}, new System.Data.DataColumn[] {
this.tableTerritories.RegionIDColumn}, false);
this.Relations.Add(this.relationFK_Territories_Region);
}
internal Order_DetailsRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableChangeLogs = ((ChangeLogsDataTable)(base.Tables["ChangeLogs"]));
if ((initTable == true)) {
if ((this.tableChangeLogs != null)) {
this.tableChangeLogs.InitVars();
}
}
this.tableCalculatedOrderDetails = ((CalculatedOrderDetailsDataTable)(base.Tables["CalculatedOrderDetails"]));
if ((initTable == true)) {
if ((this.tableCalculatedOrderDetails != null)) {
this.tableCalculatedOrderDetails.InitVars();
}
}
this.tableCalculatedOrders = ((CalculatedOrdersDataTable)(base.Tables["CalculatedOrders"]));
if ((initTable == true)) {
if ((this.tableCalculatedOrders != null)) {
this.tableCalculatedOrders.InitVars();
}
}
this.tableDeletedOrderDetails = ((DeletedOrderDetailsDataTable)(base.Tables["DeletedOrderDetails"]));
if ((initTable == true)) {
if ((this.tableDeletedOrderDetails != null)) {
this.tableDeletedOrderDetails.InitVars();
}
}
this.relationOrdersOrder_Details = this.Relations["OrdersOrder Details"];
this.relationCalculatedOrders_CalculatedOrderDetails = this.Relations["CalculatedOrders_CalculatedOrderDetails"];
}
private void InitClass() {
this.DataSetName = "Order";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Order.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableChangeLogs = new ChangeLogsDataTable();
base.Tables.Add(this.tableChangeLogs);
this.tableCalculatedOrderDetails = new CalculatedOrderDetailsDataTable();
base.Tables.Add(this.tableCalculatedOrderDetails);
this.tableCalculatedOrders = new CalculatedOrdersDataTable();
base.Tables.Add(this.tableCalculatedOrders);
this.tableDeletedOrderDetails = new DeletedOrderDetailsDataTable();
base.Tables.Add(this.tableDeletedOrderDetails);
this.relationOrdersOrder_Details = new global::System.Data.DataRelation("OrdersOrder Details", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_Details);
this.relationCalculatedOrders_CalculatedOrderDetails = new global::System.Data.DataRelation("CalculatedOrders_CalculatedOrderDetails", new global::System.Data.DataColumn[] {
this.tableCalculatedOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableCalculatedOrderDetails.OrderIDColumn}, false);
this.Relations.Add(this.relationCalculatedOrders_CalculatedOrderDetails);
}
internal void InitVars(bool initTable) {
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.InitVars();
}
}
this.tableCustomerCustomerDemo = ((CustomerCustomerDemoDataTable)(base.Tables["CustomerCustomerDemo"]));
if ((initTable == true)) {
if ((this.tableCustomerCustomerDemo != null)) {
this.tableCustomerCustomerDemo.InitVars();
}
}
this.tableCustomerDemographics = ((CustomerDemographicsDataTable)(base.Tables["CustomerDemographics"]));
if ((initTable == true)) {
if ((this.tableCustomerDemographics != null)) {
this.tableCustomerDemographics.InitVars();
}
}
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.tableEmployeeTerritories = ((EmployeeTerritoriesDataTable)(base.Tables["EmployeeTerritories"]));
if ((initTable == true)) {
if ((this.tableEmployeeTerritories != null)) {
this.tableEmployeeTerritories.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.tableRegion = ((RegionDataTable)(base.Tables["Region"]));
if ((initTable == true)) {
if ((this.tableRegion != null)) {
this.tableRegion.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
if ((initTable == true)) {
if ((this.tableSuppliers != null)) {
this.tableSuppliers.InitVars();
}
}
this.tableTerritories = ((TerritoriesDataTable)(base.Tables["Territories"]));
if ((initTable == true)) {
if ((this.tableTerritories != null)) {
this.tableTerritories.InitVars();
}
}
this.tableAlphabetical_list_of_products = ((Alphabetical_list_of_productsDataTable)(base.Tables["Alphabetical list of products"]));
if ((initTable == true)) {
if ((this.tableAlphabetical_list_of_products != null)) {
this.tableAlphabetical_list_of_products.InitVars();
}
}
this.tableCategory_Sales_for_1997 = ((Category_Sales_for_1997DataTable)(base.Tables["Category Sales for 1997"]));
if ((initTable == true)) {
if ((this.tableCategory_Sales_for_1997 != null)) {
this.tableCategory_Sales_for_1997.InitVars();
}
}
this.tableCurrent_Product_List = ((Current_Product_ListDataTable)(base.Tables["Current Product List"]));
if ((initTable == true)) {
if ((this.tableCurrent_Product_List != null)) {
this.tableCurrent_Product_List.InitVars();
}
}
this.tableCustomer_and_Suppliers_by_City = ((Customer_and_Suppliers_by_CityDataTable)(base.Tables["Customer and Suppliers by City"]));
if ((initTable == true)) {
if ((this.tableCustomer_and_Suppliers_by_City != null)) {
this.tableCustomer_and_Suppliers_by_City.InitVars();
}
}
this.tableInvoices = ((InvoicesDataTable)(base.Tables["Invoices"]));
if ((initTable == true)) {
if ((this.tableInvoices != null)) {
this.tableInvoices.InitVars();
}
}
this.tableOrder_Details_Extended = ((Order_Details_ExtendedDataTable)(base.Tables["Order Details Extended"]));
if ((initTable == true)) {
if ((this.tableOrder_Details_Extended != null)) {
this.tableOrder_Details_Extended.InitVars();
}
}
this.tableOrder_Subtotals = ((Order_SubtotalsDataTable)(base.Tables["Order Subtotals"]));
if ((initTable == true)) {
if ((this.tableOrder_Subtotals != null)) {
this.tableOrder_Subtotals.InitVars();
}
}
this.tableOrders_Qry = ((Orders_QryDataTable)(base.Tables["Orders Qry"]));
if ((initTable == true)) {
if ((this.tableOrders_Qry != null)) {
this.tableOrders_Qry.InitVars();
}
}
this.tableProduct_Sales_for_1997 = ((Product_Sales_for_1997DataTable)(base.Tables["Product Sales for 1997"]));
if ((initTable == true)) {
if ((this.tableProduct_Sales_for_1997 != null)) {
this.tableProduct_Sales_for_1997.InitVars();
}
}
this.tableProducts_Above_Average_Price = ((Products_Above_Average_PriceDataTable)(base.Tables["Products Above Average Price"]));
if ((initTable == true)) {
if ((this.tableProducts_Above_Average_Price != null)) {
this.tableProducts_Above_Average_Price.InitVars();
}
}
this.tableProducts_by_Category = ((Products_by_CategoryDataTable)(base.Tables["Products by Category"]));
if ((initTable == true)) {
if ((this.tableProducts_by_Category != null)) {
this.tableProducts_by_Category.InitVars();
}
}
this.tableQuarterly_Orders = ((Quarterly_OrdersDataTable)(base.Tables["Quarterly Orders"]));
if ((initTable == true)) {
if ((this.tableQuarterly_Orders != null)) {
this.tableQuarterly_Orders.InitVars();
}
}
this.tableSales_by_Category = ((Sales_by_CategoryDataTable)(base.Tables["Sales by Category"]));
if ((initTable == true)) {
if ((this.tableSales_by_Category != null)) {
this.tableSales_by_Category.InitVars();
}
}
this.tableSales_Totals_by_Amount = ((Sales_Totals_by_AmountDataTable)(base.Tables["Sales Totals by Amount"]));
if ((initTable == true)) {
if ((this.tableSales_Totals_by_Amount != null)) {
this.tableSales_Totals_by_Amount.InitVars();
}
}
this.tableSummary_of_Sales_by_Quarter = ((Summary_of_Sales_by_QuarterDataTable)(base.Tables["Summary of Sales by Quarter"]));
if ((initTable == true)) {
if ((this.tableSummary_of_Sales_by_Quarter != null)) {
this.tableSummary_of_Sales_by_Quarter.InitVars();
}
}
this.tableSummary_of_Sales_by_Year = ((Summary_of_Sales_by_YearDataTable)(base.Tables["Summary of Sales by Year"]));
if ((initTable == true)) {
if ((this.tableSummary_of_Sales_by_Year != null)) {
this.tableSummary_of_Sales_by_Year.InitVars();
}
}
this.tableCustOrderHist = ((CustOrderHistDataTable)(base.Tables["CustOrderHist"]));
if ((initTable == true)) {
if ((this.tableCustOrderHist != null)) {
this.tableCustOrderHist.InitVars();
}
}
this.tableCustOrdersDetail = ((CustOrdersDetailDataTable)(base.Tables["CustOrdersDetail"]));
if ((initTable == true)) {
if ((this.tableCustOrdersDetail != null)) {
this.tableCustOrdersDetail.InitVars();
}
}
this.tableCustOrdersOrders = ((CustOrdersOrdersDataTable)(base.Tables["CustOrdersOrders"]));
if ((initTable == true)) {
if ((this.tableCustOrdersOrders != null)) {
this.tableCustOrdersOrders.InitVars();
}
}
this.tableEmployee_Sales_by_Country = ((Employee_Sales_by_CountryDataTable)(base.Tables["Employee Sales by Country"]));
if ((initTable == true)) {
if ((this.tableEmployee_Sales_by_Country != null)) {
this.tableEmployee_Sales_by_Country.InitVars();
}
}
this.tableSales_by_Year = ((Sales_by_YearDataTable)(base.Tables["Sales by Year"]));
if ((initTable == true)) {
if ((this.tableSales_by_Year != null)) {
this.tableSales_by_Year.InitVars();
}
}
this.tableSalesByCategory = ((SalesByCategoryDataTable)(base.Tables["SalesByCategory"]));
if ((initTable == true)) {
if ((this.tableSalesByCategory != null)) {
this.tableSalesByCategory.InitVars();
}
}
this.tableTen_Most_Expensive_Products = ((Ten_Most_Expensive_ProductsDataTable)(base.Tables["Ten Most Expensive Products"]));
if ((initTable == true)) {
if ((this.tableTen_Most_Expensive_Products != null)) {
this.tableTen_Most_Expensive_Products.InitVars();
}
}
this.relationFK_CustomerCustomerDemo = this.Relations["FK_CustomerCustomerDemo"];
this.relationFK_CustomerCustomerDemo_Customers = this.Relations["FK_CustomerCustomerDemo_Customers"];
this.relationFK_Employees_Employees = this.Relations["FK_Employees_Employees"];
this.relationFK_EmployeeTerritories_Employees = this.Relations["FK_EmployeeTerritories_Employees"];
this.relationFK_EmployeeTerritories_Territories = this.Relations["FK_EmployeeTerritories_Territories"];
this.relationFK_Order_Details_Orders = this.Relations["FK_Order_Details_Orders"];
this.relationFK_Order_Details_Products = this.Relations["FK_Order_Details_Products"];
this.relationFK_Orders_Customers = this.Relations["FK_Orders_Customers"];
this.relationFK_Orders_Employees = this.Relations["FK_Orders_Employees"];
this.relationFK_Orders_Shippers = this.Relations["FK_Orders_Shippers"];
this.relationFK_Products_Categories = this.Relations["FK_Products_Categories"];
this.relationFK_Products_Suppliers = this.Relations["FK_Products_Suppliers"];
this.relationFK_Territories_Region = this.Relations["FK_Territories_Region"];
}
internal Order_DetailsRow(DataRowBuilder rb) :
base(rb)
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
if ((initTable == true)) {
if ((this.tableSuppliers != null)) {
this.tableSuppliers.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.relationSuppliersProducts = this.Relations["SuppliersProducts"];
this.relationCategoriesProducts = this.Relations["CategoriesProducts"];
this.relationShippersOrders = this.Relations["ShippersOrders"];
this.relationCustomersOrders = this.Relations["CustomersOrders"];
this.relationEmployeesOrders = this.Relations["EmployeesOrders"];
this.relationProductsOrder_Details = this.Relations["ProductsOrder Details"];
this.relationOrdersOrder_Details = this.Relations["OrdersOrder Details"];
}
private void InitClass() {
this.DataSetName = "NorthwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableCategories = new CategoriesDataTable();
base.Tables.Add(this.tableCategories);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("SuppliersProducts", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn});
this.tableProducts.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("CategoriesProducts", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn});
this.tableProducts.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("ShippersOrders", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("CustomersOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("EmployeesOrders", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("ProductsOrder Details", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("OrdersOrder Details", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationSuppliersProducts = new System.Data.DataRelation("SuppliersProducts", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationSuppliersProducts);
this.relationCategoriesProducts = new System.Data.DataRelation("CategoriesProducts", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationCategoriesProducts);
this.relationShippersOrders = new System.Data.DataRelation("ShippersOrders", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationShippersOrders);
this.relationCustomersOrders = new System.Data.DataRelation("CustomersOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustomersOrders);
this.relationEmployeesOrders = new System.Data.DataRelation("EmployeesOrders", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationEmployeesOrders);
this.relationProductsOrder_Details = new System.Data.DataRelation("ProductsOrder Details", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationProductsOrder_Details);
this.relationOrdersOrder_Details = new System.Data.DataRelation("OrdersOrder Details", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_Details);
this.ExtendedProperties.Add("DSGenerator_DataSetName", "NorthwindDataSet");
this.ExtendedProperties.Add("User_DataSetName", "NorthwindDataSet");
}
private void InitClass()
{
this.DataSetName = "myTypedDataSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/myTypedDataSet.xsd";
this.Locale = new CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableOrder_Details = new Order_DetailsDataTable();
this.Tables.Add(this.tableOrder_Details);
this.tableOrders = new OrdersDataTable();
this.Tables.Add(this.tableOrders);
ForeignKeyConstraint fkc;
fkc = new ForeignKeyConstraint("OrdersOrder_x0020_Details", new DataColumn[] {
this.tableOrders.OrderIDColumn}, new DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = AcceptRejectRule.None;
fkc.DeleteRule = Rule.Cascade;
fkc.UpdateRule = Rule.Cascade;
this.relationOrdersOrder_x0020_Details = new DataRelation("OrdersOrder_x0020_Details", new DataColumn[] {
this.tableOrders.OrderIDColumn}, new DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_x0020_Details);
}
private void InitClass() {
this.DataSetName = "DataSet2";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/DataSet2.xsd";
this.Locale = new global::System.Globalization.CultureInfo("zh-CN");
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("CustomersOrders", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
fkc = new global::System.Data.ForeignKeyConstraint("OrdersOrder_x0020_Details", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
this.relationCustomersOrders = new global::System.Data.DataRelation("CustomersOrders", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustomersOrders);
this.relationOrdersOrder_x0020_Details = new global::System.Data.DataRelation("OrdersOrder_x0020_Details", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_x0020_Details);
}
internal void InitVars()
{
_tableOrder_Details = ((Order_DetailsDataTable)(Tables["Order Details"]));
if ((_tableOrder_Details != null))
{
_tableOrder_Details.InitVars();
}
_tableOrders = ((OrdersDataTable)(Tables["Orders"]));
if ((_tableOrders != null))
{
_tableOrders.InitVars();
}
_relationOrdersOrder_x0020_Details = Relations["OrdersOrder_x0020_Details"];
}
internal void InitVars()
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Tables["Order Details"]));
if ((this.tableOrder_Details != null))
{
this.tableOrder_Details.InitVars();
}
this.tableOrders = ((OrdersDataTable)(this.Tables["Orders"]));
if ((this.tableOrders != null))
{
this.tableOrders.InitVars();
}
this.relationOrdersOrder_x0020_Details = this.Relations["OrdersOrder_x0020_Details"];
}
internal void InitVars(bool initTable) {
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.InitVars();
}
}
this.tableCustomerCustomerDemo = ((CustomerCustomerDemoDataTable)(base.Tables["CustomerCustomerDemo"]));
if ((initTable == true)) {
if ((this.tableCustomerCustomerDemo != null)) {
this.tableCustomerCustomerDemo.InitVars();
}
}
this.tableCustomerDemographics = ((CustomerDemographicsDataTable)(base.Tables["CustomerDemographics"]));
if ((initTable == true)) {
if ((this.tableCustomerDemographics != null)) {
this.tableCustomerDemographics.InitVars();
}
}
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.tableEmployeeTerritories = ((EmployeeTerritoriesDataTable)(base.Tables["EmployeeTerritories"]));
if ((initTable == true)) {
if ((this.tableEmployeeTerritories != null)) {
this.tableEmployeeTerritories.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.tableRegion = ((RegionDataTable)(base.Tables["Region"]));
if ((initTable == true)) {
if ((this.tableRegion != null)) {
this.tableRegion.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
if ((initTable == true)) {
if ((this.tableSuppliers != null)) {
this.tableSuppliers.InitVars();
}
}
this.tableTerritories = ((TerritoriesDataTable)(base.Tables["Territories"]));
if ((initTable == true)) {
if ((this.tableTerritories != null)) {
this.tableTerritories.InitVars();
}
}
this.relationFK_CustomerCustomerDemo = this.Relations["FK_CustomerCustomerDemo"];
this.relationFK_CustomerCustomerDemo_Customers = this.Relations["FK_CustomerCustomerDemo_Customers"];
this.relationFK_Employees_Employees = this.Relations["FK_Employees_Employees"];
this.relationFK_EmployeeTerritories_Employees = this.Relations["FK_EmployeeTerritories_Employees"];
this.relationFK_EmployeeTerritories_Territories = this.Relations["FK_EmployeeTerritories_Territories"];
this.relationFK_Order_Details_Orders = this.Relations["FK_Order_Details_Orders"];
this.relationFK_Order_Details_Products = this.Relations["FK_Order_Details_Products"];
this.relationFK_Orders_Customers = this.Relations["FK_Orders_Customers"];
this.relationFK_Orders_Employees = this.Relations["FK_Orders_Employees"];
this.relationFK_Orders_Shippers = this.Relations["FK_Orders_Shippers"];
this.relationFK_Products_Categories = this.Relations["FK_Products_Categories"];
this.relationFK_Products_Suppliers = this.Relations["FK_Products_Suppliers"];
this.relationFK_Territories_Region = this.Relations["FK_Territories_Region"];
}
private void InitClass() {
this.DataSetName = "northwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/northwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCategories = new CategoriesDataTable();
base.Tables.Add(this.tableCategories);
this.tableCustomerCustomerDemo = new CustomerCustomerDemoDataTable();
base.Tables.Add(this.tableCustomerCustomerDemo);
this.tableCustomerDemographics = new CustomerDemographicsDataTable();
base.Tables.Add(this.tableCustomerDemographics);
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
this.tableEmployeeTerritories = new EmployeeTerritoriesDataTable();
base.Tables.Add(this.tableEmployeeTerritories);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.tableRegion = new RegionDataTable();
base.Tables.Add(this.tableRegion);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.tableTerritories = new TerritoriesDataTable();
base.Tables.Add(this.tableTerritories);
this.relationFK_CustomerCustomerDemo = new global::System.Data.DataRelation("FK_CustomerCustomerDemo", new global::System.Data.DataColumn[] {
this.tableCustomerDemographics.CustomerTypeIDColumn}, new global::System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerTypeIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo);
this.relationFK_CustomerCustomerDemo_Customers = new global::System.Data.DataRelation("FK_CustomerCustomerDemo_Customers", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo_Customers);
this.relationFK_Employees_Employees = new global::System.Data.DataRelation("FK_Employees_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployees.ReportsToColumn}, false);
this.Relations.Add(this.relationFK_Employees_Employees);
this.relationFK_EmployeeTerritories_Employees = new global::System.Data.DataRelation("FK_EmployeeTerritories_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployeeTerritories.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Employees);
this.relationFK_EmployeeTerritories_Territories = new global::System.Data.DataRelation("FK_EmployeeTerritories_Territories", new global::System.Data.DataColumn[] {
this.tableTerritories.TerritoryIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployeeTerritories.TerritoryIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Territories);
this.relationFK_Order_Details_Orders = new global::System.Data.DataRelation("FK_Order_Details_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Orders);
this.relationFK_Order_Details_Products = new global::System.Data.DataRelation("FK_Order_Details_Products", new global::System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Products);
this.relationFK_Orders_Customers = new global::System.Data.DataRelation("FK_Orders_Customers", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Customers);
this.relationFK_Orders_Employees = new global::System.Data.DataRelation("FK_Orders_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Employees);
this.relationFK_Orders_Shippers = new global::System.Data.DataRelation("FK_Orders_Shippers", new global::System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationFK_Orders_Shippers);
this.relationFK_Products_Categories = new global::System.Data.DataRelation("FK_Products_Categories", new global::System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new global::System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Categories);
this.relationFK_Products_Suppliers = new global::System.Data.DataRelation("FK_Products_Suppliers", new global::System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Suppliers);
this.relationFK_Territories_Region = new global::System.Data.DataRelation("FK_Territories_Region", new global::System.Data.DataColumn[] {
this.tableRegion.RegionIDColumn}, new global::System.Data.DataColumn[] {
this.tableTerritories.RegionIDColumn}, false);
this.Relations.Add(this.relationFK_Territories_Region);
}
public Order_DetailsRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Table));
}
