public void Remove(Task task)
{
var taskModel = TaskModel.FromRepositoryType(task);
var sql = @"
DELETE
FROM TaskModels
WHERE Id = @Id
";
var parameters = new
{
Id = taskModel.Id,
};
_connection.Execute(sql, parameters);
}
public void Update(Task task)
{
var taskModel = TaskModel.FromRepositoryType(task);
var sql = @"
UPDATE TaskModels
SET
ReceivedTimestamp = @ReceivedTimestamp
WHERE Id = @Id
";
var parameters = new
{
Id = taskModel.Id,
ReceivedTimestamp = taskModel.ReceivedTimestamp,
};
_connection.Execute(sql, parameters);
}
public void Add(Task task)
{
var model = TaskModel.FromRepositoryType(task);
var sql = @"
INSERT
INTO TaskModels
(
Expiration,
Origin,
Owner_Id,
ReceivedTimestamp,
Script_Id,
Target_Id
)
VALUES
(
@Expiration,
@Origin,
@Owner_Id,
@ReceivedTimestamp,
@Script_Id,
@Target_Id
)
SELECT CAST(IDENT_CURRENT('TaskModels') as int)
";
var parameters = new
{
Expiration = model.Expiration,
Origin = model.Origin,
Owner_Id = model.Owner_Id,
ReceivedTimestamp = model.ReceivedTimestamp,
Script_Id = model.Script_Id,
Target_Id = model.Target_Id,
};
var id = _connection.QuerySingle <int>(sql, parameters);
task.SetId(id);
}