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