public ActionResult Index3_1() { YGOCardInfoEntities db = new YGOCardInfoEntities(); var packlistviewmodel = new forindex3_1(); var groupnamelist = db.refpackgroup.ToList(); packlistviewmodel.GroupNames = new List <GroupNameList>(); foreach (var item in groupnamelist) { packlistviewmodel.GroupNames.Add(new GroupNameList() { Groupname = item.groupname }); } packlistviewmodel.Per = new List <MainPageList>(); // for (int i = 1; i <= groupnamelist.Count(); i++) //{ var codelist = db.refCardList.ToList(); foreach (var item in codelist) { packlistviewmodel.Per.Add(new MainPageList() { ID = item.ID, Code = item.code, Packgroup = item.packgroup }); } //} return(View(packlistviewmodel)); }
// GET: YGOPack public ActionResult Index(short?cardnumberID) { YGOCardInfoEntities db = new YGOCardInfoEntities(); List <YGOPackViewModel> YGOPack = new List <YGOPackViewModel>(); var YGOPackList = db.refCardList.Where(rc => rc.ID == cardnumberID) .Join(db.YGOMonsters, rc => rc.ID, ym => ym.CardNumberID, (rc, ym) => new { rc.packname, rc.piece, ym.CardName, ym.CardPassword, ym.CardExtra, ym.CardNumber, ym.cardenable }) .Where(ym => ym.cardenable == true) .ToList(); foreach (var item in YGOPackList) { YGOPackViewModel objvm = new YGOPackViewModel(); objvm.packname = item.packname; objvm.piece = item.piece; objvm.CardPassword = item.CardPassword; objvm.CardExtra = item.CardExtra; objvm.CardNumber = item.CardNumber; objvm.CardName = item.CardName; YGOPack.Add(objvm); } return(View(YGOPack)); }
public ActionResult Index3_2_3() { YGOCardInfoEntities db = new YGOCardInfoEntities(); var packlist = db.refCardList.Include(rc => rc.refpackgroup) .GroupBy(rc => new { rc.refpackgroup.groupname, rc.packgroup }) .Select(g => new forindex3_2_3 { Groupnames = g.Key.groupname, GroupID = g.Key.packgroup, }) .OrderBy(rc => rc.GroupID) .ToList(); return(View(packlist)); }
public ActionResult Index3_2() { YGOCardInfoEntities db = new YGOCardInfoEntities(); // var packlistviewmodel = new forindex3_2(); var packlist = db.refCardList.Include(rc => rc.refpackgroup) .GroupBy(rc => rc.refpackgroup.groupname, rc => rc.code, (key, group) => new forindex3_2 { Groupnames = key, Per = group.ToList() }).ToList(); //IEnumerable<IGrouping<short?, string>> model = db.refCardList.GroupBy(rc => rc.packgroup,rc => rc.code); return(View(packlist)); }
// GET: MianPage public ActionResult Index() { YGOCardInfoEntities db = new YGOCardInfoEntities(); var packlistviewmodel = new MainPageViewModel(); var groupnamelist = db.refpackgroup.ToList(); packlistviewmodel.MainPageAlls = new List <MainPageAllList>(); var objmainpacklist = new List <MainPageList>(); foreach (var item in groupnamelist) { packlistviewmodel.MainPageAlls.Add(new MainPageAllList() { GroupNames = item.groupname }); } return(View(packlistviewmodel)); }
public ActionResult Index2() { YGOCardInfoEntities db = new YGOCardInfoEntities(); //var packlistviewmodel = new MainPageViewModel(); var packlistviewmodel = new MainPageAllList2(); var groupnamelist = db.refpackgroup.ToList(); //packlistviewmodel.MainPageAlls = new List<MainPageAllList>(); packlistviewmodel.GroupNames = new List <GroupNameList>(); foreach (var item in groupnamelist) { packlistviewmodel.GroupNames.Add(new GroupNameList() { Groupname = item.groupname }); } var codellist = db.refCardList.ToList(); packlistviewmodel.MainPages = new List <MainPageList>(); foreach (var item in codellist) { packlistviewmodel.MainPages.Add(new MainPageList() { ID = item.ID, Code = item.code, Packgroup = item.packgroup }); } /* * foreach(var item in groupnamelist) * { * packlistviewmodel.MainPageAlls.Add(new MainPageAllList() * { * GroupNames = item.groupname * }) ; * for (int i = 1; i <= groupnamelist.Count(); i++) * { * var packcode = db.refCardList.Where(rc => rc.packgroup == i).ToList(); * var packcodelist = new List<MainPageList>(); * foreach (var item2 in packcode) { * packcodelist.Add(new MainPageList() { * ID =item2.ID, * Code = item2.code, * Packgroup =item2.packgroup * * }); * } * * * packlistviewmodel.MainPageAlls.Add(new MainPageAllList() * { * MainPages=packcodelist * }); * * * } * * } */ return(View(packlistviewmodel)); }
// GET: YGOPack2 public ActionResult Index(short?cardnumberID) { YGOCardInfoEntities db = new YGOCardInfoEntities(); YGOPack2ViewModel ygocardlist = new YGOPack2ViewModel(); var packlist = db.refCardList.Where(rc => rc.ID == cardnumberID).ToList(); foreach (var item in packlist) { ygocardlist.YGOPackLists = new YGOPackListViewModel() { code = item.code, packname = item.packname, piece = item.piece }; } //Monster Card var monsterlist = db.YGOMonsters.Where(y => y.CardNumberID == cardnumberID && y.cardenable == true) .ToList(); ygocardlist.YGOMonsterLists = new List <YGOMonsterListViewModel>(); foreach (var item in monsterlist) { ygocardlist.YGOMonsterLists.Add(new YGOMonsterListViewModel() { CardName = item.CardName, CardNumber = item.CardNumber, CardPassword = item.CardPassword, CardExtra = item.CardExtra }); } //Spell Card var spelllist = db.YGOSpells.Where(y => y.CardNumberID == cardnumberID && y.cardenable == true) .ToList(); ygocardlist.YGOSpellLists = new List <YGOSpellListViewModel>(); foreach (var item in spelllist) { ygocardlist.YGOSpellLists.Add(new YGOSpellListViewModel() { CardName = item.CardName, CardNumber = item.CardNumber, CardPassword = item.CardPassword, }); } //Trap Card var traplist = db.YGOTraps.Where(y => y.CardNumberID == cardnumberID && y.cardenable == true) .ToList(); ygocardlist.YGOTrapLists = new List <YGOTrapListViewModel>(); foreach (var item in traplist) { ygocardlist.YGOTrapLists.Add(new YGOTrapListViewModel() { CardName = item.CardName, CardNumber = item.CardNumber, CardPassword = item.CardPassword, }); } return(View(ygocardlist)); }