private void OnCopyQuery()
{
Model.QueriesRow NewRow = ActiveModel.Queries.NewQueriesRow();
foreach (DataColumn col in ActiveModel.Queries.Columns)
{
if (col.ColumnName != "PK")
{
NewRow[col.ColumnName] = SelectedQuery[col.ColumnName];
}
}
ActiveModel.Queries.AddQueriesRow(NewRow);
foreach (Model.QueryTagMappingsRow Row in SelectedQuery.GetQueryTagMappingsRows())
{
Model.QueryTagMappingsRow NewTagMappingRow = ActiveModel.QueryTagMappings.NewQueryTagMappingsRow();
foreach (DataColumn col in ActiveModel.QueryTagMappings.Columns)
{
if (col.ColumnName == "Query")
{
NewTagMappingRow[col.ColumnName] = NewRow.PK;
}
else if (col.ColumnName != "PK")
{
NewTagMappingRow[col.ColumnName] = Row[col.ColumnName];
}
}
ActiveModel.QueryTagMappings.AddQueryTagMappingsRow(NewTagMappingRow);
}
ActiveModel.Queries.AcceptChanges();
ActiveModel.QueryTagMappings.AcceptChanges();
}
private void Query3Btn_Click(object sender, RoutedEventArgs e)
{
selectedQuery = SelectedQuery.query3;
QueryResultWindow queryResultWindow = new QueryResultWindow(this);
queryResultWindow.Show();
Hide();
}
