private void btnAssignBug_Click(object sender, EventArgs e)
{
db = new DbEntities();
var fname = selectAssignTo.Text;
var uname = combStoreUsername.Text;
var query = from o in db.AssignedBugs_tbl where o.bug_id == lblBugId.Text && o.fullname == fname select o;
// check if the bug has already been assigned to the developer
if (query.SingleOrDefault() != null)
{
MessageBox.Show("You have already assigned this bug to developer '" + fname + "'. If you still want to assign same bug, then assign to him/her by clicking Edit.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
btnAssignBug.Hide();
}
else
{
var a = new AssignedBugs_tbl()
{
prod_name = txtProdName.Text,
bug_name = txtBugName.Text,
bug_desc = richTxtBugDesc.Text,
syntax = "Syntax",
status = "Assigned",
bug_id = lblBugId.Text,
username = uname,
fullname = fname,
};
db.AssignedBugs_tbl.Add(a);
db.SaveChanges();
MessageBox.Show("Bug '" + txtBugName.Text + "' has been assigned successfully to developer '" + fname + "' !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnSubmitBug_Click(object sender, EventArgs e)
{
db = new DbEntities();
if (
txtProdName.Text == "" ||
txtBugName.Text == "" ||
richTxtBugDesc.Text == "" ||
richTxtSyntax.Text == ""
)
{
MessageBox.Show("Please fill every field to submit the bug.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
var a = new Bugs_tbl()
{
prod_name = txtProdName.Text,
bug_name = txtBugName.Text,
bug_desc = richTxtBugDesc.Text,
syntax = richTxtSyntax.Text,
status = "Pending",
date = dateTimePicker1.Value,
};
db.Bugs_tbl.Add(a);
db.SaveChanges();
MessageBox.Show("Bug has been added successfully.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnSubmitChanges_Click(object sender, EventArgs e)
{
db = new DbEntities();
var fname = selectAssignTo.Text;
var uname = combStoreUsername.Text;
var query = from o in db.AssignedBugs_tbl where o.bug_id == lblBugId.Text &&
o.username == uname && o.fullname == fname select o;
// temporarily save changes
foreach (AssignedBugs_tbl o in query)
{
o.prod_name = txtProdName.Text;
o.bug_name = txtBugName.Text;
o.bug_desc = richTxtBugDesc.Text;
o.syntax = "Syntax";
o.status = "Assigned";
o.bug_id = lblBugId.Text;
o.username = uname;
o.fullname = fname;
}
// saving the changes
try
{
db.SaveChanges();
btnSubmitChanges.Hide();
panelEditBugInfo.Enabled = false;
MessageBox.Show("Your edit has been submitted successfully.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
assignedBugstblBindingSource.DataSource = db.AssignedBugs_tbl.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}
