/// <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 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");
            }
        }