コード例 #1
0
        private void BugSolution_Load(object sender, EventArgs e)
        {
            // Data Grid View
            BugSolution vu = new BugSolution();
            DataTable   dt = vu.Select_bug();

            dgv1.DataSource = dt;
        }
コード例 #2
0
        private void btn_solution_Click(object sender, EventArgs e)
        {
            MySqlConnection conn  = new MySqlConnection("server = localhost; user id = root; database = bugtracker");
            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 = login.loggedIn;

            string Fixedby = loggedusr;

            ReportDate = DateTime.Now.ToString("yyyy-MM-dd");
            SolveDate  = DateTime.Now.ToString("yyyy-MM-dd");


            try
            {
                //connecting to the database

                MySqlCommand sda = new MySqlCommand("INSERT INTO bugsolve (bugid, project, bugtitle, class,method,line,error,solved,reportdate,solvedate,status,fixedby) " +
                                                    "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 + "',@Fixedby)", conn);
                sda.Parameters.AddWithValue("@Fixedby", Fixedby);
                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");
                    //connecting to the database
                    MySqlConnection con = new MySqlConnection("server = localhost; user id = root; database = bugtracker");
                    //getting data from database using dataadapter
                    MySqlDataAdapter adapter = new MySqlDataAdapter("update bug set status='" + this.cmbBox_status.Text + "' where id='" + this.txtBox_bugID.Text + "'", conn);
                    //to hold data from database
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);//it means the fill in our database
                    //Refresh Data Grid View

                    BugSolution bs = new BugSolution();
                    dt = bs.Select_bug();
                    dgv1.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();
            }
        }