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));
}
