public bool OtrOcNews(int id_news)
{
connection.Open();
string con = "Select * From MyTableAddNews Where ID_news=@ID_news ";
SqlCommand com = new SqlCommand(con, connection);
com.Parameters.Add("@ID_news", SqlDbType.Int).Value = id_news;
SqlDataReader reader = com.ExecuteReader();
MyTableNews News = new MyTableNews();
while (reader.Read())
{
News.otr_ozaenk = (int)reader["otr_ozaenk"];
}
reader.Close();
int otrOc = News.otr_ozaenk;
otrOc--;
string query = @"UPDATE MyTableAddNews
SET [otr_ozaenk] = @otr_ozaenk
WHERE [ID_news] = @id";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@id", id_news);
command.Parameters.AddWithValue("@otr_ozaenk", otrOc);
command.ExecuteNonQuery();
return(true);
}
public List <MyTableNews> UpdateNews(int id_news)
{
connection.Open();
string query = "SELECT * FROM MyTableAddNews Where ID_news=@id_news";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@id_news", SqlDbType.Int).Value = id_news;
SqlDataReader reader = command.ExecuteReader();
List <MyTableNews> list = new List <MyTableNews>();
while (reader.Read())
{
MyTableNews News = new MyTableNews();
News.Id_news = (int)reader["ID_news"];
News.user_nam = reader["user_nam"].ToString();
News.name_news = reader["name_news"].ToString();
News.date_publich = (DateTime)reader["date_publich"];
News.content = reader["Content"].ToString();
News.image = reader["img"].ToString();
News.typess = reader["typess"].ToString();
News.pol_ozenk = (int)reader["pol_ozenk"];
News.otr_ozaenk = (int)reader["otr_ozaenk"];
list.Add(News);
}
return(list);
}
public List <MyTableNews> SelectComments()
{
string query = "Select * From dbo.MyTableAddNews INNER JOIN dbo.MyTableComment ON dbo.MyTableAddNews.ID_news = dbo.MyTableComment.id_news ";
SqlCommand command = new SqlCommand(query, connection);
connection.Close();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <MyTableNews> list = new List <MyTableNews>();
while (reader.Read())
{
MyTableNews News = new MyTableNews();
News.comment = reader["comments"].ToString();;
News.users_comment = reader["users_comment"].ToString();
News.date_comment = (DateTime)reader["date_coments"];
News.pol_oc = (int)reader["pol_oc"];
News.otr_oc = (int)reader["otr_oc"];
list.Add(News);
}
return(list);
}
public List <MyTableNews> SelectNews()
{
connection.Open();
string query = "Select * From MyTableAddNews , MyTableComment where dbo.MyTableAddNews.ID_news = dbo.MyTableComment.id_news ";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
List <MyTableNews> list = new List <MyTableNews>();
while (reader.Read())
{
MyTableNews News = new MyTableNews();
News.Id_news = (int)reader["ID_news"];
News.user_nam = reader["user_nam"].ToString();
News.name_news = reader["name_news"].ToString();
News.date_publich = (DateTime)reader["date_publich"];
News.content = reader["Content"].ToString();
News.image = reader["img"].ToString();
News.typess = reader["typess"].ToString();
News.pol_ozenk = (int)reader["pol_ozenk"];
News.otr_ozaenk = (int)reader["otr_ozaenk"];
News.id_comments = (int)reader["ID_comment"];
News.comment = reader["comments"].ToString();;
News.users_comment = reader["users_comment"].ToString();
News.date_comment = (DateTime)reader["date_coments"];
News.pol_oc = (int)reader["pol_oc"];
News.otr_oc = (int)reader["otr_oc"];
list.Add(News);
}
return(list);
}
