private void btn_skip_Click(object sender, EventArgs e) { Main_menu form = new Main_menu(); form.Show(); this.WindowState = FormWindowState.Minimized; }
private void btn_part_complete_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txt_part_percent.Text)) { MessageBox.Show("Please Enter Percent Value", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (Convert.ToInt32(Public.Sum_of_percent_complete) > (Convert.ToDouble(txt_part_percent.Text) / 100)) { MessageBox.Show("Please enter a higher value as job completion stage is less than previously entered", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); return; } if (cmbo_staff.SelectedIndex < 0) { MessageBox.Show("Please Select a Staff Member", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } Public.order_database.Open(); Double part_percent = Convert.ToDouble(txt_part_percent.Text) / 100; Public.staff_id = Convert.ToInt32(cmb_staff.SelectedValue); SqlCommand completion_log = new SqlCommand(Public.insert_completion_log, Public.order_database); SqlCommand select_time = new SqlCommand("Select time_" + Public.Operation + " From dbo.door WHERE id = @id", Public.order_database); SqlCommand update_door = new SqlCommand("Update dbo.door SET " + Public.operation_remaining_name + " = " + Public.operation_remaining_name + " - @op_time WHERE id = @door_id", Public.order_database); SqlCommand update_department = new SqlCommand(Public.update_department_goal, Public.order_database); select_time.Parameters.AddWithValue("@id", Public.second_validation_door_id); update_door.Parameters.AddWithValue("@door_id", Public.second_validation_door_id); select_time.Parameters.AddWithValue("@op_time", "Time_" + Public.Operation); object op_time = select_time.ExecuteScalar(); if (op_time != null) { Public.op_time = Convert.ToInt32(op_time); } Double time_for_part = ((part_percent - Public.Sum_of_percent_complete) * Public.quantity_same * Public.op_time); update_door.Parameters.AddWithValue("op_time", (time_for_part / Public.quantity_same)); update_department.Parameters.AddWithValue("@time_for_part", (time_for_part / 60)); completion_log.Parameters.AddWithValue("@part_time", time_for_part); completion_log.Parameters.AddWithValue("@id", Public.second_validation_door_id); completion_log.Parameters.AddWithValue("@date", DateTime.Now); completion_log.Parameters.AddWithValue("@part", "part " + Public.Operation_log); completion_log.Parameters.AddWithValue("@part_status", "Complete"); completion_log.Parameters.AddWithValue("@op", Public.Operation_log); completion_log.Parameters.AddWithValue("@staff_id", cmbo_staff.SelectedValue); completion_log.Parameters.AddWithValue("@percent", (Convert.ToDouble(txt_part_percent.Text) / 100 - Public.Sum_of_percent_complete)); update_department.Parameters.AddWithValue("@date", Public.sqlFormattedDate); update_department.ExecuteNonQuery(); completion_log.ExecuteNonQuery(); update_door.ExecuteNonQuery(); Public.order_database.Close(); Main_menu menu = new Main_menu(); this.Hide(); menu.Show(); Fill_data(); }