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; }
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; }
public void UpdateBug(Bug bug) { using (MySqlConnection con = CreateSqlConnection()) { con.Open(); UpdateBug(bug, con); con.Close(); } }