private void button5_Click(object sender, EventArgs e) { string InputXlPath = textBox1.Text; string OutputXlPath = textBox2.Text; bool RunAllTestCases = false; if (RunAllCases.Checked) { RunAllTestCases = true; } if (InputXlPath == "") { MessageBox.Show("Please provide Input Excel Path"); return; } else if (File.Exists(InputXlPath) == false) { MessageBox.Show("Can not find Input Excel. Please enter a valid Input Excel Path"); return; } if (OutputXlPath == "") { MessageBox.Show("Please provide Output Excel Path"); return; } else if (Directory.Exists(OutputXlPath) == false) { MessageBox.Show("Can not find Output Excel folder. Please enter a valid Output Excel folder"); return; } OutputObject outputObject = new OutputObject(); if (textBox3.Text == "") { MessageBox.Show("Please provide Output SQL Server Name"); return; } outputObject.OutPutServerName = textBox3.Text; if (textBox4.Text == "") { MessageBox.Show("Please provide Output SQL Login"); return; } outputObject.OutPutUserName = textBox4.Text; if (textBox5.Text == "") { MessageBox.Show("Please provide Output SQL Password"); return; } outputObject.OutPutPass = textBox5.Text; if (textBox6.Text == "") { MessageBox.Show("Please provide Output Database"); return; } outputObject.OutPutDataBase = textBox6.Text; SqlConnection conn = new SqlConnection(); try { conn.ConnectionString = "Server=" + outputObject.OutPutServerName + ";Database=" + outputObject.OutPutDataBase + ";User Id=" + outputObject.OutPutUserName + ";Password="******"Invalid Output SQL Connection. Please check your SQL info. \n Error :" + E.Message); return; } finally { conn.Close(); } automation = new RMS.NGFMAutomation.LoopEvents.NGFMAutomation(InputXlPath, OutputXlPath, outputObject); try { automation.Run(RunAllTestCases); } catch (InvalidDataException invalidE) { MessageBox.Show(invalidE.Message); return; } MessageBox.Show("Automation Run Completed! Please check Output Excel and SQL Database for results."); Application.Exit(); }