private void step3_DoubleClick(object sender, EventArgs e)
{
bool updated = false;
if (type == Status_Type.ContractReview)
{
ContractReviewCheckList_ME contractReviewME = new ContractReviewCheckList_ME(jobNo, int.Parse(workflowListBox.SelectedItem.ToString()));
contractReviewME.ShowDialog();
updated = contractReviewME.been_updated;
}
else if (type == Status_Type.QuickRelease)
{
QuickReleaseForm_Engineering quickReleaseForm = new QuickReleaseForm_Engineering(jobNo, partNo, int.Parse(workflowListBox.SelectedItem.ToString()));
quickReleaseForm.ShowDialog();
updated = quickReleaseForm.been_updated;
}
if (updated)
{
using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string))
{
conn.Open();
// update query
string query = string.Empty;
if (type == Status_Type.ContractReview)
{
query =
"UPDATE [ATI_Workflow].[dbo].[StatusData]\n" +
"SET[LastUpdated] = '" + DateTime.Now.ToString() + "'\n" +
",[ContractReview_ME_Status] = 'Complete'\n" +
",[ContractReview_ME_UserName] = '" + Globals.userName + "'\n" +
",[ContractReview_ME_TimeStamp] = '" + DateTime.Now.ToString() + "'\n" +
"WHERE Job = '" + jobNo + "' AND Workflow_ID = '" + int.Parse(workflowListBox.SelectedItem.ToString()) + "';";
}
else
{
query =
"UPDATE [ATI_Workflow].[dbo].[StatusData]\n" +
"SET[LastUpdated] = '" + DateTime.Now.ToString() + "'\n" +
",[QuickRelease_Engineering_Status] = 'Complete'\n" +
",[QuickRelease_Engineering_UserName] = '" + Globals.userName + "'\n" +
",[QuickRelease_Engineering_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 contractReviewMEButton_Click(object sender, EventArgs e)
{
Form contractReviewMEForm = new ContractReviewCheckList_ME("10", 101);
contractReviewMEForm.Show();
}
