private void AddBugSolution_Load(object sender, EventArgs e)
{
//Data Grid View
AddBugSolution ab = new AddBugSolution();
DataTable dt = ab.SelectBug();
dgv_sol.DataSource = dt;
}
private void button_bugsol_Click(object sender, EventArgs e)
{
AddBugSolution abs = new AddBugSolution();
abs.Show();
}
private void btn_save_Click(object sender, EventArgs e)
{
MySqlConnection conn = new MySqlConnection("server = localhost; user id = root; database = bugtrack");
int BugID = 0;
if (txtBox_bugID.Text.Trim() != "")
{
BugID = int.Parse(txtBox_bugID.Text.Trim());
}
string ProjectTitle = txtboxProject.Text.ToString();
string BugTitle = txt_bugtitle.Text.Trim();
string cls = txt_class.Text;
string mthd = txt_method.Text;
string line = txt_line.Text;
string BugDescription = txtdes.Text.Trim();
string bugsolved = txt_bugsol.Text;
string ReportDate = reportDate.Text.Trim();
string SolveDate = solvedate.Text.Trim();
string status = cmbBox_status.Text.ToString();
//Getting loggedin user in added by field
string loggedusr = Form1.uname;
string BugFixedName = loggedusr;
ReportDate = DateTime.Now.ToString("yyyy-MM-dd");
SolveDate = DateTime.Now.ToString("yyyy-MM-dd");
try
{
//Database connection
MySqlCommand sda = new MySqlCommand("INSERT INTO bugsolve (bugid, projectTitle, bugTitle, class,method,line,error,solution,reportdate,solvedate,status,BugFixedName) " +
"VALUES ('" + this.txtBox_bugID.Text + "','" + this.txtboxProject.Text + "','" + this.txt_bugtitle.Text + "','" + this.txt_class.Text + "','" + this.txt_method.Text + "','" + this.txt_line.Text + "'" +
",'" + this.txtdes.Text + "','" + this.txt_bugsol.Text + "','" + this.reportDate.Text + "','" + this.solvedate.Text + "','" + this.cmbBox_status.Text + "',@BugFixedName)", conn);
sda.Parameters.AddWithValue("@BugFixedName", BugFixedName);
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 fixed. click ok to continue");
//Database connection
MySqlConnection con = new MySqlConnection("server = localhost; user id = root; database = bugtrack");
//Getting data from database using DataAdapter
MySqlDataAdapter adapter = new MySqlDataAdapter("update bugreport set status='" + this.cmbBox_status.Text + "' where id='" + this.txtBox_bugID.Text + "'", conn);
//Holding data from database
DataTable dt = new DataTable();
adapter.Fill(dt);//It means the fill in our database
//Refresh Data Grid View
AddBugSolution abs = new AddBugSolution();
dt = abs.SelectBug();
dgv_sol.DataSource = dt;
//Clear all the Input fields
txtboxProject.Clear();
txt_bugtitle.Clear();
txt_class.Clear();
txt_method.Clear();
txt_line.Clear();
txtdes.Clear();
txt_bugsol.Clear();
}
else
{
MessageBox.Show("Bug failed to fixed. click ok to continue");
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
finally
{
//Step :CLose Connection
conn.Close();
}
}