public async Task CreatePostAsync(string Text, int threadId, Guid userId, string UserName) { using (var cmd = _repo.CreateCommand()) { cmd.CommandText = $"Insert into Posts (Text,ThreadId,UserId,UserName) Values('{Text}',{threadId},'{userId}','{UserName}')"; await cmd.ExecuteNonQueryAsync(); _repo.SaveChanges(); } }
public async Task CreateThreadAsync(string Name, string Text, int TopicId, Guid UserId, string UserName) { using (var cmd = _repo.CreateCommand()) { cmd.CommandText = $"Insert into Threads (Name,TextDescription,TopicId,UserId,CreatedAt,UserName) Values('{Name}','{Text}',{TopicId},'{UserId}','{DateTime.Now:s}','{UserName}')"; await cmd.ExecuteNonQueryAsync(); _repo.SaveChanges(); } }
public async Task CreateTopicAsync(string Name) { using (var cmd = _repo.CreateCommand()) { cmd.CommandText = $"Insert into Topics (Name) Values('{Name}')"; await cmd.ExecuteNonQueryAsync(); _repo.SaveChanges(); } }