private async Task CreateBoolTypeUserTaskTableAsync(TaskHolder taskHolder) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { await cnn.ExecuteAsync(@$ "CREATE TABLE {taskHolder.Title} (Id INTEGER NOT NULL UNIQUE, IsTaskDone INTEGER, Date TEXT NOT NULL UNIQUE" + $", TimeOfCompletionUTC TEXT, TimeOfCompletionLocal TEXT, PRIMARY KEY(Id AUTOINCREMENT))"); } }
private async Task CreateTaskHolderRowAsync(TaskHolder taskHolder) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { await cnn.ExecuteAsync("INSERT INTO TaskHolder (DisplayTitle, Title, IsRepeat, WeeklyRepeatPattern," + " TaskDuration, TimeTakeToMakeTask, Description, InitTime) VALUES (@DisplayTitle, @Title, @IsRepeat, @WeeklyRepeatPattern, @TaskDuration, @TimeTakeToMakeTask," + " @Description, @InitTime)", taskHolder); } }
public override async Task UpdateTaskHolderAsync(TaskHolder taskHolder) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { await cnn.ExecuteAsync(@"UPDATE TaskHolder SET DisplayTitle = @DisplayTitle, IsRepeat = @IsRepeat, WeeklyRepeatPattern = @WeeklyRepeatPattern, TaskDuration = @TaskDuration, TimeTakeToMakeTask = @TimeTakeToMakeTask, Description = @Description WHERE Title = @Title;" , taskHolder); } }
public override async Task CreateNewTaskHolderAsync(TaskHolder taskHolder) { await Task.WhenAll(new List <Task>() { CreateTaskHolderRowAsync(taskHolder), CreateBoolTypeUserTaskTableAsync(taskHolder) }); }
public abstract Task UpdateTaskHolderAsync(TaskHolder taskHolder);
public abstract Task CreateNewTaskHolderAsync(TaskHolder taskHolder);