Пример #1
0
        /// <summary>
        /// dispatch the dvd
        /// </summary>
        /// <param name="dvdRequest"></param>
        /// <param name="dvds"></param>
        /// <returns></returns>
        private static bool dispatch(Rental dvdRequest, DVD dvd)
        {
            try
            {
                // add dvd to rental
                var therental = db.Rentals.First(r => r.RentalID == dvdRequest.RentalID);
                var theDVD = db.DVDs.First(d => d.DvdID == dvd.DvdID);
                therental.DateSent = DateTime.Now;
                therental.DateDue = DateTime.Now.AddDays(14);
                therental.QueuePosition = null;
                therental.Dvd = dvd;
                therental.DvdID = dvd.DvdID;
                db.SaveChanges();

                theDVD.Rentals.Add(therental);
                theDVD.State = "rented";

                // dispatch
                db.SaveChanges();
            }
            catch (Exception)
            {
                return false;
            }

            return true;
        }
Пример #2
0
        /// <summary>
        /// Saves a movie from TheMovieDB to BoxOffices db
        /// </summary>
        /// <param name="model">An AddMovie model containing all info</param>
        public void persistMovie(AddMovieModel model)
        {
            // create request url
            string UrlRequest = "http://api.themoviedb.org/2.1/Movie.getInfo/en/xml/b0f4c9d847ceda92061d4090b470dc10/" + model.TMDbID;

            /* make request */
            XDocument tmdbMovie = null;
            try
            {
                HttpWebRequest request = WebRequest.Create(UrlRequest) as HttpWebRequest;
                HttpWebResponse response = request.GetResponse() as HttpWebResponse;

                tmdbMovie = XDocument.Load(response.GetResponseStream());
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw new RequestFailedException();
            }

            /* parse xml */
            // Lists to fill
            var categories = new List<Category>();
            var images = new List<Image>();
            var cast = new List<CastMember>();
            var studios = new List<Studio>();
            var countries = new List<Country>();
            var dvds = new List<DVD>();

            //try
            //{
            #region movie
            // check if the new movie is to be promoted
            if (model.MovieOfTheWeek == true)
            {
                // get old movie of the week
                var promoQueryResult = (from m
                                 in db.Movies
                                        where m.isMovieOfTheWeek == true
                                        select m);

                // check if there actually is a movie
                if (!promoQueryResult.Equals(null))
                {
                    var promo = promoQueryResult.First();
                    // unpromote it
                    promo.isMovieOfTheWeek = false;
                    db.SaveChanges();
                }
            }

            // create a new Movie object and fill it with data parsed from the xml
            var movie = (from m in tmdbMovie.Descendants("movie")
                         select new Movie
                         {
                             Adult = bool.Parse(m.Element("adult").Value),
                             Alternative_name = m.Element("alternative_name").Value,
                             Cast = cast,
                             Categories = categories,
                             Certification = m.Element("certification").Value,
                             Comments = new List<Comment>(),
                             Countries = countries,
                             DateAdded = DateTime.Now,
                             DateReleased = DateTime.ParseExact(m.Element("released").Value, @"yyyy-MM-dd", CultureInfo.InvariantCulture),
                             DVDs = dvds,
                             Homepage = m.Element("homepage").Value,
                             Images = images,
                             Imdb_id = m.Element("imdb_id").Value,
                             Language = m.Element("language").Value,
                             MovieID = int.Parse(m.Element("id").Value),
                             isMovieOfTheWeek = model.MovieOfTheWeek,
                             isRentable = true,
                             Name = m.Element("name").Value,
                             Original_name = m.Element("original_name").Value,
                             Overview = m.Element("overview").Value,
                             Price = model.Price,
                             Rating_by_moviedb = float.Parse(m.Element("rating").Value),
                             Ratings = new List<Rating>(),
                             Rentals = new List<Rental>(),
                             Studios = studios,
                             Tagline = m.Element("tagline").Value,
                             Trailer = m.Element("trailer").Value,
                             Translated = bool.Parse(m.Element("translated").Value),
                             Type = m.Element("type").Value,
                             Url = m.Element("url").Value,
                             Votes_by_moviedb = int.Parse(m.Element("votes").Value)
                         }).First();

            // save the new movie
            db.Movies.Add(movie);
            db.SaveChanges();

            #endregion

            #region cast
            // now parse the cast
            var persons = from c
                          in tmdbMovie.Descendants("cast").Elements()
                          select c;

            foreach (var person in persons)
            {
                // create new CastMember
                var member = new CastMember
                {
                    Cast_id = int.Parse(person.Attribute("cast_id").Value),
                    // CastMemberID will be generated
                    Character = person.Attribute("character").Value,
                    Department = person.Attribute("department").Value,
                    Job = person.Attribute("job").Value,
                    // Movie + Movie ID added after obj creation
                    Movie = movie,
                    Name = person.Attribute("name").Value,
                    Order = int.Parse(person.Attribute("order").Value),
                    Url = person.Attribute("url").Value
                };

                // save CastMember
                cast.Add(member);
            }

            // add new CastMembers to DB
            cast.ForEach(cm => db.CastMembers.Add(cm));

            // now add FKs
            foreach (var member in cast)
            {
                member.Movie = movie;
                member.MovieID = movie.MovieID;
            }
            movie.Cast = cast;

            // save
            db.SaveChanges();

            #endregion

            #region category
            // loop over all category elements in the tmcb xml
            var categoriesXML = from elements
                                  in tmdbMovie.Descendants("categories").Elements()
                                select elements;
            foreach (var category in categoriesXML)
            {
                /* check if categories exist already */
                Int32 categoryId;
                int.TryParse(category.Attribute("id").Value, out categoryId);

                var dbCategory = (from c in db.Categories
                                  where (c.CategoryID == categoryId)
                                  select c);

                /* if yes, add existing */
                if (dbCategory.Count() != 0)
                {
                    categories.Add(dbCategory.First());
                }
                /* if no, parse it */
                else
                {
                    var c =
                        new Category
                        {
                            CategoryID = int.Parse(category.Attribute("id").Value),
                            // Movies will be set later on
                            Movies = new List<Movie>(),
                            Name = category.Attribute("name").Value,
                            Type = category.Attribute("type").Value,
                            Url = category.Attribute("url").Value
                        };

                    categories.Add(c);
                    db.Categories.Add(c);
                }
            }
            // now save categories
            db.SaveChanges();

            // add FKs
            foreach (var item in categories.ToList())
            {
                movie.Categories.Add(item);
                item.Movies.Add(movie);
                db.SaveChanges();
            }

            #endregion

            #region studio

            /* check if studio exists already in DB, if not, parse */
            var studiosInXML = from elements
                                   in tmdbMovie.Descendants("studios").Elements()
                               select elements;

            foreach (var studio in studiosInXML)
            {
                Int32 studioId;
                int.TryParse(studio.Attribute("id").Value, out studioId);

                var dbStudio = (from s in db.Studios
                                where (s.StudioID == studioId)
                                select s);

                if (dbStudio.Count() != 0)
                {
                    studios.Add(dbStudio.First());
                }
                else
                {
                    var s =
                        new Studio
                        {
                            Movies = new List<Movie>(),
                            Name = studio.Attribute("name").Value,
                            StudioID = int.Parse(studio.Attribute("id").Value),
                            Url = studio.Attribute("url").Value
                        };

                    studios.Add(s);
                    db.Studios.Add(s);
                }
            }

            /* add FKs */
            foreach (var item in studios.ToList())
            {
                item.Movies.Add(movie);
                movie.Studios.Add(item);
                db.SaveChanges();
            }

            #endregion

            #region country

            /* check if country exists already in DB, if not, parse */
            var countriesXML = from elements
                                   in tmdbMovie.Descendants("countries").Elements()
                               select elements;

            foreach (var country in countriesXML)
            {
                var code = country.Attribute("code").Value;

                var dbCountry = from c
                                    in db.Countries
                                where c.Code == code
                                select c;

                if (dbCountry.Count() != 0)
                {
                    countries.Add(dbCountry.First());
                }
                else
                {
                    var c =
                        new Country
                        {
                            Movies = new List<Movie>(),
                            Name = country.Attribute("name").Value,
                            Code = country.Attribute("code").Value,
                            Url = country.Attribute("url").Value
                        };

                    countries.Add(c);
                    db.Countries.Add(c);
                }
            }

            /* add FKs */
            foreach (var item in countries.ToList())
            {
                movie.Countries.Add(item);
                item.Movies.Add(movie);
                db.SaveChanges();
            }

            #endregion

            #region image

            /* check if studio exists already in DB, if not, parse */
            images = (from image
                          in tmdbMovie.Descendants("images").Elements()
                      where image.Attribute("type").Value.Equals("poster") && image.Attribute("size").Value.Equals("original")
                      select new Image
                      {
                          ImageID = image.Attribute("id").Value,
                          Size = image.Attribute("size").Value,
                          Type = image.Attribute("type").Value,
                          Url = image.Attribute("url").Value
                      }).ToList();

            /* save changes */
            images.ForEach(i => db.Images.Add(i));
            db.SaveChanges();

            images.ForEach(i => movie.Images.Add(i));
            db.SaveChanges();

            #endregion

            #region dvd

            /* create new DVDs according to number in AddMovie model */
            for (int i = 0; i < model.DVDs; i++)
            {
                var newDVD = new DVD
                {
                    Movie = movie,
                    MovieID = movie.MovieID,
                    Rentals = new List<Rental>(),
                    State = "available"
                };

                dvds.Add(newDVD);
            }

            // add DVDs to DB context
            dvds.ForEach(dvd => db.DVDs.Add(dvd));

            // add DVDs to movie
            dvds.ToList().ForEach(dvd => movie.DVDs.Add(dvd));

            db.SaveChanges();

            #endregion
            //}
            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //    throw e;
            //}

            return;
        }
Пример #3
0
        /// <summary>
        /// realocates a dvd
        /// </summary>
        /// <param name="aDvd"></param>
        /// <returns></returns>
        private static bool realocateDVD(DVD aDvd)
        {
            // get rentals requesting a dvd for this one's movie
            var request = from r in db.Rentals
                          where r.QueuePosition != null && r.DvdID == null
                          orderby r.QueuePosition
                          select r;

            // if request, then realocate
            if (request.Any())
            {
                var theNext = request.First();

                try
                {
                    if (dispatch(theNext, aDvd))
                    {
                        return true;
                    }
                    return false;
                }
                catch (Exception)
                {
                    return false;
                }
            }
            return true;
        }