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