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