public void Rate(short rating, int game_id) { Models.GameShopContext gameShopContext = new Models.GameShopContext(); if (Session["user"] != null) { var rate = new Models.Rating(); string username = Session["user"].ToString(); rate.game_id = game_id; rate.user_id = gameShopContext.Users.Single(x => x.username == username).id; rate.rating1 = rating; gameShopContext.Ratings.Add(rate); gameShopContext.SaveChanges(); } }
public void Comment(string comment, int game_id) { Models.GameShopContext gameShopContext = new Models.GameShopContext(); if (Session["user"] != null) { var comm = new Models.Comment(); comm.game_id = game_id; string username = Session["user"].ToString(); comm.user_id = gameShopContext.Users.Single(x => x.username == username).id; comm.comment1 = comment; gameShopContext.Comments.Add(comm); gameShopContext.SaveChanges(); } }
public ActionResult Register(string username, string password, string email) { Models.GameShopContext gameShopContext = new Models.GameShopContext(); Models.User user = new Models.User(); user.balance = 0; user.email = email; user.username = username; user.password = Hasher.CreateMD5(password); try { gameShopContext.Users.Add(user); gameShopContext.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View("Error")); } }
public ActionResult Buy(int name) { Models.GameShopContext gameShopContext = new Models.GameShopContext(); Models.Transaction trans = new Models.Transaction(); Models.User userr = new Models.User(); if (Session["user"] != null) { string user = Session["user"].ToString(); if (gameShopContext.Discounts.Any(x => x.game_id == name)) { if (gameShopContext.Users.Single(x => x.username == user).balance > (gameShopContext.Games.Single(x => x.id == name).price - gameShopContext.Discounts.Single(x => x.game_id == name).percentage_discount / 100 * gameShopContext.Games.Single(x => x.id == name).price)) { userr = gameShopContext.Users.Single(x => x.username == user); userr.balance = userr.balance - ((gameShopContext.Games.Single(x => x.id == name).price - gameShopContext.Discounts.Single(x => x.game_id == name).percentage_discount / 100 * gameShopContext.Games.Single(x => x.id == name).price)); gameShopContext.Users.Attach(userr); gameShopContext.SaveChanges(); trans.date = DateTime.Now; trans.game_id = name; trans.price = ((gameShopContext.Games.Single(x => x.id == name).price - gameShopContext.Discounts.Single(x => x.game_id == name).percentage_discount / 100 * gameShopContext.Games.Single(x => x.id == name).price)); trans.user_id = gameShopContext.Users.Single(x => x.username == user).id; gameShopContext.Transactions.Add(trans); gameShopContext.SaveChanges(); return(RedirectToAction("Shop", "Home")); } else { return(View("Error")); } } else if (gameShopContext.Users.Single(x => x.username == user).balance > gameShopContext.Games.Single(x => x.id == name).price) { userr = gameShopContext.Users.Single(x => x.username == user); userr.balance = userr.balance - gameShopContext.Games.Single(x => x.id == name).price; gameShopContext.Users.Attach(userr); gameShopContext.SaveChanges(); trans.date = DateTime.Now; trans.game_id = name; trans.price = gameShopContext.Games.Single(x => x.id == name).price; trans.user_id = gameShopContext.Users.Single(x => x.username == user).id; gameShopContext.Transactions.Add(trans); gameShopContext.SaveChanges(); return(RedirectToAction("Shop", "Home")); } else { return(View("Error")); } } else { return(Redirect(@"/Home/Login/?url=/Order/?name=" + name)); } }