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