private void BugDetailView_Load(object sender, EventArgs e) { databaseConnection con = new databaseConnection(); string sql_BugDetailView = "Select B_Subject, B_Describe, B_Code,B_Update, Date from tbl_bug where B_Id ='" + lbl_BGDBugid.Text + "'"; string sql_BugDetailView1 = "Select tbl_userlogin.UserName from tbl_userlogin left join tbl_bug on tbl_bug.User_Id = tbl_userlogin.User_Id where tbl_bug.B_Id ='" + lbl_BGDBugid.Text + "'"; MySqlCommand cmd = new MySqlCommand(sql_BugDetailView, con.Db_Connect()); MySqlCommand cmd1 = new MySqlCommand(sql_BugDetailView1, con.Db_Connect()); MySqlDataReader r = cmd.ExecuteReader(); MySqlDataReader r1 = cmd1.ExecuteReader(); if (r.Read() && r1.Read()) { lbl_BGDSubject.Text = r.GetString("B_Subject"); rtxt_BugDescribtion.Text = r.GetString("B_Describe"); rtxt_BGDBugProblem.Text = r.GetString("B_Code"); lbl_BGDTrackUser.Text = r1.GetString("UserName"); rtxt_BGDBugSolution.Text = r.GetString("B_Update"); lbl_BGDDate.Text = r.GetString("Date"); } else { MessageBox.Show("error !!!!!! UserName aand Usr_Type not shown"); } con.CloseConnection(); }
private void btn_ListDone_Click(object sender, EventArgs e) { databaseConnection con = new databaseConnection(); string sql_updateBug = "UPDATE tbl_Bug SET B_Subject= '" + txt_ListSubject.Text + "', B_Code='" + rtxt_ListCode.Text + "', B_Describe='" + rtxt_ListDescribtion.Text + "' WHERE B_Id= '" + lbl_BugIdDisplay.Text + "'"; MySqlCommand cmd = new MySqlCommand(sql_updateBug, con.Db_Connect()); cmd.ExecuteNonQuery(); MessageBox.Show("Update Successful"); txt_ListSubject.Clear(); rtxt_ListCode.Clear(); rtxt_ListDescribtion.Clear(); string sql_Buglist = "Select B_Id,B_Subject from tbl_bug"; MySqlCommand cmd1 = new MySqlCommand(sql_Buglist, con.Db_Connect()); DataTable dt = new DataTable(); MySqlDataAdapter msda = new MySqlDataAdapter(cmd1); dt.Clear(); msda.Fill(dt); dataGridView_Bug.DataSource = dt; con.CloseConnection(); }
private void btn_Submit_Click(object sender, EventArgs e) { databaseConnection con = new databaseConnection(); string sql_PpupdateBug = "UPDATE tbl_Bug SET B_Update='" + rtxt_PpUpdateCode.Text + "' WHERE B_Id= '" + lbl_PpBugId.Text + "'"; MySqlCommand cmd = new MySqlCommand(sql_PpupdateBug, con.Db_Connect()); cmd.ExecuteNonQuery(); MessageBox.Show("Submitted Successfully!!"); rtxt_PpErrorCode.Clear(); rtxt_PpUpdateCode.Clear(); string sql_Buglist = "Select B_Id,B_Subject from tbl_bug"; MySqlCommand cmd1 = new MySqlCommand(sql_Buglist, con.Db_Connect()); DataTable dt = new DataTable(); MySqlDataAdapter msda = new MySqlDataAdapter(cmd1); dt.Clear(); msda.Fill(dt); dataGridView_Bug.DataSource = dt; con.CloseConnection(); }
private void btn_Submit_Click(object sender, EventArgs e) { try { //converting image to byte byte[] images = null; //first declare using system.io; then FileStream streem = new FileStream(imglocation, FileMode.Open, FileAccess.Read); BinaryReader brs = new BinaryReader(streem); images = brs.ReadBytes((int)streem.Length); if (rtxt_Code.Text != "" && rtxt_Describe.Text != "" && txt_Subject.Text != "" && txt_Imageurl.Text != "") { //Inserting data to the database databaseConnection con = new databaseConnection(); String sql_insertbug = "INSERT INTO tbl_bug(User_Id,B_Subject,B_Describe,B_Code,B_Image,B_Update,Date, Project) VALUES ('" + lbl_UserIdDisplay.Text + "','" + txt_Subject.Text + "','" + rtxt_Describe.Text + "','" + rtxt_Code.Text + "','" + images + "','','" + dateTimePicker_Tracker.Text + "','" + comboBox_Project.Text + "')"; MySqlCommand cmd1 = new MySqlCommand(sql_insertbug, con.Db_Connect()); cmd1.ExecuteNonQuery(); MessageBox.Show("Bug have been reported"); con.CloseConnection(); //clearing all the values from the field pictureBox_Bug.Image = null; txt_Imageurl.Clear(); txt_Subject.Clear(); rtxt_Describe.Clear(); rtxt_Code.Clear(); } else { MessageBox.Show("Fill all the empty Field!!"); } try { databaseConnection con = new databaseConnection(); string sql_Buglist = "Select B_Id,B_Subject from tbl_bug"; MySqlCommand cmd1 = new MySqlCommand(sql_Buglist, con.Db_Connect()); DataTable dt = new DataTable(); MySqlDataAdapter msda = new MySqlDataAdapter(cmd1); dt.Clear(); msda.Fill(dt); dataGridView_Bug.DataSource = dt; } catch (Exception) { throw; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void AdminPanelfun() { try { //loading data in datagrid view in page load databaseConnection con1 = new databaseConnection(); string sql_Usrlist = "Select User_Id,UserName from tbl_userlogin"; MySqlCommand cmd1 = new MySqlCommand(sql_Usrlist, con1.Db_Connect()); DataTable dt = new DataTable(); MySqlDataAdapter msda1 = new MySqlDataAdapter(cmd1); dt.Clear(); msda1.Fill(dt); dataGridView_ApUserList.DataSource = dt; con1.CloseConnection(); //loading new buglist with no solution reply databaseConnection con = new databaseConnection(); string sql_Buglist = "Select B_Id,B_Subject from tbl_bug where B_Update=''"; MySqlCommand cmd = new MySqlCommand(sql_Buglist, con.Db_Connect()); DataTable dt1 = new DataTable(); MySqlDataAdapter msda = new MySqlDataAdapter(cmd); dt1.Clear(); msda.Fill(dt1); dataGridView_APBGL.DataSource = dt1; con.CloseConnection(); //loading solved buglist with solution reply databaseConnection con2 = new databaseConnection(); string sql_BuglistSolve = "Select B_Id,B_Subject from tbl_bug where B_Update!=''"; MySqlCommand cmd2 = new MySqlCommand(sql_BuglistSolve, con2.Db_Connect()); DataTable dt2 = new DataTable(); MySqlDataAdapter msda2 = new MySqlDataAdapter(cmd2); dt2.Clear(); msda2.Fill(dt2); dataGridView_APBGS.DataSource = dt2; con2.CloseConnection(); } catch (Exception) { } }
private void TrackerPanel_Load(object sender, EventArgs e) { try { databaseConnection con = new databaseConnection(); string sql_Buglist = "Select B_Id,B_Subject from tbl_bug"; MySqlCommand cmd1 = new MySqlCommand(sql_Buglist, con.Db_Connect()); DataTable dt = new DataTable(); MySqlDataAdapter msda = new MySqlDataAdapter(cmd1); dt.Clear(); msda.Fill(dt); dataGridView_Bug.DataSource = dt; con.CloseConnection(); } catch (Exception) { throw; } }