public static void RemoveBoardFromFavorites(int boardID, string userID)
{
var result = from netUser in db.UserBoardgameFavourites where netUser.ASPUsersID == userID && netUser.LocalBoardgameID == boardID select netUser;
UserBoardgameFavourite newFavorite = result.FirstOrDefault();
db.UserBoardgameFavourites.Remove(newFavorite);
db.SaveChanges();
}
public ActionResult DeleteConfirmed(int id)
{
UserBoardgameFavourite userBoardgameFavourite = db.UserBoardgameFavourites.Find(id);
db.UserBoardgameFavourites.Remove(userBoardgameFavourite);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void AddBoardToFavorites(BoardGame board, string userID)
{
var result = from netUser in db.AspNetUsers where netUser.Id == userID select netUser;
AspNetUser user = result.FirstOrDefault();
UserBoardgameFavourite newFavorite = new UserBoardgameFavourite();
newFavorite.BoardGame = board;
newFavorite.AspNetUser = user;
db.UserBoardgameFavourites.Add(newFavorite);
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "UserBoardgameFavouriteID,ASPUsersID,LocalBoardgameID")] UserBoardgameFavourite userBoardgameFavourite)
{
if (ModelState.IsValid)
{
db.Entry(userBoardgameFavourite).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ASPUsersID = new SelectList(db.AspNetUsers, "Id", "Email", userBoardgameFavourite.ASPUsersID);
ViewBag.LocalBoardgameID = new SelectList(db.BoardGames, "LocalBoardgameID", "Thumbnail", userBoardgameFavourite.LocalBoardgameID);
return(View(userBoardgameFavourite));
}
// GET: UserBoardgameFavourites/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserBoardgameFavourite userBoardgameFavourite = db.UserBoardgameFavourites.Find(id);
if (userBoardgameFavourite == null)
{
return(HttpNotFound());
}
return(View(userBoardgameFavourite));
}
// GET: UserBoardgameFavourites/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserBoardgameFavourite userBoardgameFavourite = db.UserBoardgameFavourites.Find(id);
if (userBoardgameFavourite == null)
{
return(HttpNotFound());
}
ViewBag.ASPUsersID = new SelectList(db.AspNetUsers, "Id", "Email", userBoardgameFavourite.ASPUsersID);
ViewBag.LocalBoardgameID = new SelectList(db.BoardGames, "LocalBoardgameID", "Thumbnail", userBoardgameFavourite.LocalBoardgameID);
return(View(userBoardgameFavourite));
}
