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)); }