/// <summary> ///populate dashboard /// </summary> public void PopulateDashboardItems() { bug.setBugID(bugid); BugController bc = new BugController(); bc.populatepmdashboard(bug); historytable = bc.getHistory(bug); if (historytable != null && historytable.Rows.Count > 0) { this.lbllastupdatedby.Text = historytable.Rows[0][4].ToString(); this.lbllastupdateon.Text = historytable.Rows[0][3].ToString(); this.richremarks.Text = historytable.Rows[0][7].ToString(); } else { this.lbllastupdatedby.Text = "Unkown"; this.lbllastupdateon.Text = "Unknown"; this.richremarks.Text = ""; } this.richsourcecode.Text = bug.getCode(); this.richbugdesc.Text = bug.getbugdesc(); this.imgscreenshot.Image = bug.GetImage(); this.txtclassname.Text = bug.getClass(); this.txtcomponent.Text = bug.getComponentName(); this.txtproject.Text = bug.getProjectName(); this.txtmethodname.Text = bug.getMethod(); this.txtlinefrom.Text = bug.getlinenofrom().ToString(); this.txtlineto.Text = bug.getlinenoto().ToString(); this.lblbugstatus.Text = bug.getStatus(); this.lblversion.Text = bug.getVersion(); imgnew = bug.GetImage(); //setting bug image if (bug.getSeverity() == "Critical") { this.imgbugseverity.Image = Properties.Resources.bugred; } else if (bug.getSeverity() == "Low") { this.imgbugseverity.Image = Properties.Resources.buggreen; } //enabling disabling assign bug feature if (bug.getAssignedTo() != "") { this.txtdeveloperusername.ReadOnly = true; this.txtdeveloperusername.Text = bug.getAssignedTo(); this.btnassignbug.Enabled = false; } else { this.txtdeveloperusername.ReadOnly = false; this.btnassignbug.Enabled = true; } }
/// <summary> ///populate dashboard /// </summary> public void PopulateDashboardItems() { bug.setBugID(bugid); BugController bc = new BugController(); bc.populatepmdashboard(bug); this.richsourcecode.Text = bug.getCode(); this.richbugdesc.Text = bug.getbugdesc(); this.imgscreenshot.Image = bug.GetImage(); this.txtclassname.Text = bug.getClass(); this.txtcomponent.Text = bug.getComponentName(); this.txtproject.Text = bug.getProjectName(); this.txtmethodname.Text = bug.getMethod(); this.txtlinefrom.Text = bug.getlinenofrom().ToString(); this.txtlineto.Text = bug.getlinenoto().ToString(); this.lblbugstatus.Text = bug.getStatus(); imgnew = bug.GetImage(); //setting bug image if (bug.getSeverity() == "Critical") { this.imgbugseverity.Image = Properties.Resources.bugred; } else if (bug.getSeverity() == "Low") { this.imgbugseverity.Image = Properties.Resources.buggreen; } //enabling disabling assign bug feature if (bug.getAssignedTo() != "") { this.txtdeveloperusername.ReadOnly = true; this.txtdeveloperusername.Text = bug.getAssignedTo(); this.btnassignbug.Enabled = false; } else { this.txtdeveloperusername.ReadOnly = false; this.btnassignbug.Enabled = true; } }
//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); }