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 List <User> GetListUser(string username) { using (var _context = new DbGantChartContext()) { var user = _context.Users.Where(u => u.UserName.Contains(username)); return(user.ToList()); } }
public static void AddUser(User user) { using (var _context = new DbGantChartContext()) { _context.Users.Add(user); _context.SaveChanges(); } }
public static User GetUser(string username) { using (var _context = new DbGantChartContext()) { var dbUser = (from u in _context.Users.Include("Tasks.Users") where u.UserName == username select u).SingleOrDefault(); return(dbUser); } }
public static TaskWork GetTask(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(); return(task); } }
public static List <TaskWork> GetListTask() { using (var _context = new DbGantChartContext()) { var task = (from t in _context.TaskWorks.Include(t => t.Users) select t).ToList(); return(task); } }
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 List <User> GetListUser() { using (var _context = new DbGantChartContext()) { var users = _context.Users .Include(t => t.Tasks); var listUser = from u in users select u; return(listUser.ToList()); } }
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); } }
private void btDelete_Click(object sender, EventArgs e) { if (dataTasks.SelectedRows.Count == 0) { return; } using (var _context = new DbGantChartContext()) { for (int i = 0; i < dataTasks.SelectedRows.Count; i++) { TaskController.DeleteTask(Convert.ToInt32(dataTasks.SelectedRows[i].Cells["cId"].Value)); } } HienThi(TaskController.GetListTask()); }
private void btDelete_Click(object sender, EventArgs e) { if (dataUser.SelectedRows.Count == 0) { return; } using (var _context = new DbGantChartContext()) { for (int i = 0; i < dataUser.SelectedRows.Count; i++) { string str = dataUser.SelectedRows[i].Cells["cUserName"].Value.ToString(); User user = _context.Users.Find(str); UserController.DeleteUser(user); } } RefreshControll(); }
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(); } }