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