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