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)); }