protected void gvContinue_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex < 0) { return; } using (FinalFantasyDrunkDataContext dc = new FinalFantasyDrunkDataContext()) { string gameID = e.Row.Cells[0].Text; Game game = (from t in dc.Games where t.ID == int.Parse(gameID) select t).FirstOrDefault(); PizzaNight.Session session = game.Sessions.Where(x => !x.DateEnded.HasValue).FirstOrDefault(); if (session == null) { // Create new session and go ahead session = new PizzaNight.Session() { DateStarted = DateTime.Now, GameID = game.ID }; dc.Sessions.InsertOnSubmit(session); dc.SubmitChanges(); SessionPlayer newPlayerRobb = new SessionPlayer() { SessionID = session.ID, PlayerID = 1 }; SessionPlayer newPlayerBrian = new SessionPlayer() { SessionID = session.ID, PlayerID = 2 }; dc.SessionPlayers.InsertOnSubmit(newPlayerRobb); dc.SessionPlayers.InsertOnSubmit(newPlayerBrian); dc.SubmitChanges(); } HyperLink hl = new HyperLink() { NavigateUrl = "Session?id=" + session.ID, Text = "Go", CssClass = "btn btn-default btn-cs" }; e.Row.Cells[0].Controls.Add(hl); } }
protected void EndSession_Click(object sender, EventArgs e) { using (FinalFantasyDrunkDataContext dc = new FinalFantasyDrunkDataContext()) { PizzaNight.Session session = (from t in dc.Sessions where t.ID == SessionID select t).FirstOrDefault(); session.DateEnded = DateTime.Now; dc.SubmitChanges(); } Response.Redirect("StartGame", false); Context.ApplicationInstance.CompleteRequest(); }
protected void AddGame_Click(object sender, EventArgs e) { using (FinalFantasyDrunkDataContext dc = new FinalFantasyDrunkDataContext()) { Game game = new Game() { DateStarted = DateTime.Now, CharacterName = tbCharacterName.Text, LastPlayed = DateTime.Now, GameTypeID = int.Parse(ddGameType.SelectedValue) }; dc.Games.InsertOnSubmit(game); dc.SubmitChanges(); PizzaNight.Session session = new PizzaNight.Session() { GameID = game.ID, DateStarted = DateTime.Now }; dc.Sessions.InsertOnSubmit(session); dc.SubmitChanges(); SessionPlayer newPlayerRobb = new SessionPlayer() { SessionID = session.ID, PlayerID = 1 }; SessionPlayer newPlayerBrian = new SessionPlayer() { SessionID = session.ID, PlayerID = 2 }; dc.SessionPlayers.InsertOnSubmit(newPlayerRobb); dc.SessionPlayers.InsertOnSubmit(newPlayerBrian); dc.SubmitChanges(); Response.Redirect("Session?id=" + session.ID, false); } Context.ApplicationInstance.CompleteRequest(); }
private void AddDrink(object sender, EventArgs e) { LinkButton lb = (LinkButton)sender; using (FinalFantasyDrunkDataContext dc = new FinalFantasyDrunkDataContext()) { SessionDrink drink = new SessionDrink() { DrinkID = int.Parse(lb.CommandArgument), SessionID = SessionID }; dc.SessionDrinks.InsertOnSubmit(drink); dc.SubmitChanges(); } LoadGameInfo(); }
protected void AddRule_Click(object sender, EventArgs e) { using (FinalFantasyDrunkDataContext dc = new FinalFantasyDrunkDataContext()) { Drink drink = new Drink() { DrinkRule = tbRule.Text, Penalty = tbPenalty.Text, DateAdded = DateTime.Now }; dc.Drinks.InsertOnSubmit(drink); dc.SubmitChanges(); } Response.Redirect("/FFD/AddDrinkRule", false); Context.ApplicationInstance.CompleteRequest(); }