public override void CreateRole(string roleName) { Role newRole = new Role() { Name = roleName }; FilmCatalogContext db = new FilmCatalogContext(); db.Roles.Add(newRole); db.SaveChanges(); }
public bool AddUsers(string userName, string password, string email) { User currentUser = new User(); currentUser.UserName = userName; currentUser.Password = password; currentUser.email = email; //bool isInDb = false; var user = context.Users.FirstOrDefault(x => x.UserName == currentUser.UserName); if (user != null) { currentUser.MoviesList = new List <Movie>(); currentUser.Ratings = new List <Rating>(); currentUser.Tags = new List <Tag>(); context.Users.Add(currentUser); context.SaveChanges(); return(true);//!!!!!!!! } else { return(false); } //foreach (var user1 in context.Users) //{ // try // { // if (user1.UserName == currentUser.UserName) // { // isInDb = true; // } // } // catch // { // } //} //if (isInDb == false) //{ // currentUser.MoviesList = new List<Movie>(); // currentUser.Ratings = new List<Rating>(); // currentUser.Tags = new List<Tag>(); // context.Users.Add(currentUser); // context.SaveChanges(); // return true;//!!!!!!!! //} //else return false; }
public void AddMovieTag(MovieTag movieTag) { context.MovieTags.Add(movieTag); context.SaveChanges(); }
public void AddTag(Tag tag) { context.Tags.Add(tag); context.SaveChanges(); }
public void Save() { db.SaveChanges(); }
public object AddRating() {//it was a void, but i try recoursian cuz when i have invalid movie name or username let me go back again.if recursion wasnt sucsess i would try with methods. string movieName = null; int validator = 0; int rating = 0; string userName = null; do { Console.Write("\nEnter Movie name: "); movieName = Console.ReadLine().Trim(); validator = validation.ValidateMovieName(movieName); if (validator == 0) { result = "Successfully found movie!"; // break; } else if (validator == -1) { result = "Name cannot be empty!"; } else if (validator == 1) { result = "Such movie doesn't exist!"; Console.WriteLine(result); return(this.AddRating()); } Console.WriteLine(result); } while (validation.ValidateMovieName(movieName) != 0); if (string.IsNullOrEmpty(Form2.loginUser) == false) { userName = Form2.loginUser; } if (string.IsNullOrEmpty(RegisterForm.user) == false) { userName = RegisterForm.user; } Movie movie = context.Movies.First(x => x.Name == movieName); User user = context.Users.First(x => x.UserName == userName); var answer = Setting(movie, user); if (answer == "y") //TO DO YES-A ??!! { var r = context.Ratings.FirstOrDefault(x => x.MovieId == movie.Id); //1 user може да е добавил мн рейтинг към мн филми,избираме не първият филм от базата,а този който искаме. foreach (var film in user.MoviesList) { if (r.MovieId == film.Id) { if (r != null) { ManipulationRating(rating, movieName, validator); r.Score = rating4e; context.Ratings.Update(r); context.SaveChanges(); return("Successfully updated rating in database."); } } } } if (answer == "yep")//if movieID=userId but this movie is added by other user { var a = userController.GetUser(user.UserName); var u = context.Ratings.FirstOrDefault(x => x.User.Id == a.Id); foreach (var rt in u.User.Ratings) { if (rt.MovieId == a.Id) { ManipulationRating(rating, movieName, validator); rt.Score = rating4e; context.Ratings.Update(u); context.SaveChanges(); return("Successfully updated rating in database."); } } } if (answer == "yey") { var a = userController.GetUser(user.UserName); var m = context.Ratings.FirstOrDefault(x => x.MovieId == movie.Id); foreach (var r in a.Ratings) { if (m.MovieId == r.MovieId) { ManipulationRating(rating, movieName, validator); r.Score = rating4e; context.Ratings.Update(r); context.SaveChanges(); return("Successfully updated rating in database."); } } } if (answer == "n") { return("The rating has not changed. It's still the same."); } if (answer == "r not exist") { ManipulationRating(rating, movieName, validator); Rating ratingToAdd = new Rating { Score = rating4e, Movie = movie, User = user }; context.Ratings.Add(ratingToAdd); userController.AddRating(ratingToAdd, user); context.SaveChanges(); return("Successfully added rating to database."); } else { return(""); } }
public void AddMovie(Movie movie) { context.Movies.Add(movie); context.SaveChanges(); }
public void AddGenre(Genre genre) { context.Genres.Add(genre); context.SaveChanges(); }