protected void GetGameData()
{
// populate the form with existing data from db
int GameID = Convert.ToInt32(Request.QueryString["GameID"]);
// connect to the EF DB
using (CricketInfo db = new CricketInfo())
{
// populate a student object instance with the GameID from the URL parameter
CricketInfoMain updatedGame = (from game in db.CricketInfoMains
where game.GameID == GameID
select game).FirstOrDefault();
//map the game properties to teh form control
if (updatedGame != null)
{
Team1Name.Text = updatedGame.Team_1_Name;
Team1Out.Text = updatedGame.Team_1_Outs.ToString();
Team1Runs.Text = updatedGame.Team_1_Runs.ToString();
Team2Name.Text = updatedGame.Team_2_Name;
Team2Out.Text = updatedGame.Team_2_Outs.ToString();
Team2Runs.Text = updatedGame.Team_2_Runs.ToString();
Spectators.Text = updatedGame.Spectators.ToString();
AddGameButton.Text = "Update Game";
}
}
}
protected void GamesGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//store which row was clicked
int selectedRow = e.RowIndex;
// get the selected GameId using the Grid's DataKey COllection
int GameID = Convert.ToInt32(GamesGridView.DataKeys[selectedRow].Values["GameID"]);
// use EF and LINQ to find the selected game in the DB and remove it
using (CricketInfo db = new CricketInfo())
{
var current = db.CricketInfoMains.Count();
//create object to the game class and store the query inside of it
CricketInfoMain deletedgame = (from gameRecords in db.CricketInfoMains
where gameRecords.GameID == GameID
select gameRecords).FirstOrDefault();
// remove the selected game from teh db
db.CricketInfoMains.Remove(deletedgame);
//save my changes back to the db
db.SaveChanges();
db.Database.ExecuteSqlCommand("DBCC CHECKIDENT (CricketInfoMain, RESEED, " + (current - 1) + ")");
// refresh the grid
this.GetGames();
}
}
protected void BackUp_ServerClick(object sender, EventArgs e)
{
using (CricketInfo db = new CricketInfo())
{
string tablename = "CricketInfoBackUp" + DateTime.Today.Year.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString() + DateTime.Today.DayOfWeek.ToString();
db.Database.ExecuteSqlCommand("SELECT * INTO " + tablename + " FROM CricketInfoMain");
}
}
protected void AddGameButton_Click(object sender, EventArgs e)
{
// connect to the EF DB
using (CricketInfo db = new CricketInfo())
{
// use the cricket model to create a new student object and save a new record
CricketInfoMain newGame = new CricketInfoMain();
int GameID = 0;
if (Request.QueryString.Count > 0)// our URL has a GameId in it
{
//get the id from teh URL
GameID = Convert.ToInt32(Request.QueryString["GameID"]);
// get the current game from EF db
newGame = (from game in db.CricketInfoMains
where game.GameID == GameID
select game).FirstOrDefault();
}
// add form data to the new stuent record
newGame.Team_1_Name = Team1Name.Text;
newGame.Team_1_Outs = Convert.ToInt32(Team1Out.Text);
newGame.Team_1_Runs = Convert.ToInt32(Team1Runs.Text);
newGame.Team_2_Name = Team2Name.Text;
newGame.Team_2_Outs = Convert.ToInt32(Team2Out.Text);
newGame.Team_2_Runs = Convert.ToInt32(Team2Runs.Text);
newGame.Spectators = Convert.ToInt32(Spectators.Text);
newGame.DateEntered = DateTime.Now;
// use LINQ to ADO.NET to add / insert new game into the db
if (GameID == 0)
{
db.CricketInfoMains.Add(newGame);
}
// save our changes - also updates and inserts
db.SaveChanges();
//Redirect back to the GameList
Response.Redirect("~/Admin/AdminPage");
}
}
/// <summary>
/// This method gets the game data from the DB
/// </summary>
private void GetGames()
{
// connect to EF DB
using (CricketInfo db = new CricketInfo())
{
string SortString = Session["SortColumn"].ToString() + " " +
Session["SortDirection"].ToString();
// query the CricketInfo Table using EF and LINQ
var Games = (from allGames in db.CricketInfoMains
select allGames);
// bind the result to the Students GridView
GamesGridView.DataSource = Games.AsQueryable().OrderBy(SortString).ToList();
GamesGridView.DataBind();
}
}
/// <summary
/// This method gets the game data from the DB
/// </summary
private void GetGameData()
{
// connect to EF DB
using (CricketInfo db = new CricketInfo())
{
CleanFields();
for (int Slot = 1; Slot <= 4; Slot++)
{
//run a loop to enter the data in each lable on the page
var Gameinfo = (from game in db.CricketInfoMains
where game.GameID == _rowid
select game);
if (_rowid <= db.CricketInfoMains.Count())
{
//put the information onto the main page
switch (Slot)
{
case 1:
// fill out game 1
Game1Team1Name.InnerText = Gameinfo.FirstOrDefault().Team_1_Name.ToString();
Game1Team1Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_1_Name.ToString() + ".jpg");
Game1Team1Outs.InnerText = Gameinfo.FirstOrDefault().Team_1_Outs.ToString();
Game1Team1Runs.InnerText = Gameinfo.FirstOrDefault().Team_1_Runs.ToString() + " runs/ ";
Game1Team2Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_2_Name.ToString() + ".jpg");
Game1Team2Name.InnerText = Gameinfo.FirstOrDefault().Team_2_Name.ToString();
Game1Team2Outs.InnerText = Gameinfo.FirstOrDefault().Team_2_Outs.ToString();
Game1Team2Runs.InnerText = Gameinfo.FirstOrDefault().Team_2_Runs.ToString() + " runs/ ";
Game1Spectators.InnerText = "Specators: " + Gameinfo.FirstOrDefault().Spectators.ToString();
if (Gameinfo.FirstOrDefault().Team_1_Runs > Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game1Winner.InnerText = Gameinfo.FirstOrDefault().Team_1_Name;
}
else if (Gameinfo.FirstOrDefault().Team_1_Runs < Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game1Winner.InnerText = Gameinfo.FirstOrDefault().Team_2_Name;
}
else
{
}
break;
case 2:
// fill out game 2
Game2Team1Name.InnerText = Gameinfo.FirstOrDefault().Team_1_Name.ToString();
Game2Team1Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_1_Name.ToString() + ".jpg");
Game2Team1Outs.InnerText = Gameinfo.FirstOrDefault().Team_1_Outs.ToString();
Game2Team1Runs.InnerText = Gameinfo.FirstOrDefault().Team_1_Runs.ToString() + " runs/ ";
Game2Team2Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_2_Name.ToString() + ".jpg");
Game2Team2Name.InnerText = Gameinfo.FirstOrDefault().Team_2_Name.ToString();
Game2Team2Outs.InnerText = Gameinfo.FirstOrDefault().Team_2_Outs.ToString();
Game2Team2Runs.InnerText = Gameinfo.FirstOrDefault().Team_2_Runs.ToString() + " runs/ ";
Game2Spectators.InnerText = "Specators: " + Gameinfo.FirstOrDefault().Spectators.ToString();
if (Gameinfo.FirstOrDefault().Team_1_Runs > Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game2Winner.InnerText = Gameinfo.FirstOrDefault().Team_1_Name;
}
else if (Gameinfo.FirstOrDefault().Team_1_Runs < Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game2Winner.InnerText = Gameinfo.FirstOrDefault().Team_2_Name;
}
else
{
}
break;
case 3:
// fill out game 3
Game3Team1Name.InnerText = Gameinfo.FirstOrDefault().Team_1_Name.ToString();
Game3Team1Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_1_Name.ToString() + ".jpg");
Game3Team1Outs.InnerText = Gameinfo.FirstOrDefault().Team_1_Outs.ToString();
Game3Team1Runs.InnerText = Gameinfo.FirstOrDefault().Team_1_Runs.ToString() + " runs/ ";
Game3Team2Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_2_Name.ToString() + ".jpg");
Game3Team2Name.InnerText = Gameinfo.FirstOrDefault().Team_2_Name.ToString();
Game3Team2Outs.InnerText = Gameinfo.FirstOrDefault().Team_2_Outs.ToString();
Game3Team2Runs.InnerText = Gameinfo.FirstOrDefault().Team_2_Runs.ToString() + " runs/ ";
Game3Spectators.InnerText = "Specators: " + Gameinfo.FirstOrDefault().Spectators.ToString();
if (Gameinfo.FirstOrDefault().Team_1_Runs > Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game3Winner.InnerText = Gameinfo.FirstOrDefault().Team_1_Name;
}
else if (Gameinfo.FirstOrDefault().Team_1_Runs < Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game3Winner.InnerText = Gameinfo.FirstOrDefault().Team_2_Name;
}
else
{
}
break;
case 4:
//fil out game 4
Game4Team1Name.InnerText = Gameinfo.FirstOrDefault().Team_1_Name.ToString();
Game4Team1Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_1_Name.ToString() + ".jpg");
Game4Team1Outs.InnerText = Gameinfo.FirstOrDefault().Team_1_Outs.ToString();
Game4Team1Runs.InnerText = Gameinfo.FirstOrDefault().Team_1_Runs.ToString() + " runs/ ";
Game4Team2Logo.Src = ResolveUrl("Assets/Images/" + Gameinfo.FirstOrDefault().Team_2_Name.ToString() + ".jpg");
Game4Team2Name.InnerText = Gameinfo.FirstOrDefault().Team_2_Name.ToString();
Game4Team2Outs.InnerText = Gameinfo.FirstOrDefault().Team_2_Outs.ToString();
Game4Team2Runs.InnerText = Gameinfo.FirstOrDefault().Team_2_Runs.ToString() + " runs/ ";
Game4Spectators.InnerText = "Specators: " + Gameinfo.FirstOrDefault().Spectators.ToString();
if (Gameinfo.FirstOrDefault().Team_1_Runs > Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game4Winner.InnerText = Gameinfo.FirstOrDefault().Team_1_Name;
}
else if (Gameinfo.FirstOrDefault().Team_1_Runs < Gameinfo.FirstOrDefault().Team_2_Runs)
{
Game4Winner.InnerText = Gameinfo.FirstOrDefault().Team_2_Name;
}
else
{
}
break;
}
}
else
{
Slot = 4;
}
if (db.CricketInfoMains.Count() > _rowid)
{
NextButton.Disabled = false;
}
else
{
NextButton.Disabled = true;
}
if (_rowid > 4)
{
PreviousButton.Disabled = false;
}
else
{
PreviousButton.Disabled = true;
}
_rowid++;
}
}
Global.RowID = _rowid;
}
