public static void EditTask(TaskWork task) { using (var _context = new DbGantChartContext()) { var taskdb = (from t in _context.TaskWorks.Include(x => x.Users) where t.ID == task.ID select t).Single(); taskdb.Title = task.Title; taskdb.description = task.description; taskdb.FromDate = task.FromDate; taskdb.ToDate = task.ToDate; taskdb.PercentCompleted = task.PercentCompleted; taskdb.Priority = task.Priority; taskdb.Url = task.Url; taskdb.Users.Clear(); foreach (User user in task.Users) { var userdb = (from u in _context.Users.Include(u => u.Tasks) where u.UserName == user.UserName select u).Single(); taskdb.Users.Add(userdb); } _context.SaveChanges(); } }
public static void AddUser(User user) { using (var _context = new DbGantChartContext()) { _context.Users.Add(user); _context.SaveChanges(); } }
public static void DeleteUser(User user) { using (var _context = new DbGantChartContext()) { var dbUser = (from u in _context.Users.Include(x => x.Tasks) where u.UserName == user.UserName select u).SingleOrDefault(); _context.Users.Remove(dbUser); _context.SaveChanges(); } }
public static void DeleteTask(int ID) { using (var _context = new DbGantChartContext()) { var task = (from t in _context.TaskWorks.Include(x => x.Users) where t.ID == ID select t).Single(); _context.TaskWorks.Remove(task); _context.SaveChanges(); } }
public static int UpdateUser(User user) { using (var _context = new DbGantChartContext()) { if (GetUser(user.UserName) == null) { return(-1); } _context.Users.AddOrUpdate(user); _context.SaveChanges(); return(1); } }
public static void AddTask(TaskWork taskWork) { using (var _context = new DbGantChartContext()) { TaskWork taskWork1 = new TaskWork(); foreach (User user in taskWork.Users) { var userdb = (from u in _context.Users.Include(u => u.Tasks) where u.UserName == user.UserName select u).Single(); userdb.Tasks.Add(taskWork); } taskWork.Users.Clear(); _context.TaskWorks.Add(taskWork); _context.SaveChanges(); } }