public List <Movy> GetCatalog()
{
MovieEntities db = new MovieEntities();
List <Movy> Movies = db.Movies.ToList();
return(Movies);
}
public List <Movy> GetMovie()
{
MovieEntities db = new MovieEntities();
List <Movy> movies = db.Movies.ToList();
return(movies);
}
public static Genre GetByID(int id)
{
using (MovieEntities context = new MovieEntities())
{
return(context.Genres.Where(x => x.ID == id).First());
}
}
public static Dictionary <string, object> getUserInfo(int id)
{
MovieEntities movieEntities = new MovieEntities();
User user = movieEntities.User.Where(u => u.id == id).FirstOrDefault();
return(ClassToDictionary.classToDictionary(user));
}
public static Dictionary <string, object> Login(string email, string pwd)
{
MovieEntities movieEntities = new MovieEntities();
Dictionary <string, object> result = new Dictionary <string, object>();
User user = movieEntities.User.Where(u => u.email.Equals(email)).FirstOrDefault();
if (user == null)
{
result.Add("type", ConstantValue.UserNotExist);
return(result);
}
else
{
if (user.password.Equals(pwd))
{
result.Add("type", ConstantValue.LoginSucceed);
result.Add("id", user.id);
HttpContext.Current.Session["user"] = user.id;
return(result);
}
else
{
result.Add("type", ConstantValue.WrongPwd);
return(result);
}
}
}
public static List <Genre> GetForMovie(int id)
{
using (MovieEntities context = new MovieEntities())
{
return(context.Movies.Where(x => x.ID == id).First().Genres.ToList());
}
}
public int createUser(RegisterRequestJSON req)
{
int userId = 0;
using (MovieEntities db = new MovieEntities())
{
string email_input = !string.IsNullOrWhiteSpace(req.email) ? req.email : null;
string hashedpassword_input = !string.IsNullOrWhiteSpace(req.hashedpassword) ? req.hashedpassword : null;
string salt_input = !string.IsNullOrWhiteSpace(req.salt) ? req.salt : null;
string accesstoken_input = !string.IsNullOrWhiteSpace(req.socialMediaAccessToken) ? req.socialMediaAccessToken : null;
string socialmediauserid_input = !string.IsNullOrWhiteSpace(req.socialMediaUserId) ? req.socialMediaUserId : null;
string firstname_input = !string.IsNullOrWhiteSpace(req.firstName) ? req.firstName : null;
string network_input = !string.IsNullOrWhiteSpace(req.network) ? req.network : null;
ObjectParameter output_userId = new ObjectParameter("userId", typeof(Int32));
int userid = db.pr_RegisterUser(email_input, salt_input, hashedpassword_input, network_input, accesstoken_input, socialmediauserid_input, firstname_input, output_userId);
if (output_userId.Value != null)
{
int ouserId = (int)output_userId.Value;
if (ouserId != 0)
{
userId = ouserId;
}
}
}
return(userId);
}
public static Dictionary <string, object> Register(string email, string pwd, string name)
{
MovieEntities movieEntities = new MovieEntities();
Dictionary <string, object> result = new Dictionary <string, object>();
User user = movieEntities.User.Where(u => u.email.Equals(email)).FirstOrDefault();
if (user == null)
{
user = new User
{
email = email,
password = pwd,
name = name
};
movieEntities.User.Add(user);
movieEntities.SaveChanges();
HttpContext.Current.Session["user"] = user.id;
result.Add("type", ConstantValue.RegisterSucceed);
result.Add("id", movieEntities.User.Where(u => u.email.Equals(email)).FirstOrDefault().id);
return(result);
}
else
{
result.Add("type", ConstantValue.UserExist);
return(result);
}
}
public static List <Dictionary <string, object> > list(int commentId)
{
MovieEntities movieEntities = new MovieEntities();
LinkedList <Dictionary <string, object> > result = new LinkedList <Dictionary <string, object> >();
var feedbacks = movieEntities.Feedback.Where(f => f.comment_id == commentId).Where(f => f.reply_id == 0);
foreach (var fb in feedbacks)
{
User user = new MovieEntities().User.Where(u => u.id == fb.user_id).FirstOrDefault();
User at = fb.at_id == 0 ? null : new MovieEntities().User.Where(u => u.id == fb.at_id).FirstOrDefault();
var f = ClassToDictionary.classToDictionary(fb);
f.Add("username", user.name);
f.Add("at_username", at == null ? null : at.name);
LinkedList <Dictionary <string, object> > replies = new LinkedList <Dictionary <string, object> >();
foreach (var subfb in new MovieEntities().Feedback.Where(sf => sf.reply_id == fb.id))
{
var subf = ClassToDictionary.classToDictionary(subfb);
subf.Add("username", new MovieEntities().User.Where(u => u.id == subfb.user_id).FirstOrDefault().name);
subf.Add("at_username", new MovieEntities().User.Where(u => u.id == subfb.at_id).FirstOrDefault().name);
replies.AddLast(subf);
}
f.Add("replies", replies);
result.AddLast(f);
}
return(result.Reverse().ToList());
}
public static List <Genre> GetAll()
{
using (MovieEntities context = new MovieEntities())
{
return(context.Genres.OrderBy(x => x.Name).ToList());
}
}
public void InsertOrUpdateComment(int userId, int movieId, decimal score)
{
DateTime now = DateTime.UtcNow;
using (var db = new MovieEntities())
{
var target = db.UserCommentMovies.FirstOrDefault(m => m.UserId == userId &&
m.MovieId == movieId);
if (target == null)
{
db.UserCommentMovies.Add(new UserCommentMovie
{
UserId = userId,
MovieId = movieId,
Score = score,
AddTime = now,
UpdateTime = now
});
}
else
{
target.Score = score;
target.UpdateTime = now;
}
db.SaveChanges();
}
}
public DataAccess.Movie GetMovie(int movieID) //取得指定的電影
{
MovieEntities dbMovie = new MovieEntities();
DataAccess.Movie movie = dbMovie.Movie.FirstOrDefault(x => x.ID == movieID);
return(movie);
}
public List <MovieList> GetMovieList()
{
MovieEntities db = new MovieEntities();
List <MovieList> Movies = db.MovieLists.ToList();
return(Movies);
}
public bool isAdmin(int userId)
{
bool isValid = false;
using (MovieEntities db = new MovieEntities())
{
var userrole = (from u in db.Users
join ur in db.UserRoles on u.Users_ID equals ur.Users_ID
join r in db.Roles on ur.Roles_ID equals r.Roles_ID
where ur.Users_ID == userId
select new
{
role = r.RoleName
}).ToList();
foreach (var item in userrole)
{
if (item.role.ToLower() == "admin")
{
isValid = true;
}
}
}
return(isValid);
}
public string updateAccessToken(int userId, string accessToken)
{
string status = "";
try
{
using (MovieEntities db = new MovieEntities())
{
var query = db.UsersSessions.Where(x => x.Users_ID == userId).FirstOrDefault();
if (query != null)
{
query.token = accessToken;
query.createdDate = DateTime.UtcNow;
db.SaveChanges();
}
else
{
var usersession = new UsersSession();
usersession.Users_ID = userId;
usersession.token = accessToken;
usersession.createdDate = DateTime.UtcNow;
db.UsersSessions.Add(usersession);
db.SaveChanges();
}
}
}
catch
{
status = "There seems to be an issue with updating access token. Please try again.";
}
return(status);
}
public static Dictionary <string, object> like(int commentId)
{
MovieEntities movieEntities = new MovieEntities();
int userId = SessionService.getSession();
Like like = movieEntities.Like.Where(m => m.user_id == userId && m.comment_id == commentId).FirstOrDefault();
Comment comment = movieEntities.Comment.Where(c => c.id == commentId).FirstOrDefault();
Dictionary <string, object> result = new Dictionary <string, object>();
if (like == null)
{
Like newLike = new Like();
newLike.user_id = userId;
newLike.comment_id = commentId;
movieEntities.Like.Add(newLike);
comment.likes += 1;
movieEntities.SaveChanges();
result.Add("like", true);
result.Add("likes", comment.likes);
}
else
{
movieEntities.Like.Remove(like);
comment.likes -= 1;
movieEntities.SaveChanges();
result.Add("like", false);
result.Add("likes", comment.likes);
}
return(result);
}
/// <summary>
/// 删除token
/// </summary>
/// <param name="UserId"></param>
private static void DeleteToken(int UserId)
{
MovieEntities dc = new MovieEntities();
var list = dc.Tokens.Where(c => c.UserID == UserId).FirstOrDefault();
dc.Tokens.Remove(list);
dc.SaveChanges();
}
public static List <Movie> GetAll()
{
using (MovieEntities context = new MovieEntities())
{
var movies = context.Movies.Include(x => x.Genres).OrderBy(x => x.Title).ToList();
return(movies);
}
}
public static Movie GetByID(int id)
{
using (MovieEntities context = new MovieEntities())
{
var movie = context.Movies.Include(x => x.Genres).Where(x => x.ID == id).First();
return(movie);
}
}
public bool CreateMovie(DataAccess.Movie movie) //新增電影
{
MovieEntities dbMovie = new MovieEntities();
dbMovie.Movie.Add(movie);
dbMovie.SaveChanges();
return(true);
}
private static void LoadDataIntoDb(dynamic obj, int path)
{
try
{
MovieEntities db = new MovieEntities();
string imdbId = obj[0]["imdb_id"];
//if(!db.Movies.Select(m => m.ImdbID == imdbId).First())
if (db.Movies.Count() == 0 || !db.Movies.Select(m => m.ImdbID == imdbId).First())
{
Int64 existingMovieId = 0;
if (db.Movies.Count() > 0)
{
existingMovieId = db.Movies.Count();
}
Movie movie = new Movie();
movie.ID = existingMovieId + 1;
movie.PlotDetailed = obj[0]["plot"];
movie.ImdbID = obj[0]["imdb_id"];
movie.PlotSimple = obj[0]["plot_simple"];
var tempruntime = obj[0]["runtime"];
movie.Runtime = ConvertRuntime(tempruntime.ToString());
movie.Rated = obj[0]["rated"];
movie.ImdbUrl = obj[0]["imdb_url"];
movie.AKA = obj[0]["also_known_as"][0];
movie.IMDBRating = obj[0]["rating"];
Int64 releaseDate = obj[0]["release_date"];
DateTime dtTime = new DateTime(Int32.Parse(releaseDate.ToString().Substring(0, 4)), Int32.Parse(releaseDate.ToString().Substring(4, 2)), Int32.Parse(releaseDate.ToString().Substring(6, 2)));
movie.ReleaseDate = dtTime;
movie.Title = obj[0]["title"];
Genres(obj, db);
db.Movies.Add(movie);
db.SaveChanges();
var savedMovie = db.Movies.Where(m => m.ImdbID == movie.ImdbID).Distinct();
MoviePersonRole(obj, db);
var ListOfGenre = obj[0]["genres"];
Poster poster = new Poster();
poster.imdb = obj[0]["poster"]["imdb"];
poster.cover = obj[0]["poster"]["cover"];
PosterInfo posterInfo = new PosterInfo();
posterInfo.Imdb = poster.imdb;
posterInfo.Cover = poster.cover;
posterInfo.MovieId = savedMovie.First().ID;
db.PosterInfoes.Add(posterInfo);
db.SaveChanges();
}
}
catch (Exception ex)
{
string inputfolder = "C:\\Users\\PrashMaya\\My Documents\\Exceptions\\Movie{0}.txt";
string inputfile = String.Format(inputfolder, path);
System.IO.File.WriteAllText(inputfile, ex.ToString());
Console.WriteLine(ex.Message);
}
}
[HttpGet] //Ques. #3
public Movie GetRandomMovie()
{
MovieEntities ORM = new MovieEntities();
Random r = new Random();
List <Movie> MovieList = ORM.Movies.ToList();
return(MovieList[r.Next(0, MovieList.Count)]);
}
public Movie ListRandomMovie()
{
MovieEntities ORM = new MovieEntities();
Random rand = new Random();
return(ORM.Movies.ToList()[rand.Next(ORM.Movies.Count())]);
}
public List <MovieList> GetMovieByGenre(string genre)
{
MovieEntities db = new MovieEntities();
List <MovieList> MovieGenre = (from m in db.MovieLists
where m.Genre.Contains(genre)
select m).ToList();
return(MovieGenre);
}
public List <MovieList> GetMovieByLeadActor(string actor)
{
MovieEntities db = new MovieEntities();
List <MovieList> LeadActor = (from m in db.MovieLists
where m.LeadActor.Contains(actor)
select m).ToList();
return(LeadActor);
}
public static void Delete(int id)
{
using (MovieEntities context = new MovieEntities())
{
var movie = context.Movies.Where(x => x.ID == id).First();
context.Movies.Remove(movie);
context.SaveChanges();
}
}
public List <Movy> GetMovieByCategory(string id)
{
MovieEntities db = new MovieEntities();
List <Movy> Category = (from m in db.Movies
where m.Category.Contains(id)
select m).ToList();
return(Category);
}
public bool isValidUserId(int userId)
{
using (MovieEntities db = new MovieEntities())
{
var count = (from u in db.Users
where u.Users_ID == userId
select u).Count();
return(count > 0 ? true: false);
}
}
private static void AddSampleRoleData()
{
Role role = new Role();
role.Description = "Director";
MovieEntities db = new MovieEntities();
db.Roles.Add(role);
db.SaveChanges();
}
public static LinkedList <Dictionary <string, object> > fuzzySearch(string param)
{
LinkedList <Dictionary <string, object> > result = new LinkedList <Dictionary <string, object> >();
var movies = new MovieEntities().Movie.Where(m => m.name.Contains(param) || m.genres.Contains(param) || m.regions.Contains(param) || m.directors.Contains(param) || m.stars.Contains(param));
foreach (var movie in movies)
{
result.AddLast(ClassToDictionary.movieToDictionary(movie));
}
return(result);
}
