private List <MyVaultItemViewModel> FindTopSectionList(int LoggedInMemberID)
{
List <MyVaultItemViewModel> topSectionList = new List <MyVaultItemViewModel>();
//2. Get Top Section
IQueryable <ProductInWatchList> GameInWatchlistList = db.ProductInWatchLists.Include(x => x.Game).Where(x => x.MemberID == LoggedInMemberID && x.IsExpired != true && ((x.Game.GameState.ToLower() == "prepare" || x.Game.GameState.ToLower() == "active" || x.Game.GameState.ToLower() == "released")));
foreach (ProductInWatchList game in GameInWatchlistList)
{
MyVaultItemViewModel myVaultItem = new MyVaultItemViewModel(LoggedInMemberID, game.GameID, game.Game.ProductInGames.First().ProductID);
topSectionList.Add(myVaultItem);
}
return(topSectionList);
}
public ActionResult MyVaultItems()
{
AccountService service = new AccountService(db, null);
////Security to only allow logged in user to see his own watchlist
//var LoggedInMember = MemberHelper.GetLoggedInMember(User.Identity.Name);
////Only return watchlist for logged in user
//var productInWatchLists = db.ProductInWatchLists.Include(p => p.Member).Include(p => p.Product).Where(x => x.MemberID == LoggedInMember.MemberID && (x.IsExpired == null || x.IsExpired == false));
//List<ProductViewModel> pvmList = new List<ProductViewModel>();
//foreach (var piw in productInWatchLists)
//{
// ProductViewModel pvm = new ProductViewModel(MemberHelper.GetLoggedInMember(User.Identity.Name).MemberID);
// pvm.Product = piw.Product;
// pvmList.Add(pvm);
//}
List <MyVaultItemViewModel> myVaultItems = new List <MyVaultItemViewModel>();
if (Request.IsAuthenticated)
{
int LoggedInMemberID = service.findMember(User.Identity.Name).MemberID;
//2. Get Top Section
IQueryable <ProductInWatchList> GameInWatchlistList = db.ProductInWatchLists.Include(x => x.Game).Where(x => x.MemberID == LoggedInMemberID && x.IsExpired != true && ((x.Game.GameState.ToLower() == "prepare" || x.Game.GameState.ToLower() == "active" || x.Game.GameState.ToLower() == "released")));
foreach (ProductInWatchList game in GameInWatchlistList)
{
MyVaultItemViewModel myVaultItem = new MyVaultItemViewModel(LoggedInMemberID, game.GameID, game.Game.ProductInGames.First().ProductID);
myVaultItems.Add(myVaultItem);
}
/* var productInExtendedWatchLists = db.ExtendedProductInWatchLists.Where(x => x.MemberID == LoggedInMemberID && (x.IsExpired == null || x.IsExpired == false) && (x.GameState.ToLower() == "prepare" || x.GameState.ToLower() == "active" || x.GameState.ToLower() == "released")).OrderBy(x => x.ExcecuteTime);
* foreach (ExtendedProductInWatchList piewl in productInExtendedWatchLists)
* {
* MyVaultItemViewModel myVaultItem = new MyVaultItemViewModel(LoggedInMemberID, piewl.GameID, piewl.ProductID);
* myVaultItems.Add(myVaultItem);
* }*/
}
return(View(myVaultItems.OrderBy(x => x.GameScheduleStart)));
}
