Making the dropdown unique to user

Question

Hi people I have a query which states that each game should be unique to the account holder that works fine, now when i wrote the same query for the reviews I have a problem there is a drop down which selects games of all the user which then a review can be written. The problem am having is the drop down is also showing the games added by other users which i do no want, I want the games added to be unique to the user only that has added them.

here is my review controller:

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using GameTest.Models;

    namespace GameTest.Controllers
    { 
        public class ReviewController : Controller
        {
            private gamezoneDBEntities db = new gamezoneDBEntities();

            //
            // GET: /Review/

            public ViewResult Index()
            {
                var Info = db.tblReviews.Include(x => x.tblGame).Where(UserInfo => UserInfo.UserName.Equals(User.Identity.Name)).ToList();
                return View(Info); 
            }

            //
            // GET: /Review/Details/5

            public ViewResult Details(int id)
            {
                tblReview tblreview = db.tblReviews.Find(id);
                return View(tblreview);
            }

            //
            // GET: /Review/Create

            public ActionResult Create()
            {
                ViewBag.GameIDFK = new SelectList(db.tblGames, "GameID", "GameName");
                return View(new tblReview { UserName = @User.Identity.Name });
            } 

            //
            // POST: /Review/Create

            [HttpPost]
            public ActionResult Create(tblReview tblreview)
            {
                if (ModelState.IsValid)
                {
                    db.tblReviews.Add(tblreview);
                    db.SaveChanges();
                    return RedirectToAction("Index");  
                }

                ViewBag.GameIDFK = new SelectList(db.tblGames, "GameID", "GameName", tblreview.GameIDFK);
                return View(tblreview);
            }

            //
            // GET: /Review/Edit/5

            public ActionResult Edit(int id)
            {
                tblReview tblreview = db.tblReviews.Find(id);
                ViewBag.GameIDFK = new SelectList(db.tblGames, "GameID", "GameName", tblreview.GameIDFK);
                return View(tblreview);
            }

            //
            // POST: /Review/Edit/5

            [HttpPost]
            public ActionResult Edit(tblReview tblreview)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(tblreview).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                ViewBag.GameIDFK = new SelectList(db.tblGames, "GameID", "GameName", tblreview.GameIDFK);
                return View(tblreview);
            }

            //
            // GET: /Review/Delete/5

            public ActionResult Delete(int id)
            {
                tblReview tblreview = db.tblReviews.Find(id);
                return View(tblreview);
            }

            //
            // POST: /Review/Delete/5

            [HttpPost, ActionName("Delete")]
            public ActionResult DeleteConfirmed(int id)
            {            
                tblReview tblreview = db.tblReviews.Find(id);
                db.tblReviews.Remove(tblreview);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            protected override void Dispose(bool disposing)
            {
                db.Dispose();
                base.Dispose(disposing);
            }
        }
    }

The code that i have used to make the games unique and the review unique is this:

var Info = db.tblReviews.Include(x => x.tblGame).Where(UserInfo => UserInfo.UserName.Equals(User.Identity.Name)).ToList();
            return View(Info); 

I have added this code to the index section of thei controller and the following code to the first create section of controller:

ViewBag.GameIDFK = new SelectList(db.tblGames, "GameID", "GameName");
            return View(new tblReview { UserName = @User.Identity.Name });
        } 

If there is any thing else your require please let me know?

Data Model For All Tables:

Review:

    namespace GameTest.Models
{
    using System;
    using System.Collections.Generic;

    public partial class tblReview
    {
        public int ReviewID { get; set; }
        public string Recomendation { get; set; }
        public string AvoidOrBuy { get; set; }
        public string Score { get; set; }
        public int GameIDFK { get; set; }
        public string UserName { get; set; }

        public virtual tblGame tblGame { get; set; }
    }
}

Game:

 namespace GameTest.Models
{
    using System;
    using System.Collections.Generic;

    public partial class tblGame
    {
        public tblGame()
        {
            this.tblReviews = new HashSet<tblReview>();
        }

        public int GameID { get; set; }
        public string GameName { get; set; }
        public string ReleaseYear { get; set; }
        public string Cost { get; set; }
        public string Description { get; set; }
        public string Downloads { get; set; }
        public string Image { get; set; }
        public string ConsoleNameIDFK { get; set; }
        public string UserName { get; set; }

        public virtual tblConsole tblConsole { get; set; }
        public virtual ICollection<tblReview> tblReviews { get; set; }
    }
}

Console:

namespace GameTest.Models
{
    using System;
    using System.Collections.Generic;

    public partial class tblConsole
    {
        public tblConsole()
        {
            this.tblGames = new HashSet<tblGame>();
        }

        public string ConsoleName { get; set; }

        public virtual ICollection<tblGame> tblGames { get; set; }
    }
}

Answer 1

in this line, you need to stick a .Where(...) on tblGames to filter out the games you don't want to appear

ViewBag.GameIDFK = new SelectList(db.tblGames, "GameID", "GameName");
        return View(new tblReview { UserName = @User.Identity.Name });
    }