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