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; }