/// <summary>
/// Get total view count of a film
/// </summary>
/// <param name="filmId"></param>
/// <returns></returns>
public long GetViewCount(int filmId)
{
MoviesDataContext movie = new MoviesDataContext();
var film = movie.Films.SingleOrDefault(f => f.ID == filmId);
return(film.ViewCount ?? 0);
}
/// <summary>
/// Lấy toàn bộ comment của 1 phim
/// </summary>
/// <param name="filmId"></param>
/// <returns></returns>
public List <Comment> GetAllCommentOfAFilm(int filmId)
{
MoviesDataContext movie = new MoviesDataContext();
var list = movie.Comments.Where(c => c.FilmID == filmId && c.IsActive == true).ToList();
return(list);
}
/// <summary>
/// Lấy toàn bộ thông tin của 1 Film trong Database
/// </summary>
/// <param name="filmId"></param>
/// <returns></returns>
public Film GetDetailAFilm(int filmId)
{
MoviesDataContext movie = new MoviesDataContext();
var film = movie.Films.SingleOrDefault(f => f.ID == filmId);
return(film);
}
/// <summary>
/// Thêm mới 1 account
/// </summary>
/// <param name="a"></param>
public void AddNewAccount(Account a)
{
MoviesDataContext movie = new MoviesDataContext();
movie.Accounts.InsertOnSubmit(a);
movie.SubmitChanges();
}
/// <summary>
/// Lấy 10 film có lượt view cao nhất
/// </summary>
/// <returns></returns>
public List <Film> GetTop10Film()
{
MoviesDataContext movie = new MoviesDataContext();
//sắp xếp theo thứ tự giảm dần dựa trên ViewCount rồi lấy 10 phần tử
return(movie.Films.OrderByDescending(f => f.ViewCount).Take(10).ToList());
}
/// <summary>
/// Thêm mới 1 comment vào database
/// </summary>
/// <param name="c"></param>
public void AddNewComment(Comment c)
{
MoviesDataContext movie = new MoviesDataContext();
movie.Comments.InsertOnSubmit(c);
movie.SubmitChanges();
}
/// <summary>
/// Deactive comment đã chọn
/// </summary>
/// <param name="c"></param>
public void DeleteComment(Comment c)
{
MoviesDataContext movie = new MoviesDataContext();
var comm = movie.Comments.SingleOrDefault(co => co.ID == c.ID);
comm.IsActive = false;
movie.SubmitChanges();
}
/// <summary>
/// Increase view count when film was watched
/// </summary>
/// <param name="filmId"></param>
public void IncreaseViewCount(int filmId)
{
MoviesDataContext movie = new MoviesDataContext();
var film = movie.Films.SingleOrDefault(f => f.ID == filmId);
film.ViewCount += 1;
movie.SubmitChanges();
}
/// <summary>
/// Deactive account
/// </summary>
/// <param name="a"></param>
public void DeleteAccount(Account a)
{
MoviesDataContext movie = new MoviesDataContext();
var acc = movie.Accounts.SingleOrDefault(account => account.Username.Equals(a.Username));
acc.IsActive = false;
movie.SubmitChanges();
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard Silverlight initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Show graphics profiling information while debugging.
if (System.Diagnostics.Debugger.IsAttached)
{
// Display the current frame rate counters.
Application.Current.Host.Settings.EnableFrameRateCounter = true;
// Show the areas of the app that are being redrawn in each frame.
//Application.Current.Host.Settings.EnableRedrawRegions = true;
// Enable non-production analysis visualization mode,
// which shows areas of a page that are handed off to GPU with a colored overlay.
//Application.Current.Host.Settings.EnableCacheVisualization = true;
// Disable the application idle detection by setting the UserIdleDetectionMode property of the
// application's PhoneApplicationService object to Disabled.
// Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
// and consume battery power when the user is not using the phone.
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
DB = new MoviesDataContext();
if (!DB.DatabaseExists())
{
DB.CreateDatabase();
var dbUpdater = DB.CreateDatabaseSchemaUpdater();
dbUpdater.DatabaseSchemaVersion = 2;
dbUpdater.Execute();
}
DatabaseSchemaUpdater updater = DB.CreateDatabaseSchemaUpdater();
if (updater.DatabaseSchemaVersion < 2)
{
// PublishedDate-Spalte fehlt => hinzufügen und Version erhöhen
updater.AddColumn <Movie>("PublishedDate");
updater.DatabaseSchemaVersion = 2;
updater.Execute();
}
}
/// <summary>
/// Check login info return role of user
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public string CheckLogin(string username, string password)
{
MoviesDataContext movie = new MoviesDataContext();
var acc = movie.Accounts.SingleOrDefault(account => account.Username.Equals(username));
if (acc != null && acc.Password.ToLower().Equals(password.ToLower()))
{
return(acc.Role);
}
else
{
return("");
}
}
/// <summary>
/// Thêm mới 1 account
/// </summary>
/// <param name="a"></param>
public bool AddNewAccount(Account a)
{
MoviesDataContext movie = new MoviesDataContext();
try
{
a.Role = "user";
a.JoinedDate = DateTime.Now;
a.IsActive = true;
movie.Accounts.InsertOnSubmit(a);
movie.SubmitChanges();
return(true);
}
catch (Exception ex)
{
}
return(false);
}
/// <summary>
/// Add new comment
/// </summary>
/// <param name="username"></param>
/// <param name="content"></param>
/// <param name="filmId"></param>
public long AddNewComment(string username, string content, long filmId)
{
try
{
MoviesDataContext movie = new MoviesDataContext();
Comment comment = new Comment();
comment.Username = username;
comment.Content = content;
comment.FilmID = filmId;
comment.DateTime = DateTime.Now;
comment.IsActive = true;
movie.Comments.InsertOnSubmit(comment);
movie.SubmitChanges();
return(comment.ID);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(-1);
}
/// <summary>
/// Tạo 1 danh sách film của category đã chọn
/// </summary>
/// <param name="catId"></param>
/// <returns></returns>
public List <Film> GetListFilmOfACategory(int catId)
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Films.Where(f => f.CategoryID == catId && f.IsActive == true).ToList());
}
/// <summary>
/// Tạo 1 danh sách tất cả Film hiện có trong database
/// </summary>
public List <Film> GetListFilm()
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Films.Where(f => f.IsActive == true).ToList());
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Category GetACategory(int id)
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Categories.SingleOrDefault(c => c.ID == id));
}
/// <summary>
/// tạo danh sách tất cả thể loại phim
/// </summary>
public List <Category> GetAllCategory()
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Categories.Where(c => c.IsActive == true).ToList());
}
public MovieController(MoviesDataContext context)
{
_context = context;
}
/// <summary>
/// Tạo 1 danh sách toàn bộ account
/// </summary>
/// <returns></returns>
public List <Account> GetListAccount()
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Accounts.ToList());
}
/// <summary>
/// Get top of newest film
/// </summary>
/// <param name="num"></param>
/// <returns></returns>
public List <Film> GetTopNewestFilm(int num)
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Films.OrderByDescending(f => f.ID).Take(num).ToList());
}
/// <summary>
/// Search film by title
/// </summary>
/// <param name="keyword"></param>
/// <returns></returns>
public List <Film> SearchFilm(string keyword)
{
MoviesDataContext movie = new MoviesDataContext();
return(movie.Films.Where(f => f.FullTitle.ToLower().Contains(keyword.ToLower())).ToList());
}
