private void step5_DoubleClick(object sender, EventArgs e) { bool updated = false; if (type == Status_Type.ContractReview) { ContractReviewCheckList_QE contractReviewME = new ContractReviewCheckList_QE(jobNo, int.Parse(workflowListBox.SelectedItem.ToString())); contractReviewME.ShowDialog(); updated = contractReviewME.been_updated; } if (updated) { using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string)) { conn.Open(); // update query string query = "UPDATE [ATI_Workflow].[dbo].[StatusData]\n" + "SET[LastUpdated] = '" + DateTime.Now.ToString() + "'\n" + ",[ContractReview_QE_Status] = 'Complete'\n" + ",[ContractReview_QE_UserName] = '" + Globals.userName + "'\n" + ",[ContractReview_QE_TimeStamp] = '" + DateTime.Now.ToString() + "'\n" + "WHERE Job = '" + jobNo + "' AND Workflow_ID = '" + int.Parse(workflowListBox.SelectedItem.ToString()) + "';"; OdbcCommand com = new OdbcCommand(query, conn); int rows = com.ExecuteNonQuery(); if (rows != 1) { MessageBox.Show(Globals.generic_IT_error); } } UpdateFromDB(int.Parse(workflowListBox.SelectedItem.ToString())); } }
private void contractReviewQEButton_Click(object sender, EventArgs e) { Form contractReviewQEForm = new ContractReviewCheckList_QE("10", 101); contractReviewQEForm.Show(); }