private void btnNewRepaint_Click(object sender, EventArgs e) { NewRepaint nr = new NewRepaint(); nr.ShowDialog(); this.c_view_repaint_listTableAdapter.FillBy2(this.order_databaseDataSet1.c_view_repaint_list); }
private void dgRepaintList_CellContentClick(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; int selectedrowindex = dgRepaintList.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dgRepaintList.Rows[selectedrowindex]; repaintID = Int32.Parse(selectedRow.Cells[0].Value.ToString()); doorID = Int32.Parse(selectedRow.Cells[12].Value.ToString()); repaintComplete = Int32.Parse(selectedRow.Cells[9].Value.ToString()); loggedFrom = selectedRow.Cells[10].Value.ToString(); //Gets the paint id from the door NewRepaint nr = new NewRepaint(); paintID = nr.get_paint_id(Int32.Parse(selectedRow.Cells[12].Value.ToString())); if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0) { if (loggedFrom != "Packing") { SqlConnection conn = new SqlConnection(SqlStatements.ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE dbo.repaints SET repaint_complete = -1, date_painted= @datetime where id = @id"; cmd.Parameters.AddWithValue("@id", repaintID); cmd.Parameters.AddWithValue("@datetime", DateTime.Now); cmd.ExecuteNonQuery(); this.c_view_repaint_listTableAdapter.FillBy2(this.order_databaseDataSet1.c_view_repaint_list); } else { CompleteRepaint cr = new CompleteRepaint(doorID, repaintID, paintID); cr.ShowDialog(); this.c_view_repaint_listTableAdapter.FillBy2(this.order_databaseDataSet1.c_view_repaint_list); } } }