Пример #1
0
        // KLASA TA PELNI FUNKCJE SERVISU WYKONUJACEGO METODY ROBIACE OPERACJE NA BAZIE DANYCH
        /// <summary>
        /// Edits the movie.
        /// </summary>
        /// <param name="movie">The movie.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        /// <exception cref="System.NotImplementedException"></exception>
        public bool EditMovie(Movie movie)
        {
            using (var context = new ETLModel(ConnectionString))
            {
                try
                {
                    // POBIERAMY FILM Z BAZY DANYCH I PODMIENIAMY JEGO DANE
                    var movietoEdit = context.Movies.SingleOrDefault(x => x.MovieId == movie.MovieId);
                    if (movietoEdit == null)
                    {
                        return(false);
                    }

                    movietoEdit.Title          = movie.Title;
                    movietoEdit.OrginalTitle   = movie.OrginalTitle;
                    movietoEdit.Rank           = movie.Rank;
                    movietoEdit.RateTotalVotes = movie.RateTotalVotes;
                    movietoEdit.Rate           = movie.Rate;
                    movietoEdit.Year           = movie.Year;
                    movietoEdit.Description    = movie.Description;
                    movietoEdit.Director       = movie.Director;
                    movietoEdit.Duration       = movie.Duration;
                    movietoEdit.BoxOffice      = movie.BoxOffice;

                    context.SaveChanges();
                    return(true);
                }
                catch (Exception ex)
                {
                    return(false);

                    throw new System.NotImplementedException();
                }
            }
        }
Пример #2
0
        /// <summary>
        /// Removes all.
        /// </summary>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        /// <exception cref="Exception"></exception>
        public bool RemoveAll()
        {
            using (var context = new ETLModel(ConnectionString))
            {
                try
                {
                    // USUAWNIE WSZYSTKICH REKORDÓW Z BAZY DANYCH
                    var movies = context.Movies.ToList();
                    context.Movies.RemoveRange(movies);

                    //var persons = context.Persons.ToList();
                    //context.Persons.RemoveRange(persons);

                    //var types = context.MovieTypes.ToList();
                    //context.MovieTypes.RemoveRange(types);

                    context.SaveChanges();

                    return(true);
                }
                catch (Exception ex)
                {
                    return(false);

                    throw new Exception();
                }
            }
        }
Пример #3
0
 /// <summary>
 /// Determines whether [is server connected].
 /// </summary>
 /// <returns><c>true</c> if [is server connected]; otherwise, <c>false</c>.</returns>
 public bool IsServerConnected()
 {
     using (var context = new ETLModel(ConnectionString))
     {
         try
         {
             context.Database.Connection.Open();
             return(true);
         }
         catch (Exception ex)
         {
             return(false);
         }
     }
 }
Пример #4
0
        /// <summary>
        /// Gets all movies.
        /// </summary>
        /// <returns>List&lt;Movie&gt;.</returns>
        /// <exception cref="Exception"></exception>
        public List <Movie> GetAllMovies()
        {
            using (var context = new ETLModel(ConnectionString))
            {
                try
                {
                    var result = context.Movies.ToList();

                    return(result.Select(x => x.Get()).ToList());
                }
                catch (Exception ex)
                {
                    return(null);

                    throw new Exception();
                }
            }
        }
Пример #5
0
        /// <summary>
        /// Adds the movies.
        /// </summary>
        /// <param name="movies">The movies.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        /// <exception cref="Exception"></exception>
        public bool AddMovies(List <Movie> movies)
        {
            using (var context = new ETLModel(ConnectionString))
            {
                // LAZY LOADING POZWALA NA ZWIEKSZENIE SZYBKOSCI POBIERANIA DANYCH Z BAZY ZA POMOCA ENTITY FRAMEWORKA
                // NIE POBIERA ON OBJEKTOW REFEJENCYJNYCH (np. POBIERAJAC FILM NIE POBIERZE NIEPOTRZEBNIE AUTOMATYCZNIE WSZYSTKICH AKTOROW)
                context.Configuration.LazyLoadingEnabled = false;

                try
                {
                    // NA SAMYM POCZATKU POBIERAMY DANE JUZ ZAWARTE W BAZIE, BY POTEM JE SPRAWDZAC I ZAPOBIERZ REDUNDANCJI
                    var moviesDB = context.Movies.AsNoTracking().ToList();
                    var persons  = context.Persons.AsNoTracking().ToList();
                    var types    = context.MovieTypes.AsNoTracking().ToList();

                    foreach (var movie in movies)
                    {
                        // SPRAWDZAMY CZY FILM JUZ ISTNIEJE W BAZIE
                        if (moviesDB.Any(x => x.OrginalTitle.Contains(movie.OrginalTitle) || x.Title.Contains(movie.Title)))
                        {
                            continue;
                        }

                        var movieDb = context.Movies.Create();
                        movieDb.BoxOffice      = movie.BoxOffice;
                        movieDb.Description    = movie.Description;
                        movieDb.Director       = movie.Director;
                        movieDb.Duration       = movie.Duration;
                        movieDb.OrginalTitle   = movie.OrginalTitle;
                        movieDb.Title          = movie.Title;
                        movieDb.Rank           = movie.Rank;
                        movieDb.Year           = movie.Year;
                        movieDb.RateTotalVotes = movie.RateTotalVotes;
                        movieDb.Rate           = movie.Rate;
                        movieDb.ReleaseDate    = movie.ReleaseDate;
                        movieDb.Production     = (byte)movie.Production;
                        movieDb.Staff          = new List <PersonDto>();
                        movieDb.Types          = new List <MovieTypeDto>();

                        // PETLA KTORA ITERUJE PO AKTORACH, JESLI NIE MA GO W BAZIE TO GO DODA
                        // W INNYM PRZYPADKU DOPISZE GO DO FILMU
                        foreach (var a in movie.Staff)
                        {
                            if (!persons.Any(x => x.Name == a.Name && x.Surname == a.Surname))
                            {
                                var person = context.Persons.Create();
                                person.Name    = a.Name;
                                person.Surname = a.Surname;
                                context.Persons.Add(person);
                                context.SaveChanges();
                                persons.Add(person);
                                movieDb.Staff.Add(person);
                            }
                            else
                            {
                                movieDb.Staff.Add(persons.Where(x => x.Name == a.Name && x.Surname == x.Surname).FirstOrDefault());
                            }
                        }

                        // TO SAMO JAK Z AKTORAMI
                        foreach (var t in movie.Types)
                        {
                            if (!types.Any(x => x.Name == t.Name))
                            {
                                var type = context.MovieTypes.Create();
                                type.Description = t.Description;
                                type.Type        = (byte)t.Type;
                                type.Name        = t.Name;
                                context.MovieTypes.Add(type);
                                context.SaveChanges();
                                types.Add(type);
                                movieDb.Types.Add(type);
                            }
                            else
                            {
                                movieDb.Types.Add(types.Where(x => x.Name == t.Name).FirstOrDefault());
                            }
                        }

                        context.Movies.Add(movieDb);
                        context.SaveChanges();
                    }
                    return(true);
                }
                catch (Exception ex)
                {
                    return(false);

                    throw new Exception();
                }
            }
        }