public async Project.Task CreateEmployeeTaskAsync(int taskId, int employeeId) { int countEmployeeTask = 0; countEmployeeTask = await _db.EmployeeTasks.Where(e => e.EmployeeId == employeeId && e.TaskId == taskId).CountAsync(); if (countEmployeeTask == 0) { EmployeeTask employeeTask = new EmployeeTask { EmployeeId = employeeId, TaskId = taskId, AppointmentDate = DateTime.UtcNow, Estemate = 4 }; await _db.EmployeeTasks.AddAsync(employeeTask); await _db.SaveChangesAsync(); } }
public async Project.Task CreateAsync(Task task, int employeeId) { int et = 0; et = await _db.EmployeeTasks.Where(e => e.EmployeeId == employeeId && e.Task.Name == task.Name) .CountAsync(); if (et == 0) { Task taskId = new Task(); int taskCount = 0; taskCount = await _db.Tasks.Where(t => t.Name == task.Name).CountAsync(); if (taskCount == 0) { await _db.Tasks.AddAsync(task); await _db.SaveChangesAsync(); //taskId = await _db.Tasks.OrderBy(t => t.Id).LastOrDefaultAsync(); taskId.Id = task.Id; } else { taskId = await _db.Tasks.Where(t => t.Name == task.Name).LastOrDefaultAsync(); } var employeeTask = new EmployeeTask { EmployeeId = employeeId, TaskId = taskId.Id, AppointmentDate = DateTime.UtcNow, Estemate = 4 }; await _db.EmployeeTasks.AddAsync(employeeTask); await _db.SaveChangesAsync(); } }