public int Add(PushkinoActionPost news)
        {
            var connectionString = this.GetConnection();
            int count            = 0;

            using (var con = new SqlConnection(connectionString))
            {
                try
                {
                    con.Open();
                    var query = "INSERT INTO PushkinoActionsPosts(Name, Intro, Text, Picture) VALUES(@Name, @Intro, @Text,@Picture);";
                    count = con.Execute(query, news);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    con.Close();
                }

                return(count);
            }
        }
        public int EditNews(PushkinoActionPost news)
        {
            var connectionString = this.GetConnection();
            var count            = 0;

            using (var con = new SqlConnection(connectionString))
            {
                try
                {
                    con.Open();
                    var query = "UPDATE PushkinoActionsPosts SET Name = @Name, Intro = @Intro, Text = @Text, Picture = @Picture WHERE Id = @Id";
                    count = con.Execute(query, news);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    con.Close();
                }

                return(count);
            }
        }
        public PushkinoActionPost GetNews(int id)
        {
            var connectionString       = this.GetConnection();
            PushkinoActionPost product = new PushkinoActionPost();

            using (var con = new SqlConnection(connectionString))
            {
                try
                {
                    con.Open();
                    var query = "SELECT * FROM PushkinoActionsPosts WHERE Id =" + id;
                    product = con.Query <PushkinoActionPost>(query).FirstOrDefault();
                }
                catch
                {
                    throw new Exception("Нет данного поста");
                }
                finally
                {
                    con.Close();
                }

                return(product);
            }
        }