private void dataGridView_bug_list_CellContentClick(object sender, DataGridViewCellEventArgs e) { db = new DbEntities(); if (dataGridView_bug_list.Columns[e.ColumnIndex].Name == "Assign") { panelAssignBug.Show(); panelAssignBug.Enabled = true; // fetch data from datagridview through row and cell's index number /* lblBugId.Text = dataGridView_bug_list.Rows[e.RowIndex].Cells["id"].Value.ToString();*/ int rowindex = dataGridView_bug_list.CurrentCell.RowIndex; //current row lblBugId.Text = dataGridView_bug_list.Rows[rowindex].Cells[0].Value.ToString(); txtProdName.Text = dataGridView_bug_list.Rows[rowindex].Cells[1].Value.ToString(); txtBugName.Text = dataGridView_bug_list.Rows[rowindex].Cells[2].Value.ToString(); richTxtBugDesc.Text = dataGridView_bug_list.Rows[rowindex].Cells[3].Value.ToString(); btnAssignBug.Show(); // display values in combobox selectAssignTo var query = from o in db.Users_tbl where o.role == "Developer" select o; selectAssignTo.DataSource = query.ToList(); selectAssignTo.DisplayMember = "fullname"; selectAssignTo.ValueMember = "id"; } }
private void btnSubmit_Click(object sender, EventArgs e) { db = new DbEntities(); var session_user = Session.user; int rowindex = dataGridAssignedTask.CurrentCell.RowIndex; //current row var uname = dataGridAssignedTask.Rows[rowindex].Cells[7].Value.ToString(); var fname = dataGridAssignedTask.Rows[rowindex].Cells[8].Value.ToString(); var query = from o in db.AssignedBugs_tbl where o.bug_id == txtBugId.Text && o.username == uname && o.fullname == fname select o; var query2 = from o in db.Bugs_tbl where o.id.ToString() == txtBugId.Text select o; //var query3 = from o in assignedBugstblBindingSource.DataSource as List<AssignedBugs_tbl> // where o.username == session_user select o; if ( txtBugId.Text == "" || txtProdName.Text == "" || txtBugName.Text == "" || richTxtBugDesc.Text == "" || richTxtSyntax.Text == "" ) { MessageBox.Show("Please select bug in above datagrid to debug.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (!chkboxSolved.Checked && !checkBoxUnsolved.Checked && !checkBoxInProgress.Checked) { MessageBox.Show("Please check either checkboxes as per the bug is solved or not.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (chkboxSolved.Checked && !checkBoxUnsolved.Checked && !checkBoxInProgress.Checked) { // temporarily save changes foreach (AssignedBugs_tbl o in query) { o.syntax = richTxtSyntax.Text; o.status = "Solved"; } foreach (Bugs_tbl b in query2) { b.status = "Closed"; } // saving the changes try { db.SaveChanges(); MessageBox.Show("Your edit has been submitted successfully.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (checkBoxInProgress.Checked && !checkBoxUnsolved.Checked && !chkboxSolved.Checked) { // temporarily save changes foreach (AssignedBugs_tbl o in query) { o.syntax = richTxtSyntax.Text; o.status = "In Progress"; } foreach (Bugs_tbl b in query2) { b.status = "In Progress"; } // saving the changes try { db.SaveChanges(); MessageBox.Show("Your edit has been submitted successfully.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (checkBoxUnsolved.Checked && !checkBoxInProgress.Checked && !chkboxSolved.Checked) { // temporarily save changes foreach (AssignedBugs_tbl o in query) { o.syntax = richTxtSyntax.Text; o.status = "Unsolved"; } foreach (Bugs_tbl b in query2) { b.status = "Unsolved"; } // saving the changes try { db.SaveChanges(); MessageBox.Show("Your edit has been submitted successfully.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Please check one of the box not more than one to submit your work. Thank you!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void Login_Load(object sender, EventArgs e) { db = new DbEntities(); userstblBindingSource.DataSource = db.Users_tbl.ToList(); }