public async Task <int> Add(Task entity)
{
entity.DateCreated = DateTime.Now;
var sql = "INSERT INTO [Tasks]([Name],[Description],[Status],[DueDate],[DateCreated],[DateModified]) VALUES (@Name,@Description,@Status,@DueDate,@DateCreated,@DateModified)";
using (var con = new SqlConnection(_configuration.GetConnectionString("connectionstring")))
{
con.Open();
var affectedRows = await con.ExecuteAsync(sql, entity);
return(affectedRows);
}
}
public async Task <int> Update(Task entity)
{
entity.DateCreated = DateTime.Now;
var sql = "UPDATE [Tasks]" +
"SET [Name]=@Name,[Description]=@Description,[Status]=@Status,[DueDate]=@DueDate,[DateCreated]=@DateCreated,[DateModified]=@DateModified WHERE Id=@Id";
using (var con = new SqlConnection(_configuration.GetConnectionString("connectionstring")))
{
con.Open();
var affectedRows = await con.ExecuteAsync(sql, entity);
return(affectedRows);
}
}