public void Delete(Domain.Models.Task.Task task)
{
using (var command = provider.Connection.CreateCommand())
{
command.CommandText = "DELETE FROM Task WHERE TaskId = @TaskId";
command.Parameters.Add(new SQLiteParameter("@TaskId", task.TaskId.Value));
command.ExecuteNonQuery();
}
}
private static Domain.Models.Task.Task CreteTaskFormDB(SQLiteDataReader reader)
{
var taskId = (Int64)reader["TaskId"];
var taskName = (string)reader["TaskName"];
var categoryName = (string)reader["CategoryName"];
var taskStatus = (string)reader["Status"];
var task = new Domain.Models.Task.Task(
new TaskName(taskName),
new TaskId((int)taskId),
new CategoryName(categoryName),
new Domain.Models.Task.TaskStatus(TaskStatusEnumUtil.ConvEnum(taskStatus))
);
return(task);
}
public void Save(Domain.Models.Task.Task task)
{
using (var command = provider.Connection.CreateCommand())
{
command.CommandText = @"
insert into Task
(TaskId, TaskName, CategoryName, Status)
values
(@TaskId, @TaskName, @CategoryName, @Status)
on conflict(TaskId)
do update
set
CategoryName = @CategoryName,
Status = @Status
;";
command.Parameters.Add(new SQLiteParameter("@TaskId", task.TaskId.Value));
command.Parameters.Add(new SQLiteParameter("@TaskName", task.TaskName.Value));
command.Parameters.Add(new SQLiteParameter("@CategoryName", task.CategoryName.Value));
command.Parameters.Add(new SQLiteParameter("@Status", task.Status.Value.ToString()));
command.ExecuteNonQuery();
}
}
public TaskCreateResult(Domain.Models.Task.Task task)
{
Task = task;
}
