public OpenArticle(Article _ar)
{
InitializeComponent();
ar = new Article(_ar);
DataContext = this;
UpdateListView();
}
public OpenArticle(int art_id)
{
InitializeComponent();
ar = new Article();
GetArticle(art_id);
DataContext = this;
UpdateListView();
}
public Article(Article _ar)
{
Id = _ar.Id;
Creator = _ar.Creator;
Text = _ar.Text;
Title = _ar.Title;
Date = _ar.Date;
}
private void FillArticleListView(DataTable dt)
{
List<Article> articles = new List<Article>();
Article ar;
foreach (DataRow row in dt.Rows)
{
ar = new Article();
ar.Id = Convert.ToInt32(row["ART_ID"]);
ar.Title = row["TITLE"].ToString().Trim();
ar.Creator = new Author { FirstName = row["FIRST_NAME"].ToString().Trim(), LastName = row["LAST_NAME"].ToString().Trim() };
ar.Date = Convert.ToDateTime(row["TIME"]);
articles.Add(ar);
}
if(articles.Count < 1)
{
MessageBox.Show("Нічого не знайдено.", "Результат пошуку");
return;
}
GridView myGridView = new GridView();
GridViewColumn gvc1 = new GridViewColumn();
gvc1.DisplayMemberBinding = new Binding("DateString");
gvc1.Header = "Дата";
gvc1.Width = 70;
myGridView.Columns.Add(gvc1);
GridViewColumn gvc2 = new GridViewColumn();
gvc2.DisplayMemberBinding = new Binding("Title");
gvc2.Header = "Заголовок";
myGridView.Columns.Add(gvc2);
GridViewColumn gvc3 = new GridViewColumn();
gvc3.DisplayMemberBinding = new Binding("ReturnCreatorName");
gvc3.Header = "Автор";
myGridView.Columns.Add(gvc3);
resListView.View = myGridView;
resListView.ItemsSource = articles;
}
private void FillArticlesList()
{
string ConString = ConfigurationManager.ConnectionStrings["NewspaperDB"].ConnectionString;
using (SqlConnection con = new SqlConnection(ConString))
{
string strSQL = @"SELECT ART_ID, TITLE, TIME FROM ARTICLES";
SqlCommand cmd = new SqlCommand(strSQL, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("Articles");
sda.Fill(dt);
Article artcl;
foreach (DataRow row in dt.Rows)
{
artcl = new Article();
artcl.Id = Convert.ToInt32(row["ART_ID"]);
artcl.Title = row["TITLE"].ToString().Trim();
artcl.Date = Convert.ToDateTime(row["TIME"]);
articles.Add(artcl);
}
}
}
private void FillListFromDataSet()
{
string ConString = ConfigurationManager.ConnectionStrings["NewspaperDB"].ConnectionString;
string CmdString = string.Empty;
using (SqlConnection con = new SqlConnection(ConString))
{
CmdString = "SELECT ARTICLES.ART_ID, ARTICLES.TITLE, ARTICLES.TEXT, ARTICLES.TIME, AUTHORS.AU_ID, AUTHORS.FIRST_NAME, AUTHORS.LAST_NAME FROM ARTICLES, AUTHORS, ARTICLES_AUTHORS WHERE ARTICLES.ART_ID = ARTICLES_AUTHORS.ART_ID AND ARTICLES_AUTHORS.AU_ID = AUTHORS.AU_ID";
SqlCommand cmd = new SqlCommand(CmdString, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("Articles");
sda.Fill(dt);
Article ar;
foreach (DataRow row in dt.Rows)
{
ar = new Article();
ar.Id = Convert.ToInt32(row["ART_ID"]);
ar.Title = row["TITLE"].ToString().Trim();
ar.Creator = new Author { FirstName = row["FIRST_NAME"].ToString().Trim(), LastName = row["LAST_NAME"].ToString().Trim() };
ar.Text = row["TEXT"].ToString().Trim();
ar.Date = Convert.ToDateTime(row["TIME"]);
articles.Add(ar);
}
}
}
