public async Task CreateAsync(Guid userId, Guid id, string name, string description) { var module = await _wordsModuleRepository.GetAsync(userId, id); if (module != null) { throw new Exception($"Module with this id: {id} already exists."); } module = new WordsModule(id, userId, name, description); await _wordsModuleRepository.AddAsync(module); }
public async Task DeleteAsync(WordsModule module) { string sql = "DELETE FROM WordsModule WHERE Id = @Id AND UserId = @UserId;"; connection.Open(); connection.Execute(sql, new { Id = module.Id, UserId = module.UserId }); connection.Close(); await Task.CompletedTask; }
public async Task UpdateAsync(WordsModule module) { string sql = "UPDATE WordsModules SET Name = @Name, Description = @Description WHERE Id = @Id AND UserId = @UserId;"; connection.Open(); connection.Execute(sql, new { Name = module.Name, Description = module.Description, Id = module.Id, UserId = module.UserId }); connection.Close(); await Task.CompletedTask; }
public async Task AddAsync(WordsModule module) { string sql = "INSERT INTO WordsModules Values(@Id, @UserId, @Name, @Description, @CreatedAt);"; connection.Open(); connection.Execute(sql, new { Id = module.Id, UserId = module.UserId, Name = module.Name, Description = module.Description, CreatedAt = module.CreatedAt }); connection.Close(); await Task.CompletedTask; }