// retrieve all movies public IEnumerable <Movies> GetMovies() { using (MovieDbEntities entities = new MovieDbEntities()) { return(entities.Movie.ToList()); } }
// retrieve a single movie public Movies Get(int id) { using (MovieDbEntities entities = new MovieDbEntities()) { return(entities.Movie.FirstOrDefault(e => e.ID == id)); } }
public LoginForm(MovieDbEntities context = null) { db = context ?? new MovieDbEntities(); InitializeComponent(); GlassMargins = new Margins(0, 0, 48, 48); }
private static MoviePersonalNote GetNote(MovieDbEntities db, User loggedInUser, Movie rowMovie) { try { var user = db.Users.Where(o => o.Username == loggedInUser.Username).FirstOrDefault(); var movie = db.Movies.Where(o => o.ImdbId == rowMovie.ImdbId).FirstOrDefault(); if (movie == null) { rowMovie.IsUpdated = false; db.AddToMovies(rowMovie); movie = rowMovie; } var personalNote = db.MoviePersonalNotes.Where(o => o.User.Id == loggedInUser.Id && o.Movie.Id == movie.Id). FirstOrDefault(); if (personalNote == null) { personalNote = new MoviePersonalNote { Comment = "", Movie = movie, User = user }; db.AddToMoviePersonalNotes(personalNote); } return(personalNote); } catch (Exception exp) { Logger.Exception(exp, 550); return(null); } }
public KeywordsForm(MovieDbEntities context) { _db = context; InitializeComponent(); dataListView1.DataSource = _db.Keywords; }
public UsersForm(MovieDbEntities context) { _entities = context; InitializeComponent(); var data = _entities.Users; dataListView1.DataSource = data; }
public MovieListForm(User user, MovieDbEntities context = null) { _user = user; _entities = context ?? new MovieDbEntities(); InitializeComponent(); dataListView1.DataSource = _entities.UserLists.Where(o => o.User.Id == _user.Id); }
public MovieBrowserController() { try { _entities = new MovieDbEntities(); DbLoggedIn = false; } catch (Exception exception) { Logger.Exception(exception, 43); } }
// 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)); } }