public static IEnumerable<Project> GetProjects(int page, int pageSize, bool asc, string sortExpression, out int itemsCount)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
int items;
if(sortExpression == "SortNumber")
{
var projects = db.Projects.Page(page, pageSize, p => p.ProjectId, asc, out items);
itemsCount = items;
return projects;
}
else if (sortExpression == "SortName")
{
var projects = db.Projects.Page(page, pageSize, p => p.Name, asc, out items);
itemsCount = items;
return projects;
}
else if (sortExpression == "SortDescription")
{
var projects = db.Projects.Page(page, pageSize, p => p.Description, asc, out items);
itemsCount = items;
return projects;
}
else
{
itemsCount = 0;
return null;
}
}
public static void Delete(int bugId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
Bug bugToDelete = db.Bugs.Single(t => t.BugId == bugId);
bugToDelete.Status = Status.Deleted.ToString();
db.SubmitChanges();
}
public static int GetBugsCountByProject(string projectName)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
string sqlFindBugsCountByProjectName =
"SELECT Count(*) FROM Bugs b JOIN Projects p ON (b.ProjectId=p.ProjectId) WHERE p.Name = '" + projectName + "' and b.Status != 'Closed'";
int bugsCount = db.ExecuteQuery<int>(sqlFindBugsCountByProjectName).First();
return bugsCount;
}
public static IEnumerable<Bug> GetBugs(int page, int pageSize, bool asc, string sortExpression, out int itemsCount)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
int items;
switch (sortExpression)
{
case "SortDescription":
var bugs = db.Bugs.Page(page, pageSize, p => p.Description,
p=> p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
case "SortId":
bugs = db.Bugs.Page(page, pageSize, p => p.BugId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
case "SortPriority":
bugs = db.Bugs.Page(page, pageSize, p => p.Priority,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
case "SortOwner":
bugs = db.Bugs.Page(page, pageSize, p => p.Tester.Name,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
case "SortProject":
bugs = db.Bugs.Page(page, pageSize, p => p.Project.Name,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
case "SortStatus":
bugs = db.Bugs.Page(page, pageSize, p => p.Status,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
itemsCount = 0;
return null;
}
public static void Delete(int testerId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
// all testers bugs must leave without author
foreach (Bug bug in db.Bugs.Where( p=> p.TesterId == testerId))
{
bug.TesterId = null;
}
Tester testerToDelete = db.Testers.Single(t => t.TesterId == testerId);
db.Testers.DeleteOnSubmit(testerToDelete);
db.SubmitChanges();
}
public static void Delete(int projectId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
// delete all project bugs
foreach (Bug bug in db.Bugs.Where(p => p.ProjectId == projectId))
{
db.Bugs.DeleteOnSubmit(bug);
}
Project ProjectToDelete = db.Projects.Single(t => t.ProjectId == projectId);
db.Projects.DeleteOnSubmit(ProjectToDelete);
db.SubmitChanges();
}
public static Project GetProjectByName(string projtectName)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
IQueryable<Project> projects = from p in db.Projects
where p.Name == projtectName
select p;
foreach (Project project in projects)
{
return project;
}
return null;
}
public static Tester GetTesterByUsername(string username)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
IQueryable<Tester> testers = from t in db.Testers
where t.Username == username
select t;
foreach (Tester tester in testers)
{
return tester;
}
return null;
}
public static Project GetProjectByName(string projtectName)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
IQueryable <Project> projects = from p in db.Projects
where p.Name == projtectName
select p;
foreach (Project project in projects)
{
return(project);
}
return(null);
}
public static IEnumerable<Tester> GetTesters(int page, int pageSize, bool asc, string sortExpression, out int itemsCount)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
int items;
switch (sortExpression)
{
case "SortNumber":
var testers = db.Testers.Page(page, pageSize, p => p.TesterId, p => p.Username != "admin", asc, out items);
itemsCount = items;
return testers;
case "SortName":
testers = db.Testers.Page(page, pageSize, p => p.Name, p => p.Username != "admin", asc, out items);
itemsCount = items;
return testers;
case "SortSurname":
testers = db.Testers.Page(page, pageSize, p => p.Surname, p => p.Username != "admin", asc, out items);
itemsCount = items;
return testers;
}
itemsCount = 0;
return null;
}
public static void Update(Project project)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
Project projectToUpdate = db.Projects.Single(t => t.ProjectId == project.ProjectId);
projectToUpdate.Name = project.Name;
projectToUpdate.Description = project.Description;
db.SubmitChanges();
}
public static int NumberFoundBugs(int testerId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return (from bug in db.Bugs
where bug.TesterId == testerId
select bug).Count();
}
public static int Insert(Tester tester)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
db.Testers.InsertOnSubmit(tester);
db.SubmitChanges();
return tester.TesterId;
}
public static void Update(Bug bug)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
Bug bugToUpdate = db.Bugs.Single(t => t.BugId == bug.BugId);
bugToUpdate.Description = bug.Description;
bugToUpdate.Priority = bug.Priority;
bugToUpdate.Status = bug.Status;
db.SubmitChanges();
}
public static IEnumerable<Bug> GetBugsByProjectId(int projectId, int page, int pageSize, bool asc, string sortExpression, bool showClosed, out int itemsCount)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
int items;
switch (sortExpression)
{
case "SortId":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.BugId,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.BugId,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
case "SortOwner":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.TesterId,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.TesterId,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
case "SortPriority":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Priority,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Priority,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
case "SortDate":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.CreationDate,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.CreationDate,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
case "SortDescription":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Description,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Description,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
case "SortProject":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Project.Name,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Project.Name,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
case "SortStatus":
if (showClosed)
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Status,
p => p.ProjectId == projectId,
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
else
{
var bugs = db.Bugs.Page(page, pageSize, p => p.Status,
p => p.ProjectId == projectId,
p => p.Status != Status.Closed.ToString(),
p => p.Status != Status.Deleted.ToString(),
asc, out items);
itemsCount = items;
return bugs;
}
}
itemsCount = 0;
return null;
}
public static IEnumerable <Project> GetAllProjects()
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return(db.Projects);
}
public static int NumberParticipatingProjects(int testerId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return (from bug in db.Bugs
where bug.TesterId == testerId
select bug.ProjectId).Distinct().Count();
}
public static IEnumerable <Tester> GetAllTesters()
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return(db.Testers.Where(p => p.Username != "admin"));
}
public static Tester GetTesterByTesterId(int testerId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return(db.Testers.Single(t => t.TesterId == testerId));
}
public static Bug GetBugByBugId(int bugId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return db.Bugs.Single(t => t.BugId == bugId);
}
public static IEnumerable<Project> GetAllProjects()
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return db.Projects;
}
public static void Update(Tester tester)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
Tester testerToUpdate = db.Testers.Single(t => t.TesterId == tester.TesterId);
testerToUpdate.Password = tester.Password;
testerToUpdate.Name = tester.Name;
testerToUpdate.Surname = tester.Surname;
testerToUpdate.Phone = tester.Phone;
testerToUpdate.Email = tester.Email;
testerToUpdate.LastAction = tester.LastAction;
db.SubmitChanges();
}
public static int Insert(Bug bug)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
db.Bugs.InsertOnSubmit(bug);
db.SubmitChanges();
return bug.BugId;
}
public static Project GetProjectByProjectId(int projtectId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return db.Projects.Single(t => t.ProjectId == projtectId);
}
public static IEnumerable<Tester> GetAllTesters()
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return db.Testers.Where( p => p.Username != "admin");
}
public static int Insert(Project project)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
db.Projects.InsertOnSubmit(project);
db.SubmitChanges();
return project.ProjectId;
}
public static Tester GetTesterByTesterId(int testerId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return db.Testers.Single(t => t.TesterId == testerId);
}
public static Bug GetBugByBugId(int bugId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return db.Bugs.Single(t => t.BugId == bugId);
}
public static Project GetProjectByProjectId(int projtectId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
return(db.Projects.Single(t => t.ProjectId == projtectId));
}