protected void Page_Load(object sender, EventArgs e)
{
using (var context = new videogamesmgmtEntities())
{
Session["consoleid"] = context.consoles.OrderByDescending(c => c.Console_ID).FirstOrDefault().Console_ID;
}
setConsolesGrid();
}
public void setConsolesGrid()
{
using (var context = new videogamesmgmtEntities())
{
var cat = (from r in context.consoles select r).ToList();
consolegrid.DataSource = cat;
consolegrid.DataBind();
}
}
public void getCategoriesGrid()
{
gameid = (int)Session["gameid"];
using (var context = new videogamesmgmtEntities())
{
var cat = (from vg in context.videogames join vgc in context.videogamescategories on vg.Game_ID equals vgc.VGCat_Game_ID join cm in context.categoriesmasters on vgc.VGCat_Category_ID equals cm.Category_ID where vg.Game_ID == gameid select new { GameName = vg.Game_Name, GameCat = cm.Category_Name }).ToList();
categoriesgrid.DataSource = cat;
categoriesgrid.DataBind();
}
}
public void getConsolesGrid()
{
gameid = (int)Session["gameid"];
using (var context = new videogamesmgmtEntities())
{
var cat = (from vg in context.videogames join vgc in context.videogamesconsoles on vg.Game_ID equals vgc.VGCon_Game_ID join cm in context.consoles on vgc.VGCon_Console_ID equals cm.Console_ID where vg.Game_ID == gameid select new { ReleaseID = vgc.VGCon_ID, GameName = vg.Game_Name, ConsoleName = cm.Console_Name, ConsoleType = cm.Console_Type }).ToList();
consolesgrid.DataSource = cat;
consolesgrid.DataBind();
}
}
public void getContentsGrid()
{
gameid = (int)Session["gameid"];
VGConID = (int)Session["selectedvgconid"];
using (var context = new videogamesmgmtEntities())
{
var cat = (from vg in context.videogames join vgc in context.videogamesconsoles on vg.Game_ID equals vgc.VGCon_Game_ID join con in context.consoles on vgc.VGCon_Console_ID equals con.Console_ID where vg.Game_ID == gameid join gc in context.gamecontents on vgc.VGCon_ID equals gc.GC_VGCon_ID join cm in context.conditionsmasters on gc.GC_Condition_ID equals cm.Condition_ID join gcom in context.gamecomletenesses on gc.GC_Completeness_ID equals gcom.Completeness_ID select new { Collection_ID = vgc.VGCon_ID, Console_Name = con.Console_Name, Game_Name = vg.Game_Name, GameCompleteness = gcom.Completeness_Description, GameCondition = cm.Condition_Name, PurchaseAmount = gc.GC_AmtPurchased, CurMktValue = gc.GC_CurMarketValue, PurchaseDate = gc.GC_DatePurchased }).Where(r => r.Collection_ID == VGConID).ToList();
contentsgrid.DataSource = cat;
contentsgrid.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
gameid = (int)Session["gameid"];
using (var context = new videogamesmgmtEntities())
{
var addedgame = (from r in context.videogames select r).Where(w => w.Game_ID == gameid).ToList();
selectedGameGrid.DataSource = addedgame;
selectedGameGrid.DataBind();
getCategoriesGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
gameid = (int)Session["gameid"];
using (var context = new videogamesmgmtEntities())
{
Session["vgconid"] = context.videogamesconsoles.OrderByDescending(c => c.VGCon_ID).FirstOrDefault().VGCon_ID;
var addedgame = (from r in context.videogames select r).Where(w => w.Game_ID == gameid).ToList();
selectedGameGrid.DataSource = addedgame;
selectedGameGrid.DataBind();
}
getConsolesGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
gameid = (int)Session["gameid"];
VGConID = (int)Session["selectedvgconid"];
using (var context = new videogamesmgmtEntities())
{
//Session["vgconid"] = context.videogamesconsoles.OrderByDescending(c => c.VGCon_ID).FirstOrDefault().VGCon_ID;
var addedgame = (from vg in context.videogames join vgc in context.videogamesconsoles on vg.Game_ID equals vgc.VGCon_Game_ID join cm in context.consoles on vgc.VGCon_Console_ID equals cm.Console_ID where vg.Game_ID == gameid select new { Collection_ID = vgc.VGCon_ID, Console_Name = cm.Console_Name, Game_Name = vg.Game_Name }).Where(w => w.Collection_ID == VGConID).ToList();
selectedGameGrid.DataSource = addedgame;
selectedGameGrid.DataBind();
}
getContentsGrid();
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var context = new videogamesmgmtEntities())
{
var _videogamescategories = context.Set <videogamescategory>();
_videogamescategories.Add(new videogamescategory {
VGCat_Game_ID = (int)Session["gameid"], VGCat_Category_ID = Convert.ToInt32(ddlCategories.SelectedValue)
});
context.SaveChanges();
//Response.Write("Category Added Successfully");
}
getCategoriesGrid();
}
protected void bthAdd_Click(object sender, EventArgs e)
{
using (var context = new videogamesmgmtEntities())
{
Session["consoleid"] = Convert.ToInt32(Session["consoleid"]) + 1;
var consoles = context.Set <console>();
consoles.Add(new console {
Console_ID = Convert.ToInt32(Session["consoleid"]), Console_Name = txtConsoleName.Text, Console_Type = ddlConsoleType.SelectedValue
});
context.SaveChanges();
}
setConsolesGrid();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var context = new videogamesmgmtEntities())
{
VGConID = (int)Session["selectedvgconid"];
var _gamecontents = context.Set <gamecontent>();
_gamecontents.Add(new gamecontent {
GC_VGCon_ID = VGConID, GC_Completeness_ID = Convert.ToInt32(ddlgamecompleteness.SelectedValue), GC_Condition_ID = Convert.ToInt32(ddlgamecondition.SelectedValue), GC_AmtPurchased = Convert.ToInt32(txtAmtPurchased.Text), GC_CurMarketValue = Convert.ToInt32(txtCurMarketValue.Text), GC_DatePurchased = CalPurchaseDate.SelectedDate
});
context.SaveChanges();
// Response.Write("Successfully added contents for this game!!");
}
getContentsGrid();
}
protected void addButton_Click(object sender, EventArgs e)
{
using (var context = new videogamesmgmtEntities())
{
Session["vgconid"] = Convert.ToInt32(Session["vgconid"]) + 1;
VGConID = (int)Session["vgconid"];
var _videogamesconsoles = context.Set <videogamesconsole>();
_videogamesconsoles.Add(new videogamesconsole {
VGCon_ID = VGConID, VGCon_Game_ID = gameid, VGCon_Console_ID = Convert.ToInt32(ddlconsoles.SelectedValue)
});
context.SaveChanges();
// Response.Write("Successfully added console for this game!!");
}
getConsolesGrid();
}
