/// <summary> /// gets latest bugs in chains /// </summary> /// <param name="DeveloperID"></param> /// <param name="openOnly">parameter to show only open if true, else show open and close</param> /// <returns>list of bugs that Assigned user's ID = Developer ID</returns> public static new List <DeveloperBug> GetAssignedDevloperBugs(long DeveloperID, Boolean openOnly) { List <DeveloperBug> BugList = new List <DeveloperBug>(); DataSet ds = new DataSet(); SqlConnection sqlCon = new SqlConnection(Settings.AzureBugTrackingConnectionString); SqlCommand sqlCom = new SqlCommand("SELECT dbo.Bugs.id, dbo.Bugs.Title, dbo.Bugs.Comment, dbo.Bugs.LocationID, dbo.DeveloperBug.BugOpen,dbo.Bugs.CreatedDate,dbo.DeveloperBug.Code, dbo.Bugs.Archived, dbo.DeveloperBug.NextBugId, dbo.Bugs.CreatedById, dbo.DeveloperBug.previousBugID, dbo.DeveloperBug.Priority, dbo.Bugs.AssignedUserID FROM dbo.DeveloperBug LEFT OUTER JOIN dbo.Bugs ON dbo.DeveloperBug.BugID = dbo.Bugs.id where (AssignedUserID = @Id or CreatedByID = @Id ) and dbo.DeveloperBug.NextBugId is null", sqlCon); sqlCom.Parameters.Add(new SqlParameter("@Id", DeveloperID)); if (openOnly == true) { sqlCom.Parameters.Add(new SqlParameter("@open", true)); sqlCom.CommandText += " AND BugOpen = @open"; } try { sqlCon.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCom); sqlDa.Fill(ds); } finally { sqlCon.Close(); } if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { long Id = (long)row["Id"]; String Title = (String)row["Title"]; String Comment = (String)row["Comment"]; long previousBugId = (long)Settings.iif(Convert.IsDBNull(row["previousBugId"]), 0, (long)row["previousBugId"]); long locationID = (long)Settings.iif(Convert.IsDBNull(row["locationID"]), (long)row["locationID"], (long)0); BugLocation bugLocation = new BugLocation(locationID); DateTime CreatedDate = (DateTime)row["CreatedDate"]; bool BugOpen; if ((bool)row["BugOpen"] == true) { BugOpen = true; } else { BugOpen = false; } bugLocation.Get(); long priority = (long)row["priority"]; String code = ""; if (row["Code"] != DBNull.Value) { code = (String)row["Code"]; } DeveloperBug newBug = new DeveloperBug(Id, Title, Comment, bugLocation, previousBugId, priority, BugOpen, code); newBug.CreatedDate = CreatedDate; Developer developer = Developer.Get((long)row["CreatedById"]); BugList.Add(newBug); } } else { //throw exeption return(null); } return(BugList); }
/// <summary> /// Lists all Developer Bugs /// </summary> /// <returns>List of Developer Bugs</returns> public static new List <DeveloperBug> Get() { List <DeveloperBug> BugList = new List <DeveloperBug>(); DataSet ds = new DataSet(); SqlConnection sqlCon = new SqlConnection(Settings.AzureBugTrackingConnectionString); SqlCommand sqlCom = new SqlCommand("SELECT dbo.Bugs.id, dbo.Bugs.Title, dbo.Bugs.Comment, dbo.Bugs.LocationID, dbo.DeveloperBug.BugOpen, dbo.Bugs.Archived, dbo.DeveloperBug.NextBugId, dbo.Bugs.CreatedById, dbo.Bugs.previousBugID, dbo.Bugs.Priority, dbo.Bugs.AssignedUserID FROM dbo.DeveloperBug LEFT OUTER JOIN dbo.Bugs ON dbo.DeveloperBug.BugID = dbo.Bugs.id", sqlCon); try { sqlCon.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCom); sqlDa.Fill(ds); } finally { sqlCon.Close(); } if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { long Id = (long)row["Id"]; String Title = (String)row["Title"]; String Comment = (String)row["Comment"]; long previousBugId = (long)Settings.iif(Convert.IsDBNull(row["previousBugId"]), 0, (long)row["previousBugId"]); String code = (String)row["Code"]; Boolean isNull = Convert.IsDBNull(row["NextBugID"]); long NextBugId = (long)0; if (!isNull) { NextBugId = (long)row["NextBugID"]; } long locationID = (long)Settings.iif(Convert.IsDBNull(row["locationID"]), (long)row["locationID"], (long)0); BugLocation bugLocation = new BugLocation(locationID); bool BugOpen; if ((bool)row["BugOpen"] == true) { BugOpen = true; } else { BugOpen = false; } bugLocation.Get(); long priority = (long)row["priority"]; DeveloperBug newBug = new DeveloperBug(Id, Title, Comment, bugLocation, previousBugId, priority, BugOpen, code); Developer developer = Developer.Get((long)row["CreatedById"]); BugList.Add(newBug); } } else { //throw exeption return(null); } return(BugList); }