public static void RemoveBug(int bugId) { BugTrackerEntities db = new BugTrackerEntities(); Bug bug = db.Bugs.Find(bugId); bug.Status = "Deleted"; db.Entry(bug).State = EntityState.Modified; db.SaveChanges(); }
public static void UpdateBugInfoCard(int userId, int bugId, string action) { BugTrackerEntities db = new BugTrackerEntities(); InfoCard iCard = db.InfoCards.Find(userId); iCard.LastActivity = DateTime.Now; iCard.LastAction = action + " bug #" + bugId; db.Entry(iCard).State = EntityState.Modified; db.SaveChanges(); }
public static void UpdateUser(int userId, string email, string firstName, string lastName, string phoneNumber) { BugTrackerEntities db = new BugTrackerEntities(); UserProfile user = db.UserProfiles.Find(userId); user.Email = email; user.FirstName = firstName; user.LastName = lastName; user.PhoneNumber = phoneNumber; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); }
public static void RemoveUserFromBugs(int userId) { BugTrackerEntities db = new BugTrackerEntities(); IQueryable<Bug> bugs = db.Bugs.Where(x => x.UserId == userId); foreach (var bug in bugs) { bug.UserId = null; db.Entry(bug).State = EntityState.Modified; } db.SaveChanges(); }
public static void UpdateBug(int bugId, string priority, string status, string description) { BugTrackerEntities db = new BugTrackerEntities(); Bug bug = db.Bugs.Find(bugId); bug.Priority = priority; bug.Status = status; bug.Description = description; db.Entry(bug).State = EntityState.Modified; db.SaveChanges(); }
public static void AddBugToInfoCard(int userId, int projectId) { BugTrackerEntities db = new BugTrackerEntities(); InfoCard iCard = db.InfoCards.Find(userId); Project project = db.Projects.Find(projectId); if (!iCard.Projects.Contains(project)) { iCard.NumberOfProjects += 1; iCard.Projects.Add(project); } iCard.NumberOfBugs += 1; iCard.LastActivity = DateTime.Now; iCard.LastAction = "Added new bug for project \"" + project.ProjectName + "\""; db.Entry(iCard).State = EntityState.Modified; db.SaveChanges(); }
public static void UpdateProject(int projectId, string projectName, string description) { BugTrackerEntities db = new BugTrackerEntities(); Project project = db.Projects.Find(projectId); project.ProjectName = projectName; project.Description = description; db.Entry(project).State = EntityState.Modified; db.SaveChanges(); }
public static void UpdateInfoCardDescription(int iCardId, string description) { BugTrackerEntities db = new BugTrackerEntities(); InfoCard iCard = db.InfoCards.Find(iCardId); iCard.LastActivity = DateTime.Now; iCard.LastAction = description; db.Entry(iCard).State = EntityState.Modified; db.SaveChanges(); }