private void InitClass()
{
this.DataSetName = "BookDataSet";
this.Prefix = "";
this.Namespace = "urn:apress-proadonet-chapter5-BookDataSet.xsd";
this.EnforceConstraints = true;
this.tableBooks = new BooksDataTable();
base.Tables.Add(this.tableBooks);
this.tableBookReviews = new BookReviewsDataTable();
base.Tables.Add(this.tableBookReviews);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("Reviews", new System.Data.DataColumn[] {
this.tableBooks.BookIDColumn
}, new System.Data.DataColumn[] {
this.tableBookReviews.BookIDColumn
});
this.tableBookReviews.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationReviews = new System.Data.DataRelation("Reviews", new System.Data.DataColumn[] {
this.tableBooks.BookIDColumn
}, new System.Data.DataColumn[] {
this.tableBookReviews.BookIDColumn
}, false);
this.relationReviews.ExtendedProperties.Add("typedChildren", "Reviews");
this.relationReviews.ExtendedProperties.Add("typedParent", "Book");
this.Relations.Add(this.relationReviews);
}
private void InitClass()
{
this.DataSetName = "vistaForm";
this.Prefix = "";
this.Namespace = "http://tempuri.org/VistaDettSpeseIncassi.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableexpenselinkedproceeds = new expenselinkedproceedsDataTable();
base.Tables.Add(this.tableexpenselinkedproceeds);
this.tablelinkedexpense = new linkedexpenseDataTable();
base.Tables.Add(this.tablelinkedexpense);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("vistaFormKey2", new System.Data.DataColumn[] {
this.tablelinkedexpense.idlinkedexpenseColumn
}, new System.Data.DataColumn[] {
this.tableexpenselinkedproceeds.idlinkedexpenseColumn
});
this.tableexpenselinkedproceeds.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationlinkedexpenseexpenselinkedproceeds = new System.Data.DataRelation("linkedexpenseexpenselinkedproceeds", new System.Data.DataColumn[] {
this.tablelinkedexpense.idlinkedexpenseColumn
}, new System.Data.DataColumn[] {
this.tableexpenselinkedproceeds.idlinkedexpenseColumn
}, false);
this.Relations.Add(this.relationlinkedexpenseexpenselinkedproceeds);
}
private void InitClass()
{
this.DataSetName = "ResxData";
this.Prefix = "";
this.Namespace = "http://tempuri.org/ResxData.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableResx = new ResxDataTable();
base.Tables.Add(this.tableResx);
this.tableResxLocalized = new ResxLocalizedDataTable();
base.Tables.Add(this.tableResxLocalized);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("FK_Resx_ResxLocalized", new System.Data.DataColumn[] {
this.tableResx.IdColumn
}, new System.Data.DataColumn[] {
this.tableResxLocalized.ParentIdColumn
});
this.tableResxLocalized.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationFK_Resx_ResxLocalized = new System.Data.DataRelation("FK_Resx_ResxLocalized", new System.Data.DataColumn[] {
this.tableResx.IdColumn
}, new System.Data.DataColumn[] {
this.tableResxLocalized.ParentIdColumn
}, false);
this.Relations.Add(this.relationFK_Resx_ResxLocalized);
}
private void InitClass()
{
this.DataSetName = "QuestionAnswerSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/QuestionAnswerSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableAnswers = new AnswersDataTable();
base.Tables.Add(this.tableAnswers);
this.tableQuestions = new QuestionsDataTable();
base.Tables.Add(this.tableQuestions);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("QuestionsAnswers", new System.Data.DataColumn[] {
this.tableQuestions.IdColumn
}, new System.Data.DataColumn[] {
this.tableAnswers.QuestionIdColumn
});
this.tableAnswers.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationQuestionsAnswers = new System.Data.DataRelation("QuestionsAnswers", new System.Data.DataColumn[] {
this.tableQuestions.IdColumn
}, new System.Data.DataColumn[] {
this.tableAnswers.QuestionIdColumn
}, false);
this.Relations.Add(this.relationQuestionsAnswers);
}
private void InitClass()
{
this.DataSetName = "ParentChildDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/ParentChildDataSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableTreeNodes = new TreeNodesDataTable();
base.Tables.Add(this.tableTreeNodes);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("FK_TreeNodes_ParentTreeNodes", new System.Data.DataColumn[] {
this.tableTreeNodes.TreeNodeIDColumn
}, new System.Data.DataColumn[] {
this.tableTreeNodes.ParentTreeNodeIDColumn
});
this.tableTreeNodes.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.None;
this.relationFK_TreeNodes_ParentTreeNodes = new System.Data.DataRelation("FK_TreeNodes_ParentTreeNodes", new System.Data.DataColumn[] {
this.tableTreeNodes.TreeNodeIDColumn
}, new System.Data.DataColumn[] {
this.tableTreeNodes.ParentTreeNodeIDColumn
}, false);
this.relationFK_TreeNodes_ParentTreeNodes.Nested = true;
this.Relations.Add(this.relationFK_TreeNodes_ParentTreeNodes);
this.ExtendedProperties.Add("DSGenerator_DataSetName", "ParentChildDataSet");
this.ExtendedProperties.Add("User_DataSetName", "ParentChildDataSet");
}
private void LoadData()
{
taskDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events WHERE ID=" + id, connection);
alertsDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events_alerts WHERE event_id=" + id, connection);
dataSet = new System.Data.DataSet();
var taskCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(taskDataAdapter);
var alertsCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(alertsDataAdapter);
taskDataAdapter.Fill(dataSet, "event");
alertsDataAdapter.Fill(dataSet, "alerts");
var parentColumn = dataSet.Tables["event"].Columns["ID"];
{
var childColumn = dataSet.Tables["alerts"].Columns["event_id"];
var relation = new System.Data.DataRelation("event_alerts", parentColumn, childColumn);
dataSet.Relations.Add(relation);
}
//var table = dataSet.Tables["event"];
row = dataSet.Tables["event"].Rows[0];
dataSet.Tables["event"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowDeleted += table_RowDeleted;
dataSet.Tables["alerts"].TableNewRow += table_TableNewRow;
FillDeadline(row);
FillTags(id);
TaskGrid.DataContext = dataSet.Tables["event"].DefaultView;
AlertsDataGrid.ItemsSource = dataSet.Tables["alerts"].DefaultView;
}
private void InitClass()
{
this.DataSetName = "Tasks";
this.Prefix = "";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableTask = new TaskDataTable();
base.Tables.Add(this.tableTask);
this.tableSchedule = new ScheduleDataTable();
base.Tables.Add(this.tableSchedule);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("Task_Schedule", new System.Data.DataColumn[] {
this.tableTask.Task_IdColumn
}, new System.Data.DataColumn[] {
this.tableSchedule.Task_IdColumn
});
this.tableSchedule.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationTask_Schedule = new System.Data.DataRelation("Task_Schedule", new System.Data.DataColumn[] {
this.tableTask.Task_IdColumn
}, new System.Data.DataColumn[] {
this.tableSchedule.Task_IdColumn
}, false);
this.relationTask_Schedule.Nested = true;
this.Relations.Add(this.relationTask_Schedule);
}
public static System.Data.DataRelation AddRelation(System.Data.DataColumn ParentColumn, System.Data.DataColumn ChildColumn, string Filter)
{
System.Data.DataRelation dataRel = new System.Data.DataRelation(string.Format("{0}_{1}_{2}_{3}", ParentColumn.ColumnName, ParentColumn.Table.TableName, ChildColumn.ColumnName, ChildColumn.Table.TableName),
ParentColumn, ChildColumn, false);
dataRel.ExtendedProperties.Add(DataRelation.RealtionFilterExtendedPropertyName, Filter);
ParentColumn.Table.DataSet.Relations.Add(dataRel);
return dataRel;
}
internal void InitVars(bool initTable)
{
this.tableTreeNodes = ((TreeNodesDataTable)(base.Tables["TreeNodes"]));
if ((initTable == true))
{
if ((this.tableTreeNodes != null))
{
this.tableTreeNodes.InitVars();
}
}
this.relationFK_TreeNodes_ParentTreeNodes = this.Relations["FK_TreeNodes_ParentTreeNodes"];
}
public IDictionary <string, string> Execute(IEnumerable <LinkedService> linkedServices, IEnumerable <Dataset> datasets, Activity activity, IActivityLogger logger)
{
var inDS = Helper.DatasetHelper.GetInputDataset(activity, linkedServices, datasets);
var outDS = Helper.DatasetHelper.GetOutputDatasetShell(activity, linkedServices, datasets);
//Settings:
//MergeC# : C#
//OutputColName: T#C#
List <System.Data.DataColumn> lstParentColumns = new List <System.Data.DataColumn>();
List <System.Data.DataColumn> lstChildColumns = new List <System.Data.DataColumn>();
//Build column relationship list
foreach (var mergeSetting in ((DotNetActivity)(activity.TypeProperties)).ExtendedProperties.Where(ep => ep.Key.Contains("Merge")))
{
lstParentColumns.Add(inDS.Tables[0].Columns[int.Parse(mergeSetting.Key.Replace("MergeC", ""))]);
lstChildColumns.Add(inDS.Tables[1].Columns[int.Parse(mergeSetting.Value.Replace("C", ""))]);
}
System.Data.DataRelation dr = new System.Data.DataRelation("Merge", lstParentColumns.ToArray(), lstChildColumns.ToArray(), false);
inDS.Relations.Add(dr);
//Loop the child, not the parent
foreach (System.Data.DataRow r in inDS.Tables[1].Rows)
{
System.Data.DataRow lstOutRow = outDS.Tables[0].NewRow();
foreach (var colSetting in ((DotNetActivity)(activity.TypeProperties)).ExtendedProperties.Where(ep => !ep.Key.Contains("Merge") && !ep.Key.Contains("SliceStart")))
{
if (colSetting.Value.Contains("T1"))
{
lstOutRow[colSetting.Key] = r[int.Parse(colSetting.Value.Replace("T1C", ""))];
}
else
{
lstOutRow[colSetting.Key] = r.GetParentRow("Merge")[int.Parse(colSetting.Value.Replace("T0C", ""))];
}
}
outDS.Tables[0].Rows.Add(lstOutRow);
}
Helper.DatasetHelper.WriteOutputDataset(activity, linkedServices, datasets, outDS);
return(new Dictionary <string, string>());
}
private void InitClass()
{
this.DataSetName = "testdbDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/testdbDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableDataTable1 = new DataTable1DataTable();
base.Tables.Add(this.tableDataTable1);
this.tableDataTable2 = new DataTable2DataTable();
base.Tables.Add(this.tableDataTable2);
this.relationDataTable2_DataTable1 = new System.Data.DataRelation("DataTable2_DataTable1", new System.Data.DataColumn[] {
this.tableDataTable2.Column1Column
}, new System.Data.DataColumn[] {
this.tableDataTable1.Column1Column
}, false);
this.Relations.Add(this.relationDataTable2_DataTable1);
}
private void InitClass()
{
this.DataSetName = "BatchRunDS";
this.Prefix = "";
this.Namespace = "http://tempuri.org/BatchRunDS.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableScriptsList = new ScriptsListDataTable();
base.Tables.Add(this.tableScriptsList);
this.tableBatch = new BatchDataTable();
base.Tables.Add(this.tableBatch);
this.relationBatch_ScriptsList = new System.Data.DataRelation("Batch_ScriptsList", new System.Data.DataColumn[] {
this.tableBatch.BatchIdColumn
}, new System.Data.DataColumn[] {
this.tableScriptsList.BatchIdColumn
}, false);
this.Relations.Add(this.relationBatch_ScriptsList);
}
internal void InitVars(bool initTable)
{
this.tableAnswers = ((AnswersDataTable)(base.Tables["Answers"]));
if ((initTable == true))
{
if ((this.tableAnswers != null))
{
this.tableAnswers.InitVars();
}
}
this.tableQuestions = ((QuestionsDataTable)(base.Tables["Questions"]));
if ((initTable == true))
{
if ((this.tableQuestions != null))
{
this.tableQuestions.InitVars();
}
}
this.relationQuestionsAnswers = this.Relations["QuestionsAnswers"];
}
internal void InitVars(bool initTable)
{
this.tableDataTable1 = ((DataTable1DataTable)(base.Tables["DataTable1"]));
if ((initTable == true))
{
if ((this.tableDataTable1 != null))
{
this.tableDataTable1.InitVars();
}
}
this.tableDataTable2 = ((DataTable2DataTable)(base.Tables["DataTable2"]));
if ((initTable == true))
{
if ((this.tableDataTable2 != null))
{
this.tableDataTable2.InitVars();
}
}
this.relationDataTable2_DataTable1 = this.Relations["DataTable2_DataTable1"];
}
internal void InitVars(bool initTable)
{
this.tableScriptsList = ((ScriptsListDataTable)(base.Tables["ScriptsList"]));
if ((initTable == true))
{
if ((this.tableScriptsList != null))
{
this.tableScriptsList.InitVars();
}
}
this.tableBatch = ((BatchDataTable)(base.Tables["Batch"]));
if ((initTable == true))
{
if ((this.tableBatch != null))
{
this.tableBatch.InitVars();
}
}
this.relationBatch_ScriptsList = this.Relations["Batch_ScriptsList"];
}
internal void InitVars(bool initTable)
{
this.tableResx = ((ResxDataTable)(base.Tables["Resx"]));
if ((initTable == true))
{
if ((this.tableResx != null))
{
this.tableResx.InitVars();
}
}
this.tableResxLocalized = ((ResxLocalizedDataTable)(base.Tables["ResxLocalized"]));
if ((initTable == true))
{
if ((this.tableResxLocalized != null))
{
this.tableResxLocalized.InitVars();
}
}
this.relationFK_Resx_ResxLocalized = this.Relations["FK_Resx_ResxLocalized"];
}
internal void InitVars(bool initTable)
{
this.tableTask = ((TaskDataTable)(base.Tables["Task"]));
if ((initTable == true))
{
if ((this.tableTask != null))
{
this.tableTask.InitVars();
}
}
this.tableSchedule = ((ScheduleDataTable)(base.Tables["Schedule"]));
if ((initTable == true))
{
if ((this.tableSchedule != null))
{
this.tableSchedule.InitVars();
}
}
this.relationTask_Schedule = this.Relations["Task_Schedule"];
}
internal void InitVars(bool initTable)
{
this.tableexpenselinkedproceeds = ((expenselinkedproceedsDataTable)(base.Tables["expenselinkedproceeds"]));
if ((initTable == true))
{
if ((this.tableexpenselinkedproceeds != null))
{
this.tableexpenselinkedproceeds.InitVars();
}
}
this.tablelinkedexpense = ((linkedexpenseDataTable)(base.Tables["linkedexpense"]));
if ((initTable == true))
{
if ((this.tablelinkedexpense != null))
{
this.tablelinkedexpense.InitVars();
}
}
this.relationlinkedexpenseexpenselinkedproceeds = this.Relations["linkedexpenseexpenselinkedproceeds"];
}
internal void InitVars(bool initTable)
{
this.tableBooks = ((BooksDataTable)(base.Tables["Books"]));
if ((initTable == true))
{
if ((this.tableBooks != null))
{
this.tableBooks.InitVars();
}
}
this.tableBookReviews = ((BookReviewsDataTable)(base.Tables["BookReviews"]));
if ((initTable == true))
{
if ((this.tableBookReviews != null))
{
this.tableBookReviews.InitVars();
}
}
this.relationReviews = this.Relations["Reviews"];
}
private void InitClass() {
this.DataSetName = "MDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/MDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCash = new CashDataTable();
base.Tables.Add(this.tableCash);
this.tableDocumentType = new DocumentTypeDataTable();
base.Tables.Add(this.tableDocumentType);
this.tableInvoiceMaster = new InvoiceMasterDataTable();
base.Tables.Add(this.tableInvoiceMaster);
this.tableInvoiceDetail = new InvoiceDetailDataTable(false);
base.Tables.Add(this.tableInvoiceDetail);
this.tablePeriods = new PeriodsDataTable();
base.Tables.Add(this.tablePeriods);
this.tableReceiptDetail = new ReceiptDetailDataTable(false);
base.Tables.Add(this.tableReceiptDetail);
this.tableReceiptMaster = new ReceiptMasterDataTable();
base.Tables.Add(this.tableReceiptMaster);
this.tableReceiptRemains = new ReceiptRemainsDataTable();
base.Tables.Add(this.tableReceiptRemains);
this.tableProduct = new ProductDataTable();
base.Tables.Add(this.tableProduct);
this.tableRemains = new RemainsDataTable(false);
base.Tables.Add(this.tableRemains);
this.tableStock = new StockDataTable();
base.Tables.Add(this.tableStock);
this.tableLocalSetting = new LocalSettingDataTable();
base.Tables.Add(this.tableLocalSetting);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableinventoryMaster = new inventoryMasterDataTable();
base.Tables.Add(this.tableinventoryMaster);
this.tableinventoryDetails = new inventoryDetailsDataTable(false);
base.Tables.Add(this.tableinventoryDetails);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] {
this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.InvoiceMasterRefColumn});
this.tableInvoiceDetail.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("Remains_InvoiceDetail", new System.Data.DataColumn[] {
this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.LocalReceiptDetailRefColumn});
this.tableInvoiceDetail.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.None;
fkc = new System.Data.ForeignKeyConstraint("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] {
this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableinventoryDetails.inventoryMasterRefColumn});
this.tableinventoryDetails.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] {
this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.InvoiceMasterRefColumn}, false);
this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster);
this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] {
this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationRemains_InvoiceDetail);
this.relationFK_inventoryMaster_inventoryDetails = new System.Data.DataRelation("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] {
this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableinventoryDetails.inventoryMasterRefColumn}, false);
this.Relations.Add(this.relationFK_inventoryMaster_inventoryDetails);
this.relationFK_ReceiptDetail_ReceiptMaster = new System.Data.DataRelation("FK_ReceiptDetail_ReceiptMaster", new System.Data.DataColumn[] {
this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.ReceiptMasterRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptDetail_ReceiptMaster);
this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] {
this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptMaster.DocumentTypeRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType);
this.relationFK_InvoiceDetail_ReceiptRemains = new System.Data.DataRelation("FK_InvoiceDetail_ReceiptRemains", new System.Data.DataColumn[] {
this.tableReceiptRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationFK_InvoiceDetail_ReceiptRemains);
this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptMaster.MainStockRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptMaster_Stock);
this.relationFK_ReceiptMaster_Stock1 = new System.Data.DataRelation("FK_ReceiptMaster_Stock1", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptMaster.SenderStockRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptMaster_Stock1);
this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] {
this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, false);
this.Relations.Add(this.relationReceiptDetail_Remains);
this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_ReceiptDetail);
this.relationInvoiceDetail_Product = new System.Data.DataRelation("InvoiceDetail_Product", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.ProductRefColumn}, false);
this.Relations.Add(this.relationInvoiceDetail_Product);
this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_Orders);
this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableRemains.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_Remains);
}
private void InitClass() {
this.DataSetName = "FbcFoodBankDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/FbcFoodBankDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableContacts = new ContactsDataTable();
base.Tables.Add(this.tableContacts);
this.tableVisits = new VisitsDataTable();
base.Tables.Add(this.tableVisits);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("Reference", new System.Data.DataColumn[] {
this.tableContacts.NameColumn}, new System.Data.DataColumn[] {
this.tableVisits.NameColumn});
this.tableVisits.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.Cascade;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationReference = new System.Data.DataRelation("Reference", new System.Data.DataColumn[] {
this.tableContacts.NameColumn}, new System.Data.DataColumn[] {
this.tableVisits.NameColumn}, false);
this.Relations.Add(this.relationReference);
}
internal void InitVars(bool initTable) {
this.tableCash = ((CashDataTable)(base.Tables["Cash"]));
if ((initTable == true)) {
if ((this.tableCash != null)) {
this.tableCash.InitVars();
}
}
this.tableDocumentType = ((DocumentTypeDataTable)(base.Tables["DocumentType"]));
if ((initTable == true)) {
if ((this.tableDocumentType != null)) {
this.tableDocumentType.InitVars();
}
}
this.tableInvoiceMaster = ((InvoiceMasterDataTable)(base.Tables["InvoiceMaster"]));
if ((initTable == true)) {
if ((this.tableInvoiceMaster != null)) {
this.tableInvoiceMaster.InitVars();
}
}
this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"]));
if ((initTable == true)) {
if ((this.tableInvoiceDetail != null)) {
this.tableInvoiceDetail.InitVars();
}
}
this.tablePeriods = ((PeriodsDataTable)(base.Tables["Periods"]));
if ((initTable == true)) {
if ((this.tablePeriods != null)) {
this.tablePeriods.InitVars();
}
}
this.tableReceiptDetail = ((ReceiptDetailDataTable)(base.Tables["ReceiptDetail"]));
if ((initTable == true)) {
if ((this.tableReceiptDetail != null)) {
this.tableReceiptDetail.InitVars();
}
}
this.tableReceiptMaster = ((ReceiptMasterDataTable)(base.Tables["ReceiptMaster"]));
if ((initTable == true)) {
if ((this.tableReceiptMaster != null)) {
this.tableReceiptMaster.InitVars();
}
}
this.tableReceiptRemains = ((ReceiptRemainsDataTable)(base.Tables["ReceiptRemains"]));
if ((initTable == true)) {
if ((this.tableReceiptRemains != null)) {
this.tableReceiptRemains.InitVars();
}
}
this.tableProduct = ((ProductDataTable)(base.Tables["Product"]));
if ((initTable == true)) {
if ((this.tableProduct != null)) {
this.tableProduct.InitVars();
}
}
this.tableRemains = ((RemainsDataTable)(base.Tables["Remains"]));
if ((initTable == true)) {
if ((this.tableRemains != null)) {
this.tableRemains.InitVars();
}
}
this.tableStock = ((StockDataTable)(base.Tables["Stock"]));
if ((initTable == true)) {
if ((this.tableStock != null)) {
this.tableStock.InitVars();
}
}
this.tableLocalSetting = ((LocalSettingDataTable)(base.Tables["LocalSetting"]));
if ((initTable == true)) {
if ((this.tableLocalSetting != null)) {
this.tableLocalSetting.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableinventoryMaster = ((inventoryMasterDataTable)(base.Tables["inventoryMaster"]));
if ((initTable == true)) {
if ((this.tableinventoryMaster != null)) {
this.tableinventoryMaster.InitVars();
}
}
this.tableinventoryDetails = ((inventoryDetailsDataTable)(base.Tables["inventoryDetails"]));
if ((initTable == true)) {
if ((this.tableinventoryDetails != null)) {
this.tableinventoryDetails.InitVars();
}
}
this.relationFK_InvoiceDetail_InvoiceMaster = this.Relations["FK_InvoiceDetail_InvoiceMaster"];
this.relationRemains_InvoiceDetail = this.Relations["Remains_InvoiceDetail"];
this.relationFK_inventoryMaster_inventoryDetails = this.Relations["FK_inventoryMaster_inventoryDetails"];
this.relationFK_ReceiptDetail_ReceiptMaster = this.Relations["FK_ReceiptDetail_ReceiptMaster"];
this.relationFK_ReceiptMaster_DocumentType = this.Relations["FK_ReceiptMaster_DocumentType"];
this.relationFK_InvoiceDetail_ReceiptRemains = this.Relations["FK_InvoiceDetail_ReceiptRemains"];
this.relationFK_ReceiptMaster_Stock = this.Relations["FK_ReceiptMaster_Stock"];
this.relationFK_ReceiptMaster_Stock1 = this.Relations["FK_ReceiptMaster_Stock1"];
this.relationReceiptDetail_Remains = this.Relations["ReceiptDetail_Remains"];
this.relationProduct_ReceiptDetail = this.Relations["Product_ReceiptDetail"];
this.relationInvoiceDetail_Product = this.Relations["InvoiceDetail_Product"];
this.relationProduct_Orders = this.Relations["Product_Orders"];
this.relationProduct_Remains = this.Relations["Product_Remains"];
}
private void InitClass() {
this.DataSetName = "other_ds";
this.Prefix = "";
this.Namespace = "http://tempuri.org/other_ds.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tabletblIller = new tblIllerDataTable();
base.Tables.Add(this.tabletblIller);
this.tabletblSaglikTesisiList = new tblSaglikTesisiListDataTable();
base.Tables.Add(this.tabletblSaglikTesisiList);
this.tablest_iller = new st_illerDataTable();
base.Tables.Add(this.tablest_iller);
this.tablest_kamu_ozel = new st_kamu_ozelDataTable();
base.Tables.Add(this.tablest_kamu_ozel);
this.tablest_tesis_turleri = new st_tesis_turleriDataTable();
base.Tables.Add(this.tablest_tesis_turleri);
this.tablest_tesisler = new st_tesislerDataTable();
base.Tables.Add(this.tablest_tesisler);
this.tabletblDoktorList = new tblDoktorListDataTable();
base.Tables.Add(this.tabletblDoktorList);
this.relationst_iller_st_tesisler = new System.Data.DataRelation("st_iller_st_tesisler", new System.Data.DataColumn[] {
this.tablest_iller.ridColumn}, new System.Data.DataColumn[] {
this.tablest_tesisler.ILIColumn}, false);
this.Relations.Add(this.relationst_iller_st_tesisler);
this.relationst_tesis_turleri_st_tesisler = new System.Data.DataRelation("st_tesis_turleri_st_tesisler", new System.Data.DataColumn[] {
this.tablest_tesis_turleri.ridColumn}, new System.Data.DataColumn[] {
this.tablest_tesisler.TESISTURUColumn}, false);
this.Relations.Add(this.relationst_tesis_turleri_st_tesisler);
this.relationst_kamu_ozel_st_tesisler = new System.Data.DataRelation("st_kamu_ozel_st_tesisler", new System.Data.DataColumn[] {
this.tablest_kamu_ozel.ridColumn}, new System.Data.DataColumn[] {
this.tablest_tesisler.KAMOZColumn}, false);
this.Relations.Add(this.relationst_kamu_ozel_st_tesisler);
}
internal void InitVars(bool initTable) {
this.tableContacts = ((ContactsDataTable)(base.Tables["Contacts"]));
if ((initTable == true)) {
if ((this.tableContacts != null)) {
this.tableContacts.InitVars();
}
}
this.tableVisits = ((VisitsDataTable)(base.Tables["Visits"]));
if ((initTable == true)) {
if ((this.tableVisits != null)) {
this.tableVisits.InitVars();
}
}
this.relationReference = this.Relations["Reference"];
}
internal void InitVars(bool initTable) {
this.tabletbl_TaniBlg = ((tbl_TaniBlgDataTable)(base.Tables["tbl_TaniBlg"]));
if ((initTable == true)) {
if ((this.tabletbl_TaniBlg != null)) {
this.tabletbl_TaniBlg.InitVars();
}
}
this.tabletblKonsultasyonBilgisi = ((tblKonsultasyonBilgisiDataTable)(base.Tables["tblKonsultasyonBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblKonsultasyonBilgisi != null)) {
this.tabletblKonsultasyonBilgisi.InitVars();
}
}
this.tabletbkBranj = ((tbkBranjDataTable)(base.Tables["tbkBranj"]));
if ((initTable == true)) {
if ((this.tabletbkBranj != null)) {
this.tabletbkBranj.InitVars();
}
}
this.tabletbkHastaYatisBilgisi = ((tbkHastaYatisBilgisiDataTable)(base.Tables["tbkHastaYatisBilgisi"]));
if ((initTable == true)) {
if ((this.tabletbkHastaYatisBilgisi != null)) {
this.tabletbkHastaYatisBilgisi.InitVars();
}
}
this.tabletblDisBilgisi = ((tblDisBilgisiDataTable)(base.Tables["tblDisBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblDisBilgisi != null)) {
this.tabletblDisBilgisi.InitVars();
}
}
this.tabletblAmeliyatveGirisimBilgisi = ((tblAmeliyatveGirisimBilgisiDataTable)(base.Tables["tblAmeliyatveGirisimBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblAmeliyatveGirisimBilgisi != null)) {
this.tabletblAmeliyatveGirisimBilgisi.InitVars();
}
}
this.tabletblTetkikveRadyolojiBilgisi = ((tblTetkikveRadyolojiBilgisiDataTable)(base.Tables["tblTetkikveRadyolojiBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblTetkikveRadyolojiBilgisi != null)) {
this.tabletblTetkikveRadyolojiBilgisi.InitVars();
}
}
this.tabletbkTahlilBilgisi = ((tbkTahlilBilgisiDataTable)(base.Tables["tbkTahlilBilgisi"]));
if ((initTable == true)) {
if ((this.tabletbkTahlilBilgisi != null)) {
this.tabletbkTahlilBilgisi.InitVars();
}
}
this.tabletblDigerIslemBilgileri = ((tblDigerIslemBilgileriDataTable)(base.Tables["tblDigerIslemBilgileri"]));
if ((initTable == true)) {
if ((this.tabletblDigerIslemBilgileri != null)) {
this.tabletblDigerIslemBilgileri.InitVars();
}
}
this.tabletblIlacBilgisi = ((tblIlacBilgisiDataTable)(base.Tables["tblIlacBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblIlacBilgisi != null)) {
this.tabletblIlacBilgisi.InitVars();
}
}
this.tabletblMalzemeBilgileri = ((tblMalzemeBilgileriDataTable)(base.Tables["tblMalzemeBilgileri"]));
if ((initTable == true)) {
if ((this.tabletblMalzemeBilgileri != null)) {
this.tabletblMalzemeBilgileri.InitVars();
}
}
this.tabletblRaporBilgileri = ((tblRaporBilgileriDataTable)(base.Tables["tblRaporBilgileri"]));
if ((initTable == true)) {
if ((this.tabletblRaporBilgileri != null)) {
this.tabletblRaporBilgileri.InitVars();
}
}
this.tabletblOdemeSorguHataBilgisi = ((tblOdemeSorguHataBilgisiDataTable)(base.Tables["tblOdemeSorguHataBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblOdemeSorguHataBilgisi != null)) {
this.tabletblOdemeSorguHataBilgisi.InitVars();
}
}
this.tabletblIslemFiyatBilgisi = ((tblIslemFiyatBilgisiDataTable)(base.Tables["tblIslemFiyatBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblIslemFiyatBilgisi != null)) {
this.tabletblIslemFiyatBilgisi.InitVars();
}
}
this.tabletblHastaTakipList = ((tblHastaTakipListDataTable)(base.Tables["tblHastaTakipList"]));
if ((initTable == true)) {
if ((this.tabletblHastaTakipList != null)) {
this.tabletblHastaTakipList.InitVars();
}
}
this.tabletblFaturaBilgisi = ((tblFaturaBilgisiDataTable)(base.Tables["tblFaturaBilgisi"]));
if ((initTable == true)) {
if ((this.tabletblFaturaBilgisi != null)) {
this.tabletblFaturaBilgisi.InitVars();
}
}
this.tabletblFaturaHataliKayit = ((tblFaturaHataliKayitDataTable)(base.Tables["tblFaturaHataliKayit"]));
if ((initTable == true)) {
if ((this.tabletblFaturaHataliKayit != null)) {
this.tabletblFaturaHataliKayit.InitVars();
}
}
this.tabletblFaturaBasariliKayit = ((tblFaturaBasariliKayitDataTable)(base.Tables["tblFaturaBasariliKayit"]));
if ((initTable == true)) {
if ((this.tabletblFaturaBasariliKayit != null)) {
this.tabletblFaturaBasariliKayit.InitVars();
}
}
this.tabletblTakipNumaralari = ((tblTakipNumaralariDataTable)(base.Tables["tblTakipNumaralari"]));
if ((initTable == true)) {
if ((this.tabletblTakipNumaralari != null)) {
this.tabletblTakipNumaralari.InitVars();
}
}
this.relationtbkBranj_tblKonsultasyonBilgisi = this.Relations["tbkBranj_tblKonsultasyonBilgisi"];
this.relationtbkBranj_tbkHastaYatisBilgisi = this.Relations["tbkBranj_tbkHastaYatisBilgisi"];
this.relationtbkBranj_tblAmeliyatveGirisimBilgisi = this.Relations["tbkBranj_tblAmeliyatveGirisimBilgisi"];
this.relationtbkBranj_tblTetkikveRadyolojiBilgisi = this.Relations["tbkBranj_tblTetkikveRadyolojiBilgisi"];
this.relationtbkBranj_tbkTahlilBilgisi = this.Relations["tbkBranj_tbkTahlilBilgisi"];
this.relationtbkBranj_tblDigerIslemBilgileri = this.Relations["tbkBranj_tblDigerIslemBilgileri"];
}
internal void InitVars(bool initTable) {
this.tabledoa = ((doaDataTable)(base.Tables["doa"]));
if ((initTable == true)) {
if ((this.tabledoa != null)) {
this.tabledoa.InitVars();
}
}
this.tablefaghare = ((faghareDataTable)(base.Tables["faghare"]));
if ((initTable == true)) {
if ((this.tablefaghare != null)) {
this.tablefaghare.InitVars();
}
}
this.tabletext = ((textDataTable)(base.Tables["text"]));
if ((initTable == true)) {
if ((this.tabletext != null)) {
this.tabletext.InitVars();
}
}
this.tableword = ((wordDataTable)(base.Tables["word"]));
if ((initTable == true)) {
if ((this.tableword != null)) {
this.tableword.InitVars();
}
}
this.tableword1 = ((word1DataTable)(base.Tables["word1"]));
if ((initTable == true)) {
if ((this.tableword1 != null)) {
this.tableword1.InitVars();
}
}
this.relationdoafaghare = this.Relations["doafaghare"];
this.relationfagharetext = this.Relations["fagharetext"];
this.relationtextword = this.Relations["textword"];
this.relationtextword1 = this.Relations["textword1"];
}
private void LoadData()
{
taskDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM tasks WHERE ID=" + id, connection);
alertsDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM tasks_alerts WHERE task_id=" + id, connection);
subTasksDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT ID, child_of, name FROM tasks WHERE child_of=" + id, connection);
dataSet = new System.Data.DataSet();
var taskCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(taskDataAdapter);
var alertsCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(alertsDataAdapter);
var subTasksCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(subTasksDataAdapter);
taskDataAdapter.Fill(dataSet, "task");
taskDataAdapter.AcceptChangesDuringUpdate = true;
alertsDataAdapter.Fill(dataSet, "alerts");
alertsDataAdapter.AcceptChangesDuringUpdate = true;
subTasksDataAdapter.Fill(dataSet, "sub_tasks");
subTasksDataAdapter.AcceptChangesDuringUpdate = true;
var parentColumn = dataSet.Tables["task"].Columns["ID"];
{
var childColumn = dataSet.Tables["alerts"].Columns["task_id"];
var relation = new System.Data.DataRelation("task_alerts", parentColumn, childColumn);
dataSet.Relations.Add(relation);
}
{
var childColumn = dataSet.Tables["sub_tasks"].Columns["child_of"];
var relation = new System.Data.DataRelation("task_sub_tasks", parentColumn, childColumn);
dataSet.Relations.Add(relation);
}
row = dataSet.Tables["task"].Rows[0];
dataSet.Tables["task"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowDeleted += table_RowDeleted;
dataSet.Tables["alerts"].TableNewRow += table_TableNewRow;
dataSet.Tables["sub_tasks"].RowChanged += table_RowChanged;
dataSet.Tables["sub_tasks"].RowDeleted += table_RowDeleted;
dataSet.Tables["sub_tasks"].TableNewRow += table_TableNewRow;
FillDeadline(row);
FillTags(id);
TaskGrid.DataContext = dataSet.Tables["task"].DefaultView;
AlertsDataGrid.ItemsSource = dataSet.Tables["alerts"].DefaultView;
SubTasksDataGrid.ItemsSource = dataSet.Tables["sub_tasks"].DefaultView;
FillPrioritiesComboBox();
}
internal void InitVars(bool initTable) {
this.tableCountry = ((CountryDataTable)(base.Tables["Country"]));
if ((initTable == true)) {
if ((this.tableCountry != null)) {
this.tableCountry.InitVars();
}
}
this.tableDocumentType = ((DocumentTypeDataTable)(base.Tables["DocumentType"]));
if ((initTable == true)) {
if ((this.tableDocumentType != null)) {
this.tableDocumentType.InitVars();
}
}
this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"]));
if ((initTable == true)) {
if ((this.tableInvoiceDetail != null)) {
this.tableInvoiceDetail.InitVars();
}
}
this.tableInvoiceMaster = ((InvoiceMasterDataTable)(base.Tables["InvoiceMaster"]));
if ((initTable == true)) {
if ((this.tableInvoiceMaster != null)) {
this.tableInvoiceMaster.InitVars();
}
}
this.tableOrganization = ((OrganizationDataTable)(base.Tables["Organization"]));
if ((initTable == true)) {
if ((this.tableOrganization != null)) {
this.tableOrganization.InitVars();
}
}
this.tableReceiptRemains = ((ReceiptRemainsDataTable)(base.Tables["ReceiptRemains"]));
if ((initTable == true)) {
if ((this.tableReceiptRemains != null)) {
this.tableReceiptRemains.InitVars();
}
}
this.tableStock = ((StockDataTable)(base.Tables["Stock"]));
if ((initTable == true)) {
if ((this.tableStock != null)) {
this.tableStock.InitVars();
}
}
this.tableTradePutlet = ((TradePutletDataTable)(base.Tables["TradePutlet"]));
if ((initTable == true)) {
if ((this.tableTradePutlet != null)) {
this.tableTradePutlet.InitVars();
}
}
this.tableReceiptMaster = ((ReceiptMasterDataTable)(base.Tables["ReceiptMaster"]));
if ((initTable == true)) {
if ((this.tableReceiptMaster != null)) {
this.tableReceiptMaster.InitVars();
}
}
this.tableReceiptDetail = ((ReceiptDetailDataTable)(base.Tables["ReceiptDetail"]));
if ((initTable == true)) {
if ((this.tableReceiptDetail != null)) {
this.tableReceiptDetail.InitVars();
}
}
this.tableStorageCondition = ((StorageConditionDataTable)(base.Tables["StorageCondition"]));
if ((initTable == true)) {
if ((this.tableStorageCondition != null)) {
this.tableStorageCondition.InitVars();
}
}
this.tableProduct = ((ProductDataTable)(base.Tables["Product"]));
if ((initTable == true)) {
if ((this.tableProduct != null)) {
this.tableProduct.InitVars();
}
}
this.tableFarmGroup = ((FarmGroupDataTable)(base.Tables["FarmGroup"]));
if ((initTable == true)) {
if ((this.tableFarmGroup != null)) {
this.tableFarmGroup.InitVars();
}
}
this.tablePacking = ((PackingDataTable)(base.Tables["Packing"]));
if ((initTable == true)) {
if ((this.tablePacking != null)) {
this.tablePacking.InitVars();
}
}
this.tableSubstance = ((SubstanceDataTable)(base.Tables["Substance"]));
if ((initTable == true)) {
if ((this.tableSubstance != null)) {
this.tableSubstance.InitVars();
}
}
this.tableUnit = ((UnitDataTable)(base.Tables["Unit"]));
if ((initTable == true)) {
if ((this.tableUnit != null)) {
this.tableUnit.InitVars();
}
}
this.tableManufacturer = ((ManufacturerDataTable)(base.Tables["Manufacturer"]));
if ((initTable == true)) {
if ((this.tableManufacturer != null)) {
this.tableManufacturer.InitVars();
}
}
this.tableFarmGroupLevel2 = ((FarmGroupLevel2DataTable)(base.Tables["FarmGroupLevel2"]));
if ((initTable == true)) {
if ((this.tableFarmGroupLevel2 != null)) {
this.tableFarmGroupLevel2.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableRemains = ((RemainsDataTable)(base.Tables["Remains"]));
if ((initTable == true)) {
if ((this.tableRemains != null)) {
this.tableRemains.InitVars();
}
}
this.tablePricesPurchase = ((PricesPurchaseDataTable)(base.Tables["PricesPurchase"]));
if ((initTable == true)) {
if ((this.tablePricesPurchase != null)) {
this.tablePricesPurchase.InitVars();
}
}
this.tablePeriods = ((PeriodsDataTable)(base.Tables["Periods"]));
if ((initTable == true)) {
if ((this.tablePeriods != null)) {
this.tablePeriods.InitVars();
}
}
this.tableLinkedInvoiceDetail = ((LinkedInvoiceDetailDataTable)(base.Tables["LinkedInvoiceDetail"]));
if ((initTable == true)) {
if ((this.tableLinkedInvoiceDetail != null)) {
this.tableLinkedInvoiceDetail.InitVars();
}
}
this.tableLinkedInvoiceMaster = ((LinkedInvoiceMasterDataTable)(base.Tables["LinkedInvoiceMaster"]));
if ((initTable == true)) {
if ((this.tableLinkedInvoiceMaster != null)) {
this.tableLinkedInvoiceMaster.InitVars();
}
}
this.tableReceiptDetailAdding = ((ReceiptDetailAddingDataTable)(base.Tables["ReceiptDetailAdding"]));
if ((initTable == true)) {
if ((this.tableReceiptDetailAdding != null)) {
this.tableReceiptDetailAdding.InitVars();
}
}
this.relationFK_InvoiceMaster_StockMain = this.Relations["FK_InvoiceMaster_StockMain"];
this.relationFK_Stock_InvoiceMaster = this.Relations["FK_Stock_InvoiceMaster"];
this.relationFK_ReceiptRemains_ReceiptDetail = this.Relations["FK_ReceiptRemains_ReceiptDetail"];
this.relationReceiptMaster_ReceiptDetail = this.Relations["ReceiptMaster_ReceiptDetail"];
this.relationFK_Substance_Product = this.Relations["FK_Substance_Product"];
this.relationFK_Unit_Product = this.Relations["FK_Unit_Product"];
this.relationFK_FarmGroupLevel2_Product = this.Relations["FK_FarmGroupLevel2_Product"];
this.relationFK_FarmGroup_FarmGroupLevel2 = this.Relations["FK_FarmGroup_FarmGroupLevel2"];
this.relationFK_ReceiptDetailAdding_ReceiptDetail = this.Relations["FK_ReceiptDetailAdding_ReceiptDetail"];
this.relationFK_InvoiceDetail_InvoiceMaster = this.Relations["FK_InvoiceDetail_InvoiceMaster"];
this.relationFK_InvoiceMaster_Organization = this.Relations["FK_InvoiceMaster_Organization"];
this.relationFK_ReceiptMaster_DocumentType = this.Relations["FK_ReceiptMaster_DocumentType"];
this.relationFK_ReceiptMaster_Organization = this.Relations["FK_ReceiptMaster_Organization"];
this.relationFK_ReceiptMaster_Stock = this.Relations["FK_ReceiptMaster_Stock"];
this.relationStorageCondition_Product = this.Relations["StorageCondition_Product"];
this.relationFK_Packing_Product = this.Relations["FK_Packing_Product"];
this.relationReceiptDetail_Orders = this.Relations["ReceiptDetail_Orders"];
this.relationProduct_Remains = this.Relations["Product_Remains"];
this.relationProduct_Orders = this.Relations["Product_Orders"];
this.relationTradePutlet_Orders = this.Relations["TradePutlet_Orders"];
this.relationOrganization_PricesPurchase = this.Relations["Organization_PricesPurchase"];
this.relationProduct_PricesPurchase = this.Relations["Product_PricesPurchase"];
this.relationReceiptDetail_PricesPurchase = this.Relations["ReceiptDetail_PricesPurchase"];
this.relationReceiptDetail_InvoiceDetail = this.Relations["ReceiptDetail_InvoiceDetail"];
this.relationReceiptDetail_Remains = this.Relations["ReceiptDetail_Remains"];
this.relationTradePutlet_Stock = this.Relations["TradePutlet_Stock"];
this.relationProduct_ReceiptDetail = this.Relations["Product_ReceiptDetail"];
this.relationFK_Manufacturer_ReceiptDetail = this.Relations["FK_Manufacturer_ReceiptDetail"];
this.relationLinkedInvoiceMaster_LinkedInvoiceDetail = this.Relations["LinkedInvoiceMaster_LinkedInvoiceDetail"];
this.relationFK_Country_Manufacturer = this.Relations["FK_Country_Manufacturer"];
this.relationRemains_InvoiceDetail = this.Relations["Remains_InvoiceDetail"];
}
internal void InitVars(bool initTable) {
this.tableConfigurations = ((ConfigurationsDataTable)(base.Tables["Configurations"]));
if ((initTable == true)) {
if ((this.tableConfigurations != null)) {
this.tableConfigurations.InitVars();
}
}
this.tabledeviceKeys = ((deviceKeysDataTable)(base.Tables["deviceKeys"]));
if ((initTable == true)) {
if ((this.tabledeviceKeys != null)) {
this.tabledeviceKeys.InitVars();
}
}
this.tableDevices = ((DevicesDataTable)(base.Tables["Devices"]));
if ((initTable == true)) {
if ((this.tableDevices != null)) {
this.tableDevices.InitVars();
}
}
this.tableLearnedKeys = ((LearnedKeysDataTable)(base.Tables["LearnedKeys"]));
if ((initTable == true)) {
if ((this.tableLearnedKeys != null)) {
this.tableLearnedKeys.InitVars();
}
}
this.tableUsers = ((UsersDataTable)(base.Tables["Users"]));
if ((initTable == true)) {
if ((this.tableUsers != null)) {
this.tableUsers.InitVars();
}
}
this.relationFK_deviceKeys_Devices = this.Relations["FK_deviceKeys_Devices"];
this.relationFK_deviceKeys_LearnedKeys = this.Relations["FK_deviceKeys_LearnedKeys"];
this.relationFK_Devices_Configurations = this.Relations["FK_Devices_Configurations"];
this.relationFK_LearnedKeys_Devices = this.Relations["FK_LearnedKeys_Devices"];
}
private void InitClass() {
this.DataSetName = "test_oneWZDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/test_oneWZDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableConfigurations = new ConfigurationsDataTable();
base.Tables.Add(this.tableConfigurations);
this.tabledeviceKeys = new deviceKeysDataTable();
base.Tables.Add(this.tabledeviceKeys);
this.tableDevices = new DevicesDataTable();
base.Tables.Add(this.tableDevices);
this.tableLearnedKeys = new LearnedKeysDataTable();
base.Tables.Add(this.tableLearnedKeys);
this.tableUsers = new UsersDataTable();
base.Tables.Add(this.tableUsers);
this.relationFK_deviceKeys_Devices = new System.Data.DataRelation("FK_deviceKeys_Devices", new System.Data.DataColumn[] {
this.tableDevices.UserIDColumn,
this.tableDevices.ConfigIDColumn,
this.tableDevices.DeviceIDColumn}, new System.Data.DataColumn[] {
this.tabledeviceKeys.UserIDColumn,
this.tabledeviceKeys.ConfigIDColumn,
this.tabledeviceKeys.DeviceIDColumn}, false);
this.Relations.Add(this.relationFK_deviceKeys_Devices);
this.relationFK_deviceKeys_LearnedKeys = new System.Data.DataRelation("FK_deviceKeys_LearnedKeys", new System.Data.DataColumn[] {
this.tableLearnedKeys.UserIDColumn,
this.tableLearnedKeys.ConfigIDColumn,
this.tableLearnedKeys.DeviceIDColumn,
this.tableLearnedKeys.LearnedIDColumn}, new System.Data.DataColumn[] {
this.tabledeviceKeys.UserIDColumn,
this.tabledeviceKeys.ConfigIDColumn,
this.tabledeviceKeys.DeviceIDColumn,
this.tabledeviceKeys.LearnedIDColumn}, false);
this.Relations.Add(this.relationFK_deviceKeys_LearnedKeys);
this.relationFK_Devices_Configurations = new System.Data.DataRelation("FK_Devices_Configurations", new System.Data.DataColumn[] {
this.tableConfigurations.UserIDColumn,
this.tableConfigurations.ConfigIDColumn}, new System.Data.DataColumn[] {
this.tableDevices.UserIDColumn,
this.tableDevices.ConfigIDColumn}, false);
this.Relations.Add(this.relationFK_Devices_Configurations);
this.relationFK_LearnedKeys_Devices = new System.Data.DataRelation("FK_LearnedKeys_Devices", new System.Data.DataColumn[] {
this.tableDevices.UserIDColumn,
this.tableDevices.ConfigIDColumn,
this.tableDevices.DeviceIDColumn}, new System.Data.DataColumn[] {
this.tableLearnedKeys.UserIDColumn,
this.tableLearnedKeys.ConfigIDColumn,
this.tableLearnedKeys.DeviceIDColumn}, false);
this.Relations.Add(this.relationFK_LearnedKeys_Devices);
}
internal void InitVars(bool initTable) {
this.tableFact = ((FactDataTable)(base.Tables["Fact"]));
if ((initTable == true)) {
if ((this.tableFact != null)) {
this.tableFact.InitVars();
}
}
this.tableWhat = ((WhatDataTable)(base.Tables["What"]));
if ((initTable == true)) {
if ((this.tableWhat != null)) {
this.tableWhat.InitVars();
}
}
this.tableWhere = ((WhereDataTable)(base.Tables["Where"]));
if ((initTable == true)) {
if ((this.tableWhere != null)) {
this.tableWhere.InitVars();
}
}
this.tableWhen = ((WhenDataTable)(base.Tables["When"]));
if ((initTable == true)) {
if ((this.tableWhen != null)) {
this.tableWhen.InitVars();
}
}
this.relationFK_What_Fact = this.Relations["FK_What_Fact"];
this.relationFK_Where_Fact = this.Relations["FK_Where_Fact"];
this.relationFK_When_Fact = this.Relations["FK_When_Fact"];
}
internal void InitVars(bool initTable) {
this.tableSPR_IZG = ((SPR_IZGDataTable)(base.Tables["SPR_IZG"]));
if ((initTable == true)) {
if ((this.tableSPR_IZG != null)) {
this.tableSPR_IZG.InitVars();
}
}
this.tableSPR_TOV = ((SPR_TOVDataTable)(base.Tables["SPR_TOV"]));
if ((initTable == true)) {
if ((this.tableSPR_TOV != null)) {
this.tableSPR_TOV.InitVars();
}
}
this.relationSPR_IZG_SPR_TOV = this.Relations["SPR_IZG_SPR_TOV"];
}
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.relationCustOrders = this.Relations["CustOrders"];
}
private void InitClass() {
this.DataSetName = "MDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/MDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCountry = new CountryDataTable();
base.Tables.Add(this.tableCountry);
this.tableDocumentType = new DocumentTypeDataTable();
base.Tables.Add(this.tableDocumentType);
this.tableInvoiceDetail = new InvoiceDetailDataTable(false);
base.Tables.Add(this.tableInvoiceDetail);
this.tableInvoiceMaster = new InvoiceMasterDataTable(false);
base.Tables.Add(this.tableInvoiceMaster);
this.tableOrganization = new OrganizationDataTable(false);
base.Tables.Add(this.tableOrganization);
this.tableReceiptRemains = new ReceiptRemainsDataTable();
base.Tables.Add(this.tableReceiptRemains);
this.tableStock = new StockDataTable(false);
base.Tables.Add(this.tableStock);
this.tableTradePutlet = new TradePutletDataTable();
base.Tables.Add(this.tableTradePutlet);
this.tableReceiptMaster = new ReceiptMasterDataTable(false);
base.Tables.Add(this.tableReceiptMaster);
this.tableReceiptDetail = new ReceiptDetailDataTable(false);
base.Tables.Add(this.tableReceiptDetail);
this.tableStorageCondition = new StorageConditionDataTable(false);
base.Tables.Add(this.tableStorageCondition);
this.tableProduct = new ProductDataTable(false);
base.Tables.Add(this.tableProduct);
this.tableFarmGroup = new FarmGroupDataTable();
base.Tables.Add(this.tableFarmGroup);
this.tablePacking = new PackingDataTable();
base.Tables.Add(this.tablePacking);
this.tableSubstance = new SubstanceDataTable();
base.Tables.Add(this.tableSubstance);
this.tableUnit = new UnitDataTable();
base.Tables.Add(this.tableUnit);
this.tableManufacturer = new ManufacturerDataTable(false);
base.Tables.Add(this.tableManufacturer);
this.tableFarmGroupLevel2 = new FarmGroupLevel2DataTable(false);
base.Tables.Add(this.tableFarmGroupLevel2);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableRemains = new RemainsDataTable(false);
base.Tables.Add(this.tableRemains);
this.tablePricesPurchase = new PricesPurchaseDataTable(false);
base.Tables.Add(this.tablePricesPurchase);
this.tablePeriods = new PeriodsDataTable(false);
base.Tables.Add(this.tablePeriods);
this.tableLinkedInvoiceDetail = new LinkedInvoiceDetailDataTable();
base.Tables.Add(this.tableLinkedInvoiceDetail);
this.tableLinkedInvoiceMaster = new LinkedInvoiceMasterDataTable();
base.Tables.Add(this.tableLinkedInvoiceMaster);
this.tableReceiptDetailAdding = new ReceiptDetailAddingDataTable();
base.Tables.Add(this.tableReceiptDetailAdding);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceMaster_StockMain", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceMaster.MainStockRefColumn});
this.tableInvoiceMaster.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_Stock_InvoiceMaster", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceMaster.RemoteStockRefColumn});
this.tableInvoiceMaster.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_ReceiptRemains_ReceiptDetail", new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptRemains.ReceiptDetailRefColumn});
this.tableReceiptRemains.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("ReceiptMaster_ReceiptDetail", new System.Data.DataColumn[] {
this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.ReceiptMasterRefColumn});
this.tableReceiptDetail.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_Substance_Product", new System.Data.DataColumn[] {
this.tableSubstance.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.SubstanceRefColumn});
this.tableProduct.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_Unit_Product", new System.Data.DataColumn[] {
this.tableUnit.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.UnitRefColumn});
this.tableProduct.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_FarmGroupLevel2_Product", new System.Data.DataColumn[] {
this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.FarmGrouplevel2RefColumn});
this.tableProduct.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_FarmGroup_FarmGroupLevel2", new System.Data.DataColumn[] {
this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] {
this.tableFarmGroupLevel2.FarmGroupRefColumn});
this.tableFarmGroupLevel2.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("FK_ReceiptDetailAdding_ReceiptDetail", new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetailAdding.ReceiptDetailRefColumn});
this.tableReceiptDetailAdding.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationFK_InvoiceMaster_StockMain = new System.Data.DataRelation("FK_InvoiceMaster_StockMain", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceMaster.MainStockRefColumn}, false);
this.Relations.Add(this.relationFK_InvoiceMaster_StockMain);
this.relationFK_Stock_InvoiceMaster = new System.Data.DataRelation("FK_Stock_InvoiceMaster", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceMaster.RemoteStockRefColumn}, false);
this.Relations.Add(this.relationFK_Stock_InvoiceMaster);
this.relationFK_ReceiptRemains_ReceiptDetail = new System.Data.DataRelation("FK_ReceiptRemains_ReceiptDetail", new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptRemains.ReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptRemains_ReceiptDetail);
this.relationReceiptMaster_ReceiptDetail = new System.Data.DataRelation("ReceiptMaster_ReceiptDetail", new System.Data.DataColumn[] {
this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.ReceiptMasterRefColumn}, false);
this.Relations.Add(this.relationReceiptMaster_ReceiptDetail);
this.relationFK_Substance_Product = new System.Data.DataRelation("FK_Substance_Product", new System.Data.DataColumn[] {
this.tableSubstance.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.SubstanceRefColumn}, false);
this.Relations.Add(this.relationFK_Substance_Product);
this.relationFK_Unit_Product = new System.Data.DataRelation("FK_Unit_Product", new System.Data.DataColumn[] {
this.tableUnit.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.UnitRefColumn}, false);
this.Relations.Add(this.relationFK_Unit_Product);
this.relationFK_FarmGroupLevel2_Product = new System.Data.DataRelation("FK_FarmGroupLevel2_Product", new System.Data.DataColumn[] {
this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.FarmGrouplevel2RefColumn}, false);
this.Relations.Add(this.relationFK_FarmGroupLevel2_Product);
this.relationFK_FarmGroup_FarmGroupLevel2 = new System.Data.DataRelation("FK_FarmGroup_FarmGroupLevel2", new System.Data.DataColumn[] {
this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] {
this.tableFarmGroupLevel2.FarmGroupRefColumn}, false);
this.Relations.Add(this.relationFK_FarmGroup_FarmGroupLevel2);
this.relationFK_ReceiptDetailAdding_ReceiptDetail = new System.Data.DataRelation("FK_ReceiptDetailAdding_ReceiptDetail", new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetailAdding.ReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptDetailAdding_ReceiptDetail);
this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] {
this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.InvoiceMasterRefColumn}, false);
this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster);
this.relationFK_InvoiceMaster_Organization = new System.Data.DataRelation("FK_InvoiceMaster_Organization", new System.Data.DataColumn[] {
this.tableOrganization.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceMaster.OrganisationRefColumn}, false);
this.Relations.Add(this.relationFK_InvoiceMaster_Organization);
this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] {
this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptMaster.DocumentTypeRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType);
this.relationFK_ReceiptMaster_Organization = new System.Data.DataRelation("FK_ReceiptMaster_Organization", new System.Data.DataColumn[] {
this.tableOrganization.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptMaster.OrganizationRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptMaster_Organization);
this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] {
this.tableStock.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptMaster.MainStockRefColumn}, false);
this.Relations.Add(this.relationFK_ReceiptMaster_Stock);
this.relationStorageCondition_Product = new System.Data.DataRelation("StorageCondition_Product", new System.Data.DataColumn[] {
this.tableStorageCondition.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.StorageConditionRefColumn}, false);
this.Relations.Add(this.relationStorageCondition_Product);
this.relationFK_Packing_Product = new System.Data.DataRelation("FK_Packing_Product", new System.Data.DataColumn[] {
this.tablePacking.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.PackingRefColumn}, false);
this.Relations.Add(this.relationFK_Packing_Product);
this.relationReceiptDetail_Orders = new System.Data.DataRelation("ReceiptDetail_Orders", new System.Data.DataColumn[] {
this.tableReceiptDetail.ProductRefColumn}, new System.Data.DataColumn[] {
this.tableOrders.ProductRefColumn}, false);
this.Relations.Add(this.relationReceiptDetail_Orders);
this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableRemains.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_Remains);
this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_Orders);
this.relationTradePutlet_Orders = new System.Data.DataRelation("TradePutlet_Orders", new System.Data.DataColumn[] {
this.tableTradePutlet.IDColumn}, new System.Data.DataColumn[] {
this.tableOrders.TradePupletRefColumn}, false);
this.Relations.Add(this.relationTradePutlet_Orders);
this.relationOrganization_PricesPurchase = new System.Data.DataRelation("Organization_PricesPurchase", new System.Data.DataColumn[] {
this.tableOrganization.IDColumn}, new System.Data.DataColumn[] {
this.tablePricesPurchase.OrganizationRefColumn}, false);
this.Relations.Add(this.relationOrganization_PricesPurchase);
this.relationProduct_PricesPurchase = new System.Data.DataRelation("Product_PricesPurchase", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tablePricesPurchase.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_PricesPurchase);
this.relationReceiptDetail_PricesPurchase = new System.Data.DataRelation("ReceiptDetail_PricesPurchase", new System.Data.DataColumn[] {
this.tableReceiptDetail.ProductRefColumn}, new System.Data.DataColumn[] {
this.tablePricesPurchase.ProductRefColumn}, false);
this.Relations.Add(this.relationReceiptDetail_PricesPurchase);
this.relationReceiptDetail_InvoiceDetail = new System.Data.DataRelation("ReceiptDetail_InvoiceDetail", new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationReceiptDetail_InvoiceDetail);
this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] {
this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
this.tableRemains.ReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationReceiptDetail_Remains);
this.relationTradePutlet_Stock = new System.Data.DataRelation("TradePutlet_Stock", new System.Data.DataColumn[] {
this.tableTradePutlet.IDColumn}, new System.Data.DataColumn[] {
this.tableStock.TradePutletRefColumn}, false);
this.Relations.Add(this.relationTradePutlet_Stock);
this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] {
this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.ProductRefColumn}, false);
this.Relations.Add(this.relationProduct_ReceiptDetail);
this.relationFK_Manufacturer_ReceiptDetail = new System.Data.DataRelation("FK_Manufacturer_ReceiptDetail", new System.Data.DataColumn[] {
this.tableManufacturer.IDColumn}, new System.Data.DataColumn[] {
this.tableReceiptDetail.ManufacturerRefColumn}, false);
this.Relations.Add(this.relationFK_Manufacturer_ReceiptDetail);
this.relationLinkedInvoiceMaster_LinkedInvoiceDetail = new System.Data.DataRelation("LinkedInvoiceMaster_LinkedInvoiceDetail", new System.Data.DataColumn[] {
this.tableLinkedInvoiceMaster.TradePutletRefColumn,
this.tableLinkedInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
this.tableLinkedInvoiceDetail.TradePutletRefColumn,
this.tableLinkedInvoiceDetail.InvoiceMasterRefColumn}, false);
this.Relations.Add(this.relationLinkedInvoiceMaster_LinkedInvoiceDetail);
this.relationFK_Country_Manufacturer = new System.Data.DataRelation("FK_Country_Manufacturer", new System.Data.DataColumn[] {
this.tableCountry.IDColumn}, new System.Data.DataColumn[] {
this.tableManufacturer.CounrtyRefColumn}, false);
this.Relations.Add(this.relationFK_Country_Manufacturer);
this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] {
this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
this.Relations.Add(this.relationRemains_InvoiceDetail);
}
private void InitClass() {
this.DataSetName = "NosSiteMapDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/NosSiteMapDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableRaiz = new RaizDataTable();
base.Tables.Add(this.tableRaiz);
this.tableNo = new NoDataTable();
base.Tables.Add(this.tableNo);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("Raiz_No", new System.Data.DataColumn[] {
this.tableRaiz.CodigoColumn}, new System.Data.DataColumn[] {
this.tableNo.CodigoRaizColumn});
this.tableNo.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.None;
fkc.UpdateRule = System.Data.Rule.None;
this.relationRaiz_No = new System.Data.DataRelation("Raiz_No", new System.Data.DataColumn[] {
this.tableRaiz.CodigoColumn}, new System.Data.DataColumn[] {
this.tableNo.CodigoRaizColumn}, false);
this.Relations.Add(this.relationRaiz_No);
}
internal void InitVars(bool initTable) {
this.tableProduct = ((ProductDataTable)(base.Tables["Product"]));
if ((initTable == true)) {
if ((this.tableProduct != null)) {
this.tableProduct.InitVars();
}
}
this.tableCountry = ((CountryDataTable)(base.Tables["Country"]));
if ((initTable == true)) {
if ((this.tableCountry != null)) {
this.tableCountry.InitVars();
}
}
this.tableFarmGroup = ((FarmGroupDataTable)(base.Tables["FarmGroup"]));
if ((initTable == true)) {
if ((this.tableFarmGroup != null)) {
this.tableFarmGroup.InitVars();
}
}
this.tableFarmGroupLevel2 = ((FarmGroupLevel2DataTable)(base.Tables["FarmGroupLevel2"]));
if ((initTable == true)) {
if ((this.tableFarmGroupLevel2 != null)) {
this.tableFarmGroupLevel2.InitVars();
}
}
this.tableManufacturer = ((ManufacturerDataTable)(base.Tables["Manufacturer"]));
if ((initTable == true)) {
if ((this.tableManufacturer != null)) {
this.tableManufacturer.InitVars();
}
}
this.tablePacking = ((PackingDataTable)(base.Tables["Packing"]));
if ((initTable == true)) {
if ((this.tablePacking != null)) {
this.tablePacking.InitVars();
}
}
this.tableStorageCondition = ((StorageConditionDataTable)(base.Tables["StorageCondition"]));
if ((initTable == true)) {
if ((this.tableStorageCondition != null)) {
this.tableStorageCondition.InitVars();
}
}
this.tableUnit = ((UnitDataTable)(base.Tables["Unit"]));
if ((initTable == true)) {
if ((this.tableUnit != null)) {
this.tableUnit.InitVars();
}
}
this.tableSubstance = ((SubstanceDataTable)(base.Tables["Substance"]));
if ((initTable == true)) {
if ((this.tableSubstance != null)) {
this.tableSubstance.InitVars();
}
}
this.relationFK_Product_FarmGroupLevel2 = this.Relations["FK_Product_FarmGroupLevel2"];
this.relationFK_FarmGroupLevel2_FarmGroup = this.Relations["FK_FarmGroupLevel2_FarmGroup"];
this.relationFK_Manufacturer_Country = this.Relations["FK_Manufacturer_Country"];
this.relationFK_Product_Packing = this.Relations["FK_Product_Packing"];
this.relationFK_Product_StorageCondition = this.Relations["FK_Product_StorageCondition"];
this.relationFK_Product_Unit = this.Relations["FK_Product_Unit"];
this.relationFK_Product_Substance = this.Relations["FK_Product_Substance"];
}
private void InitClass() {
this.DataSetName = "sahifehDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/sahifehDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tabledoa = new doaDataTable();
base.Tables.Add(this.tabledoa);
this.tablefaghare = new faghareDataTable();
base.Tables.Add(this.tablefaghare);
this.tabletext = new textDataTable();
base.Tables.Add(this.tabletext);
this.tableword = new wordDataTable();
base.Tables.Add(this.tableword);
this.tableword1 = new word1DataTable();
base.Tables.Add(this.tableword1);
this.relationdoafaghare = new System.Data.DataRelation("doafaghare", new System.Data.DataColumn[] {
this.tabledoa.idColumn}, new System.Data.DataColumn[] {
this.tablefaghare.doaColumn}, false);
this.Relations.Add(this.relationdoafaghare);
this.relationfagharetext = new System.Data.DataRelation("fagharetext", new System.Data.DataColumn[] {
this.tablefaghare.idColumn}, new System.Data.DataColumn[] {
this.tabletext.faghareColumn}, false);
this.Relations.Add(this.relationfagharetext);
this.relationtextword = new System.Data.DataRelation("textword", new System.Data.DataColumn[] {
this.tabletext.idColumn}, new System.Data.DataColumn[] {
this.tableword.textColumn}, false);
this.Relations.Add(this.relationtextword);
this.relationtextword1 = new System.Data.DataRelation("textword1", new System.Data.DataColumn[] {
this.tabletext.idColumn}, new System.Data.DataColumn[] {
this.tableword1.textColumn}, false);
this.Relations.Add(this.relationtextword1);
}
private void InitClass() {
this.DataSetName = "FullDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/FullDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableProduct = new ProductDataTable();
base.Tables.Add(this.tableProduct);
this.tableCountry = new CountryDataTable();
base.Tables.Add(this.tableCountry);
this.tableFarmGroup = new FarmGroupDataTable();
base.Tables.Add(this.tableFarmGroup);
this.tableFarmGroupLevel2 = new FarmGroupLevel2DataTable(false);
base.Tables.Add(this.tableFarmGroupLevel2);
this.tableManufacturer = new ManufacturerDataTable(false);
base.Tables.Add(this.tableManufacturer);
this.tablePacking = new PackingDataTable();
base.Tables.Add(this.tablePacking);
this.tableStorageCondition = new StorageConditionDataTable();
base.Tables.Add(this.tableStorageCondition);
this.tableUnit = new UnitDataTable();
base.Tables.Add(this.tableUnit);
this.tableSubstance = new SubstanceDataTable();
base.Tables.Add(this.tableSubstance);
this.relationFK_Product_FarmGroupLevel2 = new System.Data.DataRelation("FK_Product_FarmGroupLevel2", new System.Data.DataColumn[] {
this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.FarmGrouplevel2RefColumn}, false);
this.Relations.Add(this.relationFK_Product_FarmGroupLevel2);
this.relationFK_FarmGroupLevel2_FarmGroup = new System.Data.DataRelation("FK_FarmGroupLevel2_FarmGroup", new System.Data.DataColumn[] {
this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] {
this.tableFarmGroupLevel2.FarmGroupRefColumn}, false);
this.Relations.Add(this.relationFK_FarmGroupLevel2_FarmGroup);
this.relationFK_Manufacturer_Country = new System.Data.DataRelation("FK_Manufacturer_Country", new System.Data.DataColumn[] {
this.tableCountry.IDColumn}, new System.Data.DataColumn[] {
this.tableManufacturer.CounrtyRefColumn}, false);
this.Relations.Add(this.relationFK_Manufacturer_Country);
this.relationFK_Product_Packing = new System.Data.DataRelation("FK_Product_Packing", new System.Data.DataColumn[] {
this.tablePacking.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.PackingRefColumn}, false);
this.Relations.Add(this.relationFK_Product_Packing);
this.relationFK_Product_StorageCondition = new System.Data.DataRelation("FK_Product_StorageCondition", new System.Data.DataColumn[] {
this.tableStorageCondition.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.StorageConditionRefColumn}, false);
this.Relations.Add(this.relationFK_Product_StorageCondition);
this.relationFK_Product_Unit = new System.Data.DataRelation("FK_Product_Unit", new System.Data.DataColumn[] {
this.tableUnit.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.UnitRefColumn}, false);
this.Relations.Add(this.relationFK_Product_Unit);
this.relationFK_Product_Substance = new System.Data.DataRelation("FK_Product_Substance", new System.Data.DataColumn[] {
this.tableSubstance.IDColumn}, new System.Data.DataColumn[] {
this.tableProduct.SubstanceRefColumn}, false);
this.Relations.Add(this.relationFK_Product_Substance);
}
internal void InitVars(bool initTable) {
this.tabletblIller = ((tblIllerDataTable)(base.Tables["tblIller"]));
if ((initTable == true)) {
if ((this.tabletblIller != null)) {
this.tabletblIller.InitVars();
}
}
this.tabletblSaglikTesisiList = ((tblSaglikTesisiListDataTable)(base.Tables["tblSaglikTesisiList"]));
if ((initTable == true)) {
if ((this.tabletblSaglikTesisiList != null)) {
this.tabletblSaglikTesisiList.InitVars();
}
}
this.tablest_iller = ((st_illerDataTable)(base.Tables["st_iller"]));
if ((initTable == true)) {
if ((this.tablest_iller != null)) {
this.tablest_iller.InitVars();
}
}
this.tablest_kamu_ozel = ((st_kamu_ozelDataTable)(base.Tables["st_kamu_ozel"]));
if ((initTable == true)) {
if ((this.tablest_kamu_ozel != null)) {
this.tablest_kamu_ozel.InitVars();
}
}
this.tablest_tesis_turleri = ((st_tesis_turleriDataTable)(base.Tables["st_tesis_turleri"]));
if ((initTable == true)) {
if ((this.tablest_tesis_turleri != null)) {
this.tablest_tesis_turleri.InitVars();
}
}
this.tablest_tesisler = ((st_tesislerDataTable)(base.Tables["st_tesisler"]));
if ((initTable == true)) {
if ((this.tablest_tesisler != null)) {
this.tablest_tesisler.InitVars();
}
}
this.tabletblDoktorList = ((tblDoktorListDataTable)(base.Tables["tblDoktorList"]));
if ((initTable == true)) {
if ((this.tabletblDoktorList != null)) {
this.tabletblDoktorList.InitVars();
}
}
this.relationst_iller_st_tesisler = this.Relations["st_iller_st_tesisler"];
this.relationst_tesis_turleri_st_tesisler = this.Relations["st_tesis_turleri_st_tesisler"];
this.relationst_kamu_ozel_st_tesisler = this.Relations["st_kamu_ozel_st_tesisler"];
}
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 = "Facts";
this.Prefix = "";
this.Namespace = "urn:www.genetibase.com:Facts";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableFact = new FactDataTable();
base.Tables.Add(this.tableFact);
this.tableWhat = new WhatDataTable();
base.Tables.Add(this.tableWhat);
this.tableWhere = new WhereDataTable();
base.Tables.Add(this.tableWhere);
this.tableWhen = new WhenDataTable();
base.Tables.Add(this.tableWhen);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("FK_What_Fact", new System.Data.DataColumn[] {
this.tableWhat.IDColumn}, new System.Data.DataColumn[] {
this.tableFact.WhatColumn});
this.tableFact.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("FK_Where_Fact", new System.Data.DataColumn[] {
this.tableWhere.IDColumn}, new System.Data.DataColumn[] {
this.tableFact.WhereColumn});
this.tableFact.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("FK_When_Fact", new System.Data.DataColumn[] {
this.tableWhen.IDColumn}, new System.Data.DataColumn[] {
this.tableFact.WhenColumn});
this.tableFact.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationFK_What_Fact = new System.Data.DataRelation("FK_What_Fact", new System.Data.DataColumn[] {
this.tableWhat.IDColumn}, new System.Data.DataColumn[] {
this.tableFact.WhatColumn}, false);
this.Relations.Add(this.relationFK_What_Fact);
this.relationFK_Where_Fact = new System.Data.DataRelation("FK_Where_Fact", new System.Data.DataColumn[] {
this.tableWhere.IDColumn}, new System.Data.DataColumn[] {
this.tableFact.WhereColumn}, false);
this.Relations.Add(this.relationFK_Where_Fact);
this.relationFK_When_Fact = new System.Data.DataRelation("FK_When_Fact", new System.Data.DataColumn[] {
this.tableWhen.IDColumn}, new System.Data.DataColumn[] {
this.tableFact.WhenColumn}, false);
this.Relations.Add(this.relationFK_When_Fact);
}
private void InitClass() {
this.DataSetName = "c00_ds";
this.Prefix = "";
this.Namespace = "http://tempuri.org/c00_ds.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tabletbl_TaniBlg = new tbl_TaniBlgDataTable();
base.Tables.Add(this.tabletbl_TaniBlg);
this.tabletblKonsultasyonBilgisi = new tblKonsultasyonBilgisiDataTable();
base.Tables.Add(this.tabletblKonsultasyonBilgisi);
this.tabletbkBranj = new tbkBranjDataTable();
base.Tables.Add(this.tabletbkBranj);
this.tabletbkHastaYatisBilgisi = new tbkHastaYatisBilgisiDataTable();
base.Tables.Add(this.tabletbkHastaYatisBilgisi);
this.tabletblDisBilgisi = new tblDisBilgisiDataTable();
base.Tables.Add(this.tabletblDisBilgisi);
this.tabletblAmeliyatveGirisimBilgisi = new tblAmeliyatveGirisimBilgisiDataTable();
base.Tables.Add(this.tabletblAmeliyatveGirisimBilgisi);
this.tabletblTetkikveRadyolojiBilgisi = new tblTetkikveRadyolojiBilgisiDataTable();
base.Tables.Add(this.tabletblTetkikveRadyolojiBilgisi);
this.tabletbkTahlilBilgisi = new tbkTahlilBilgisiDataTable();
base.Tables.Add(this.tabletbkTahlilBilgisi);
this.tabletblDigerIslemBilgileri = new tblDigerIslemBilgileriDataTable();
base.Tables.Add(this.tabletblDigerIslemBilgileri);
this.tabletblIlacBilgisi = new tblIlacBilgisiDataTable();
base.Tables.Add(this.tabletblIlacBilgisi);
this.tabletblMalzemeBilgileri = new tblMalzemeBilgileriDataTable();
base.Tables.Add(this.tabletblMalzemeBilgileri);
this.tabletblRaporBilgileri = new tblRaporBilgileriDataTable();
base.Tables.Add(this.tabletblRaporBilgileri);
this.tabletblOdemeSorguHataBilgisi = new tblOdemeSorguHataBilgisiDataTable();
base.Tables.Add(this.tabletblOdemeSorguHataBilgisi);
this.tabletblIslemFiyatBilgisi = new tblIslemFiyatBilgisiDataTable();
base.Tables.Add(this.tabletblIslemFiyatBilgisi);
this.tabletblHastaTakipList = new tblHastaTakipListDataTable();
base.Tables.Add(this.tabletblHastaTakipList);
this.tabletblFaturaBilgisi = new tblFaturaBilgisiDataTable();
base.Tables.Add(this.tabletblFaturaBilgisi);
this.tabletblFaturaHataliKayit = new tblFaturaHataliKayitDataTable();
base.Tables.Add(this.tabletblFaturaHataliKayit);
this.tabletblFaturaBasariliKayit = new tblFaturaBasariliKayitDataTable();
base.Tables.Add(this.tabletblFaturaBasariliKayit);
this.tabletblTakipNumaralari = new tblTakipNumaralariDataTable();
base.Tables.Add(this.tabletblTakipNumaralari);
this.relationtbkBranj_tblKonsultasyonBilgisi = new System.Data.DataRelation("tbkBranj_tblKonsultasyonBilgisi", new System.Data.DataColumn[] {
this.tabletbkBranj.kodColumn}, new System.Data.DataColumn[] {
this.tabletblKonsultasyonBilgisi.bransKoduColumn}, false);
this.Relations.Add(this.relationtbkBranj_tblKonsultasyonBilgisi);
this.relationtbkBranj_tbkHastaYatisBilgisi = new System.Data.DataRelation("tbkBranj_tbkHastaYatisBilgisi", new System.Data.DataColumn[] {
this.tabletbkBranj.kodColumn}, new System.Data.DataColumn[] {
this.tabletbkHastaYatisBilgisi.bransKoduColumn}, false);
this.Relations.Add(this.relationtbkBranj_tbkHastaYatisBilgisi);
this.relationtbkBranj_tblAmeliyatveGirisimBilgisi = new System.Data.DataRelation("tbkBranj_tblAmeliyatveGirisimBilgisi", new System.Data.DataColumn[] {
this.tabletbkBranj.kodColumn}, new System.Data.DataColumn[] {
this.tabletblAmeliyatveGirisimBilgisi.bransKoduColumn}, false);
this.Relations.Add(this.relationtbkBranj_tblAmeliyatveGirisimBilgisi);
this.relationtbkBranj_tblTetkikveRadyolojiBilgisi = new System.Data.DataRelation("tbkBranj_tblTetkikveRadyolojiBilgisi", new System.Data.DataColumn[] {
this.tabletbkBranj.kodColumn}, new System.Data.DataColumn[] {
this.tabletblTetkikveRadyolojiBilgisi.bransKoduColumn}, false);
this.Relations.Add(this.relationtbkBranj_tblTetkikveRadyolojiBilgisi);
this.relationtbkBranj_tbkTahlilBilgisi = new System.Data.DataRelation("tbkBranj_tbkTahlilBilgisi", new System.Data.DataColumn[] {
this.tabletbkBranj.kodColumn}, new System.Data.DataColumn[] {
this.tabletbkTahlilBilgisi.bransKoduColumn}, false);
this.Relations.Add(this.relationtbkBranj_tbkTahlilBilgisi);
this.relationtbkBranj_tblDigerIslemBilgileri = new System.Data.DataRelation("tbkBranj_tblDigerIslemBilgileri", new System.Data.DataColumn[] {
this.tabletbkBranj.kodColumn}, new System.Data.DataColumn[] {
this.tabletblDigerIslemBilgileri.bransKoduColumn}, false);
this.Relations.Add(this.relationtbkBranj_tblDigerIslemBilgileri);
}
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 = "NorthwindCustomerOrders";
this.Prefix = "";
this.EnforceConstraints = true;
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("CustOrders", 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;
this.relationCustOrders = new System.Data.DataRelation("CustOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustOrders);
}
internal void InitVars(bool initTable) {
this.tableKeys = ((KeysDataTable)(base.Tables["Keys"]));
if ((initTable == true)) {
if ((this.tableKeys != null)) {
this.tableKeys.InitVars();
}
}
this.tableDevices = ((DevicesDataTable)(base.Tables["Devices"]));
if ((initTable == true)) {
if ((this.tableDevices != null)) {
this.tableDevices.InitVars();
}
}
this.tableExecutors = ((ExecutorsDataTable)(base.Tables["Executors"]));
if ((initTable == true)) {
if ((this.tableExecutors != null)) {
this.tableExecutors.InitVars();
}
}
this.tableKeyIRs = ((KeyIRsDataTable)(base.Tables["KeyIRs"]));
if ((initTable == true)) {
if ((this.tableKeyIRs != null)) {
this.tableKeyIRs.InitVars();
}
}
this.tableModes = ((ModesDataTable)(base.Tables["Modes"]));
if ((initTable == true)) {
if ((this.tableModes != null)) {
this.tableModes.InitVars();
}
}
this.relationKeysToKeysIR = this.Relations["KeysToKeysIR"];
this.relationDevicesToExecutors = this.Relations["DevicesToExecutors"];
this.relationDevices_Keys = this.Relations["Devices_Keys"];
}
private void InitClass() {
this.DataSetName = "IBDataset";
this.Prefix = "";
this.Namespace = "http://tempuri.org/IBDataset.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableSPR_IZG = new SPR_IZGDataTable();
base.Tables.Add(this.tableSPR_IZG);
this.tableSPR_TOV = new SPR_TOVDataTable();
base.Tables.Add(this.tableSPR_TOV);
this.relationSPR_IZG_SPR_TOV = new System.Data.DataRelation("SPR_IZG_SPR_TOV", new System.Data.DataColumn[] {
this.tableSPR_IZG.ID_IZGColumn}, new System.Data.DataColumn[] {
this.tableSPR_TOV.ID_IZGColumn}, false);
this.Relations.Add(this.relationSPR_IZG_SPR_TOV);
}
private void InitClass() {
this.DataSetName = "DeviceImagesDS";
this.Prefix = "";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableKeys = new KeysDataTable();
base.Tables.Add(this.tableKeys);
this.tableDevices = new DevicesDataTable();
base.Tables.Add(this.tableDevices);
this.tableExecutors = new ExecutorsDataTable();
base.Tables.Add(this.tableExecutors);
this.tableKeyIRs = new KeyIRsDataTable();
base.Tables.Add(this.tableKeyIRs);
this.tableModes = new ModesDataTable();
base.Tables.Add(this.tableModes);
this.relationKeysToKeysIR = new System.Data.DataRelation("KeysToKeysIR", new System.Data.DataColumn[] {
this.tableKeys.Key_fkColumn}, new System.Data.DataColumn[] {
this.tableKeyIRs.Key_fkColumn}, false);
this.Relations.Add(this.relationKeysToKeysIR);
this.relationDevicesToExecutors = new System.Data.DataRelation("DevicesToExecutors", new System.Data.DataColumn[] {
this.tableDevices.Executor_fkColumn}, new System.Data.DataColumn[] {
this.tableExecutors.Executor_fkColumn}, false);
this.Relations.Add(this.relationDevicesToExecutors);
this.relationDevices_Keys = new System.Data.DataRelation("Devices_Keys", new System.Data.DataColumn[] {
this.tableDevices.DBDevTypeColumn,
this.tableDevices.DBDevIDColumn}, new System.Data.DataColumn[] {
this.tableKeys.DBDevTypeColumn,
this.tableKeys.DBDevIDColumn}, false);
this.Relations.Add(this.relationDevices_Keys);
}
