public EntertaintmentList BuildEntertainmentListByUserId(int id)
{
EntertaintmentList et = new EntertaintmentList();
et.Movies = rda.GetAllMovieReviewByUserId(id);
et.TvSeries = rda.GetAllTvSerieReviewByUserId(id);
et.Games = rda.GetAllGameReviewByUserId(id);
return(et);
}
public EntertaintmentList GetELByUserId(int id)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("Select * From [dbo].[EntertainmentList], [dbo].[Movie] WHERE MovieReview.id = @id AND MovieReview.movieId = Movie.id", connection);
connection.Open();
cmd.Parameters.AddWithValue("id", id);
var reader = cmd.ExecuteReader();
EntertaintmentList entertaintmentList = new EntertaintmentList();
while (reader.Read())
{
}
return(entertaintmentList);
};
}
