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