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);
}
}
