public async Task <IActionResult> CreateTask(CreateUpdateTaskRequest task)
{
if (task.Deadline < DateTime.Now)
{
return(BadRequest("Invalid deadline date."));
}
await _taskService.CreateTaskAsync(task);
return(Ok(HttpStatusCode.Created));
}
public async Task CreateTaskAsync(CreateUpdateTaskRequest task)
{
await _taskRepository.CreateTaskAsync(task);
var tasksCount = await _taskRepository.GetPersonToDoTasksCountAsync(task.AssigneeId);
if (tasksCount >= 10)
{
await emailService.NotifyStudentAboutBigAmountOfTasksAsync(task.AssigneeId);
}
}
public async Task CreateTaskAsync(CreateUpdateTaskRequest task)
{
await using var connection = new SqlConnection(_dbConfig.ConnectionString);
await using var command = new SqlCommand("CreateTask", connection)
{
CommandType = CommandType.StoredProcedure
};
connection.Open();
command.Parameters.AddWithValue("statement", task.Statement);
command.Parameters.AddWithValue("deadline", task.Deadline);
command.Parameters.AddWithValue("description", task.Description);
command.Parameters.AddWithValue("subjectId", task.SubjectId);
command.Parameters.AddWithValue("assigneeId", task.AssigneeId);
command.Parameters.AddWithValue("authorId", task.AuthorId);
command.Parameters.AddWithValue("typeId", task.TypeId);
command.Parameters.AddWithValue("statusId", task.StatusId);
await Task.Run(() => command.ExecuteNonQuery());
}
public async Task UpdateTaskAsync(CreateUpdateTaskRequest task)
{
await using var connection = new SqlConnection(_dbConfig.ConnectionString);
await using var command = new SqlCommand("UpdateTask", connection)
{
CommandType = CommandType.StoredProcedure
};
connection.Open();
command.Parameters.AddWithValue("taskId", task.Id);
command.Parameters.AddWithValue("deadline", task.Deadline);
command.Parameters.AddWithValue("description", task.Description);
command.Parameters.AddWithValue("statement", task.Statement);
command.Parameters.AddWithValue("statusId", task.StatusId);
command.Parameters.AddWithValue("subjectId", task.SubjectId);
command.Parameters.AddWithValue("typeId", task.TypeId);
command.Parameters.AddWithValue("isInQa", task.IsInQa);
await command.ExecuteNonQueryAsync();
}
public async Task <IActionResult> UpdateTask(CreateUpdateTaskRequest task)
{
await _taskService.UpdateTaskAsync(task);
return(Ok(HttpStatusCode.NoContent));
}
public async Task UpdateTaskAsync(CreateUpdateTaskRequest task)
{
await _taskRepository.UpdateTaskAsync(task);
}
