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 ActionResult Register(Account account)
{
account.IsAdmin = admin;
// account.Password = Encrypt(account.Password);
if (ModelState.IsValid)
{
db.Accounts.Add(account);
try {
db.SaveChanges();
}
catch (Exception ex)
{
if (ex is System.Data.SqlClient.SqlException || ex is System.Data.Entity.Infrastructure.DbUpdateException)
{
ViewBag.ErrorMsg = "The Email/Username already Exists in our database, kindly use another one";
return(View());
}
//throw;
}
return(RedirectToAction("Login", "Accounts"));
}
return(View(account));
}
private void AddMovie()
{
if (txbMovieTitle.Text == "" ||
txbMovieYear.Text == "" ||
txbMovieReleaseCountry.Text == "" ||
txbMovieTime.Text == "" ||
txbMovieLanguage.Text == "")
{
MessageBox.Show("Thông tin chưa đủ");
}
try
{
movie movie = new movie();
movie.mov_title = txbMovieTitle.Text;
movie.mov_year = Convert.ToInt32(txbMovieYear.Text);
movie.mov_rel_country = txbMovieReleaseCountry.Text;
movie.mov_time = Convert.ToInt32(txbMovieTime.Text);
movie.mov_lang = txbMovieLanguage.Text;
movie.mov_dt_rel = dpMovieReleaseDate.Value;
movie.mov_image = txbMovieImage.Text;
db.movies.Add(movie);
db.SaveChanges();
MessageBox.Show("Thêm movie thành công");
ReloadDataGird();
}
catch (Exception)
{
MessageBox.Show("Thêm movie thất bại");
}
}
private void AddDirector()
{
if (txbDirectorFirstName.Text == "" ||
txbDirectorLastName.Text == "")
{
MessageBox.Show("Thông tin chưa đủ");
}
try
{
director director = new director();
director.dir_fname = txbDirectorFirstName.Text;
director.dir_lname = txbDirectorLastName.Text;
director.dir_image = txbDirectorImage.Text;
db.directors.Add(director);
db.SaveChanges();
MessageBox.Show("Thêm actor thành công");
ReloadDataGird();
}
catch (Exception)
{
MessageBox.Show("Thêm actor thất bại");
}
}
public void AddActor()
{
if (txbActorFirstName.Text == "" ||
txbActorLastName.Text == "" ||
cbbActorGender.selectedValue == "")
{
MessageBox.Show("Thông tin chưa đủ");
}
try
{
actor actor = new actor();
actor.act_fname = txbActorFirstName.Text;
actor.act_lname = txbActorLastName.Text;
actor.act_gender = cbbActorGender.selectedValue;
actor.act_image = txbActorImage.Text;
db.actors.Add(actor);
db.SaveChanges();
MessageBox.Show("Thêm actor thành công");
ReloadDataGird();
}
catch (Exception ex)
{
MessageBox.Show("Thêm actor thất bại");
}
}
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);
}
// [ValidateAntiForgeryToken]
public ActionResult Create(/*[Bind(Include = "Id,MovieID")] */ Favourite favourite)
{
if (Session["Username"] != null)
{
if (ModelState.IsValid)
{
db.Favourites.Add(favourite);
try
{
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
ViewBag.Id = new SelectList(db.Accounts, "Id", "EmailID", favourite.Id);
return(View(favourite));
}
else
{
return(RedirectToAction("Login", "Accounts"));
}
}
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);
}
}
public ActionResult Create([Bind(Include = "Admin_ID,Admin_Name,Admin_Password,DateOfBirth,Admin_Contact")] AdminTable adminTable)
{
if (ModelState.IsValid)
{
db.AdminTables.Add(adminTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adminTable));
}
public ActionResult Create([Bind(Include = "Id,Name,Sex,DOB,Bio")] Producer producer)
{
if (ModelState.IsValid)
{
db.Producers.Add(producer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(producer));
}
public ActionResult Create([Bind(Include = "Name,Id,Sex,DOB,Bio")] Actor actor)
{
if (ModelState.IsValid)
{
db.Actors.Add(actor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(actor));
}
public ActionResult Create([Bind(Include = "Name,Plot,Poster,Release_Year,Producer_Id,Id")] Movy movy)
{
if (ModelState.IsValid)
{
db.Movies.Add(movy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Producer_Id = new SelectList(db.Producers, "Id", "Name", movy.Producer_Id);
return(View(movy));
}
public ActionResult Create([Bind(Include = "Id,Actor_Id,Movie_Id")] Movie_Actors movie_Actors)
{
if (ModelState.IsValid)
{
db.Movie_Actors.Add(movie_Actors);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Actor_Id = new SelectList(db.Actors, "Id", "Name", movie_Actors.Actor_Id);
ViewBag.Movie_Id = new SelectList(db.Movies, "Id", "Name", movie_Actors.Movie_Id);
return(View(movie_Actors));
}
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);
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
// Lay thong tin tren man hinh giao dien
string username = txbUsername.Text;
string password = txbPassword.Text;
// Kiem tra user co ton tai trong database hay khong
bool hasUser = db.users.Any(x => x.user_name == username && x.user_password == password);
if (hasUser == true)
{
MessageBox.Show("Tài khoản đã tồn tại, đăng ký thất bại");
}
else
{
string type = cbbUserType.selectedValue;
user newUser = new user();
newUser.user_name = username;
newUser.user_password = password;
newUser.user_type = type;
try
{
db.users.Add(newUser);
db.SaveChanges();
MessageBox.Show("Đăng ký thành công");
}
catch (Exception)
{
MessageBox.Show("Đăng ký thất bại");
}
}
}
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();
}
}
/// <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 bool CreateMovie(DataAccess.Movie movie) //新增電影
{
MovieEntities dbMovie = new MovieEntities();
dbMovie.Movie.Add(movie);
dbMovie.SaveChanges();
return(true);
}
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();
}
}
/// <summary>
/// 保存订单明细
/// </summary>
/// <param name="model"></param>
/// <param name="orderID"></param>
private void SaveOrderDetails(OrderModel model, int orderID)
{
List <OrderDetails> list = new List <OrderDetails>();
for (int i = 0; i < model.SeatList.Count; i++)
{
list.Add(new OrderDetails
{
Day = DateTime.Now,
OrderID = orderID,
TimeID = model.TimeID,
Col = model.SeatList[i].Col,
Row = model.SeatList[i].Row
});
}
//保存提交信息
dc.OrderDetails.Add(list.FirstOrDefault());
dc.SaveChanges();
}
private static void AddSampleRoleData()
{
Role role = new Role();
role.Description = "Director";
MovieEntities db = new MovieEntities();
db.Roles.Add(role);
db.SaveChanges();
}
public void deleteMovie(int?movieId)
{
using (MovieEntities db = new MovieEntities())
{
// delete from MoviesGenre
var genre = (from m in db.MoviesGenres where m.Movies_ID == movieId select m).ToList();
if (genre.Count() > 0)
{
foreach (var item in genre)
{
db.MoviesGenres.Remove(item);
db.SaveChanges();
}
}
// delete from ActorMovies
var actor = (from m in db.ActorMovies where m.Movies_ID == movieId select m).ToList();
if (actor.Count() > 0)
{
foreach (var item in actor)
{
db.ActorMovies.Remove(item);
db.SaveChanges();
}
}
// delete from Movies
var result = (from m in db.Movies where m.Movies_ID == movieId select m).ToList();
if (result.Count() > 0)
{
foreach (var item in result)
{
db.Movies.Remove(item);
db.SaveChanges();
}
}
}
}
public IHttpActionResult Register([FromBody] Users u)
{
if (u != null)
{
var list = dc.Users.Where(c => c.UserName == u.UserName);
if (list.Count() > 0)
{
return(StatusCode(HttpStatusCode.Conflict));
}
else
{
dc.Users.Add(u);
dc.SaveChanges();
return(Ok());
}
}
else
{
return(BadRequest());
}
}
public bool UpdateMovie(DataAccess.Movie movie) //更新電影
{
MovieEntities dbMovie = new MovieEntities();
DataAccess.Movie queryMovie = dbMovie.Movie.FirstOrDefault(x => x.ID == movie.ID);
if (queryMovie != null)
{
dbMovie.Entry(queryMovie).CurrentValues.SetValues(movie);
dbMovie.SaveChanges();
return(true);
}
return(false);
}
public bool DeleteMovie(int movieID) //刪除電影
{
MovieEntities dbMovie = new MovieEntities();
DataAccess.Movie queryMovie = dbMovie.Movie.FirstOrDefault(x => x.ID == movieID);
if (queryMovie != null)
{
dbMovie.Movie.Remove(queryMovie);
dbMovie.SaveChanges();
return(true);
}
return(false);
}
public string rentMovies(RentMoviesRequestJSON res)
{
string status = "";
try
{
using (MovieEntities db = new MovieEntities())
{
foreach (var item in res.moviesIds)
{
UsersRental ur = new UsersRental();
ur.Users_ID = res.userId;
ur.Movies_ID = item;
DateTime datefrom = convertToDate(res.RentalDateFrom);
DateTime dateto = convertToDate(res.RentalDateTo);
if (datefrom == DateTime.Now)
{
ur.RentalDateFrom = null;
}
else
{
ur.RentalDateFrom = datefrom;
}
if (dateto == DateTime.Now)
{
ur.RentalDateTo = null;
}
else
{
ur.RentalDateTo = dateto;
}
ur.UsersTransaction_ID = null;
ur.CreatedDate = DateTime.UtcNow;
db.UsersRentals.Add(ur);
db.SaveChanges();
}
/* if authorizePayment is set to true user credit card details can obtained from Users table.
* if true, we can get these details from Users table and charge accordingly using Stripe or Authorize.net library
*/
status = "Rented successfully";
}
}
catch
{
status = "ERR: There seems to be issue with rental. Please try again.";
}
return(status);
}
private void AddGenres()
{
if (txbGenresTitle.Text == "")
{
MessageBox.Show("Thông tin chưa đủ");
}
try
{
genre genre = new genre();
genre.gen_title = txbGenresTitle.Text;
db.genres.Add(genre);
db.SaveChanges();
MessageBox.Show("Thêm genres thành công");
ReloadDataGird();
}
catch (Exception)
{
MessageBox.Show("Thêm genres thất bại");
}
}
public static Record save(int userId, int movieId, string content)
{
Record record = new Record
{
user_id = userId,
movie_id = movieId,
time = DateTime.Now,
content = content
};
MovieEntities movieEntities = new MovieEntities();
movieEntities.Record.Add(record);
movieEntities.SaveChanges();
return(record);
}
public static Dictionary <string, object> reply(int commentId, int atId, string content, int replyId)
{
MovieEntities movieEntities = new MovieEntities();
int userId = SessionService.getSession();
Feedback feedback = new Feedback();
feedback.comment_id = commentId;
feedback.user_id = userId;
feedback.at_id = atId;
feedback.reply_id = replyId;
feedback.content = content;
feedback.time = DateTime.Now;
movieEntities.Feedback.Add(feedback);
movieEntities.SaveChanges();
return(ClassToDictionary.classToDictionary(feedback));
}
public static void Edit(int id, string title, DateTime releaseDate, decimal price, List <int> genres)
{
using (MovieEntities context = new MovieEntities())
{
var movie = context.Movies.Where(x => x.ID == id).First();
movie.Title = title;
movie.ReleaseDate = releaseDate;
movie.Genres.Clear();
foreach (var genreID in genres)
{
var genre = context.Genres.Find(genreID);
movie.Genres.Add(genre);
}
context.SaveChanges();
}
}
