public async Task <int> Add(app_core.entities.Task entity)
{
entity.DateCreated = DateTime.Now;
var sql = "INSERT INTO Tasks (Name, Description, Status, DueDate, DateCreated) Values (@Name, @Description, @Status, @DueDate, @DateCreated);";
using var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"));
connection.Open();
var affectedRows = await connection.ExecuteAsync(sql, entity);
return(affectedRows);
}
public async Task <int> Update(app_core.entities.Task entity)
{
entity.DateModified = DateTime.Now;
var sql = "UPDATE Tasks SET Name = @Name, Description = @Description, Status = @Status, DueDate = @DueDate, DateModified = @DateModified WHERE Id = @Id;";
using var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"));
connection.Open();
var affectedRows = await connection.ExecuteAsync(sql, entity);
return(affectedRows);
}
public async Task <int> Inserir(app_core.entities.Task entity)
{
var resultado = await _unitOfWork.Tasks.Add(entity);
return(resultado);
}
