/// <summary> /// Tester Dashboard Load /// </summary> /// <param name="bug"></param> public void populatetesterdashboard(BugModel bug) { try { String sql = "select pro.project_name,com.component_name," + "bug.summary,bug.version,bug.severity,bug.os,bug.class,bug.method,bug.linenofrom,bug.linenoto,bug.vcrurl," + "bug.screenshot,bug.bugdesc,bug.code,bug.submittedby,bug.submitteddate,bug.status,bug.assignedto" + " from tbl_project as pro" + " inner join tbl_component as com on pro.project_id = com.project_id " + "inner join tbl_bug as bug on com.component_id = bug.component_id " + "where bug_id = @bug_id"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@bug_id", bug.getBUGID()); MySqlDataAdapter MyAdapter = new MySqlDataAdapter(); MyAdapter.SelectCommand = cmd; DataTable dTable = new DataTable(); MyAdapter.Fill(dTable); bug.dtable = dTable; bug.setProjectName(dTable.Rows[0][0].ToString()); bug.setComponentName(dTable.Rows[0][1].ToString()); bug.setVersion(dTable.Rows[0][3].ToString()); bug.setSeverity(dTable.Rows[0][4].ToString()); bug.setClass(dTable.Rows[0][6].ToString()); bug.setMethod(dTable.Rows[0][7].ToString()); bug.setlinenofrom(Convert.ToInt32(dTable.Rows[0][8].ToString())); bug.setlinenoto(Convert.ToInt32(dTable.Rows[0][9].ToString())); bug.setbugdesc(dTable.Rows[0][12].ToString()); bug.setCode(dTable.Rows[0][13].ToString()); bug.setVCURL(dTable.Rows[0][10].ToString()); byte[] img = (byte[])dTable.Rows[0][11]; MemoryStream ms = new MemoryStream(img); bug.setImage(System.Drawing.Image.FromStream(ms)); bug.setStatus(dTable.Rows[0][16].ToString()); bug.setAssignedTo(dTable.Rows[0][17].ToString()); } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } }
private void btnassignbug_Click(object sender, EventArgs e) { BugModel bug = new BugModel(); bug.setAssignedTo(this.txtdeveloperusername.Text); bug.setBugID(bugid); BugController bc = new BugController(); if (bc.AssignBug(bug) == false) { MessageBox.Show("Sorry, Bug cannot be assigned to this user. Either Check the privilage or if the user exists.", "Assign Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Bug has been assigned and the developer has been notified"); } }