public async Task <ICollection <Review> > GetLikedReviews(IJustWatchedContext context,
string userId)
{
var rows = from row in context.LikesReviews select row;
var likedReviews = rows.Where(row => row.LikedByUser.Id == userId)
.Select(row => row.LikedReview);
return(await likedReviews.ToListAsync());
}
// TODO: check for correctness
public async Task <ICollection <User> > GetReviewLikes(IJustWatchedContext context,
int reviewId)
{
var rows = from row in context.LikesReviews select row;
var likes = rows.Where(row => row.LikedReview.Id == reviewId)
.Select(row => row.LikedByUser);
return(await likes.ToListAsync());
}
public async Task <ICollection <Review> > GetReviewsFromTag(IJustWatchedContext context,
int tagId)
{
var rows = from row in context.TagsReviews select row;
var reviews = rows.Where(row => row.TagInReview.Id == tagId)
.Select(user => user.TaggedReview);
return(await reviews.ToListAsync());
}
public CommentHub(IJustWatchedContext context, UserManager <User> userManager)
{
_context = context;
_userManager = userManager;
}
public HomeController(IJustWatchedContext context, UserManager <User> userManager)
{
_context = context;
_userManager = userManager;
}
public FilmController(IJustWatchedContext context)
{
_context = context;
}
public static void InitializeFilms(IServiceProvider serviceProvider)
{
using (var context = new IJustWatchedContext(
serviceProvider.GetRequiredService <
DbContextOptions <IJustWatchedContext> >()))
{
if (!context.Films.Any())
{
context.Films.AddRange(
new Film
{
Title = "Joker",
ReleaseDate = DateTime.Parse("2019-10-4"),
Directors = "Todd Phillips",
PosterURL = "https://m.media-amazon.com/images/M/MV5BNGVjNWI4ZGUtNzE0MS00YTJmLWE0ZDctN2ZiYTk2YmI3NTYyXkEyXkFqcGdeQXVyMTkxNjUyNQ@@._V1_SX300.jpg",
TrailerURL = "https://www.youtube.com/embed/zAGVQLHvwOY"
},
new Film
{
Title = "Fight Club",
ReleaseDate = DateTime.Parse("1999-10-15"),
Directors = "David Fincher",
PosterURL = "https://m.media-amazon.com/images/M/MV5BMmEzNTkxYjQtZTc0MC00YTVjLTg5ZTEtZWMwOWVlYzY0NWIwXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_SX300.jpg",
TrailerURL = "https://www.youtube.com/embed/SUXWAEX2jlg"
},
new Film
{
Title = "Blade runner",
ReleaseDate = DateTime.Parse("1982-6-25"),
Directors = "Ridley Scott",
PosterURL = "https://m.media-amazon.com/images/M/MV5BNzQzMzJhZTEtOWM4NS00MTdhLTg0YjgtMjM4MDRkZjUwZDBlXkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_SX300.jpg",
TrailerURL = "https://www.youtube.com/embed/eogpIG53Cis"
},
new Film
{
Title = "Pulp ficiton",
ReleaseDate = DateTime.Parse("1994-10-14"),
Directors = "Quentin Tarantino",
PosterURL = "https://m.media-amazon.com/images/M/MV5BNGNhMDIzZTUtNTBlZi00MTRlLWFjM2ItYzViMjE3YzI5MjljXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_SX300.jpg",
TrailerURL = "https://www.youtube.com/embed/5ZAhzsi1ybM"
},
new Film()
{
Title = "Interstellar",
ReleaseDate = DateTime.Parse("2014-11-7"),
Directors = "Christopher Nolan",
PosterURL = "https://m.media-amazon.com/images/M/MV5BZjdkOTU3MDktN2IxOS00OGEyLWFmMjktY2FiMmZkNWIyODZiXkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_SX300.jpg",
TrailerURL = "https://www.youtube.com/embed/zSWdZVtXT7E"
},
new Film()
{
Title = "Mommy",
ReleaseDate = DateTime.Parse("2014-10-4"),
Directors = "Xavier Dolan",
PosterURL = "https://m.media-amazon.com/images/M/MV5BMGI3YWFmNDQtNjc0Ny00ZDBjLThlNjYtZTc1ZTk5MzU2YTVjXkEyXkFqcGdeQXVyNzA4ODc3ODU@._V1_SX300.jpg",
TrailerURL = "https://www.youtube.com/embed/dcmueTy2FoM"
}
);
context.SaveChanges();
}
if (!context.Users.Any())
{
var userManager = serviceProvider.GetRequiredService <UserManager <User> >();
using (var roleContext = serviceProvider.GetRequiredService <RoleManager <IdentityRole> >())
{
roleContext.CreateAsync(new IdentityRole("admin"));
roleContext.CreateAsync(new IdentityRole("moderator"));
roleContext.CreateAsync(new IdentityRole("user"));
}
var users = new List <User>()
{
new User()
{
Email = "*****@*****.**",
UserName = "******",
BirthdayDate = DateTime.Now,
},
new User()
{
Email = "*****@*****.**",
UserName = "******",
BirthdayDate = DateTime.Now,
},
new User()
{
Email = "*****@*****.**",
UserName = "******",
BirthdayDate = DateTime.Now,
},
};
var admin = userManager.CreateAsync(users[0], "Qwerty_9");
var moderator = userManager.CreateAsync(users[1], "Mo_1234");
var user = userManager.CreateAsync(users[2], "Us_1234");
if (admin.IsCompletedSuccessfully && moderator.IsCompletedSuccessfully &&
user.IsCompletedSuccessfully)
{
userManager.AddToRoleAsync(users[0], "admin");
userManager.AddToRoleAsync(users[1], "moderator");
userManager.AddToRoleAsync(users[2], "user");
}
context.SaveChanges();
}
}
}
public TagsViewComponent(IJustWatchedContext context)
{
_context = context;
}
