public ActionResult DetailsComingSoon(int id)
        {
            AccountService service  = new AccountService(db, null);
            int            MemberID = 0;

            if (Request.IsAuthenticated)
            {
                MemberID = service.findMember(User.Identity.Name).MemberID;
            }

            ProductInGame pigs = db.ProductInGames.Where(x => x.GameID == id).First();

            if (pigs.Game.GameState.ToLower() == "completed")
            {
                return(Redirect("/"));
            }
            ProductDisplayViewModel pdvm = new ProductDisplayViewModel(MemberID, pigs.GameID);

            pdvm.Product = pigs.Product;
            pdvm.images  = pigs.Product.Imagedetails.Where(w => w.ImageTypeID == 3);


            //TODO: DS: What are therules for which p.i.g. to select/display here
            GameDao gd = new GameDao(db);
            List <GameListViewModel> otherGames = gd.getOtherGames(MemberID, pigs.Game.MemberSubscriptionType);

            otherGames.RemoveAll(g => g.gameID == id);
            pdvm.CurrentProductInGame = pigs;
            pdvm.otherGames           = otherGames;

            return(View(pdvm));
        }