public static void AddNewTask(Task task, Employee em, frmListTask frmListTask) { using (var _context = new DBLabManagementEntities()) { var Ids = (from t in _context.Tasks select t.IDTask).ToList(); for (int i = 1; i <= _context.Tasks.Count() + 1; i++) { if (!Ids.Contains(i)) { task.IDTask = i; break; } } var employee = _context.Employees.FirstOrDefault(x => x.IDEmployee == em.IDEmployee); if (employee == null) { return; } employee.Tasks.Add(task); _context.Employees.AddOrUpdate(employee); _context.Tasks.Add(task); _context.SaveChanges(); AddTask(task, frmListTask); } }
public static void LoadListTask(Employee e, frmListTask frmListTask) { using (var _context = new DBLabManagementEntities()) { var employee = _context.Employees.FirstOrDefault(x => x.IDEmployee == e.IDEmployee); if (employee == null) { return; } foreach (Task task in employee.Tasks) { AddTask(task, frmListTask); } } }
public static void AddOrUpdateTask(Task task, frmListTask frmListTask, urcTask urcTask) { using (var _context = new DBLabManagementEntities()) { var t = _context.Tasks.FirstOrDefault(x => x.IDTask == task.IDTask); t.Employees.Clear(); _context.Tasks.AddOrUpdate(t); foreach (var em in task.Employees) { var employee = _context.Employees.FirstOrDefault(x => x.IDEmployee == em.IDEmployee); employee.Tasks.Add(t); } _context.Tasks.AddOrUpdate(task); _context.SaveChanges(); urcTask.Dispose(); AddTask(task, frmListTask); } }
private static void AddTask(Task task, frmListTask frmListTask) { if (frmListTask == null) { return; } if (task.Status == true.ToString()) { frmListTask.AddCompletegTask(task); } else { if (task.EndDate.Value > DateTime.Now) { frmListTask.AddDoingTask(task); } else { frmListTask.AddExpiredTask(task); } } }