private game GetNewGame(ReplayData replayData, server dbServer, frsDb db)
{
int gameId = 0;
if (db.game.Any())
{
gameId = db.game.Max(g => g.GameID) + 1; //Generate Max GameID + 1
}
game fateGame = new game
{
GameID = gameId,
GameName = replayData.GameName,
Log = String.Join("\n", replayData.GameChatMessage.ToArray()),
MatchType = replayData.GameMode.ToString(),
MapVersion = ReplayData.MapVersion,
Duration = new TimeSpan(0, 0, 0, 0, (int)replayData.ReplayHeader.ReplayLength),
PlayedDate = replayData.GameDateTime,
ReplayUrl = replayData.ReplayUrl,
FK_ServerID = dbServer.ServerID,
TeamOneWinCount = replayData.TeamOneVictoryCount,
TeamTwoWinCount = replayData.TeamTwoVictoryCount
};
if (replayData.IsForfeitedGame)
{
fateGame.IsForfeitedGame = true;
if (replayData.ForfeitedTeam == ForfeitedTeam.T1)
{
fateGame.Result = GameResult.T2W.ToString();
}
else if (replayData.ForfeitedTeam == ForfeitedTeam.T2)
{
fateGame.Result = GameResult.T1W.ToString();
}
else
{
throw new InvalidDataException("Could not determine forfeiting team");
}
}
else
{
if (replayData.TeamOneVictoryCount > replayData.TeamTwoVictoryCount)
{
fateGame.Result = GameResult.T1W.ToString();
}
else if (replayData.TeamOneVictoryCount < replayData.TeamTwoVictoryCount)
{
fateGame.Result = GameResult.T2W.ToString();
}
else
{
fateGame.Result = GameResult.NONE.ToString();
}
}
return(fateGame);
}
public void InsertReplayData(ReplayData replayData, string serverName)
{
using (var db = frsDb.Create())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
if (!db.server.Any(x => x.ServerName == serverName && x.IsServiced))
{
throw new Exception(
String.Format("DB Error: Either server name doesn't exist or it is not serviced: {0}",
serverName));
}
server dbServer = db.server.FirstOrDefault(x => x.ServerName == serverName);
//Player collection based on server
var dbPlayers = db.Set <player>().Where(x => x.FK_ServerID == dbServer.ServerID);
List <player> fatePlayerList = AddPlayerList(replayData, dbPlayers, dbServer, db);
db.SaveChanges();
game fateGame = GetNewGame(replayData, dbServer, db);
db.game.Add(fateGame);
List <gameplayerdetail> fateGamePlayerDetailList = GetGamePlayerDetailList(replayData,
fatePlayerList,
fateGame, dbServer, db);
db.gameplayerdetail.AddRange(fateGamePlayerDetailList);
AddPlayerStatToDatabase(replayData, fatePlayerList, db, dbServer, fateGame);
AddPlayerHeroStatToDatabase(replayData, fatePlayerList, db, dbServer);
db.SaveChanges(); //Save changes at this point to assign IDs to tables
AddItemPurchaseDetailToDatabase(replayData, db, fateGamePlayerDetailList, fatePlayerList);
AddHeroStatLearnDetailToDatabase(replayData, db, fateGamePlayerDetailList, fatePlayerList);
AddGodsHelpUseToDatabase(replayData, db, fateGamePlayerDetailList, fatePlayerList);
AddAttributeLearnToDatabase(replayData, db, fateGamePlayerDetailList, fatePlayerList);
AddCommandSealUseToDatabase(replayData, db, fateGamePlayerDetailList, fatePlayerList);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
logger.Error(ex.ToString());
throw;
}
}
}
}
private static void AddPlayerHeroStatToDatabase(ReplayData replayData, IEnumerable <player> dbPlayers,
frsDb db, server dbServer)
{
foreach (player player in dbPlayers)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new Exception(String.Format("Player Name not found during PlayerHeroStat module. Input: {0}",
player.PlayerName));
}
herotype playerHeroType = db.herotype.First(x => x.HeroUnitTypeID == playerInfo.ServantId);
playerherostat playerHeroStat =
db.playerherostat.FirstOrDefault(
x =>
x.FK_ServerID == dbServer.ServerID && x.FK_PlayerID == player.PlayerID &&
x.FK_HeroTypeID == playerHeroType.HeroTypeID);
bool isNewHeroStat = false;
if (playerHeroStat == null)
{
playerHeroStat = new playerherostat
{
FK_PlayerID = player.PlayerID,
FK_ServerID = dbServer.ServerID,
FK_HeroTypeID = playerHeroType.HeroTypeID
};
db.playerherostat.Add(playerHeroStat);
isNewHeroStat = true;
}
playerHeroStat.HeroPlayCount++;
playerHeroStat.TotalHeroKills += playerInfo.Kills;
playerHeroStat.TotalHeroDeaths += playerInfo.Deaths;
playerHeroStat.TotalHeroAssists += playerInfo.Assists;
//Upsert
db.playerherostat.Attach(playerHeroStat);
var playerHeroStatEntry = db.Entry(playerHeroStat);
playerHeroStatEntry.State = isNewHeroStat ? EntityState.Added : EntityState.Modified;
}
}
private List <player> AddPlayerList(ReplayData replayData, IQueryable <player> dbPlayers, server dbServer,
frsDb db)
{
List <player> playerList = new List <player>();
int playerId = 0;
foreach (PlayerInfo playerInfo in replayData.PlayerInfoList)
{
//Ignore observer
if (playerInfo.IsObserver)
{
continue;
}
player player = dbPlayers.FirstOrDefault(x => x.PlayerName == playerInfo.PlayerName);
if (player != null)
{
playerList.Add(player);
continue;
}
if (db.player.Any())
{
playerId = db.player.Max(g => g.PlayerID) + 1; //Generate Max GameID + 1
}
player = new player
{
FK_ServerID = dbServer.ServerID,
IsBanned = false,
LastUpdatedBy = "FateRankingSystem",
PlayerName = playerInfo.PlayerName,
RegDate = DateTime.Now,
LastUpdatedOn = DateTime.Now,
PlayerID = playerId
};
playerId++;
playerList.Add(player);
db.player.Add(player);
}
return(playerList);
}
private List <gameplayerdetail> GetGamePlayerDetailList(ReplayData replayData, IEnumerable <player> dbPlayers, game fateGame, server dbServer,
frsDb db)
{
List <gameplayerdetail> fateGamePlayerDetailList = new List <gameplayerdetail>();
foreach (player player in dbPlayers)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new Exception(String.Format("Player Name not found during GamePlayerDetailList module. Input: {0}",
player.PlayerName));
}
gameplayerdetail fateGamePlayerDetail = new gameplayerdetail();
fateGamePlayerDetail.FK_GameID = fateGame.GameID;
fateGamePlayerDetail.FK_PlayerID = player.PlayerID;
fateGamePlayerDetail.FK_ServerID = dbServer.ServerID;
herotype playerHeroType = db.herotype.FirstOrDefault(x => x.HeroUnitTypeID == playerInfo.ServantId);
if (playerHeroType == null)
{
throw new Exception(String.Format("DB Error: Unknown hero type id: {0}", playerInfo.ServantId));
}
fateGamePlayerDetail.FK_HeroTypeID = playerHeroType.HeroTypeID;
fateGamePlayerDetail.Kills = playerInfo.Kills;
fateGamePlayerDetail.Deaths = playerInfo.Deaths;
fateGamePlayerDetail.Assists = playerInfo.Assists;
fateGamePlayerDetail.Team = (playerInfo.Team + 1).ToString();
fateGamePlayerDetail.DamageTaken = playerInfo.DamageTaken;
fateGamePlayerDetail.DamageDealt = playerInfo.DamageDealt;
fateGamePlayerDetail.HeroLevel = playerInfo.ServantLevel;
if (fateGame.Result == GameResult.NONE.ToString())
{
fateGamePlayerDetail.Result = GamePlayerResult.NONE.ToString();
}
else if (fateGame.Result == GameResult.T1W.ToString())
{
fateGamePlayerDetail.Result = playerInfo.Team == 0
? GamePlayerResult.WIN.ToString()
: GamePlayerResult.LOSS.ToString();
}
else if (fateGame.Result == GameResult.T2W.ToString())
{
fateGamePlayerDetail.Result = playerInfo.Team == 1
? GamePlayerResult.WIN.ToString()
: GamePlayerResult.LOSS.ToString();
}
else
{
throw new Exception(String.Format("Unexpected GameResult enumeration. Input: {0}",
fateGame.Result));
}
fateGamePlayerDetailList.Add(fateGamePlayerDetail);
}
return(fateGamePlayerDetailList);
}
private void AddPlayerStatToDatabase(ReplayData replayData, IEnumerable <player> dbPlayers, frsDb db,
server dbServer, game fateGame)
{
foreach (player player in dbPlayers)
{
bool isNewPlayerStat = false;
playerstat playerStat =
db.playerstat.FirstOrDefault(
x => x.FK_ServerID == dbServer.ServerID && x.FK_PlayerID == player.PlayerID);
if (playerStat == null)
{
playerStat = new playerstat();
playerStat.FK_PlayerID = player.PlayerID;
playerStat.FK_ServerID = dbServer.ServerID;
db.playerstat.Add(playerStat);
isNewPlayerStat = true;
}
playerStat.PlayCount++;
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new Exception(String.Format("Player Name not found during PlayerStatList module. Input: {0}",
player.PlayerName));
}
if (fateGame.Result == GameResult.NONE.ToString())
{
continue;
}
if (fateGame.Result == GameResult.T1W.ToString())
{
if (playerInfo.Team == 0)
{
playerStat.Win++;
}
else if (playerInfo.Team == 1)
{
playerStat.Loss++;
}
else
{
throw new Exception(String.Format("Unexpected playerInfo team at PlayerStatListModule. Input: {0}",
playerInfo.Team));
}
}
else if (fateGame.Result == GameResult.T2W.ToString())
{
if (playerInfo.Team == 0)
{
playerStat.Loss++;
}
else if (playerInfo.Team == 1)
{
playerStat.Win++;
}
else
{
throw new Exception(String.Format("Unexpected playerInfo team at PlayerStatListModule. Input: {0}",
playerInfo.Team));
}
}
else
{
throw new Exception(String.Format("Unexpected GameResult enumeration at PlayerStatListModule. Input: {0}",
fateGame.Result));
}
//Upsert
db.playerstat.Attach(playerStat);
var playerStatEntry = db.Entry(playerStat);
playerStatEntry.State = isNewPlayerStat ? EntityState.Added : EntityState.Modified;
}
}
