private void btnRun_Click(object sender, EventArgs e) { rchOutput.Text = ""; if (txtFolderName.Text == "" || txtWorkflowName.Text == "" || txtUserName.Text == "" || txtWorkflowName.Text == "") { MessageBox.Show("Not All Information Has Been Entered"); } else { try { Teradata td = new Teradata(txtUserName.Text, txtPassword.Text); this.addMessage("Attempting to Connect to Teradata....."); if (td.tryConnect()) { this.addMessage("Teradata Connection Successful"); this.addMessage("Checking to see if workflow exists...."); if (td.doesWorkflowExist(txtFolderName.Text, txtWorkflowName.Text)) { this.addMessage(txtFolderName.Text + "_" + txtWorkflowName.Text + " Found in DEV"); CMD powershell = new CMD(this.buildTaskName(), this.buildParameter(), txtUserName.Text, txtPassword.Text); this.addMessage("Creating SB Task For " + txtFolderName.Text + "_" + txtWorkflowName.Text + "....."); this.addMessage(powershell.getOutput()); powershell.resetOutput(); } else { this.addMessage(txtFolderName.Text + "_" + txtWorkflowName.Text + " Not Found in DEV"); } } else { this.addMessage("Failed Connection: Please See Error Box"); } } catch (Exception ex) { this.addMessage(ex.Message); MessageBox.Show(ex.Message); } } }
private void btnRunMultiple_Click(object sender, EventArgs e) { rchOutput.Text = ""; try { int TDsuccess = 0, TDfail = 0, SBsuccess = 0, SBfail = 0; String[,] success = new String[dgvWorkflows.Rows.Count, 3]; String[,] fail = new String[dgvWorkflows.Rows.Count, 3]; if (txtUserNameMultiple.Text == "" || txtPasswordMultiple.Text == "" || dgvWorkflows.Rows.Count == 0) { MessageBox.Show("Not All Information Has Been Entered"); } else { Teradata tdmultiple = new Teradata(txtUserNameMultiple.Text, txtPasswordMultiple.Text); this.addMessage("Attempting to Connect to Teradata....."); if (tdmultiple.tryConnect()) { this.addMessage("Teradata Connection Successful!"); this.addMessage("Checking to see if workflow exists...."); for (int i = 0; i < dgvWorkflows.Rows.Count; i++) { if (tdmultiple.doesWorkflowExist(dgvWorkflows.Rows[i].Cells[0].Value.ToString(), dgvWorkflows.Rows[i].Cells[1].Value.ToString())) { this.addMessage(dgvWorkflows.Rows[i].Cells[0].Value.ToString() + " " + dgvWorkflows.Rows[i].Cells[1].Value.ToString() + " Found in DEV"); success[TDsuccess, 0] = dgvWorkflows.Rows[i].Cells[0].Value.ToString(); success[TDsuccess, 1] = dgvWorkflows.Rows[i].Cells[1].Value.ToString(); success[TDsuccess, 2] = dgvWorkflows.Rows[i].Cells[2].Value.ToString(); TDsuccess++; } else { fail[TDfail, 0] = dgvWorkflows.Rows[i].Cells[0].Value.ToString(); fail[TDfail, 1] = dgvWorkflows.Rows[i].Cells[1].Value.ToString(); fail[TDfail, 2] = dgvWorkflows.Rows[i].Cells[2].Value.ToString(); TDfail++; this.addMessage(dgvWorkflows.Rows[i].Cells[0].Value.ToString() + " " + dgvWorkflows.Rows[i].Cells[1].Value.ToString() + " NOT Found in DEV"); } } this.addMessage(""); for (int i = 0; i < TDsuccess; i++) { int milliseconds = 250; Thread.Sleep(milliseconds);//added because it was running too fast, powershell script was still being used by previous process(add multi-threading?) this.addMessage(Environment.NewLine + "Creating SB Task For " + (String)success[i, 0] + "_" + (String)success[i, 1] + "....."); CMD powershell = new CMD(this.buildTaskName((String)success[i, 0], (String)success[i, 1]), this.buildParameter((String)success[i, 0], (String)success[i, 1], (String)success[i, 2]), txtUserNameMultiple.Text, txtPasswordMultiple.Text); if (powershell.getOutput().Contains("Success")) { SBsuccess++; } else { SBfail++; } this.addMessage(powershell.getOutput()); powershell.resetOutput(); } this.addMessage(""); this.addMessage("TD Workflows Found: " + TDsuccess + Environment.NewLine + "TD Workflows Not Found:" + TDfail); this.addMessage("SB Success: " + SBsuccess + Environment.NewLine + "SB Fail: " + SBfail); } else { this.addMessage("Failed Connection: Please See Error Box"); } } }catch (Exception ex) { this.addMessage(ex.Message); MessageBox.Show(ex.Message); } }