/// <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; }
/// <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; }
/// <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; }