private void btn_packing_Click(object sender, EventArgs e) { Public.door_id = ""; packing_report packing = new packing_report(); packing.Show(); }
private void grid_packing_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == grid_packing.Columns["btn_print"].Index && e.RowIndex >= 0) { try { int i = e.RowIndex; Public.door_id = dt_packing.Rows[i][0].ToString(); packing_report packing = new packing_report(); packing.Show(); } catch { } } if (e.ColumnIndex == grid_packing.Columns["btn_packing_note"].Index && e.RowIndex >= 0) { try { int i = e.RowIndex; Public.note_id = dt_packing.Rows[i][0].ToString(); Public.note_department = "Packing"; allocation_note note_menu = new allocation_note(); note_menu.Show(); } catch { } } else if (e.ColumnIndex == grid_packing.Columns["btn_taken_packing"].Index && e.RowIndex >= 0) { try { int i = e.RowIndex; string date = dt_packing.Rows[i][4].ToString(); string door_id = dt_packing.Rows[i][0].ToString(); if (date != "") { DialogResult complete = MessageBox.Show("That Door is already taken, Mark as Paused?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (complete == DialogResult.Yes) { if (Public.order_database != null && Public.order_database.State == ConnectionState.Closed) { Public.order_database.Open(); } SqlCommand mark_paused_packing = new SqlCommand(Public.mark_paused_packing, Public.order_database); SqlCommand insert_stopped_packing = new SqlCommand(Public.insert_stopped_packing, Public.order_database); mark_paused_packing.Parameters.AddWithValue("@door_id", door_id); insert_stopped_packing.Parameters.AddWithValue("@staff_id", cmb_search.SelectedValue); insert_stopped_packing.Parameters.AddWithValue("@door_id", door_id); insert_stopped_packing.Parameters.AddWithValue("@date", DateTime.Now); mark_paused_packing.ExecuteNonQuery(); insert_stopped_packing.ExecuteNonQuery(); Public.order_database.Close(); pct_search_Click(sender, e); return; } else { return; } } SqlCommand insert_started_packing = new SqlCommand(Public.insert_started_packing, Public.order_database); SqlCommand mark_taken = new SqlCommand(Public.mark_taken_packing, Public.order_database); if (Public.order_database != null && Public.order_database.State == ConnectionState.Closed) { Public.order_database.Open(); } mark_taken.Parameters.AddWithValue("@date", DateTime.Now); mark_taken.Parameters.AddWithValue("@door_id", door_id); insert_started_packing.Parameters.AddWithValue("@staff_id", cmb_search.SelectedValue); insert_started_packing.Parameters.AddWithValue("@door_id", door_id); insert_started_packing.Parameters.AddWithValue("@date", DateTime.Now); insert_started_packing.ExecuteNonQuery(); mark_taken.ExecuteNonQuery(); MessageBox.Show("Door " + door_id + " Marked as taken", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); Public.order_database.Close(); pct_search_Click(sender, e); } catch (Exception ex) { MessageBox.Show(ex.ToString()); if (Public.order_database != null && Public.order_database.State == ConnectionState.Open) { Public.order_database.Close(); } } } }