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