private void btnAllocate_Click(object sender, EventArgs e) { DataAccessLayer dl = new DataAccessLayer(); if (dbConn.State == ConnectionState.Closed) { dbConn.Open(); } try { for (int i = dgvProblems.Rows.Count - 1; i > 0; i--) { DataGridViewRow row = dgvProblems.Rows[i - 1]; if (Convert.ToBoolean(row.Cells["Assign"].Value) == true) { p.UpdateProblem(int.Parse(row.Cells["ProbID"].Value.ToString()), cmbStaffID.Text.ToString(), "Assigned"); pl.InsertProblem(int.Parse(row.Cells["ProbID"].Value.ToString()), DateTime.Now.ToString(), cmbStaffID.Text.ToString(), "Initial allocated staff ID"); } } dgvProblems.DataSource = dl.getOpenProblems(); try { frmAllocateProblem frm = new frmAllocateProblem(); frm.Close(); } catch { } } catch (SqlException sqlex) { MessageBox.Show("SQL exception: " + sqlex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } this.Close(); }
private void btnAllocateProblem_Click(object sender, EventArgs e) { frmAllocateProblem fAll = new frmAllocateProblem(); fAll.ShowDialog(); }
private void allocateProblemToolStripMenuItem_Click(object sender, EventArgs e) { frmAllocateProblem fAll = new frmAllocateProblem(); fAll.ShowDialog(); }