Example #1
0
        public IList<Bug> GetBugList(string sprint)
        {
            List<Bug> bugs = new List<Bug>();

            Options options = new Options();

            using (MySqlConnection con = CreateSqlConnection())
            {
                con.Open();

                using (MySqlCommand com = new MySqlCommand(options.BugSelectQuery, con))
                {
                    com.Parameters.AddWithValue("@sprintName", sprint);

                    using (MySqlDataReader reader = com.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            Bug bug = new Bug();
                            bug.ID = reader.GetInt64(0);
                            bug.Title = reader.GetString(1);
                            bug.Estimate = reader.GetString(2);
                            bug.Priority = reader.GetString(3);

                            if (!reader.IsDBNull(4))
                                bug.Importance = reader.GetInt64(4);

                            bug.Feature = reader.GetString(5);
                            bug.Product = reader.GetString(6);

                            bugs.Add(bug);
                        }
                    }
                }

                con.Close();
            }

            return bugs;
        }
Example #2
0
        private void UpdateBug(Bug bug, MySqlConnection con)
        {
            using (MySqlCommand com = new MySqlCommand("UPDATE bugs set cf_scrum_importance = @importance WHERE bug_id = @bugID", con))
            {
                com.Parameters.AddWithValue("@importance", bug.Importance);
                com.Parameters.AddWithValue("@bugID", bug.ID);

                com.ExecuteNonQuery();
            }

            bug = null;
            con = null;
        }
Example #3
0
        public void UpdateBug(Bug bug)
        {
            using (MySqlConnection con = CreateSqlConnection())
            {
                con.Open();

                UpdateBug(bug, con);

                con.Close();
            }
        }