public override System.Data.DataTable Clone()
{
ItemsDataTable cln = ((ItemsDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void InitClass()
{
this.DataSetName = "ItemsDataSet";
this.Prefix = "";
this.Namespace = "http://library.org/ItemsDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableItems = new ItemsDataTable();
base.Tables.Add(this.tableItems);
}
private void InitClass()
{
this.DataSetName = "FromToReportFormDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/FromToReportFormDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableItems = new ItemsDataTable();
base.Tables.Add(this.tableItems);
}
internal void InitVars(bool initTable)
{
this.tableItems = ((ItemsDataTable)(base.Tables["Items"]));
if ((initTable == true))
{
if ((this.tableItems != null))
{
this.tableItems.InitVars();
}
}
}
internal ItemsRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableItems = ((ItemsDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "dsCore";
this.Prefix = "";
this.Namespace = "http://tempuri.org/dsCore.xsd";
this.Locale = new global::System.Globalization.CultureInfo("id-ID");
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCurrencies = new CurrenciesDataTable();
base.Tables.Add(this.tableCurrencies);
this.tableItems = new ItemsDataTable();
base.Tables.Add(this.tableItems);
this.tableUnitMeasures = new UnitMeasuresDataTable();
base.Tables.Add(this.tableUnitMeasures);
this.tableWarehouses = new WarehousesDataTable();
base.Tables.Add(this.tableWarehouses);
this.tableCompanies = new CompaniesDataTable();
base.Tables.Add(this.tableCompanies);
this.tableItemInventories = new ItemInventoriesDataTable();
base.Tables.Add(this.tableItemInventories);
this.tableOrderDetails = new OrderDetailsDataTable();
base.Tables.Add(this.tableOrderDetails);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableItemCategories = new ItemCategoriesDataTable();
base.Tables.Add(this.tableItemCategories);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Items_Categories", new global::System.Data.DataColumn[] {
this.tableItemCategories.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.CategoryIDColumn});
this.tableItems.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Items_UnitMeasures", new global::System.Data.DataColumn[] {
this.tableUnitMeasures.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.MeasureIDColumn});
this.tableItems.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_ItemInventories_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.ItemIDColumn});
this.tableItemInventories.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_ItemInventories_Warehouse", new global::System.Data.DataColumn[] {
this.tableWarehouses.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.WarehouseIDColumn});
this.tableItemInventories.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_OrderDetails_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.ItemIDColumn});
this.tableOrderDetails.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_OrderDetails_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn});
this.tableOrderDetails.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("FK_Orders_Companies", new global::System.Data.DataColumn[] {
this.tableCompanies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CompanyIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Orders_Parent", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ParentIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Orders_Currencies", new global::System.Data.DataColumn[] {
this.tableCurrencies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CurrencyIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
this.relationFK_Items_Categories = new global::System.Data.DataRelation("FK_Items_Categories", new global::System.Data.DataColumn[] {
this.tableItemCategories.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.CategoryIDColumn}, false);
this.Relations.Add(this.relationFK_Items_Categories);
this.relationFK_Items_UnitMeasures = new global::System.Data.DataRelation("FK_Items_UnitMeasures", new global::System.Data.DataColumn[] {
this.tableUnitMeasures.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.MeasureIDColumn}, false);
this.Relations.Add(this.relationFK_Items_UnitMeasures);
this.relationFK_ItemInventories_Items = new global::System.Data.DataRelation("FK_ItemInventories_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.ItemIDColumn}, false);
this.Relations.Add(this.relationFK_ItemInventories_Items);
this.relationFK_ItemInventories_Warehouse = new global::System.Data.DataRelation("FK_ItemInventories_Warehouse", new global::System.Data.DataColumn[] {
this.tableWarehouses.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.WarehouseIDColumn}, false);
this.Relations.Add(this.relationFK_ItemInventories_Warehouse);
this.relationFK_OrderDetails_Items = new global::System.Data.DataRelation("FK_OrderDetails_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.ItemIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Items);
this.relationFK_OrderDetails_Orders = new global::System.Data.DataRelation("FK_OrderDetails_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Orders);
this.relationFK_Orders_Companies = new global::System.Data.DataRelation("FK_Orders_Companies", new global::System.Data.DataColumn[] {
this.tableCompanies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CompanyIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Companies);
this.relationFK_Orders_Parent = new global::System.Data.DataRelation("FK_Orders_Parent", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ParentIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Parent);
this.relationFK_Orders_Currencies = new global::System.Data.DataRelation("FK_Orders_Currencies", new global::System.Data.DataColumn[] {
this.tableCurrencies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CurrencyIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Currencies);
this.relationFK_Items_Companies = new global::System.Data.DataRelation("FK_Items_Companies", new global::System.Data.DataColumn[] {
this.tableCompanies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.CompanyIDColumn}, false);
this.Relations.Add(this.relationFK_Items_Companies);
this.relationFK_OrderDetails_Reference = new global::System.Data.DataRelation("FK_OrderDetails_Reference", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.ReferenceIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Reference);
}
internal void InitVars(bool initTable) {
this.tableCurrencies = ((CurrenciesDataTable)(base.Tables["Currencies"]));
if ((initTable == true)) {
if ((this.tableCurrencies != null)) {
this.tableCurrencies.InitVars();
}
}
this.tableItems = ((ItemsDataTable)(base.Tables["Items"]));
if ((initTable == true)) {
if ((this.tableItems != null)) {
this.tableItems.InitVars();
}
}
this.tableUnitMeasures = ((UnitMeasuresDataTable)(base.Tables["UnitMeasures"]));
if ((initTable == true)) {
if ((this.tableUnitMeasures != null)) {
this.tableUnitMeasures.InitVars();
}
}
this.tableWarehouses = ((WarehousesDataTable)(base.Tables["Warehouses"]));
if ((initTable == true)) {
if ((this.tableWarehouses != null)) {
this.tableWarehouses.InitVars();
}
}
this.tableCompanies = ((CompaniesDataTable)(base.Tables["Companies"]));
if ((initTable == true)) {
if ((this.tableCompanies != null)) {
this.tableCompanies.InitVars();
}
}
this.tableItemInventories = ((ItemInventoriesDataTable)(base.Tables["ItemInventories"]));
if ((initTable == true)) {
if ((this.tableItemInventories != null)) {
this.tableItemInventories.InitVars();
}
}
this.tableOrderDetails = ((OrderDetailsDataTable)(base.Tables["OrderDetails"]));
if ((initTable == true)) {
if ((this.tableOrderDetails != null)) {
this.tableOrderDetails.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableItemCategories = ((ItemCategoriesDataTable)(base.Tables["ItemCategories"]));
if ((initTable == true)) {
if ((this.tableItemCategories != null)) {
this.tableItemCategories.InitVars();
}
}
this.relationFK_Items_Categories = this.Relations["FK_Items_Categories"];
this.relationFK_Items_UnitMeasures = this.Relations["FK_Items_UnitMeasures"];
this.relationFK_ItemInventories_Items = this.Relations["FK_ItemInventories_Items"];
this.relationFK_ItemInventories_Warehouse = this.Relations["FK_ItemInventories_Warehouse"];
this.relationFK_OrderDetails_Items = this.Relations["FK_OrderDetails_Items"];
this.relationFK_OrderDetails_Orders = this.Relations["FK_OrderDetails_Orders"];
this.relationFK_Orders_Companies = this.Relations["FK_Orders_Companies"];
this.relationFK_Orders_Parent = this.Relations["FK_Orders_Parent"];
this.relationFK_Orders_Currencies = this.Relations["FK_Orders_Currencies"];
this.relationFK_Items_Companies = this.Relations["FK_Items_Companies"];
this.relationFK_OrderDetails_Reference = this.Relations["FK_OrderDetails_Reference"];
}
internal ItemsRow(System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableItems = ((ItemsDataTable)(this.Table));
}
public ProductService(ItemsDataTable db)
{
_db = db;
}
private void InitClass() {
this.DataSetName = "KitchenPrintDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/KitchenPrintDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableItems = new ItemsDataTable();
base.Tables.Add(this.tableItems);
}
internal void InitVars(bool initTable) {
this.tableItems = ((ItemsDataTable)(base.Tables["Items"]));
if ((initTable == true)) {
if ((this.tableItems != null)) {
this.tableItems.InitVars();
}
}
}