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