Exemple #1
0
        private void button3_Click(object sender, RoutedEventArgs e)
        {
            CinemaDataContext Context = new CinemaDataContext();

            int i = 0;

            string[] Strs = File.ReadAllLines("Films.txt");
            Context.ExecuteCommand("delete from tblMovie");
            do
            {
                tblMovie Movie = new tblMovie();
                Movie.MovieName     = Strs[i++];
                Movie.MovieDirector = Strs[i++];
                Movie.MovieDuration = Convert.ToInt32(Strs[i++]);
                Movie.MovieYear     = Convert.ToInt32(Strs[i++]);
                Movie.MinAge        = Convert.ToInt32(Strs[i++]);
                Movie.MainActor     = Strs[i++];

                Context.tblMovies.InsertOnSubmit(Movie);
                Context.SubmitChanges();

                int MovieID = (from M in Context.tblMovies
                               where M.MovieName == Movie.MovieName
                               select M.MovieID).First();

                string[] GenresStrs = Strs[i++].Split();
                foreach (string S in GenresStrs)
                {
                    tblMovieGenre MovieGenre = new tblMovieGenre();
                    MovieGenre.MovieID = MovieID;
                    MovieGenre.GenreID = (from G in Context.tblGenres
                                          where G.GenreName == S
                                          select G.GenreID).First();
                    Context.tblMovieGenres.InsertOnSubmit(MovieGenre);
                }

                string[] CountriesStrs = Strs[i++].Split();
                foreach (string S in CountriesStrs)
                {
                    tblMovieCountry MovieCountry = new tblMovieCountry();
                    MovieCountry.MovieID   = MovieID;
                    MovieCountry.CountryID = (from G in Context.tblCountries
                                              where G.CountryName == S
                                              select G.CountryID).First();
                    Context.tblMovieCountries.InsertOnSubmit(MovieCountry);
                }

                i++;
            }while (i < Strs.Length);


            Context.SubmitChanges();
        }
Exemple #2
0
 static public void Delete(int movieId, int genreId)
 {
     using (DVDEntities dc = new DVDEntities())
     {
         tblMovieGenre movieGenre = dc.tblMovieGenres.FirstOrDefault(mg => mg.MovieId == movieId && mg.GenreId == genreId);
         if (movieGenre != null)
         {
             dc.tblMovieGenres.Remove(movieGenre);
             dc.SaveChanges();
         }
     }
 }
        public static void Add(int movieId, int genreId)
        {
            using (DVDCentralEntities dc = new DVDCentralEntities())
            {
                tblMovieGenre mg = new tblMovieGenre();
                mg.Id      = dc.tblMovieGenres.Any() ? dc.tblMovieGenres.Max(p => p.Id) + 1 : 1;
                mg.MovieId = movieId;
                mg.GenreId = genreId;

                dc.tblMovieGenres.Add(mg);
                dc.SaveChanges();
            }
        }
        public static void Delete(int movieId, int genreId)
        {
            using (DVDCentralEntities dc = new DVDCentralEntities())
            {
                tblMovieGenre mg = dc.tblMovieGenres.FirstOrDefault(p => p.MovieId == movieId &&
                                                                    p.GenreId == genreId);

                if (mg != null)
                {
                    dc.tblMovieGenres.Remove(mg);
                    dc.SaveChanges();
                }
            }
        }
Exemple #5
0
        static public void Add(int movieId, int genreId)
        {
            using (DVDEntities dc = new DVDEntities())
            {
                tblMovieGenre mg = new tblMovieGenre
                {
                    Id      = dc.tblMovieGenres.Any() ? dc.tblMovieGenres.Max(m => m.Id) + 1 : 1,
                    MovieId = movieId,
                    GenreId = genreId
                };

                dc.tblMovieGenres.Add(mg);
                dc.SaveChanges();
            }
        }
Exemple #6
0
        private void button3_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                tblMovie Movie = new tblMovie();
                if (string.IsNullOrWhiteSpace(tbFilmName.Text))
                {
                    throw new Exception("Не введено название фильма");
                }
                Movie.MovieName = tbFilmName.Text;

                if (string.IsNullOrWhiteSpace(tbDirector.Text))
                {
                    throw new Exception("Не введено имя режиссера");
                }
                Movie.MovieDirector = tbDirector.Text;
                Movie.MovieDuration = Convert.ToInt32(udDuration.Value);
                Movie.MovieYear     = Convert.ToInt32(udYear.Value);
                Movie.MinAge        = Convert.ToInt32(udMinAge.Value);
                if (string.IsNullOrWhiteSpace(tbMainHero.Text))
                {
                    throw new Exception("Не введено имя главного актера");
                }
                Movie.MainActor = tbMainHero.Text;

                if (string.IsNullOrWhiteSpace(tbGenres.Text))
                {
                    throw new Exception("Не выбран хотя бы один жанр");
                }
                if (string.IsNullOrWhiteSpace(tbCountries.Text))
                {
                    throw new Exception("Не выбран хотя бы одна страна");
                }

                CinemaDataContext Context = new CinemaDataContext();
                Context.tblMovies.InsertOnSubmit(Movie);
                Context.SubmitChanges();

                int MovieID = (from M in Context.tblMovies where M.MovieName == tbFilmName.Text select M.MovieID).ToArray()[0];

                List <int> GenresID;
                List <int> CountriesID;
                GetID(tbGenres.Text, tbCountries.Text, out GenresID, out CountriesID);

                foreach (int ID in GenresID)
                {
                    tblMovieGenre MovieGenre = new tblMovieGenre();
                    MovieGenre.MovieID = MovieID;
                    MovieGenre.GenreID = ID;
                    Context.tblMovieGenres.InsertOnSubmit(MovieGenre);
                }

                foreach (int ID in CountriesID)
                {
                    tblMovieCountry MovieCountry = new tblMovieCountry();
                    MovieCountry.MovieID   = MovieID;
                    MovieCountry.CountryID = ID;
                    Context.tblMovieCountries.InsertOnSubmit(MovieCountry);
                }

                Context.SubmitChanges();

                ReloadFilmsRooms();

                MessageBox.Show("Фильм " + Movie.MovieName + " успешно добавлен");
            }
            catch (Exception Ex)
            {
                MessageBox.Show("Ошибка: " + Ex.Message);
            }
        }