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_); }