private string GetTeamString(TeamMatch tm, Player p, TrambambuleDBContextDataContext context)
{
var offence = tm.TeamMatchPlayers.First(x => x.Position == (byte)Common.EPosition.Offence);
var defence = tm.TeamMatchPlayers.First(x => x.Position == (byte)Common.EPosition.Defence);
int offenceRatingChange = 0;
int defenceRatingChange = 0;
if (offence.RatingChange.HasValue)
{
offenceRatingChange = (int)offence.RatingChange.Value;
}
else
{
offenceRatingChange = (int)Math.Round((double)(offence.Rating - PlayerHelper.INITIAL_RATING), 0);
}
if (defence.RatingChange.HasValue)
{
defenceRatingChange = (int)defence.RatingChange.Value;
}
else
{
defenceRatingChange = (int)Math.Round((double)(defence.Rating - PlayerHelper.INITIAL_RATING), 0);
}
return(string.Format("{0} ({2})<br/>{1} ({3})",
GetPlayerNameString(offence.Player, p),
GetPlayerNameString(defence.Player, p),
GetRatingChangeString(offenceRatingChange),
GetRatingChangeString(defenceRatingChange)));
}
private string GetMatchResultLabel(TeamMatch tm)
{
Common.EResult result = (Common.EResult)Enum.Parse(typeof(Common.EResult), tm.Result.ToString());
switch (result)
{
case Common.EResult.Draw:
return("<span style='color: blue;'>R </span>");
case Common.EResult.Loose:
return("<span style='color: red;'>P </span>");
case Common.EResult.Win:
return("<span style='color: green;'>Z </span>");
default:
return(string.Empty);
}
}
private void detach_TeamMatches(TeamMatch entity)
{
this.SendPropertyChanging();
entity.Match = null;
}
private void attach_TeamMatches(TeamMatch entity)
{
this.SendPropertyChanging();
entity.Match = this;
}
partial void DeleteTeamMatch(TeamMatch instance);
partial void UpdateTeamMatch(TeamMatch instance);
partial void InsertTeamMatch(TeamMatch instance);
private string GetMatchResultLabel(TeamMatch tm)
{
Common.EResult result = (Common.EResult)Enum.Parse(typeof(Common.EResult), tm.Result.ToString());
switch (result)
{
case Common.EResult.Draw:
return "<span style='color: blue;'>R </span>";
case Common.EResult.Loose:
return "<span style='color: red;'>P </span>";
case Common.EResult.Win:
return "<span style='color: green;'>Z </span>";
default:
return string.Empty;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
litAchievements.Text = "";
List <Player> players = DataAccess.GetPlayers();
int g1 = int.Parse(tbxScoreA.Text);
int g2 = int.Parse(tbxScoreB.Text);
Common.EResult t1Result = Common.GetResult(g1, g2);
Common.EResult t2Result = Common.GetResult(g2, g1);
Match match = new Match()
{
Id = Guid.NewGuid(), Timestamp = DateTime.Now
};
TeamMatch tm1 = new TeamMatch()
{
Id = Guid.NewGuid(), MatchId = match.Id,
Result = (byte)t1Result, GoalsScored = g1, GoalsLost = g2, Timestamp = DateTime.Now
};
TeamMatch tm2 = new TeamMatch()
{
Id = Guid.NewGuid(), MatchId = match.Id,
Result = (byte)t2Result, GoalsScored = g2, GoalsLost = g1, Timestamp = DateTime.Now
};
Player p1Off = DataAccess.GetPlayer(tbxPlayer1Off.Text);
Player p1Def = DataAccess.GetPlayer(tbxPlayer1Deff.Text);
Player p2Off = DataAccess.GetPlayer(tbxPlayer2Off.Text);
Player p2Def = DataAccess.GetPlayer(tbxPlayer2Deff.Text);
List <Player> playersInThisGame = new List <Player>()
{
p1Off, p1Def, p2Off, p2Def
};
TeamMatchPlayer tmp1Off = new TeamMatchPlayer()
{
PlayerId = p1Off.Id,
Position = (int)Common.EPosition.Offence,
Timestamp = DateTime.Now,
TeamMatchId = tm1.Id
};
TeamMatchPlayer tmp1Def = new TeamMatchPlayer()
{
PlayerId = p1Def.Id,
Position = (int)Common.EPosition.Defence,
Timestamp = DateTime.Now,
TeamMatchId = tm1.Id
};
TeamMatchPlayer tmp2Off = new TeamMatchPlayer()
{
PlayerId = p2Off.Id,
Position = (int)Common.EPosition.Offence,
Timestamp = DateTime.Now,
TeamMatchId = tm2.Id
};
TeamMatchPlayer tmp2Def = new TeamMatchPlayer()
{
PlayerId = p2Def.Id,
Position = (int)Common.EPosition.Defence,
Timestamp = DateTime.Now,
TeamMatchId = tm2.Id
};
double?player1OffPreRating, player1DefPreRating, player2OffPreRating, player2DefPreRating;
double?player1OffPreRankPosition = null;
double?player1DefPreRankPosition = null;
double?player2OffPreRankPosition = null;
double?player2DefPreRankPosition = null;
int? player1OffPostRankPosition, player1DefPostRankPosition, player2OffPostRankPosition, player2DefPostRankPosition;
using (TrambambuleDBContextDataContext context = new TrambambuleDBContextDataContext())
{
var player1Off = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp1Off.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
var player1Def = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp1Def.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
var player2Off = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp2Off.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
var player2Def = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp2Def.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
if (player1Off != null)
{
player1OffPreRating = player1Off.Rating;
player1OffPreRankPosition = context.GetPlayerRankPosition(player1Off.PlayerId);
}
else
{
player1OffPreRating = PlayerHelper.INITIAL_RATING;
player1OffPreRankPosition = null;
}
if (player1Def != null)
{
player1DefPreRating = player1Def.Rating;
player1DefPreRankPosition = context.GetPlayerRankPosition(player1Def.PlayerId);
}
else
{
player1DefPreRating = PlayerHelper.INITIAL_RATING;
player1DefPreRankPosition = null;
}
if (player2Off != null)
{
player2OffPreRating = player2Off.Rating;
player2OffPreRankPosition = context.GetPlayerRankPosition(player2Off.PlayerId);
}
else
{
player2OffPreRating = PlayerHelper.INITIAL_RATING;
player2OffPreRankPosition = null;
}
if (player2Def != null)
{
player2DefPreRating = player2Def.Rating;
player2DefPreRankPosition = context.GetPlayerRankPosition(player2Def.PlayerId);
}
else
{
player2DefPreRating = PlayerHelper.INITIAL_RATING;
player2DefPreRankPosition = null;
}
PlayerHelper.FillPlayersRating(ref tmp1Off, ref tmp1Def, ref tmp2Off, ref tmp2Def,
player1Off,
player1Def,
player2Off,
player2Def,
g1, g2);
context.Matches.InsertOnSubmit(match);
context.TeamMatches.InsertOnSubmit(tm1);
context.TeamMatches.InsertOnSubmit(tm2);
context.TeamMatchPlayers.InsertOnSubmit(tmp1Def);
context.TeamMatchPlayers.InsertOnSubmit(tmp2Def);
context.TeamMatchPlayers.InsertOnSubmit(tmp1Off);
context.TeamMatchPlayers.InsertOnSubmit(tmp2Off);
context.SubmitChanges();
player1OffPostRankPosition = context.GetPlayerRankPosition(tmp1Off.PlayerId);
player1DefPostRankPosition = context.GetPlayerRankPosition(tmp1Def.PlayerId);
player2OffPostRankPosition = context.GetPlayerRankPosition(tmp2Off.PlayerId);
player2DefPostRankPosition = context.GetPlayerRankPosition(tmp2Def.PlayerId);
}
double player1OffRatingChange = Math.Round((double)(tmp1Off.Rating - player1OffPreRating), 0);
double player1DefRatingChange = Math.Round((double)(tmp1Def.Rating - player1DefPreRating), 0);
double player2OffRatingChange = Math.Round((double)(tmp2Off.Rating - player2OffPreRating), 0);
double player2DefRatingChange = Math.Round((double)(tmp2Def.Rating - player2DefPreRating), 0);
int player1OffRankPositionChange = player1OffPreRankPosition.HasValue ? (int)(player1OffPreRankPosition - player1OffPostRankPosition) : -1;
int player1DefRankPositionChange = player1DefPreRankPosition.HasValue ? (int)(player1DefPreRankPosition - player1DefPostRankPosition) : -1;
int player2OffRankPositionChange = player2OffPreRankPosition.HasValue ? (int)(player2OffPreRankPosition - player2OffPostRankPosition) : -1;
int player2DefRankPositionChange = player2DefPreRankPosition.HasValue ? (int)(player2DefPreRankPosition - player2DefPostRankPosition) : -1;
litTbxPlayer1OffStats.Text = string.Format(PostSubmittedStats, player1OffPostRankPosition, GetColouredRankPosition(player1OffRankPositionChange), Math.Round((double)tmp1Off.Rating, 0), GetColouredRating(player1OffRatingChange));
litTbxPlayer1DeffStats.Text = string.Format(PostSubmittedStats, player1DefPostRankPosition, GetColouredRankPosition(player1DefRankPositionChange), Math.Round((double)tmp1Def.Rating, 0), GetColouredRating(player1DefRatingChange));
litTbxPlayer2OffStats.Text = string.Format(PostSubmittedStats, player2OffPostRankPosition, GetColouredRankPosition(player2OffRankPositionChange), Math.Round((double)tmp2Off.Rating, 0), GetColouredRating(player2OffRatingChange));
litTbxPlayer2DeffStats.Text = string.Format(PostSubmittedStats, player2DefPostRankPosition, GetColouredRankPosition(player2DefRankPositionChange), Math.Round((double)tmp2Def.Rating, 0), GetColouredRating(player2DefRatingChange));
pnlInfo.Controls.Add(new LiteralControl("Mecz został zapisany"));
tbxScoreA.Text = tbxScoreB.Text = "";
tbxPlayer1Off.Focus();
CalculateAchievements(playersInThisGame);
Cache.Remove(DataAccess.OverallStatsCacheName);
}
private void detach_TeamMatches(TeamMatch entity)
{
this.SendPropertyChanging();
entity.Match = null;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
litAchievements.Text = "";
List<Player> players = DataAccess.GetPlayers();
int g1 = int.Parse(tbxScoreA.Text);
int g2 = int.Parse(tbxScoreB.Text);
Common.EResult t1Result = Common.GetResult(g1, g2);
Common.EResult t2Result = Common.GetResult(g2, g1);
Match match = new Match() { Id = Guid.NewGuid(), Timestamp = DateTime.Now };
TeamMatch tm1 = new TeamMatch() { Id = Guid.NewGuid(), MatchId = match.Id,
Result = (byte)t1Result, GoalsScored = g1, GoalsLost = g2, Timestamp = DateTime.Now };
TeamMatch tm2 = new TeamMatch() { Id = Guid.NewGuid(), MatchId = match.Id,
Result = (byte)t2Result, GoalsScored = g2, GoalsLost = g1, Timestamp = DateTime.Now };
Player p1Off = DataAccess.GetPlayer(tbxPlayer1Off.Text);
Player p1Def = DataAccess.GetPlayer(tbxPlayer1Deff.Text);
Player p2Off = DataAccess.GetPlayer(tbxPlayer2Off.Text);
Player p2Def = DataAccess.GetPlayer(tbxPlayer2Deff.Text);
List<Player> playersInThisGame = new List<Player>() { p1Off, p1Def, p2Off, p2Def };
TeamMatchPlayer tmp1Off = new TeamMatchPlayer()
{
PlayerId = p1Off.Id,
Position = (int)Common.EPosition.Offence,
Timestamp = DateTime.Now,
TeamMatchId = tm1.Id
};
TeamMatchPlayer tmp1Def = new TeamMatchPlayer()
{
PlayerId = p1Def.Id,
Position = (int)Common.EPosition.Defence,
Timestamp = DateTime.Now,
TeamMatchId = tm1.Id
};
TeamMatchPlayer tmp2Off = new TeamMatchPlayer()
{
PlayerId = p2Off.Id,
Position = (int)Common.EPosition.Offence,
Timestamp = DateTime.Now,
TeamMatchId = tm2.Id
};
TeamMatchPlayer tmp2Def = new TeamMatchPlayer()
{
PlayerId = p2Def.Id,
Position = (int)Common.EPosition.Defence,
Timestamp = DateTime.Now,
TeamMatchId = tm2.Id
};
double? player1OffPreRating, player1DefPreRating, player2OffPreRating, player2DefPreRating;
double? player1OffPreRankPosition = null;
double? player1DefPreRankPosition = null;
double? player2OffPreRankPosition = null;
double? player2DefPreRankPosition = null;
int? player1OffPostRankPosition, player1DefPostRankPosition, player2OffPostRankPosition, player2DefPostRankPosition;
using (TrambambuleDBContextDataContext context = new TrambambuleDBContextDataContext())
{
var player1Off = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp1Off.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
var player1Def = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp1Def.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
var player2Off = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp2Off.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
var player2Def = context.TeamMatchPlayers.Where(p => p.PlayerId == tmp2Def.PlayerId)
.OrderByDescending(p => p.Timestamp).FirstOrDefault();
if (player1Off != null)
{
player1OffPreRating = player1Off.Rating;
player1OffPreRankPosition = context.GetPlayerRankPosition(player1Off.PlayerId);
}
else
{
player1OffPreRating = PlayerHelper.INITIAL_RATING;
player1OffPreRankPosition = null;
}
if (player1Def != null)
{
player1DefPreRating = player1Def.Rating;
player1DefPreRankPosition = context.GetPlayerRankPosition(player1Def.PlayerId);
}
else
{
player1DefPreRating = PlayerHelper.INITIAL_RATING;
player1DefPreRankPosition = null;
}
if (player2Off != null)
{
player2OffPreRating = player2Off.Rating;
player2OffPreRankPosition = context.GetPlayerRankPosition(player2Off.PlayerId);
}
else
{
player2OffPreRating = PlayerHelper.INITIAL_RATING;
player2OffPreRankPosition = null;
}
if (player2Def != null)
{
player2DefPreRating = player2Def.Rating;
player2DefPreRankPosition = context.GetPlayerRankPosition(player2Def.PlayerId);
}
else
{
player2DefPreRating = PlayerHelper.INITIAL_RATING;
player2DefPreRankPosition = null;
}
PlayerHelper.FillPlayersRating(ref tmp1Off, ref tmp1Def, ref tmp2Off, ref tmp2Def,
player1Off,
player1Def,
player2Off,
player2Def,
g1, g2);
context.Matches.InsertOnSubmit(match);
context.TeamMatches.InsertOnSubmit(tm1);
context.TeamMatches.InsertOnSubmit(tm2);
context.TeamMatchPlayers.InsertOnSubmit(tmp1Def);
context.TeamMatchPlayers.InsertOnSubmit(tmp2Def);
context.TeamMatchPlayers.InsertOnSubmit(tmp1Off);
context.TeamMatchPlayers.InsertOnSubmit(tmp2Off);
context.SubmitChanges();
player1OffPostRankPosition = context.GetPlayerRankPosition(tmp1Off.PlayerId);
player1DefPostRankPosition = context.GetPlayerRankPosition(tmp1Def.PlayerId);
player2OffPostRankPosition = context.GetPlayerRankPosition(tmp2Off.PlayerId);
player2DefPostRankPosition = context.GetPlayerRankPosition(tmp2Def.PlayerId);
}
double player1OffRatingChange = Math.Round((double)(tmp1Off.Rating - player1OffPreRating),0);
double player1DefRatingChange = Math.Round((double)(tmp1Def.Rating - player1DefPreRating),0);
double player2OffRatingChange = Math.Round((double)(tmp2Off.Rating - player2OffPreRating),0);
double player2DefRatingChange = Math.Round((double)(tmp2Def.Rating - player2DefPreRating),0);
int player1OffRankPositionChange = player1OffPreRankPosition.HasValue ? (int)(player1OffPreRankPosition - player1OffPostRankPosition) : -1;
int player1DefRankPositionChange = player1DefPreRankPosition.HasValue ? (int)(player1DefPreRankPosition - player1DefPostRankPosition) : -1;
int player2OffRankPositionChange = player2OffPreRankPosition.HasValue ? (int)(player2OffPreRankPosition - player2OffPostRankPosition) : -1;
int player2DefRankPositionChange = player2DefPreRankPosition.HasValue ? (int)(player2DefPreRankPosition - player2DefPostRankPosition) : -1;
litTbxPlayer1OffStats.Text = string.Format(PostSubmittedStats, player1OffPostRankPosition, GetColouredRankPosition(player1OffRankPositionChange), Math.Round((double)tmp1Off.Rating, 0), GetColouredRating(player1OffRatingChange));
litTbxPlayer1DeffStats.Text = string.Format(PostSubmittedStats, player1DefPostRankPosition, GetColouredRankPosition(player1DefRankPositionChange), Math.Round((double)tmp1Def.Rating, 0), GetColouredRating(player1DefRatingChange));
litTbxPlayer2OffStats.Text = string.Format(PostSubmittedStats, player2OffPostRankPosition, GetColouredRankPosition(player2OffRankPositionChange), Math.Round((double)tmp2Off.Rating, 0), GetColouredRating(player2OffRatingChange));
litTbxPlayer2DeffStats.Text = string.Format(PostSubmittedStats, player2DefPostRankPosition, GetColouredRankPosition(player2DefRankPositionChange), Math.Round((double)tmp2Def.Rating, 0), GetColouredRating(player2DefRatingChange));
pnlInfo.Controls.Add(new LiteralControl("Mecz został zapisany"));
tbxScoreA.Text = tbxScoreB.Text = "";
tbxPlayer1Off.Focus();
CalculateAchievements(playersInThisGame);
Cache.Remove(DataAccess.OverallStatsCacheName);
}
private void attach_TeamMatches(TeamMatch entity)
{
this.SendPropertyChanging();
entity.Match = this;
}
partial void DeleteTeamMatch(TeamMatch instance);
partial void UpdateTeamMatch(TeamMatch instance);
partial void InsertTeamMatch(TeamMatch instance);
private string GetTeamString(TeamMatch tm, Player p, TrambambuleDBContextDataContext context)
{
var offence = tm.TeamMatchPlayers.First(x => x.Position == (byte)Common.EPosition.Offence);
var defence = tm.TeamMatchPlayers.First(x => x.Position == (byte)Common.EPosition.Defence);
int offenceRatingChange = 0;
int defenceRatingChange = 0;
if (offence.RatingChange.HasValue)
offenceRatingChange = (int)offence.RatingChange.Value;
else
offenceRatingChange = (int)Math.Round((double)(offence.Rating - PlayerHelper.INITIAL_RATING), 0);
if (defence.RatingChange.HasValue)
defenceRatingChange = (int)defence.RatingChange.Value;
else
defenceRatingChange = (int)Math.Round((double)(defence.Rating - PlayerHelper.INITIAL_RATING), 0);
return string.Format("{0} ({2})<br/>{1} ({3})",
GetPlayerNameString(offence.Player, p),
GetPlayerNameString(defence.Player, p),
GetRatingChangeString(offenceRatingChange),
GetRatingChangeString(defenceRatingChange));
}
