public void gamesGrid_UpdateItem(int gameID)
{
using (PetanqueContext db = new PetanqueContext())
{
Game item = null;
item = db.Games.Find(gameID);
if (item == null)
{
ModelState.AddModelError("", String.Format("Item with id {0} was not found", gameID));
return;
}
// change foreign keys to correct ids based on name selected during update
item.Winner1Id = (from u in db.Users where u.Name == newWinner1Name select u.UserID).SingleOrDefault();
item.Winner1 = (from u in db.Users where u.UserID == item.Winner1Id select u).SingleOrDefault();
item.Winner2Id = (from u in db.Users where u.Name == newWinner2Name select u.UserID).SingleOrDefault();
item.Winner2 = (from u in db.Users where u.UserID == item.Winner2Id select u).SingleOrDefault();
item.Winner3Id = (from u in db.Users where u.Name == newWinner3Name select u.UserID).SingleOrDefault();
item.Winner3 = (from u in db.Users where u.UserID == item.Winner3Id select u).SingleOrDefault();
item.Loser1Id = (from u in db.Users where u.Name == newLoser1Name select u.UserID).SingleOrDefault();
item.Loser1 = (from u in db.Users where u.UserID == item.Loser1Id select u).SingleOrDefault();
item.Loser2Id = (from u in db.Users where u.Name == newLoser2Name select u.UserID).SingleOrDefault();
item.Loser2 = (from u in db.Users where u.UserID == item.Loser2Id select u).SingleOrDefault();
item.Loser3Id = (from u in db.Users where u.Name == newLoser3Name select u.UserID).SingleOrDefault();
item.Loser3 = (from u in db.Users where u.UserID == item.Loser3Id select u).SingleOrDefault();
TryUpdateModel(item);
if (ModelState.IsValid)
{
db.SaveChanges();
}
}
}
public List <string> GetUserNamesWithoutDeletedOrNoone()
{
using (PetanqueContext db = new PetanqueContext())
{
return(db.Users.Where(u => u.Name != "[Deleted]" && u.Name != "[Noone]").Select(u => u.Name).ToList());
}
}
public List <int> GetUserIds()
{
using (PetanqueContext db = new PetanqueContext())
{
return(db.Users.Select(u => u.UserID).ToList());
}
}
public List <string> GetUserNames()
{
using (PetanqueContext db = new PetanqueContext())
{
return(db.Users.Select(u => u.Name).ToList());
}
}
private List <int> GetUserScores()
{
using (PetanqueContext db = new PetanqueContext())
{
return(db.Users.Select(u => u.TestScore).ToList());
}
}
public IQueryable <Game> gamesGrid_GetData()
{
// don't display grid if no name is selected
if (ddUser.SelectedValue == "[Noone]")
{
return(null);
}
// get the id of the user name in the dropdown
int userID = GetUserIdByName(ddUser.SelectedValue);
// get league and year
LeagueType league = (LeagueType)Enum.Parse(typeof(LeagueType), ddLeague.SelectedItem.Text);
int year = Int32.Parse(ddYear.SelectedItem.Text);
PetanqueContext db = new PetanqueContext();
var query = db.Games.Where(g => (g.Winner1Id == userID ||
g.Winner2Id == userID ||
g.Winner3Id == userID ||
g.Loser1Id == userID ||
g.Loser2Id == userID ||
g.Loser3Id == userID) &&
g.League == league &&
g.Date.Year == year);
return(query);
}
public IQueryable <Game> gamesGrid_GetData()
{
PetanqueContext db = new PetanqueContext();
var query = db.Games;
return(query);
}
public int GetUserIdByName(string name)
{
using (PetanqueContext db = new PetanqueContext())
{
return((from u in db.Users
where u.Name == name
select u.UserID).SingleOrDefault());
}
}
public List <Game> GetGamesByUserReference(int id)
{
using (PetanqueContext db = new PetanqueContext())
{
return((from g in db.Games
where g.Winner1Id == id || g.Winner2Id == id || g.Winner3Id == id || g.Loser1Id == id || g.Loser2Id == id || g.Loser3Id == id
select g).ToList());
}
}
public IQueryable <User> usersGrid_GetData([Control] AgeBracket?ageBracket)
{
PetanqueContext db = new PetanqueContext();
IQueryable <User> query = db.Users.Where(u => (u.Name != "[Deleted]") && (u.Name != "[Noone]"));
if (ageBracket != null)
{
query = query.Where(u => u.AgeRange == ageBracket);
}
return(query);
}
public void addUserForm_InsertItem()
{
var item = new User();
TryUpdateModel(item);
if (ModelState.IsValid)
{
using (PetanqueContext db = new PetanqueContext())
{
db.Users.Add(item);
db.SaveChanges();
}
}
}
public string GetUserNameById(int id)
{
using (PetanqueContext db = new PetanqueContext())
{
string name = (from u in db.Users
where u.UserID == id
select u.Name).SingleOrDefault();
if (name == "[Noone]")
{
name = "";
}
return(name);
}
}
public void usersGrid_DeleteItem(int userId)
{
using (PetanqueContext db = new PetanqueContext())
{
// Change any games that reference this user to reference a dummy user instead
List <Game> refGames = GetGamesByUserReference(userId);
int dummyUserId = GetUserIdByName("[Deleted]");
foreach (Game game in refGames)
{
if (game.Winner1Id == userId)
{
game.Winner1Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Winner2Id == userId)
{
game.Winner2Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Winner3Id == userId)
{
game.Winner3Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Loser1Id == userId)
{
game.Loser1Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Loser2Id == userId)
{
game.Loser2Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Loser3Id == userId)
{
game.Loser3Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
}
db.SaveChanges();
var item = new User {
UserID = userId
};
db.Entry(item).State = EntityState.Deleted;
try { db.SaveChanges(); }
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", userId));
}
}
}
public void gamesGrid_DeleteItem(int gameID)
{
using (PetanqueContext db = new PetanqueContext())
{
var item = new Game {
GameID = gameID
};
db.Entry(item).State = EntityState.Deleted;
try { db.SaveChanges(); }
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", gameID));
}
}
}
private List <int> GetYears()
{
using (PetanqueContext db = new PetanqueContext())
{
List <int> years = new List <int>();
List <Game> games = db.Games.ToList();
foreach (Game game in games)
{
if (!years.Contains(game.Date.Year))
{
years.Add(game.Date.Year);
}
}
return(years);
}
}
public void usersGrid_UpdateItem(int userId)
{
using (PetanqueContext db = new PetanqueContext())
{
User item = null;
item = db.Users.Find(userId);
if (item == null)
{
ModelState.AddModelError("", String.Format("Item with id {0} was not found", userId));
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
db.SaveChanges();
}
}
}
protected void insertButton_Click(object sender, EventArgs e)
{
// return and show error if date isn't valid
DateTime dt;
if (!DateTime.TryParseExact(tbDate.Text, "dd-MMM-yy", null, DateTimeStyles.None, out dt) == true)
{
// not a valid DateTime in short date string format
lValidation.Text = "Please enter a valid date using the calendar";
return;
}
using (PetanqueContext db = new PetanqueContext())
{
var item = new Game();
item.Winner1Id = (from u in db.Users where u.Name == ddWinner1.SelectedItem.Text select u.UserID).SingleOrDefault();
item.Winner1 = (from u in db.Users where u.UserID == item.Winner1Id select u).SingleOrDefault();
item.Winner2Id = (from u in db.Users where u.Name == ddWinner2.SelectedItem.Text select u.UserID).SingleOrDefault();
item.Winner2 = (from u in db.Users where u.UserID == item.Winner2Id select u).SingleOrDefault();
item.Winner3Id = (from u in db.Users where u.Name == ddWinner3.SelectedItem.Text select u.UserID).SingleOrDefault();
item.Winner3 = (from u in db.Users where u.UserID == item.Winner3Id select u).SingleOrDefault();
item.Loser1Id = (from u in db.Users where u.Name == ddLoser1.SelectedItem.Text select u.UserID).SingleOrDefault();
item.Loser1 = (from u in db.Users where u.UserID == item.Loser1Id select u).SingleOrDefault();
item.Loser2Id = (from u in db.Users where u.Name == ddLoser2.SelectedItem.Text select u.UserID).SingleOrDefault();
item.Loser2 = (from u in db.Users where u.UserID == item.Loser2Id select u).SingleOrDefault();
item.Loser3Id = (from u in db.Users where u.Name == ddLoser3.SelectedItem.Text select u.UserID).SingleOrDefault();
item.Loser3 = (from u in db.Users where u.UserID == item.Loser3Id select u).SingleOrDefault();
item.LosingScore = Int32.Parse(ddLosingScore.SelectedItem.Text);
item.Date = Convert.ToDateTime(tbDate.Text);
item.League = (LeagueType)Enum.Parse(typeof(LeagueType), ddLeague.SelectedItem.Text);
db.Games.Add(item);
db.SaveChanges();
}
Response.Redirect("~/Games");
}
private List <User> GetUsersByLeague(LeagueType league, int year)
{
using (PetanqueContext db = new PetanqueContext())
{
// Get list of all games played during the selected league
List <Game> games = db.Games.Where(g => g.League == league).Where(g => g.Date.Year == year).ToList();
if (games.Count == 0)
{
// no games played so hide chart, display error message and return
Chart1.Visible = false;
lError.Text = "No games were played during the selected time period.";
return(null);
}
Chart1.Visible = true;
lError.Text = "";
// Get list of all valid petanque members (users)
List <User> users = db.Users.Where(u => u.Name != "[Deleted]" && u.Name != "[Noone]").ToList();
// Loop through each user and work out their league score. Store this in their Score class property
foreach (User user in users)
{
user.NumGamesWon = 0;
user.NumGamesLost = 0;
// loop through all games in league to total number of wins and losses for the user
foreach (Game game in games)
{
if (game.Winner1 == user || game.Winner2 == user || game.Winner3 == user)
{
user.NumGamesWon++;
}
else if (game.Loser1 == user || game.Loser2 == user || game.Loser3 == user)
{
user.NumGamesLost++;
}
}
// if this is the selected user then store number of games won and lost (before they get reduced down to 8)
if (user.Name == ddUser.SelectedValue)
{
numGamesWonByUser = user.NumGamesWon;
numGamesLostByUser = user.NumGamesLost;
}
// best 8 games of the league are used so adjust total games down to 8, removing losses first
if ((user.NumGamesWon + user.NumGamesLost) > 8)
{
if (user.NumGamesWon >= 8)
{
user.NumGamesWon = 8;
user.NumGamesLost = 0;
}
else
{
user.NumGamesLost = 8 - user.NumGamesWon;
}
}
// Calculate score of all games, awarding 3 points for a win and 1 point for a loss
user.Score = 3 * user.NumGamesWon + user.NumGamesLost;
if (user.Name == ddUser.SelectedValue)
{
userScore = user.Score;
}
}
// finally, remove any non-scoring users from the list since they didn't play any games for this league
users = users.Where(u => u.Score != 0).ToList();
// return the user list with calucated scores for use in the chart
return(users);
}
}
