private void ok_button_Click(object sender, RoutedEventArgs e) { ReplaceTextData.TextToParse = textToPasrse_text.Text; ReplaceTextData.TextToFind = textToFind_text.Text; TextRange textRange = new TextRange(textToReplace_rtb.Document.ContentStart, textToReplace_rtb.Document.ContentEnd); ReplaceTextData.ReplaceWith = textRange.Text.Trim(); ReplaceTextData.UseRegulerExpression = (bool)useRegulerExpression_checkBox.IsChecked; ReplaceTextData.IgnoreCase = (bool)ignoreCase_checkbox.IsChecked; ReplaceTextData.ReplaceTextStoreVar = VariableStorage.VariableNameFormator(replacedTextStoreVar_text.Text.Trim()); ReplaceTextData.ActiveEscapeSequence = (bool)activeEscapteSequence_checkBox.IsChecked; if (!string.IsNullOrEmpty(replacedTextStoreVar_text.Text.Trim())) { if (VariableStorage.ReplaceTextVar.ContainsKey(ReplaceTextData.ReplaceTextStoreVar)) { VariableStorage.ReplaceTextVar.Remove(ReplaceTextData.ReplaceTextStoreVar); } VariableStorage.ReplaceTextVar.Add(ReplaceTextData.ReplaceTextStoreVar, Tuple.Create(ReplaceTextData.ID, "value has not been set yet")); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { ConvertDateTimeToTextData.DateTimeToConvertVar = dateTiemToConvert_combo.Text; ConvertDateTimeToTextData.DateTimeToCovertVarComboIndex = dateTiemToConvert_combo.SelectedIndex; ConvertDateTimeToTextData.StandardFormatIndex = standardFormat_Combo.SelectedIndex; ConvertDateTimeToTextData.CustomFormat = customFromat_Combo.Text; ConvertDateTimeToTextData.DateTiemToConvertOptionComboIndex = formatToUse_Combo.SelectedIndex; ConvertDateTimeToTextData.ResultStoreVar = VariableStorage.VariableNameFormator(storeVar_text.Text.Trim()); if (!string.IsNullOrEmpty(storeVar_text.Text.Trim())) { if (VariableStorage.DateToTextVar.ContainsKey(ConvertDateTimeToTextData.ResultStoreVar)) { VariableStorage.DateToTextVar.Remove(ConvertDateTimeToTextData.ResultStoreVar); } VariableStorage.DateToTextVar.Add(ConvertDateTimeToTextData.ResultStoreVar, Tuple.Create(ConvertDateTimeToTextData.ID, "value has not been set yet")); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { FindTextData.TextToParse = textToParse_text.Text; FindTextData.TextToFind = textToFind_text.Text; FindTextData.UseRegulerExpression = (bool)useRegulerExpression_checkBox.IsChecked; FindTextData.IgnoreCase = (bool)ignoreCase_checkBox.IsChecked; FindTextData.FirstOccurenceOnly = (bool)firstOccurence_checkBox.IsChecked; FindTextData.ResultStoreVar = VariableStorage.VariableNameFormator(storeVar_text.Text.Trim());; int integer; if (int.TryParse(startingPosition_text.Text.Trim(), out integer)) { FindTextData.StartingPoint = Convert.ToInt32(startingPosition_text.Text.Trim()); } if (!string.IsNullOrEmpty(storeVar_text.Text.Trim())) { if (VariableStorage.FindTextVar.ContainsKey(FindTextData.ResultStoreVar)) { VariableStorage.FindTextVar.Remove(FindTextData.ResultStoreVar); } VariableStorage.FindTextVar.Add(FindTextData.ResultStoreVar, Tuple.Create(FindTextData.ID, new List <int>())); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { ChangeTextCaseData.TextToConvert = textToConvert_text.Text; ChangeTextCaseData.ConvertIntoCaseComboIndex = convertIntoCombo.SelectedIndex; ChangeTextCaseData.ConveredTextStoreVar = VariableStorage.VariableNameFormator(storeConvertCase_text.Text.Trim()); if (!string.IsNullOrEmpty(storeConvertCase_text.Text.Trim())) { if (VariableStorage.CaseConvetedTextVar.ContainsKey(ChangeTextCaseData.ConveredTextStoreVar)) { VariableStorage.CaseConvetedTextVar.Remove(ChangeTextCaseData.ConveredTextStoreVar); } VariableStorage.CaseConvetedTextVar.Add(ChangeTextCaseData.ConveredTextStoreVar, Tuple.Create(ChangeTextCaseData.ID, "value has not set yet")); //if (TestVar.TestVariable.ContainsKey(ChangeTextCaseData.ConveredTextStoreVar)) //{ // TestVar.TestVariable.Remove(ChangeTextCaseData.ConveredTextStoreVar); //} //TestVar.TestVariable.Add(ChangeTextCaseData.ConveredTextStoreVar, "value has not set yet"); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { // LaunchExcelData.ExcelFileName = excelFileName_text.Text; Microsoft.Office.Interop.Excel.Application excel_application = new Microsoft.Office.Interop.Excel.Application(); if (openExcelCombo.SelectedIndex == 0) { LaunchExcelData.ExcelFileName = destinationFolder_text.Text + "\\" + excelFileName_text.Text; //+ ".xlsx"; LaunchExcelData.ExcelSchemaIndex = 0; System.Diagnostics.Process excelProcessVar = new System.Diagnostics.Process(); excelProcessVar.StartInfo = new System.Diagnostics.ProcessStartInfo(LaunchExcelData.ExcelFileName); string excelInstanceName = VariableStorage.VariableNameFormator(excelStoreVar_text.Text.Trim()); LaunchExcelData.ExcelVar = excelInstanceName; if (VariableStorage.ExcelVar.ContainsKey(excelInstanceName)) { VariableStorage.ExcelVar.Remove(excelInstanceName); } VariableStorage.ExcelVar.Add(excelInstanceName, Tuple.Create(LaunchExcelData.ID, excel_application)); } else if (openExcelCombo.SelectedIndex == 1) { LaunchExcelData.ExcelFileName = opentExcelDoc_Text.Text; LaunchExcelData.ExcelSchemaIndex = 1; System.Diagnostics.Process excelProcessVar = new System.Diagnostics.Process(); excelProcessVar.StartInfo = new System.Diagnostics.ProcessStartInfo(LaunchExcelData.ExcelFileName); if (VariableStorage.ExcelVar.ContainsKey(excelStoreVar_text.Text.Trim())) { VariableStorage.ExcelVar.Remove(excelStoreVar_text.Text.Trim()); } VariableStorage.ExcelVar.Add(excelStoreVar_text.Text.Trim(), Tuple.Create(LaunchExcelData.ID, excel_application)); LaunchExcelData.ExcelVar = excelStoreVar_text.Text.Trim(); } LaunchExcelData.MakeVisible = (bool)makevisible_checkBox.IsChecked; if (string.IsNullOrEmpty(excelStoreVar_text.Text)) { System.Windows.MessageBox.Show("Please, enter a name to store excel file."); } if (!string.IsNullOrEmpty(excelStoreVar_text.Text)) { ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; } }
private void ok_button_Click(object sender, RoutedEventArgs e) { try { if (!string.IsNullOrEmpty(VarName_text.Text.Trim())) { SetVariableData.VarName = VariableStorage.VariableNameFormator(VarName_text.Text.Trim()); SetVariableData.ValueStr = value_text.Text.Trim(); double doub; if (double.TryParse(value_text.Text.Trim(), out doub)) { SetVariableData.DataType = typeof(double); if (VariableStorage.SetVariableVar.ContainsKey(VarName_text.Text.Trim())) { VariableStorage.SetVariableVar.Remove(VarName_text.Text.Trim()); } VariableStorage.SetVariableVar.Add(VariableStorage.VariableNameFormator(VarName_text.Text.Trim()), Tuple.Create(SetVariableData.ID, (object)value_text.Text, typeof(double))); } else { SetVariableData.DataType = typeof(string); if (VariableStorage.SetVariableVar.ContainsKey(VarName_text.Text.Trim())) { VariableStorage.SetVariableVar.Remove(VarName_text.Text.Trim()); } VariableStorage.SetVariableVar.Add(VariableStorage.VariableNameFormator(VarName_text.Text.Trim()), Tuple.Create(SetVariableData.ID, (object)value_text.Text, typeof(string))); } if (RobotActionBase.testVariable.ContainsKey(SetVariableData.VarName)) { RobotActionBase.testVariable.Remove(SetVariableData.VarName); } RobotActionBase.testVariable.Add(SetVariableData.VarName, Tuple.Create(SetVariableData.ID, SetVariableData.VarName)); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; } catch (Exception) { throw; } }
private void ok_button_Click(object sender, RoutedEventArgs e) { CreateNewListData.EmptyListName = VariableStorage.VariableNameFormator(listName_text.Text.Trim()); if (VariableStorage.CreateNewListVar.ContainsKey(listName_text.Text.Trim())) { VariableStorage.CreateNewListVar.Remove(listName_text.Text.Trim()); } VariableStorage.CreateNewListVar.Add(VariableStorage.VariableNameFormator(listName_text.Text.Trim()), Tuple.Create(CreateNewListData.ID, new List <object>(), typeof(List <object>))); ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { ReverseTextData.TextToReverse = textToReverse_text.Text; ReverseTextData.ReversedTextStoreVar = VariableStorage.VariableNameFormator(reverseTextStore_text.Text.Trim()); if (!string.IsNullOrEmpty(reverseTextStore_text.Text.Trim())) { if (VariableStorage.ReversedTextVar.ContainsKey(ReverseTextData.ReversedTextStoreVar)) { VariableStorage.ReversedTextVar.Remove(ReverseTextData.ReversedTextStoreVar); } VariableStorage.ReversedTextVar.Add(ReverseTextData.ReversedTextStoreVar, Tuple.Create(ReverseTextData.ID, "value has not been set yet")); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { GetTextLengthData.TextToMeasure = textToMeasure_text.Text; GetTextLengthData.TextLengthStoreVar = VariableStorage.VariableNameFormator(storeLengthInto_text.Text.Trim()); if (!string.IsNullOrEmpty(storeLengthInto_text.Text.Trim())) { if (VariableStorage.TextLengthVar.ContainsKey(GetTextLengthData.TextLengthStoreVar)) { VariableStorage.TextLengthVar.Remove(GetTextLengthData.TextLengthStoreVar); } VariableStorage.TextLengthVar.Add(GetTextLengthData.TextLengthStoreVar, Tuple.Create(GetTextLengthData.ID, -1)); // -1 is dummy data } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { TrimTextData.TrimToText = textToTrim_text.Text; TrimTextData.WhatToTrimComboIndex = whatToTrim_combo.SelectedIndex; TrimTextData.TrimmedTextStoreVar = VariableStorage.VariableNameFormator(trimmedTextStoreVar_text.Text.Trim()); if (!string.IsNullOrEmpty(trimmedTextStoreVar_text.Text.Trim())) { if (VariableStorage.TrimmedTextVar.ContainsKey(TrimTextData.TrimmedTextStoreVar)) { VariableStorage.TrimmedTextVar.Remove(TrimTextData.TrimmedTextStoreVar); } VariableStorage.TrimmedTextVar.Add(TrimTextData.TrimmedTextStoreVar, Tuple.Create(TrimTextData.ID, "value has not been set yet")); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { ChangeTextToNumberData.TextToConvert = textToConvert_text.Text; ChangeTextToNumberData.TextToNumverStoreVar = VariableStorage.VariableNameFormator(store_text.Text.Trim()); if (!string.IsNullOrEmpty(store_text.Text.Trim())) { if (VariableStorage.TextToNumberVar.ContainsKey(ChangeTextToNumberData.TextToNumverStoreVar)) { VariableStorage.TextToNumberVar.Remove(ChangeTextToNumberData.TextToNumverStoreVar); } VariableStorage.TextToNumberVar.Add(ChangeTextToNumberData.TextToNumverStoreVar, Tuple.Create(ChangeTextToNumberData.ID, -1)); // -1 is a dummy data } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { GetObjectDetailsData.WebElementDetailsStoreVar = VariableStorage.VariableNameFormator(attribureStore_text.Text.Trim()); GetObjectDetailsData.htmlElementInfo = htmlElementInfo; GetObjectDetailsData.WebDriverInstanceVar = webBrowserInstance_combo.Text; GetObjectDetailsData.Address = address_textBlock.Text; GetObjectDetailsData.Control = control_textBlock.Text; if (VariableStorage.WebElementDetailsVar.ContainsKey(GetObjectDetailsData.WebElementDetailsStoreVar)) { VariableStorage.WebDetailsVar.Remove(GetObjectDetailsData.WebElementDetailsStoreVar); } VariableStorage.WebElementDetailsVar.Add(GetObjectDetailsData.WebElementDetailsStoreVar, Tuple.Create(GetObjectDetailsData.ID, "")); ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { ConvertTextToDateTimeData.TextToDate = textToConvert_text.Text; ConvertTextToDateTimeData.UseCustomFormat = (bool)customFormat_checkBox.IsChecked; ConvertTextToDateTimeData.CustomFormat = customFormat_text.Text; ConvertTextToDateTimeData.DateToStoreVar = VariableStorage.VariableNameFormator(storeVar_text.Text.Trim()); if (!string.IsNullOrEmpty(storeVar_text.Text.Trim())) { if (VariableStorage.TextToDateTimeVar.ContainsKey(ConvertTextToDateTimeData.DateToStoreVar)) { VariableStorage.TextToDateTimeVar.Remove(ConvertTextToDateTimeData.DateToStoreVar); } VariableStorage.TextToDateTimeVar.Add(ConvertTextToDateTimeData.DateToStoreVar, Tuple.Create(ConvertTextToDateTimeData.ID, DateTime.Now)); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { TruncateNumberData.WorkingVariable = working_variable; TruncateNumberData.NumberToTruncate = numberToTruncate_text.Text.Trim(); TruncateNumberData.TruncateSchema = trancate_combo.SelectedIndex; TruncateNumberData.ResultStoreVar =VariableStorage.VariableNameFormator( storeVar_text.Text.Trim()); TruncateNumberData.WorkingVariableStr=numberToTruncate_text.Text; TruncateNumberData.RoundUp =Convert.ToInt32( numericDropDown.Value); ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { ConverNumberToTextData.TextToConvert = textToConvert_text.Text; ConverNumberToTextData.UseSeparator = (bool)useSeparator_checkBox.IsChecked; ConverNumberToTextData.NumberOfDecimalPlaces = Convert.ToInt32(numericDropDown.Value); ConverNumberToTextData.ResultStoreVar = VariableStorage.VariableNameFormator(storeResultInto_text.Text.Trim()); if (!string.IsNullOrEmpty(storeResultInto_text.Text.Trim())) { if (VariableStorage.NumberToTextVar.ContainsKey(ConverNumberToTextData.ResultStoreVar)) { VariableStorage.NumberToTextVar.Remove(ConverNumberToTextData.ResultStoreVar); } VariableStorage.NumberToTextVar.Add(ConverNumberToTextData.ResultStoreVar, Tuple.Create(ConverNumberToTextData.ID, "value has not been set yet")); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { SplitTextData.TextToSplit = textToSplit_text.Text; SplitTextData.DelimiterOption = delimiterOption_combo.SelectedIndex; SplitTextData.StandardDelimeterIndex = standardDelimitercombo.SelectedIndex; SplitTextData.DelimiterOccurneceNumber = Convert.ToInt32(numericDropDown.Value); if (delimiterOption_combo.SelectedIndex == 0) { if (standardDelimitercombo.SelectedIndex == 0) { SplitTextData.Delimiter = " "; } else if (standardDelimitercombo.SelectedIndex == 1) { SplitTextData.Delimiter = "\t"; } else if (standardDelimitercombo.SelectedIndex == 2) { SplitTextData.Delimiter = "\n"; } } else if (delimiterOption_combo.SelectedIndex == 1) { SplitTextData.IsRegulerExpression = (bool)regulerExpressionCheckBox.IsChecked; SplitTextData.CustomDelimiter = customDelimeter_text.Text; } SplitTextData.SplitTextStoreVar = VariableStorage.VariableNameFormator(splittedTextStoreVar_text.Text.Trim()); if (!string.IsNullOrEmpty(splittedTextStoreVar_text.Text.Trim())) { if (VariableStorage.SplitTextVar.ContainsKey(SplitTextData.SplitTextStoreVar)) { VariableStorage.SplitTextVar.Remove(SplitTextData.SplitTextStoreVar); } VariableStorage.SplitTextVar.Add(SplitTextData.SplitTextStoreVar, Tuple.Create(SplitTextData.ID, new string[] { })); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
private void ok_button_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrEmpty(outputList_text.Text.Trim())) { MergeListsData.FirstList = FirstList; MergeListsData.SecondList = SecondList; MergeListsData.FirstListStr = firstList.Text; MergeListsData.SecondListStr = secondList.Text; MergeListsData.ResultStoreVar = VariableStorage.VariableNameFormator(outputList_text.Text.Trim()); if (VariableStorage.CreateNewListVar.ContainsKey(MergeListsData.ResultStoreVar)) { VariableStorage.CreateNewListVar.Remove(MergeListsData.ResultStoreVar); } VariableStorage.CreateNewListVar.Add(MergeListsData.ResultStoreVar, Tuple.Create(MergeListsData.ID, new List <object>(), typeof(List <object>))); ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; } }
private void ok_button_Click(object sender, RoutedEventArgs e) { OpenSQLConnectionTaskData.AutomationConnectionString = connStringText.Text; OpenSQLConnectionTaskData.ConnectionStrVar = VariableStorage.VariableNameFormator(connStrVar.Text.Trim()); if (string.IsNullOrEmpty(connStrVar.Text.Trim())) { MessageBox.Show("Please, Enter a name to store SQL Connection"); } if (string.IsNullOrEmpty(connStringText.Text.Trim())) { MessageBox.Show("Please, enter a valid connection string"); } //if (VariableStorage.DataBaseConnStrVar.ContainsKey(OpenSQLConnectionTaskData.ConnectionStrVar)) //{ // MessageBox.Show("Variable name already exists"); //} if (VariableStorage.DataBaseConnStrVar.ContainsKey(OpenSQLConnectionTaskData.ConnectionStrVar)) { VariableStorage.DataBaseConnStrVar.Remove(OpenSQLConnectionTaskData.ConnectionStrVar); } VariableStorage.DataBaseConnStrVar.Add(OpenSQLConnectionTaskData.ConnectionStrVar, Tuple.Create(OpenSQLConnectionTaskData.ID, new OleDbConnection() { ConnectionString = OpenSQLConnectionTaskData.AutomationConnectionString })); if (!string.IsNullOrEmpty(connStrVar.Text.Trim()) && !string.IsNullOrEmpty(connStringText.Text)) { ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; } }
private void ok_button_Click(object sender, RoutedEventArgs e) { ExtractPageDetailsData.WebDriverInstanceComboIndex = webDriverInstanceCombo.SelectedIndex; ExtractPageDetailsData.WebDriverInstanceVar = webDriverInstanceCombo.Text; ExtractPageDetailsData.PropertyStoreVar = VariableStorage.VariableNameFormator(propertyStoreVar_text.Text.Trim()); ExtractPageDetailsData.OperatinIndex = operationCombo.SelectedIndex; if (VariableStorage.WebDetailsVar.ContainsKey(ExtractPageDetailsData.PropertyStoreVar)) { VariableStorage.WebDetailsVar.Remove(ExtractPageDetailsData.PropertyStoreVar); } VariableStorage.WebDetailsVar.Add(ExtractPageDetailsData.PropertyStoreVar, Tuple.Create(ExtractPageDetailsData.ID, "")); if (string.IsNullOrEmpty(propertyStoreVar_text.Text.Trim())) { MessageBox.Show("Please, Enter a variable name to store data."); } if (!string.IsNullOrEmpty(propertyStoreVar_text.Text.Trim())) { ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; } }
private void ok_button_Click(object sender, RoutedEventArgs e) { GetSubTextData.StartIndexComboIndex = startIndex_combo.SelectedIndex; GetSubTextData.LengthComboIndex = length_combo.SelectedIndex; if (working_variable != null) { GetSubTextData.OriginalText = working_variable.ObjectValue.ToString(); } else { GetSubTextData.OriginalText = originalText_text.Text.Trim(); } int integer; if (startIndex_combo.SelectedIndex == 1) { if (startPosition_variable != null) { GetSubTextData.StartIndex = Convert.ToInt32(startPosition_variable.ObjectValue); } else { GetSubTextData.StartIndex = Convert.ToInt32(startPositon_text.Text.Trim()); } } else { GetSubTextData.StartIndex = 0; } if (length_combo.SelectedIndex == 1) { if (numberOfChar_variable != null) { GetSubTextData.Length = Convert.ToInt32(numberOfChar_variable.ObjectValue); } else { GetSubTextData.Length = Convert.ToInt32(numberOfChar_text.Text.Trim()); } } else { GetSubTextData.Length = originalText_text.Text.Trim().Length; } GetSubTextData.SubTextStorVar = VariableStorage.VariableNameFormator(subtextStoreVar_text.Text.Trim()); if (!string.IsNullOrEmpty(subtextStoreVar_text.Text.Trim())) { if (VariableStorage.SubTextVar.ContainsKey(GetSubTextData.SubTextStorVar)) { VariableStorage.SubTextVar.Remove(GetSubTextData.SubTextStorVar); } VariableStorage.SubTextVar.Add(GetSubTextData.SubTextStorVar, Tuple.Create(GetSubTextData.ID, "value has not been set yet")); } ((((this.Parent as StackPanel).Parent as Grid).Parent as TaskViewFrameUC).Parent as MetroWindow).DialogResult = false; }
public int Execute() { try { sqlResultVarName = VariableStorage.VariableNameFormator(sqlResultVarName); if (GetConnSchemaIndex == 0) { OleDbConnection OledbConnection = new OleDbConnection(newConnStr); if (OledbConnection.State.ToString() != "Open") { OledbConnection.Open(); } OleDbCommand command = new OleDbCommand(Query, OledbConnection); OleDbDataAdapter adp = new OleDbDataAdapter(command); DataSet dataSet = new DataSet(); adp.Fill(dataSet); dataSet.WriteXml(@"E:\queryresult.xml"); if (VariableStorage.DataBaseQueryResultlVar.ContainsKey(sqlResultVarName)) { VariableStorage.DataBaseQueryResultlVar.Remove(sqlResultVarName); } VariableStorage.DataBaseQueryResultlVar.Add(sqlResultVarName, Tuple.Create(this.ID, dataSet)); } else if (GetConnSchemaIndex == 1) { OleDbConnection OledbConnection = VariableStorage.DataBaseConnStrVar[connStrVar].Item2; if (OledbConnection.State.ToString() != "Open") { OledbConnection.Open(); } OleDbCommand command = new OleDbCommand(Query, OledbConnection); OleDbDataAdapter adp = new OleDbDataAdapter(command); DataSet dataSet = new DataSet(); adp.Fill(dataSet); dataSet.WriteXml(@"E:\queryresult.xml"); if (VariableStorage.DataBaseQueryResultlVar.ContainsKey(sqlResultVarName)) { VariableStorage.DataBaseQueryResultlVar.Remove(sqlResultVarName); } VariableStorage.DataBaseQueryResultlVar.Add(sqlResultVarName, Tuple.Create(this.ID, dataSet)); } return(1); } catch (Exception ex) { return(0); } }