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