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