public SqlExecutor(
ISqlParser sqlParser,
TablesMetadata tablesMetadata,
IQueryExecutor queryExecutor,
ISearchExpressionProvider searchExpressionProvider,
IOperationsProvider operationsProvider)
{
_sqlParser = sqlParser;
_tablesMetadata = tablesMetadata;
_queryExecutor = queryExecutor;
_stageConverter = new StageConverter();
_searchExpressionProvider = searchExpressionProvider;
_operationsProvider = operationsProvider;
}
public IActionResult HeadToHead()
{
var dbContext = new SmashggTrackerContext();
int user1 = 549;
int user2 = 544;
var player1 = dbContext.Players.FirstOrDefault(x => x.Id == user1);
var player2 = dbContext.Players.FirstOrDefault(x => x.Id == user2);
var matches = dbContext.Matches
.Where(x => (x.Player1.Id == user1 || x.Player2.Id == user1) &&
(x.Player2.Id == user2 || x.Player1.Id == user2)).Include(x => x.Player1)
.Include(x => x.Player2).Include(x => x.Matches).Include(x => x.Tournament).ToList();
ViewBag.Player1 = player1.Name;
ViewBag.Player2 = player2.Name;
var stageMatchupP1 = new StageMatchup();
var characterStatsP1 = new StageMatchup();
var characterStatsP2 = new StageMatchup();
foreach (var match in matches)
{
foreach (var game in match.Matches)
{
if (match.Player1.Id == user1)
{
if (game.StocksP1 > game.StocksP2)
{
if (!string.IsNullOrEmpty(StageConverter.GetStageById(game.StageId)))
{
stageMatchupP1.AddStageWin(game.StageId);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP1 - 1)))
{
characterStatsP1.AddStageWin(game.CharacterIdP1);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP2 - 1)))
{
characterStatsP2.AddStageLoss(game.CharacterIdP2);
}
}
else
{
if (!string.IsNullOrEmpty(StageConverter.GetStageById(game.StageId)))
{
stageMatchupP1.AddStageLoss(game.StageId);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP1 - 1)))
{
characterStatsP1.AddStageLoss(game.CharacterIdP1);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP2 - 1)))
{
characterStatsP2.AddStageWin(game.CharacterIdP2);
}
}
}
else if (!string.IsNullOrEmpty(StageConverter.GetStageById(game.StageId)))
{
if (game.StocksP1 > game.StocksP2)
{
if (!string.IsNullOrEmpty(StageConverter.GetStageById(game.StageId)))
{
stageMatchupP1.AddStageLoss(game.StageId);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP1 - 1)))
{
characterStatsP1.AddStageLoss(game.CharacterIdP1);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP2 - 1)))
{
characterStatsP2.AddStageWin(game.CharacterIdP2);
}
}
else
{
if (!string.IsNullOrEmpty(StageConverter.GetStageById(game.StageId)))
{
stageMatchupP1.AddStageWin(game.StageId);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP1 - 1)))
{
characterStatsP1.AddStageWin(game.CharacterIdP1);
}
if (!string.IsNullOrEmpty(CharacterConverter.GetChracterById(game.CharacterIdP2 - 1)))
{
characterStatsP2.AddStageLoss(game.CharacterIdP2);
}
}
}
}
}
ViewBag.StagesP1 = stageMatchupP1;
ViewBag.CharacterP1 = characterStatsP1;
ViewBag.CharacterP2 = characterStatsP2;
return(View(matches));
}
