public void Delete()
{
TagArticle.DeleteConnectedWithArticle(Id);
var sqlCmd = $"delete from articles where id = {Id}";
var cmd = new NpgsqlCommand(sqlCmd, DBConnect.Connection);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void Create(int userId, List <int> tagsIds)
{
UserId = userId;
var insertCmd = $"insert into articles(latin_header, russian_header, body, author_user_id) values('{HeaderLatin}', '{Header}', '{Body}', '{UserId}') returning id";
var cmd = new NpgsqlCommand(insertCmd, DBConnect.Connection);
var reded = cmd.ExecuteScalar();
Id = (int)reded;
cmd.Dispose();
foreach (var x in tagsIds)
{
var tagArticle = new TagArticle {
ArticleId = Id, TagId = x
};
tagArticle.Create();
}
}