public IActionResult Edit(int?matchId, int?homeTeamId, int?oppTeamId, int?playerScoreId)
{
ViewBag.Name = "Edit Match Players";
ViewBag.HowOut = new SelectList(_context.HowOut
.AsNoTracking()
.Select(i => new { i.HowOutId, i.Name })
, "HowOutId", "Name");
var scoreDto = new ScoreCarddto();
//ViewBag.matchId = matchId;
ViewBag.OpponentTeam = _context.Teams
.AsNoTracking()
.Where(i => i.TeamId == oppTeamId)
.Select(i => i.Team_Name)
.Single();
ViewBag.HomeTeam = _context.Teams
.AsNoTracking()
.Where(i => i.TeamId == homeTeamId)
.Select(i => i.Team_Name)
.Single();
ViewBag.homeTeamId = homeTeamId;
ViewBag.opponentTeamId = oppTeamId;
ViewBag.HomePlayerId = new SelectList(_context.Players
.AsNoTracking()
.Where(i => i.TeamId == homeTeamId)
.Select(i => new { i.PlayerId, i.Player_Name })
, "PlayerId", "Player_Name");
ViewBag.OpponentPlayerId = new SelectList(_context.Players
.AsNoTracking()
.Where(i => i.TeamId == oppTeamId), "PlayerId", "Player_Name");
var matchPlayers = _context.PlayerScores
.AsNoTracking()
.Where(m => m.MatchId == matchId && (m.TeamId == homeTeamId || m.TeamId == oppTeamId))
.Select(i => new MatchSummarydto
{
PlayerScoreId = i.PlayerScoreId,
IsPlayedInning = i.IsPlayedInning,
PlayerId = i.PlayerId,
HowOutId = i.HowOutId,
Bowler = i.Bowler,
MatchId = i.MatchId,
TeamId = i.TeamId,
Wickets = i.Wickets
})
.ToList();
scoreDto.HomeTeamScoreCard = matchPlayers.Where(i => i.TeamId == homeTeamId).ToList();
scoreDto.OpponentTeamScoreCard = matchPlayers.Where(i => i.TeamId == oppTeamId).ToList();
if (matchId.HasValue)
{
for (var index = 0; index < 15; index++)
{
if (scoreDto.HomeTeamScoreCard.Count == index)
{
scoreDto.HomeTeamScoreCard.Add(new MatchSummarydto
{
MatchId = matchId.Value,
});
}
}
}
if (matchId.HasValue)
{
for (var index = 0; index < 15; index++)
{
if (scoreDto.OpponentTeamScoreCard.Count == index)
{
scoreDto.OpponentTeamScoreCard.Add(new MatchSummarydto
{
MatchId = matchId.Value,
});
}
}
}
scoreDto.TeamScoreCard = _context.TeamScores
.AsNoTracking()
.Where(m => m.MatchId == matchId)
.Select(i => new TeamScoredto
{
TeamScoreId = i.TeamScoreId,
Wickets = i.Wickets,
TotalScore = i.TotalScore,
Byes = i.Byes,
LegByes = i.LegByes,
Wideballs = i.Wideballs,
NoBalls = i.NoBalls,
MatchId = i.MatchId
})
.ToList();
if (matchId.HasValue)
{
for (var index = 0; index < 2; index++)
{
if (scoreDto.TeamScoreCard.Count == index)
{
scoreDto.TeamScoreCard.Add(new TeamScoredto
{
MatchId = matchId.Value,
});
}
}
}
scoreDto.FallOfWicket = _context.FallOFWickets
.AsNoTracking()
.Where(m => m.MatchId == matchId)
.Select(i => new FallOfWicketdto
{
FallOfWicketId = i.FallOfWicketId,
TeamId = i.TeamId,
MatchId = i.MatchId,
First = i.First,
Second = i.Second,
Third = i.Third,
Fourth = i.Fourth,
Fifth = i.Fifth,
Sixth = i.Sixth,
Seventh = i.Seventh,
Eight = i.Eight,
Ninth = i.Ninth,
Tenth = i.Tenth
})
.ToList();
if (matchId.HasValue)
{
for (var index = 0; index < 2; index++)
{
if (scoreDto.FallOfWicket.Count == index)
{
scoreDto.FallOfWicket.Add(new FallOfWicketdto
{
MatchId = matchId.Value,
});
}
}
}
return(View(scoreDto));
}
// [Route("PlayerScores/Index/matchId{matchId}/homeTeamId{homeTeamId}/oppTeamId{oppTeamId}/playerScoreId{playerScoreId}")]
public IActionResult Index(int?matchId, int?homeTeamId, int?oppTeamId, bool api)
{
ViewBag.Name = "Score Card";
var scoreDto = new ScoreCarddto();
ViewBag.matchId = matchId;
ViewBag.homeTeamId = homeTeamId;
ViewBag.oppTeamId = oppTeamId;
ViewBag.Overs = _context.Matches
.AsNoTracking()
.Where(i => i.MatchId == matchId)
.Select(i => i.MatchOvers)
.Single();
var connection = _context.Database.GetDbConnection();
var s = connection.Query <Summary2dto>(
"usp_Summary2",
new
{
paramMatchId = matchId,
paramHomeTeamId = homeTeamId,
paramOpponentTeamId = oppTeamId
},
commandType: CommandType.StoredProcedure) ?? new List <Summary2dto>()
{
};
var matchSummary = _context.PlayerScores
.AsNoTracking()
.Where(i => (i.TeamId == homeTeamId || i.TeamId == oppTeamId) && i.MatchId == matchId)
.Select(i => new MatchSummarydto
{
PlayerScoreId = i.PlayerScoreId,
PlayerId = i.PlayerId,
Position = i.Position,
MatchId = i.MatchId,
Bowler = i.BowlerId,
Catches = i.Catches,
IsPlayedInning = i.IsPlayedInning,
Ball_Runs = i.Ball_Runs,
Bat_Balls = i.Bat_Balls,
Bat_Runs = i.Bat_Runs,
Four = i.Four,
HowOutId = i.HowOutId,
Maiden = i.Maiden,
Overs = i.Overs,
RunOut = i.RunOut,
Six = i.Six,
Stump = i.Stump,
Wickets = i.Wickets,
PlayerName = i.Player.Player_Name,
HowOutName = i.HowOut.Name,
TeamId = i.TeamId,
Fielder = i.Fielder
})
.OrderBy(i => i.Position)
.ToList();
scoreDto.HomeTeamScoreCard = matchSummary.Where(i => i.TeamId == homeTeamId).ToList();
scoreDto.OpponentTeamScoreCard = matchSummary.Where(i => i.TeamId == oppTeamId).ToList();
scoreDto.Summary2dto = s.SingleOrDefault();
scoreDto.TeamScoreCard = _context.TeamScores
.AsNoTracking()
.Include(i => i.Team)
.Where(i => i.MatchId == matchId)
.Select(i => new TeamScoredto
{
TeamId = i.TeamId,
TotalScore = i.TotalScore,
Wideballs = i.Wideballs,
NoBalls = i.NoBalls,
Byes = i.Byes,
LegByes = i.LegByes,
TeamName = i.Team.Team_Name,
Wickets = i.Wickets
})
.OrderBy(i => i.TeamScoreId)
.ToList();
var graph = _context.FallOFWickets
.AsNoTracking()
.Where(i => i.MatchId == matchId && (i.TeamId == homeTeamId || i.TeamId == oppTeamId))
.Select(i => new FallOfWicketdto
{
TeamId = i.TeamId,
MatchId = i.MatchId,
First = i.First,
Second = i.Second,
Third = i.Third,
Fourth = i.Fourth,
Fifth = i.Fifth,
Sixth = i.Sixth,
Seventh = i.Seventh,
Eight = i.Eight,
Ninth = i.Ninth,
Tenth = i.Tenth
}).ToList();
scoreDto.HomeTeamFOW = graph.Where(i => i.TeamId == homeTeamId).ToList();
scoreDto.OpponentTeamFOW = graph.Where(i => i.TeamId == oppTeamId).ToList();
if (api == true)
{
return(Json(scoreDto));
}
else
{
return(View(scoreDto));
}
}
public IActionResult Index(int?matchId, int?homeTeamId, int?oppTeamId, long?playerScoreId)
{
ViewBag.Name = "Score Card";
var scoreDto = new ScoreCarddto();
ViewBag.matchId = matchId;
ViewBag.homeTeamId = homeTeamId;
ViewBag.oppTeamId = oppTeamId;
ViewBag.OpponentTeam = _context.Teams
.AsNoTracking()
.Where(i => i.TeamId == oppTeamId)
.Select(i => i.Team_Name)
.Single();
ViewBag.GroundName = _context.Matches
.AsNoTracking()
.Where(i => i.MatchId == matchId)
.Select(i => i.GroundName)
.Single();
ViewBag.Overs = _context.Matches
.AsNoTracking()
.Where(i => i.MatchId == matchId)
.Select(i => i.MatchOvers)
.Single();
ViewBag.HomeTeam = _context.Teams
.AsNoTracking()
.Where(i => i.TeamId == homeTeamId)
.Select(i => i.Team_Name)
.Single();
ViewBag.HomeTeamScore = _context.TeamScores
.AsNoTracking()
.Where(i => i.TeamId == homeTeamId && i.MatchId == matchId)
.Select(i => i.TotalScore).SingleOrDefault();
ViewBag.OppTeamScore = _context.TeamScores
.AsNoTracking()
.Where(i => i.TeamId == oppTeamId && i.MatchId == matchId)
.Select(i => i.TotalScore).SingleOrDefault();
ViewBag.HomeTeamOut = _context.PlayerScores
.AsNoTracking()
.Count(i => i.HowOutId != 7 && i.HowOutId != null && i.TeamId == homeTeamId && i.MatchId == matchId);
ViewBag.OpponenetTeamOut = _context.PlayerScores
.AsNoTracking()
.Where(i => i.HowOutId != 7 && i.HowOutId != null && i.TeamId == oppTeamId && i.MatchId == matchId)
.Count();
var matchSummary = _context.PlayerScores
.AsNoTracking()
.Where(i => (i.TeamId == homeTeamId || i.TeamId == oppTeamId) && i.MatchId == matchId)
.Select(i => new MatchSummarydto
{
PlayerScoreId = i.PlayerScoreId,
PlayerId = i.PlayerId,
Position = i.Position,
MatchId = i.MatchId,
Bowler = i.Bowler,
Catches = i.Catches,
IsPlayedInning = i.IsPlayedInning,
Ball_Runs = i.Ball_Runs,
Bat_Balls = i.Bat_Balls,
Bat_Runs = i.Bat_Runs,
Four = i.Four,
HowOutId = i.HowOutId,
Maiden = i.Maiden,
Overs = i.Overs,
RunOut = i.RunOut,
Six = i.Six,
Stump = i.Stump,
Wickets = i.Wickets,
Player = i.Player,
HowOutName = i.HowOut.Name,
TeamId = i.TeamId
})
.OrderBy(i => i.Position)
.ToList();
scoreDto.HomeTeamScoreCard = matchSummary.Where(i => i.TeamId == homeTeamId).ToList();
scoreDto.OpponentTeamScoreCard = matchSummary.Where(i => i.TeamId == oppTeamId).ToList();
scoreDto.TeamScoreCard = _context.TeamScores
.AsNoTracking()
.Include(i => i.Team)
.Where(i => i.MatchId == matchId)
.Select(i => new TeamScoredto
{
TeamId = i.TeamId,
TotalScore = i.TotalScore,
Wideballs = i.Wideballs,
NoBalls = i.NoBalls,
Byes = i.Byes,
LegByes = i.LegByes,
TeamName = i.Team.Team_Name,
Wickets = i.Wickets
})
.OrderBy(i => i.TeamScoreId)
.ToList();
var graph = _context.FallOFWickets
.AsNoTracking()
.Where(i => i.MatchId == matchId && (i.TeamId == homeTeamId || i.TeamId == oppTeamId))
.Select(i => new FallOfWicketdto
{
TeamId = i.TeamId,
MatchId = i.MatchId,
First = i.First,
Second = i.Second,
Third = i.Third,
Fourth = i.Fourth,
Fifth = i.Fifth,
Sixth = i.Sixth,
Seventh = i.Seventh,
Eight = i.Eight,
Ninth = i.Ninth,
Tenth = i.Tenth
}).ToList();
scoreDto.HomeTeamFOW = graph.Where(i => i.TeamId == homeTeamId).ToList();
scoreDto.OpponentTeamFOW = graph.Where(i => i.TeamId == oppTeamId).ToList();
return(View(scoreDto));
}
public IActionResult Edit(int?matchId, int?homeTeamId, int?oppTeamId)
{
ViewBag.Name = "Edit Match Players";
ViewBag.HowOut = new SelectList(_context.HowOut
.AsNoTracking()
.Select(i => new { i.HowOutId, i.Name })
, "HowOutId", "Name");
var scoreDto = new ScoreCarddto();
var connection = _context.Database.GetDbConnection();
var s = connection.Query <Summary2dto>(
"usp_Summary2",
new
{
paramMatchId = matchId,
paramHomeTeamId = homeTeamId,
paramOpponentTeamId = oppTeamId
},
commandType: CommandType.StoredProcedure) ?? new List <Summary2dto>()
{
};
scoreDto.Summary2dto = s.SingleOrDefault();
//ViewBag.matchId = matchId;
ViewBag.homeTeamId = homeTeamId;
ViewBag.opponentTeamId = oppTeamId;
ViewBag.HomePlayerId = new SelectList(_context.Players
.AsNoTracking()
.Where(i => i.TeamId == homeTeamId)
.Select(i => new { i.PlayerId, i.Player_Name })
, "PlayerId", "Player_Name");
ViewBag.OpponentPlayerId = new SelectList(_context.Players
.AsNoTracking()
.Where(i => i.TeamId == oppTeamId), "PlayerId", "Player_Name");
var matchPlayers = _context.PlayerScores
.AsNoTracking()
.Where(m => m.MatchId == matchId && (m.TeamId == homeTeamId || m.TeamId == oppTeamId))
.Select(i => new MatchSummarydto
{
PlayerScoreId = i.PlayerScoreId,
IsPlayedInning = i.IsPlayedInning,
PlayerId = i.PlayerId,
HowOutId = i.HowOutId,
Bowler = i.BowlerId,
MatchId = i.MatchId,
TeamId = i.TeamId,
Wickets = i.Wickets,
Fielder = i.Fielder
})
.ToList();
scoreDto.HomeTeamScoreCard = matchPlayers.Where(i => i.TeamId == homeTeamId).ToList();
scoreDto.OpponentTeamScoreCard = matchPlayers.Where(i => i.TeamId == oppTeamId).ToList();
if (matchId.HasValue)
{
for (var index = 0; index < 15; index++)
{
if (scoreDto.HomeTeamScoreCard.Count == index)
{
scoreDto.HomeTeamScoreCard.Add(new MatchSummarydto
{
MatchId = matchId.Value,
TeamId = homeTeamId.Value
});
}
}
}
if (matchId.HasValue)
{
for (var index = 0; index < 15; index++)
{
if (scoreDto.OpponentTeamScoreCard.Count == index)
{
scoreDto.OpponentTeamScoreCard.Add(new MatchSummarydto
{
MatchId = matchId.Value,
TeamId = oppTeamId.Value
});
}
}
}
scoreDto.TeamScoreCard = _context.TeamScores
.AsNoTracking()
.Where(m => m.MatchId == matchId)
.Select(i => new TeamScoredto
{
TeamScoreId = i.TeamScoreId,
Wickets = i.Wickets,
TotalScore = i.TotalScore,
Byes = i.Byes,
LegByes = i.LegByes,
Wideballs = i.Wideballs,
NoBalls = i.NoBalls,
MatchId = i.MatchId
})
.ToList();
if (matchId.HasValue)
{
for (var index = 0; index < 2; index++)
{
if (scoreDto.TeamScoreCard.Count == index)
{
scoreDto.TeamScoreCard.Add(new TeamScoredto
{
MatchId = matchId.Value,
});
}
}
}
scoreDto.FallOfWicket = _context.FallOFWickets
.AsNoTracking()
.Where(m => m.MatchId == matchId)
.Select(i => new FallOfWicketdto
{
FallOfWicketId = i.FallOfWicketId,
TeamId = i.TeamId,
MatchId = i.MatchId,
First = i.First,
Second = i.Second,
Third = i.Third,
Fourth = i.Fourth,
Fifth = i.Fifth,
Sixth = i.Sixth,
Seventh = i.Seventh,
Eight = i.Eight,
Ninth = i.Ninth,
Tenth = i.Tenth
})
.ToList();
if (matchId.HasValue)
{
for (var index = 0; index < 2; index++)
{
if (scoreDto.FallOfWicket.Count == index)
{
scoreDto.FallOfWicket.Add(new FallOfWicketdto
{
MatchId = matchId.Value,
});
}
}
}
return(View(scoreDto));
}
