/// <summary> /// Get History /// </summary> /// <param name="bug"></param> /// <returns></returns> public DataTable getHistory(BugModel bug) { DataTable historytable = new DataTable(); try { String sql = "SELECT * FROM tbl_history where bug_id=@bug_id ORDER BY updatedate DESC LIMIT 1"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; Debug.WriteLine("History Called" + bug.getBUGID()); // Add and set value for parameter. MySqlDataAdapter MyAdapter = new MySqlDataAdapter(); cmd.Parameters.AddWithValue("@bug_id", bug.getBUGID()); MyAdapter.SelectCommand = cmd; MyAdapter.Fill(historytable); } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(historytable); }
/// <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); } }
/// <summary> /// //assign bug /// </summary> /// <param name="bug"></param> /// <returns> flag </returns> public bool AssignBug(BugModel bug) { bool flag = false; if (CheckUsername(bug.getAssignedTo()) == false) { flag = false; } else { try { String sql = "update tbl_bug set assignedto = @username, status='assigned' where bug_id = @bug_id"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; // Add and set value for parameter. cmd.Parameters.AddWithValue("@username", bug.getAssignedTo()); cmd.Parameters.AddWithValue("@bug_id", bug.getBUGID()); int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { MailService mail = new MailService(); flag = mail.sendMail(bug.getAssignedTo()); } else { flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } } return(flag); }
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"); } }
/// <summary> /// Update Bug Information /// </summary> /// <param name="bug"></param> /// <returns></returns> public bool UpdateBug(BugModel bug) { bool flag = false; try { String sql = "update tbl_bug set code=@code, status=@status, version=@version where bug_id = @bug_id"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; // Add and set value for parameter. Debug.WriteLine("UpdateBUg Called"); cmd.Parameters.AddWithValue("@code", bug.getCode()); cmd.Parameters.AddWithValue("@status", bug.getStatus()); cmd.Parameters.AddWithValue("@bug_id", bug.getBUGID()); cmd.Parameters.AddWithValue("@version", bug.getVersion()); Debug.WriteLine(bug.getCode() + bug.getStatus() + bug.getBUGID()); int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { Debug.WriteLine("Updated"); flag = setHistory(bug); } else { flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(flag); }
/// <summary> /// Get History for Audit /// </summary> /// <param name="bug"></param> public bool setHistory(BugModel bug) { bool flag = false; try { String sql = "INSERT INTO `tbl_history`( `bug_id`,`version`, `updatedate`, `updatedby`, `code`, `status`, `remarks`) " + "VALUES (@bug_id,@version,@updatedate,@updatedby,@code,@status,@remarks)"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Parameters.AddWithValue("@bug_id", bug.getBUGID()); cmd.Parameters.AddWithValue("@version", bug.getVersion()); cmd.Parameters.AddWithValue("@updatedate", DateTime.Now.ToString("yyyy-MM-dd H:mm:ss")); cmd.Parameters.AddWithValue("@updatedby", bug.getUsername()); cmd.Parameters.AddWithValue("@code", bug.getCode()); cmd.Parameters.AddWithValue("@status", bug.getStatus()); cmd.Parameters.AddWithValue("@remarks", bug.getRemarks()); Debug.WriteLine("setHistory Called"); cmd.Connection = conn; cmd.CommandText = sql; int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { flag = true; } else { flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(flag); }
public bool addProjectComponent(BugModel bug) { bool flag = false; try { String sql = "INSERT INTO `tbl_component`( `component_name`, `component_desc`, `project_id`, `developerusername`) VALUES (@component_name,@component_desc,@project_id,@developerusername)"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); Debug.WriteLine("addprojectcomponent Called"); cmd.Connection = conn; cmd.Parameters.AddWithValue("@component_name", bug.getComponentName()); cmd.Parameters.AddWithValue("@component_desc", bug.getcomponentdesc()); cmd.Parameters.AddWithValue("@project_id", bug.getprojectid()); cmd.Parameters.AddWithValue("@developerusername", bug.getUsername()); cmd.CommandText = sql; int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { flag = true; } else { flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(flag); }
private void pbsubmit_Click(object sender, EventArgs e) { BugModel bug = new BugModel(); string projectname = this.cmbProject.GetItemText(this.cmbProject.SelectedItem); bug.setprojectid(bc.getProjectID(projectname)); bug.setcomponentdesc(this.txtcomponentdescription.Text); bug.setComponentName(this.txtcomponentname.Text); bug.setUsername(this.txtdeveloper.Text); bool flag = bc.addProjectComponent(bug); if (flag == true) { this.Hide(); MessageBox.Show("Project Component Was Added"); } else { MessageBox.Show("Sorry, Project Component Could not be Added, Please Try Again"); } }
private void submit_Click(object sender, EventArgs e) { BugModel bug = new BugModel(); bug.setRemarks(this.txtremarks.Text); bug.setCode(this.txtupdatecode.Text); bug.setStatus(this.cmbStatus.Text); bug.setVersion(this.txtversion.Text); Debug.WriteLine("Username is:" + username); bug.setUsername(username); bug.setBugID(bugid); BugController bc = new BugController(); bool flag = bc.UpdateBug(bug); if (flag == true) { this.Hide(); MessageBox.Show("Bug Was Succesfully Updated"); } else if (flag == false) { MessageBox.Show("Bug could not be updated"); } }
//report bug public bool ReportBug(BugModel bug) { Bitmap img = new Bitmap(bug.getImageLocation()); var image = imageToByte(img); try { //query to insert bug report to the database MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); String sql = "INSERT INTO `tbl_bug`( `component_id`, `summary`, `version`, `severity`, `os`," + " `class`, `method`, `linenofrom`, `linenoto`, " + "`vcrurl`, `screenshot`, `bugdesc`, `code`,`submittedby`,`submitteddate`) VALUES (@component_id,@summary,@version,@severity,@os,@class,@method," + "@linenofrom,@linenoto,@vcrurl,@screenshot,@bugdesc,@code,@submittedby,@submitteddate)"; //adding values to the parameters cmd.Parameters.AddWithValue("@component_id", bug.getComponentID()); cmd.Parameters.AddWithValue("@summary", bug.getSummary()); cmd.Parameters.AddWithValue("@version", bug.getVersion()); cmd.Parameters.AddWithValue("@severity", bug.getSeverity()); cmd.Parameters.AddWithValue("@os", bug.getOS()); cmd.Parameters.AddWithValue("@class", bug.getClass()); cmd.Parameters.AddWithValue("@method", bug.getMethod()); cmd.Parameters.AddWithValue("@linenofrom", bug.getlinenofrom()); cmd.Parameters.AddWithValue("@linenoto", bug.getlinenoto()); cmd.Parameters.AddWithValue("@vcrurl", bug.getVCURL()); //getting image var paramUserImage = new MySqlParameter("@screenshot", MySqlDbType.Blob, image.Length); paramUserImage.Value = image; cmd.Parameters.Add(paramUserImage); cmd.Parameters.AddWithValue("@bugdesc", bug.getbugdesc()); cmd.Parameters.AddWithValue("@code", bug.getCode()); cmd.Parameters.AddWithValue("@submittedby", submittedby); cmd.Parameters.AddWithValue("@submitteddate", DateTime.Now.ToString("yyyy-MM-dd H:mm:ss")); cmd.Connection = conn; cmd.CommandText = sql; int rowCount = cmd.ExecuteNonQuery(); if (rowCount >= 1) { flag = true; } else { flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(flag); }