public async Task <int> Update(Core.ModelView.TaskViewModel taskViewModel)
{
taskViewModel.Date = 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, taskViewModel);
return(affectedRows);
}
}
public async Task <int> Add(Core.ModelView.TaskViewModel taskViewModel)
{
taskViewModel.Date = 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, taskViewModel);
return(affectedRows);
}
}
