private static void AddCommandSealUseToDatabase(ReplayData replayData, frsDb db,
List <gameplayerdetail> dbPlayerDetailList, List <player> dbPlayerList)
{
foreach (player player in dbPlayerList)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new InvalidOperationException("Player Name could not be found from replay data (AddCommandSealUseToDatabase): " + player.PlayerName);
}
gameplayerdetail gpDetail = dbPlayerDetailList.First(x => x.FK_PlayerID == player.PlayerID);
var commandSealGroup = playerInfo.CommandSealList.GroupBy(x => x)
.Select(group => new
{
CommandSealAbilID = group.Key,
UseCount = group.Count()
});
foreach (var commandSeal in commandSealGroup)
{
commandsealuse commandSealUsed = new commandsealuse()
{
FK_GamePlayerDetailID = gpDetail.GamePlayerDetailID,
CommandSealAbilID = commandSeal.CommandSealAbilID,
UseCount = commandSeal.UseCount
};
db.commandsealuses.Add(commandSealUsed);
}
}
}
private static void AddGodsHelpUseToDatabase(ReplayData replayData, frsDb db,
List <gameplayerdetail> dbPlayerDetailList, List <player> dbPlayerList)
{
foreach (player player in dbPlayerList)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new InvalidOperationException("Player Name could not be found from replay data (AddGodsHelpUseToDatabase): " + player.PlayerName);
}
gameplayerdetail gpDetail = dbPlayerDetailList.First(x => x.FK_PlayerID == player.PlayerID);
foreach (var godsHelpAbilId in playerInfo.GodsHelpList)
{
godshelpinfo godsHelpInfo = db.godshelpinfo.First(x => x.GodsHelpAbilID == godsHelpAbilId);
godshelpuse godsHelpUsed = new godshelpuse()
{
FK_GodsHelpInfoID = godsHelpInfo.GodsHelpInfoID,
FK_GamePlayerDetailID = gpDetail.GamePlayerDetailID
};
db.godshelpuse.Add(godsHelpUsed);
}
}
}
private static void AddHeroStatLearnDetailToDatabase(ReplayData replayData, frsDb db,
List <gameplayerdetail> dbPlayerDetailList, List <player> dbPlayerList)
{
foreach (player player in dbPlayerList)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new InvalidOperationException("Player Name could not be found from replay data (AddHeroStatLearnDetailToDatabase): " + player.PlayerName);
}
var statList = playerInfo.StatList.GroupBy(x => x)
.Select(group => new
{
StatAbilID = group.Key,
StatLearnCount = group.Count()
});
gameplayerdetail gpDetail = dbPlayerDetailList.First(x => x.FK_PlayerID == player.PlayerID);
foreach (var stat in statList)
{
herostatinfo statInfo = db.herostatinfo.First(x => x.HeroStatAbilID == stat.StatAbilID);
herostatlearn statLearned = new herostatlearn()
{
FK_HeroStatInfoID = statInfo.HeroStatInfoID,
FK_GamePlayerDetailID = gpDetail.GamePlayerDetailID,
LearnCount = stat.StatLearnCount
};
db.herostatlearn.Add(statLearned);
}
}
}
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);
}
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 static void AddItemPurchaseDetailToDatabase(ReplayData replayData, frsDb db,
List <gameplayerdetail> dbPlayerDetailList, List <player> dbPlayerList)
{
int maxGameItemPurchaseId = 0;
if (db.gameitempurchase.Any())
{
maxGameItemPurchaseId = db.gameitempurchase.Max(x => x.GameItemPurchaseID) + 1;
}
foreach (player player in dbPlayerList)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new InvalidOperationException("Player Name could not be found from replay data (AIPDTD): " + player.PlayerName);
}
var purchasedItemGroup = playerInfo.ItemPurchaseList.GroupBy(x => x)
.Select(group => new
{
ItemTypeID = group.Key,
PurchaseCount = group.Count()
});
gameplayerdetail gpDetail = dbPlayerDetailList.First(x => x.FK_PlayerID == player.PlayerID);
int spentGold = 0;
foreach (var item in purchasedItemGroup)
{
iteminfo itemInfo = db.iteminfo.First(x => x.ItemTypeID == item.ItemTypeID);
gameitempurchase itemPurchaseRow = new gameitempurchase
{
GameItemPurchaseID = maxGameItemPurchaseId,
FK_GamePlayerDetailID = gpDetail.GamePlayerDetailID,
FK_ItemID = itemInfo.ItemID,
ItemPurchaseCount = item.PurchaseCount
};
spentGold += itemInfo.ItemCost * item.PurchaseCount;
db.gameitempurchase.Add(itemPurchaseRow);
maxGameItemPurchaseId++;
}
gpDetail.GoldSpent = spentGold;
}
}
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 static void AddAttributeLearnToDatabase(ReplayData replayData, frsDb db,
List <gameplayerdetail> dbPlayerDetailList, List <player> dbPlayerList)
{
foreach (player player in dbPlayerList)
{
PlayerInfo playerInfo = replayData.GetPlayerInfoByPlayerName(player.PlayerName);
if (playerInfo == null)
{
throw new InvalidOperationException("Player Name could not be found from replay data (AddAttributeLearnToDatabase): " + player.PlayerName);
}
gameplayerdetail gpDetail = dbPlayerDetailList.First(x => x.FK_PlayerID == player.PlayerID);
foreach (var attributeAbilId in playerInfo.AttributeList)
{
attributeinfo attributeInfo = db.attributeinfo.FirstOrDefault(x => x.AttributeAbilID == attributeAbilId);
if (attributeInfo == null)
{
int maxId = 0;
if (db.attributeinfo.Any())
{
maxId = db.attributeinfo.Max(x => x.AttributeInfoID);
}
attributeInfo = new attributeinfo
{
AttributeInfoID = maxId,
AttributeAbilID = attributeAbilId,
AttributeName = ""
};
db.attributeinfo.Add(attributeInfo);
}
attributelearn attributeLearned = new attributelearn()
{
FK_AttributeInfoID = attributeInfo.AttributeInfoID,
FK_GamePlayerDetailID = gpDetail.GamePlayerDetailID
};
db.attributelearn.Add(attributeLearned);
}
}
}
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;
}
}