public IEnumerable <TaskModel> GetAll()
{
IEnumerable <TaskModel> result = _sqlConnection.Query <TaskModel>(
sql: TaskAccessModel.GetAllQuery());
return(result);
}
public TaskModel GetById(int id)
{
TaskModel result = _sqlConnection.Query <TaskModel>(
sql: TaskAccessModel.GetByIdQuery(),
param: TaskAccessModel.GetByIdParams(id)).Single();
return(result);
}
public TaskModel Update(TaskModel task)
{
var id = _sqlConnection.Query <int>(
sql: TaskAccessModel.UpdateQuery(),
param: TaskAccessModel.UpdateParams(task)).Single();
var result = this.GetById(id);
return(result);
}
public void Delete(int id)
{
_sqlConnection.Execute(
sql: TaskAccessModel.DeleteQuery(),
param: TaskAccessModel.DeleteParams(id));
}
