public static void CreateMovie(Movie movy, MovieUser movieUser) { MovieAuthEntities db = new MoviesWithAuth.MovieAuthEntities(); Movie checkMovie = (from m in db.Movies where m.MovieName == movy.MovieName select m).FirstOrDefault(); if (checkMovie == null) { db.Movies.Add(movy); db.SaveChanges(); checkMovie = db.Movies.Where(m => m.MovieName == movy.MovieName).FirstOrDefault(); } movieUser.MovieId = checkMovie.MovieId; db.MovieUsers.Add(movieUser); db.SaveChanges(); }
public static void DeleteMovieFromUser(string userName, int movieId) { using (MovieAuthEntities db = new MoviesWithAuth.MovieAuthEntities()) { var movUserToDelete = (from mu in db.MovieUsers where mu.MovieId == movieId && mu.UserName == userName select mu).FirstOrDefault(); if (movUserToDelete != null) { db.MovieUsers.Remove(movUserToDelete); db.SaveChanges(); } } }