private void bt_complete_Click(object sender, EventArgs e) { if (Public.Sum_of_percent_complete == 1) { MessageBox.Show("This door is marked as complete!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } DialogResult complete = MessageBox.Show("Mark Job As Complete?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (complete == DialogResult.Yes) { Public.order_database.Open(); SqlCommand job_complete = new SqlCommand("Update dbo.door SET " + Public.date_op_complete + " = @date, " + Public.operation_remaining_name + " = 0, complete_" + Public.Operation + " = -1 WHERE id = @door_id", Public.order_database); SqlCommand completion_log = new SqlCommand(Public.insert_completion_log, Public.order_database); SqlCommand department_goal = new SqlCommand(Public.update_department_goal, Public.order_database); job_complete.Parameters.AddWithValue("@date", DateTime.Now); job_complete.Parameters.AddWithValue("@door_id", Public.second_validation_door_id); completion_log.Parameters.AddWithValue("@id", Public.second_validation_door_id); completion_log.Parameters.AddWithValue("@date", DateTime.Now); completion_log.Parameters.AddWithValue("@part_time", Public.operation_time + ".0"); completion_log.Parameters.AddWithValue("@part", Public.Operation); completion_log.Parameters.AddWithValue("@part_status", "Complete"); completion_log.Parameters.AddWithValue("@op", Public.Operation_log); completion_log.Parameters.AddWithValue("@staff_id", cmb_staff.SelectedValue.ToString()); completion_log.Parameters.AddWithValue("@percent", 1 - (Public.Sum_of_percent_complete)); department_goal.Parameters.AddWithValue("@date", Public.sqlFormattedDate); department_goal.Parameters.AddWithValue("@time_for_part", (Convert.ToDouble(Public.operation_time)) / 60); completion_log.ExecuteNonQuery(); job_complete.ExecuteNonQuery(); department_goal.ExecuteNonQuery(); this.Hide(); if (Public.Operation == "pack") { additional_info info = new additional_info(); info.Show(); } if (Public.Operation == "SL_buff") { //Stock_door_check(); } Public.order_database.Close(); } if (complete == DialogResult.No) { Public.staff_selection = cmb_staff.SelectedIndex.ToString(); Part_complete form = new Part_complete(); form.Show(); this.Hide(); } }
private void button1_Click_1(object sender, EventArgs e) { additional_info info = new additional_info(); info.Show(); }