private void Window_Loaded(object sender, RoutedEventArgs e)
{
name.Text = film.get_name();
year.Text = film.get_year().ToString();
pic.Source = film.get_poster();
DataTable t_janres = DataBase.exec_zapros("select Жанр from Жанры");
for (int i = 0; i < t_janres.Rows.Count; i++)
{
genres_in_db.Add(t_janres.Rows[i][0].ToString());
if (film.get_genres().Contains(t_janres.Rows[i][0].ToString()))
{
Items.Add(new item {
Name = t_janres.Rows[i][0].ToString(), Isselected = true
});
}
else
{
Items.Add(new item {
Name = t_janres.Rows[i][0].ToString(), Isselected = false
});
}
}
janres.ItemsSource = Items;
}
private void add_film(film f)
{
panel_film film = new panel_film();
film.Poster = f.get_poster();
film.NameFilm = f.get_name();
film.Year = f.get_year();
film.Ozenka = f.get_sr_ozenka();
List <string> m_genres = f.get_genres();
string genres = "";
for (int g = 0; g < m_genres.Count; g++)
{
genres += m_genres[g];
if (g != m_genres.Count - 1)
{
genres += ", ";
}
}
film.Genres = genres;
film.Views = f.get_views();
film.edit.Click += open_edit_film;
film.stat.Click += stat_film;
film.close.Click += delete_film;
film.MouseDown += dbl_click_film;
wrp.Children.Add(film);
}
public void update_film_info(film f, BitmapImage poster)
{
panel_film pf = (active.Parent as Border).Parent as panel_film;
pf.NameFilm = f.get_name();
pf.Year = f.get_year();
List <string> genres = f.get_genres();
string gnr = "";
for (int i = 0; i < genres.Count; i++)
{
gnr += genres[i];
if (i != genres.Count - 1)
{
gnr += ", ";
}
}
pf.Genres = gnr;
if (poster != null)
{
pf.Poster = poster;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
List <value> rating_ = new List <value>();
List <value> genre = new List <value>();
List <value> year_ = new List <value>();
List <value> views_ = new List <value>();
DataTable genres_count = DataBase.exec_zapros("select Жанры.Жанр,count(Жанры_Фильмы.[id жанра]) from Жанры_Фильмы inner join Жанры on Жанры.[id жанра]=Жанры_Фильмы.[id жанра] group by Жанр");
DataTable years_count = DataBase.exec_zapros("select Год,COUNT(Год) from Фильмы group by Год");
for (int i = 0; i < genres_count.Rows.Count; i++)
{
if (film.get_genres().Contains(genres_count.Rows[i][0].ToString()))
{
genre.Add(new value {
X = genres_count.Rows[i][0].ToString(), Y = Convert.ToInt32(genres_count.Rows[i][1]), this_film = true
});
}
else
{
genre.Add(new value {
X = genres_count.Rows[i][0].ToString(), Y = Convert.ToInt32(genres_count.Rows[i][1]), this_film = false
});
}
}
for (int i = 0; i < years_count.Rows.Count; i++)
{
if (film.get_year() == Convert.ToInt32(years_count.Rows[i][0]))
{
year_.Add(new value {
X = years_count.Rows[i][0].ToString(), Y = Convert.ToInt32(years_count.Rows[i][1]), this_film = true
});
}
else
{
year_.Add(new value {
X = years_count.Rows[i][0].ToString(), Y = Convert.ToInt32(years_count.Rows[i][1]), this_film = false
});
}
}
foreach (var item in list)
{
if (item == film)
{
rating_.Add(new value {
X = item.get_name(), Y = item.get_sr_ozenka(), this_film = true
});
views_.Add(new value {
X = item.get_name(), Y = item.get_views(), this_film = true
});
}
else
{
rating_.Add(new value {
X = item.get_name(), Y = item.get_sr_ozenka(), this_film = false
});
views_.Add(new value {
X = item.get_name(), Y = item.get_views(), this_film = false
});
}
}
draw_diagram(ref rating, rating_);
draw_diagram(ref janr, genre);
draw_diagram(ref year, year_);
draw_diagram(ref views, views_);
}