private void submitButton_Click(object sender, EventArgs e) { // go to status page with job, partNo and customer if (partNoLabel.Text.Trim().Length == 0) { return; } // calculate the type of form to create after string type = string.Empty; if (question3YesRadioButton.Checked || question4YesRadioButton.Checked || question5YesRadioButton.Checked || question6YesRadioButton.Checked) { type = "Contract Review"; } else if (!question3YesRadioButton.Checked || !question4YesRadioButton.Checked || !question5YesRadioButton.Checked || !question6YesRadioButton.Checked) { if (question1NewRadioButton.Checked) { type = "Quick Release"; } else if (question1ActiveRadioButton.Checked || question1CompleteRadioButton.Checked) { type = "Nothing"; } } if (this.Modal) { // submit query info: TOD_DO this.Close(); } else { // load status page this.Hide(); Form statusForm = new StatusPage(jobNo, partNoLabel.Text.Trim(), "ROLLS", type); statusForm.FormClosed += (s, args) => this.Close(); statusForm.Show(); } }
private void dataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { // check that the cell is valid if (e == null) { return; } if (dataGridView.Rows[e.RowIndex].Cells[0].Value == null || dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString().Trim().Length == 0) { return; } // launch status page and pass job, partno and customer as arguments this.Hide(); Form statusPage = new StatusPage(dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString(), dataGridView.Rows[e.RowIndex].Cells[4].Value.ToString(), dataGridView.Rows[e.RowIndex].Cells[1].Value.ToString(), "Contract Review"); statusPage.FormClosed += (s, args) => this.Close(); statusPage.Show(); }
private void submitButton_Click(object sender, EventArgs e) { // go to status page with job, partNo and customer if (partNoLabel.Text.Trim().Length == 0) { return; } // calculate the type of form to create after if (question3YesRadioButton.Checked || question4YesRadioButton.Checked || question5YesRadioButton.Checked || question6YesRadioButton.Checked || question7YesRadioButton.Checked) { type = "Contract Review"; } else { if (question1NewRadioButton.Checked) { type = "Quick Release"; } else if (question1ActiveRadioButton.Checked || question1CompleteRadioButton.Checked) { type = "Nothing"; } } if (this.Modal) { // TO_DO: Submit query info using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string)) { conn.Open(); string query = "INSERT INTO [ATI_Workflow].[dbo].[Honda_PO_Review]\n" + "([Job]\n" + ",[Workflow_ID]\n" + ",[Initiated_By]\n" + ",[Date]\n" + ",[PO_No]\n" + ",[PO_Qty]\n" + ",[PO_Rev]\n" + ",[PO_Rev_Date]\n" + ",[Description_Of_Change]\n" + ",[Question1_Response]\n" + ",[Question2_Response]\n" + ",[Question3_Response]\n" + ",[Question4_Response]\n" + ",[Question5_Response]\n" + ",[Question6_Response]\n" + ",[Question7_Response]\n" + ",[Question8_Response]\n" + ",[Part_Number]\n" + ",[Drawing_Rev]\n" + ",[Applicable_CID_Numbers])\n" + "VALUES\n" + "('" + jobNo + "',\n" + "'" + workflow_id + "',\n" + "'" + Globals.userName + "',\n" + "'" + dateTextBox.Text + "',\n" + "'" + poNoTextBox.Text + "',\n" + "'" + poQtyTextBox.Text + "',\n" + "'" + revTextBox.Text + "',\n" + "'" + revDateTextBox.Text + "',\n" + "'" + descriptionOfChangeTextBox.Text + "',\n" + (question1NewRadioButton.Checked ? "'New'" : (question1ActiveRadioButton.Checked ? "'Active'" : (question1CompleteRadioButton.Checked ? "'Complete'" : "NULL"))) + ",\n" + (question2YesRadioButton.Checked ? "1" : (question2NoRadioButton.Checked ? "0" : "NULL")) + ",\n" + (question3YesRadioButton.Checked ? "'Yes'" : (question3NoRadioButton.Checked ? "'No'" : (question3NARadioButton.Checked ? "'N/A'" : "NULL"))) + ",\n" + (question4YesRadioButton.Checked ? "1" : (question4NoRadioButton.Checked ? "0" : "NULL")) + ",\n" + (question5YesRadioButton.Checked ? "1" : (question5NoRadioButton.Checked ? "0" : "NULL")) + ",\n" + (question6YesRadioButton.Checked ? "1" : (question6NoRadioButton.Checked ? "0" : "NULL")) + ",\n" + (question7YesRadioButton.Checked ? "'Yes'" : (question7NoRadioButton.Checked ? "'No'" : (question7NARadioButton.Checked ? "'N/A'" : "NULL"))) + ",\n" + (question8YesRadioButton.Checked ? "1" : (question8NoRadioButton.Checked ? "0" : "NULL")) + ",\n" + "'" + partNoLabel.Text + "',\n" + "'" + drawingRevTextBox.TextAlign + "',\n" + "'" + applicableCIDNosTextBox.Text + "');"; OdbcCommand com = new OdbcCommand(query, conn); int rows = com.ExecuteNonQuery(); } this.Close(); } else { // load status page this.Hide(); Form statusForm = new StatusPage(jobNo, partNoLabel.Text.Trim(), "HONDA AERO", type); statusForm.FormClosed += (s, args) => this.Close(); statusForm.Show(); } }