public static Project FindProject(int id)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
Project project = db.Projects.Find(id);
return(project);
}
/// <summary>
/// Select all bugs from given project
/// </summary>
/// <param name="project">project name</param>
/// <returns>list</returns>
public static List <Bug> SelectAllBugsFromProject(int projectId)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.Bugs.Where(x => x.ProjectId == projectId && !x.Status.Equals("Deleted") &&
!x.Status.Equals("Closed")).Select(x => x).ToList());
}
public static void AddActivity(string user)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var User = db.UserProfiles.Where(x => x.UserName.Equals(user)).Select(x => x).FirstOrDefault();
User.LastActivityTime = DateTime.Now;
db.SaveChanges();
}
public static void DeleteBug(int BugId)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
Bug bug = db.Bugs.Where(x => x.BugId == BugId).Select(x => x).FirstOrDefault();
bug.Status = "Deleted";
db.SaveChanges();
}
public static void DeleteUser(int id)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
UserProfile User = db.UserProfiles.Where(x => x.UserId == id).Select(x => x).FirstOrDefault();
User.IsActive = false;
db.SaveChanges();
}
public static void DeleteAllUserProjects(int userId)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var userProjects = db.UserProfiles.Where(x => x.UserId == userId).Select(x => x).FirstOrDefault();
var projects = userProjects.Projects.ToList();
projects.ForEach(project => userProjects.Projects.Remove(project));
db.SaveChanges();
}
public static void DeleteBugFromDB(int BugId)
{
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
Bug bug = db.Bugs.Where(x => x.BugId == BugId).Select(x => x).FirstOrDefault();
db.Bugs.Remove(bug);
db.SaveChanges();
}
}
public static void EditProject(int project, string name, string description)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var findProject = db.Projects.Find(project);
findProject.ProjectName = name;
findProject.ProjectDescription = description;
db.SaveChanges();
}
public static void DeleteAllUsersForProject(int id)
{
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
Project project = db.Projects.Where(x => x.ProjectId == id).Select(x => x).FirstOrDefault();
var usersInProject = project.UserProfiles.ToList();
usersInProject.ForEach(user => project.UserProfiles.Remove(user));
db.SaveChanges();
}
}
public static void DeleteBugsToUser(int id)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var userBugs = db.Bugs.Where(x => x.UserId == id).Select(x => x);
foreach (var item in userBugs)
{
item.UserId = null;
}
db.SaveChanges();
}
public static void DeleteLogsForUser(int userId)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var logs = db.Logs.Where(x => x.UserId == userId).Select(x => x);
foreach (var item in logs)
{
db.Logs.Remove(item);
}
db.SaveChanges();
}
public static List <Bug> GetAllBugs()
{
List <Bug> allBug = null;
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
allBug = db.Bugs.Include("Project")
.Include("UserProfile").Where(x => !x.Status.Equals("Closed") && !x.Status.Equals("Deleted")).ToList();
}
return(allBug);
}
public static void AddProject(string projectName, string projectDescription)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
Project newProject = new Project()
{
ProjectName = projectName,
ProjectDescription = projectDescription,
};
db.Projects.Add(newProject);
db.SaveChanges();
}
public static void EditBug(int projectID, int userID, string status, string description, string priority, int bugId)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var selectBug = db.Bugs.Where(x => bugId == x.BugId).FirstOrDefault();
selectBug.ProjectId = projectID;
selectBug.UserId = userID;
selectBug.Status = status;
selectBug.BugDescription = description;
selectBug.Priority = priority;
db.SaveChanges();
}
public static void DeleteProject(int id)
{
LogDAL.DeleteAllLogsForProject(id);
BugDAL.DeleteBugsToProject(id);
DeleteAllUsersForProject(id);
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
Project project = db.Projects.Where(x => x.ProjectId == id).Select(x => x).FirstOrDefault();
db.Projects.Remove(project);
db.SaveChanges();
}
}
public static void DeleteLogsForBug(int bugId)
{
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
var log = db.Logs.Where(x => x.BugId == bugId).Select(x => x).ToList();
foreach (var item in log)
{
db.Logs.Remove(item);
}
db.SaveChanges();
}
}
public static void EditUserInfo(string username, string firstName, string lastName, string email, string telephone, int id)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var user = db.UserProfiles.Where(x => x.UserId == id).Select(x => x).FirstOrDefault();
user.UserName = username;
user.FirstName = firstName;
user.LastName = lastName;
user.Email = email;
user.Telephone = telephone;
db.SaveChanges();
}
public static void DeleteBugsToProject(int id)
{
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
var projectBugs = db.Bugs.Where(x => x.ProjectId == id).Select(x => x).ToList();
foreach (var item in projectBugs)
{
DeleteBugFromDB(item.BugId);
}
db.SaveChanges();
}
}
public static void AddLogForBug(string user, int bugId, string actvity)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var User = db.UserProfiles.Where(x => x.UserName.Equals(user)).FirstOrDefault();
Log log = new Log()
{
BugId = bugId,
UserId = User.UserId,
Time = DateTime.Now,
Activity = actvity,
};
db.Logs.Add(log);
db.SaveChanges();
}
public static bool IsProjectExist(string ProjectName, string Description)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var project = db.Projects.Where(x => x.ProjectName.Equals(ProjectName) && x.ProjectDescription
.Equals(Description)).Select(x => x).FirstOrDefault();
if (project == null)
{
return(false);
}
else
{
return(true);
}
}
//not working
public static void DeleteAllLogsForProject(int id)
{
using (BugReporter_v2Entities db = new BugReporter_v2Entities())
{
var selectAllBugsToProject = db.Bugs.Include("Logs").Where(x => x.ProjectId == id).Select(x => x);
foreach (var item in selectAllBugsToProject)
{
DeleteLogsForBug(item.BugId);
//var logs = item.Logs.ToList();
//logs.ForEach(log => item.Logs.Remove(log));
//db.Bugs.Remove(item);
}
db.SaveChanges();
}
}
/// <summary>
/// Submitting a bug to project
/// </summary>
/// <param name="project">project name </param>
/// <param name="user">user name</param>
///
public static void SubmitBugToProject(int projectId, string user, string status, string description, string priority)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
var User = db.UserProfiles.Include("Projects").Where(x => x.UserName.Equals(user)).Select(x => x).FirstOrDefault();
var project = db.Projects.Where(x => x.ProjectId == projectId).Select(x => x).FirstOrDefault();
var userID = User.UserId;
Bug newBug = new Bug()
{
UserId = userID,
Status = status,
BugDescription = description,
Priority = priority,
ProjectId = projectId,
DateOfFirstSubmit = DateTime.Now
};
db.Bugs.Add(newBug);
User.Projects.Add(project);
db.SaveChanges();
}
public static List <UserProfile> GetAllUsers()
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.UserProfiles.Select(x => x).ToList());
}
public static UserProfile GetUserByName(string userName)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.UserProfiles.Where(x => x.UserName.Equals(userName)).Select(x => x).FirstOrDefault());
}
public static Bug GetBugByID(int id)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.Bugs.Where(x => x.BugId == id).Select(x => x).FirstOrDefault());
}
public static List <Bug> GetLastAddedBug()
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.Bugs.OrderByDescending(x => x.BugId).Select(x => x).Take(1).ToList());
}
public static UserProfile FindUser(int id)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.UserProfiles.Find(id));
}
public static int GetCountOfProjects(string username)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.UserProfiles.Where(x => x.UserName.Equals(username)).Select(x => x.Projects).Count());
}
public static List <Log> GetAllLogsForUser(string username)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.Logs.Where(x => x.UserProfile.UserName.Equals(username)).Select(x => x).ToList());
}
public static UserProfile FindUserByName(string name)
{
BugReporter_v2Entities db = new BugReporter_v2Entities();
return(db.UserProfiles.Find(name));
}
