public DeveloperBug(String title, String comment, BugLocation location, long PreviousBugId, long Priority, Boolean BugOpen, String Code) : base(title, comment, location)
{
this.PreviousBugID = PreviousBugId;
this.Priority = Priority;
this.BugOpen = BugOpen;
this.Code = Code;
}
public Bug(long Id, String Title, String Comment, BugLocation location)
{
this.Title = Title;
this.Comment = Comment;
this.Id = Id;
this.Location = location;
}
/// <summary>
/// gets latest bugs in chains
/// </summary>
/// <param name="DeveloperID"></param>
/// <param name="notArchived">parameter to show only not Archived Bugs, that do not have a new version</param>
/// <returns>list of bugs that Assigned user's ID = Developer ID</returns>
public static List <Bug> GetAssignedBugs(long DeveloperID, Boolean notArchived)
{
List <Bug> BugList = new List <Bug>();
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.Bugs.CreatedDate, dbo.Bugs.CreatedById, dbo.Bugs.AssignedUserID FROM Bugs where AssignedUserID = @Id", sqlCon);
sqlCom.Parameters.Add(new SqlParameter("@Id", DeveloperID));
if (notArchived)
{
sqlCom.CommandText += " AND Bugs.Archived = @Archived";
sqlCom.Parameters.Add(new SqlParameter("@Archived", false));
}
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 locationID = (long)Settings.iif(Convert.IsDBNull(row["locationID"]), (long)row["locationID"], (long)0);
BugLocation bugLocation = new BugLocation(locationID);
DateTime CreatedDate = (DateTime)row["CreatedDate"];
Bug newBug = new Bug(Id, Title, Comment, bugLocation);
newBug.CreatedDate = CreatedDate;
Developer developer = Developer.Get((long)row["CreatedById"]);
BugList.Add(newBug);
}
}
else
{
//throw exeption
return(null);
}
return(BugList);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Boolean Get(long id)
{
//retreives information about bug with ID
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(Settings.AzureBugTrackingConnectionString);
SqlCommand sqlCom = new SqlCommand("Select * From Bugs where Id = @ID", sqlCon);
sqlCom.Parameters.Add(new SqlParameter("@ID", id));
try
{
sqlCon.Open();
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCom);
sqlDa.Fill(ds);
}
finally
{
sqlCon.Close();
}
if (ds.Tables[0].Rows.Count > 0)
{
this.Id = id;
this.Title = (String)ds.Tables[0].Rows[0]["Title"];
this.Comment = (String)ds.Tables[0].Rows[0]["Comment"];
this.Location = new BugLocation((long)ds.Tables[0].Rows[0]["LocationID"]);
this.AssignedUserID = (long)ds.Tables[0].Rows[0]["AssignedUserID"];
this.CreatedDate = (DateTime)ds.Tables[0].Rows[0]["CreatedDate"];
this.createdByID = (long)ds.Tables[0].Rows[0]["CreatedByID"];
return(true);
}
else
{
return(false);
}
}
public DeveloperBug(long Id, String title, String comment, BugLocation location, long PreviousBugId, long Priority, Boolean BugOpen, String Code) : this(title, comment, location, PreviousBugId, Priority, BugOpen, Code)
{
this.Id = Id;
}
/// <summary>
/// Get single developer Bug details
/// </summary>
/// <param name="id">Id of developer bug</param>
/// <returns>returns bug</returns>
public static new DeveloperBug Get(long id)
{
//retreives information about bug with ID
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.Bugs.CreatedDate, dbo.DeveloperBug.BugOpen,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 Id = @ID", sqlCon);
sqlCom.Parameters.Add(new SqlParameter("@ID", id));
try
{
sqlCon.Open();
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCom);
sqlDa.Fill(ds);
}
finally
{
sqlCon.Close();
}
if (ds.Tables[0].Rows.Count > 0)
{
long Id = id;
String Title = (String)ds.Tables[0].Rows[0]["Title"];
String Comment = (String)ds.Tables[0].Rows[0]["Comment"];
BugLocation Location = new BugLocation((long)ds.Tables[0].Rows[0]["LocationID"]);
DateTime CreatedDate = (DateTime)ds.Tables[0].Rows[0]["CreatedDate"];
long PreviousBugId = 0;
if (ds.Tables[0].Rows[0]["PreviousBugID"] != DBNull.Value)
{
PreviousBugId = (long)ds.Tables[0].Rows[0]["PreviousBugID"];
}
long NextBugID = 0;
if (ds.Tables[0].Rows[0]["NextBugId"] != DBNull.Value)
{
NextBugID = (long)ds.Tables[0].Rows[0]["NextBugId"];
}
List <Bug> UserBugs;
long Priority = (long)ds.Tables[0].Rows[0]["Priority"];
Boolean BugOpen = (Boolean)ds.Tables[0].Rows[0]["BugOpen"];
String code = "";
if (ds.Tables[0].Rows[0]["Code"] != DBNull.Value)
{
code = (String)ds.Tables[0].Rows[0]["Code"];
}
long assignedUserID = 0;
if (ds.Tables[0].Rows[0]["Code"] != DBNull.Value)
{
assignedUserID = (long)ds.Tables[0].Rows[0]["AssignedUserID"];
}
DeveloperBug bug = new DeveloperBug(Id, Title, Comment, Location, PreviousBugId, Priority, BugOpen, code);
bug.CreatedDate = CreatedDate;
bug.NextBugId = NextBugID;
bug.AssignedUserID = assignedUserID;
return(bug);
}
else
{
return(null);
}
}
/// <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);
}
public Bug(string Title, string Comment, BugLocation location) : this(Title, Comment)
{
Location = location;
}
/// <summary>
/// gets defaulted user based on location
/// </summary>
/// <returns>defaulted user to attend this bug</returns>
public static User GetDefaultedUser(BugLocation location)
{
return(null);
}