public ActionResult Create([Bind(Include = "Movie_id,Movie_Name,Release_Date")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult Create([Bind(Include = "Multiplex_id,Multiplex_Name,Location,Movie_id,MovieMovie_id")] Multiplex multiplex)
{
if (ModelState.IsValid)
{
db.Multiplexes.Add(multiplex);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MovieMovie_id = new SelectList(db.Movies, "Movie_id", "Movie_Name", multiplex.MovieMovie_id);
return(View(multiplex));
}
private void clCreate_Click(object sender, EventArgs e)
{
if (_entities.UserLists.Where(o => o.ListName == textUsername.Text && o.User.Id == _user.Id).FirstOrDefault() == null)
{
var userList = new UserList {
User = _user, ListName = textUsername.Text
};
_entities.AddToUserLists(userList);
_entities.SaveChanges();
dataListView1.DataSource = _entities.UserLists.Where(o => o.User.Id == _user.Id);
}
}
private void clUpdate_Click(object sender, System.EventArgs e)
{
User u = (from user in _entities.Users
where user.Username == textUsername.Text
select user).FirstOrDefault();
if (u == null)
{
u = new User {
Username = textUsername.Text, Password = textPassword.Text
};
_entities.AddToUsers(u);
dataListView1.DataSource = _entities.Users;
}
else
{
u.Username = textUsername.Text;
u.Password = textPassword.Text;
}
_entities.SaveChanges();
dataListView1.Enabled = true;
textUsername.ReadOnly = true;
textPassword.ReadOnly = true;
}
private void ratingStar1_RatingValueChanged(object sender, RatingControl.RatingChangedEventArgs e)
{
foreach (Keyword keyword in dataListView1.SelectedObjects)
{
keyword.Rated = (int)ratingStar1.Rating;
//Keyword keyword1 = keyword;
//var k = _db.Keywords.Where(o => o.Id == keyword1.Id).FirstOrDefault().Rated = (int)ratingStar1.Rating;
}
_db.SaveChanges();
}
private void clLogin_Click(object sender, EventArgs e)
{
if (textUsername.Text.Trim().Length == 0)
{
return;
}
if (textPassword.Text.Trim().Length == 0)
{
return;
}
var user = db.Users.Where(o => o.Username == textUsername.Text).FirstOrDefault();
if (user == null)
{
user = new User {
Username = textUsername.Text, Password = textPassword.Text
};
db.AddToUsers(user);
db.SaveChanges();
_args = new TextEventArgs("Success")
{
Data = user
};
this.Hide();
}
else if (user.Password != textPassword.Text)
{
_args = new TextEventArgs("Fail")
{
Data = null
};
MessageBox.Show(this, @"Username/Password does not match!");
}
else
{
_args = new TextEventArgs("Success")
{
Data = user
};
this.Hide();
}
}
// delete a movie
public HttpResponseMessage Delete(Movies Movie, int id)
{
try
{
using (MovieDbEntities entities = new MovieDbEntities())
{
entities.Movie.Remove(entities.Movie.FirstOrDefault(e => e.ID == id));
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK);
return(message);
}
}
catch (Exception exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exception));
}
}
// create a new movie
public HttpResponseMessage Post([FromBody] Movies Movie)
{
try
{
using (MovieDbEntities entities = new MovieDbEntities())
{
entities.Movie.Add(Movie);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, Movie);
message.Headers.Location = new Uri(Request.RequestUri + Movie.ID.ToString());
return(message);
}
}
catch (Exception exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exception));
}
}
// edit an existing movie
public HttpResponseMessage Put(int id, [FromBody] Movies Movie)
{
try
{
using (MovieDbEntities entities = new MovieDbEntities())
{
var entity = entities.Movie.FirstOrDefault(e => e.ID == id);
entity.Title = Movie.Title;
entity.Year = Movie.Year;
entity.Director = Movie.Director;
entity.Genre = Movie.Genre;
entity.Synopsis = Movie.Synopsis;
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK, Movie);
return(message);
}
}
catch (Exception exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exception));
}
}
public Movie CollectAndAddMovieToDb(Movie movie2, string moviePage = null, bool collectKeyword = true)
{
if (string.IsNullOrEmpty(moviePage))
{
InvokeOnNotificationFired("Started collecting movie: " + movie2.Title);
moviePage = HttpHelper.FetchWebPage(ImdbTitle + movie2.ImdbId);
}
var parseMovieInfo = ParseMovieInfo(moviePage);
if (parseMovieInfo == null)
{
return(null);
}
var movie = _entities.Movies.Where(o => o.ImdbId == parseMovieInfo.ImdbId).FirstOrDefault();
if (movie == null)
{
movie = parseMovieInfo;
movie.IsUpdated = false;
_entities.AddToMovies(movie);
_entities.SaveChanges();
}
else
{
movie.CopyFromMovie(parseMovieInfo);
_entities.SaveChanges();
}
foreach (var g in parseMovieInfo.Genres)
{
var genre = GetGenre(g);
var movieGenre = _entities.MovieGenres.Where(o => o.Movie.Id == movie.Id && o.Genre.Id == genre.Id).FirstOrDefault();
if (movieGenre != null)
{
continue;
}
movieGenre = new MovieGenre {
Movie = movie, Genre = genre
};
_entities.AddToMovieGenres(movieGenre);
_entities.SaveChanges();
}
foreach (var g in parseMovieInfo.Languages)
{
var language = GetLanguage(g);
var movieLanguage = _entities.MovieLanguages.Where(o => o.Movie.Id == movie.Id && o.Language.Id == language.Id).FirstOrDefault();
if (movieLanguage != null)
{
continue;
}
movieLanguage = new MovieLanguage {
Movie = movie, Language = language
};
_entities.AddToMovieLanguages(movieLanguage);
_entities.SaveChanges();
}
foreach (var g in parseMovieInfo.Countries)
{
var country = GetCountry(g);
var movieCountry = _entities.MovieCountries.Where(o => o.Movie.Id == movie.Id && o.Country.Id == country.Id).FirstOrDefault();
if (movieCountry != null)
{
continue;
}
movieCountry = new MovieCountry {
Movie = movie, Country = country
};
_entities.AddToMovieCountries(movieCountry);
_entities.SaveChanges();
}
foreach (var g in parseMovieInfo.PersonDirectors)
{
var person = GetPerson(g);
var director = _entities.Directors.Where(o => o.Movie.Id == movie.Id && o.Person.Id == person.Id).FirstOrDefault();
if (director != null)
{
continue;
}
director = new Director {
Movie = movie, Person = person
};
_entities.AddToDirectors(director);
_entities.SaveChanges();
}
foreach (var g in parseMovieInfo.PersonStars)
{
var person = GetPerson(g);
var star = _entities.Stars.Where(o => o.Movie.Id == movie.Id && o.Person.Id == person.Id).FirstOrDefault();
if (star != null)
{
continue;
}
star = new Star {
Movie = movie, Person = person
};
_entities.AddToStars(star);
_entities.SaveChanges();
}
foreach (var g in parseMovieInfo.PersonWriters)
{
var person = GetPerson(g);
var writer = _entities.Writers.Where(o => o.Movie.Id == movie.Id && o.Person.Id == person.Id).FirstOrDefault();
if (writer != null)
{
continue;
}
writer = new Writer {
Movie = movie, Person = person
};
_entities.AddToWriters(writer);
_entities.SaveChanges();
}
if (collectKeyword)
{
var keywordPage = HttpHelper.FetchWebPage(string.Format(ImdbKeywordUrl, parseMovieInfo.ImdbId));
parseMovieInfo.Keywords = ImdbParser.ParseKeywords(keywordPage);
foreach (var g in parseMovieInfo.Keywords)
{
var keyword = GetKeyword(g);
var movieKeyword =
_entities.MovieKeywords.Where(o => o.Movie.Id == movie.Id && o.Keyword.Id == keyword.Id).
FirstOrDefault();
if (movieKeyword != null)
{
continue;
}
movieKeyword = new MovieKeyword {
Movie = movie, Keyword = keyword
};
_entities.AddToMovieKeywords(movieKeyword);
_entities.SaveChanges();
}
}
InvokeOnNotificationFired("Fiished collecting movie: " + movie.Title);
movie.IsUpdated = true;
_entities.SaveChanges();
return(movie);
}
