private void button_bugreport_Click(object sender, EventArgs e)
{
Bug b = new Bug();
b.Show();
}
private void button_update_Click(object sender, EventArgs e)
{
MySqlConnection conn = new MySqlConnection("server = localhost; user id = root; database = bugtrack");
int BugID = 0;
if (textBox_bugid.Text.Trim() != "")
{
BugID = int.Parse(textBox_bugid.Text.Trim());
}
string ProjectTitle = comboBox_project.Text.ToString();
string BugTitle = textBox_bugtitle.Text.Trim();
string BugDescription = textBox_bugissue.Text.Trim();
string ReportDate = reportDate.Text.Trim();
string ImagePath = lbl_img_path.Text.Trim();
string status = combo_bugStatus.Text.ToString();
//getting loggedin user in added by field
string loggedusertype = Form1.usertype;
string reportedby = loggedusertype;
ReportDate = DateTime.Now.ToString("yyyy-MM-dd");
try
{
//Database connection
MySqlCommand sda = new MySqlCommand("update bugreport set project='" + this.comboBox_project.Text + "',bugtitle='" + this.textBox_bugtitle.Text + "',bugissue='" + this.textBox_bugissue.Text + "',reportdate='" + this.reportDate.Text + "',status='" + this.combo_bugStatus.Text + "',image='" + this.lbl_img_path.Text + "' where bugreport.id='" + this.textBox_bugid.Text + "'", conn);
conn.Open();
int rows = sda.ExecuteNonQuery();
//if Inserted rows is greater is greater than 0
//Else set isSuccess to false, Save Failed
if (rows > 0)
{
MessageBox.Show("Bug updated. click ok to continue");
//Refresh Data Grid View
Bug vb = new Bug();
DataTable dt = vb.Select_bug();
dataGridView.DataSource = dt;
//Clear all the Input fields
textBox_bugid.Clear();
comboBox_project.Text = "";
textBox_bugtitle.Clear();
textBox_bugissue.Clear();
reportDate.Text = "";
lbl_img_path.Text = "path";
combo_bugStatus.Text = "";
}
else
{
MessageBox.Show("Bug failed to update. click ok to continue");
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
finally
{
//Step :CLose Connection
conn.Close();
}
}
private void btn_managebug_Click(object sender, EventArgs e)
{
Bug bg = new Bug();
bg.Show();
}
