public async Task <IActionResult> FallOfWicketSave([FromForm] TeamMatchScoredto Model)
{
if (ModelState.IsValid)
{
_context.AddRange(Model.FallOfWicket.Select(i => new FallOfWicket
{
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
}
));
await _context.SaveChangesAsync();
return(Json(ResponseHelper.Success()));
// return RedirectToAction(nameof(Index), new { matchId = Matchplayers.Select(i => i.MatchId).First(), teamId });
}
return(Json(ResponseHelper.UnSuccess()));
}
public async Task <IActionResult> HomeTeamUpdate([FromForm] TeamMatchScoredto Matchplayers, int teamId)
{
if (ModelState.IsValid)
{
foreach (var mp in Matchplayers.HomeTeamScoreCard)
{
var matchScore = new PlayerScore {
PlayerScoreId = mp.PlayerScoreId
};
_context.PlayerScores.Attach(matchScore);
matchScore.PlayerScoreId = mp.PlayerScoreId;
matchScore.Position = mp.Position;
matchScore.IsPlayedInning = mp.IsPlayedInning;
matchScore.PlayerId = mp.PlayerId;
matchScore.HowOutId = mp.HowOutId;
matchScore.Bowler = mp.Bowler;
matchScore.MatchId = mp.MatchId;
matchScore.TeamId = mp.TeamId;
await _context.SaveChangesAsync();
}
return(Json(ResponseHelper.UpdateSuccess()));
// return RedirectToAction(nameof(Index), new { matchId = Matchplayers.Select(i => i.MatchId).First(), teamId });
}
return(Json(ResponseHelper.UpdateUnSuccess()));
}
public async Task <IActionResult> UpdateTeamScore([FromForm] TeamMatchScoredto model)
{
if (ModelState.IsValid)
{
foreach (var teamScore in model.TeamScore)
{
var teamScoreDbModel = new TeamScore
{
TeamScoreId = teamScore.TeamScoreId
};
_context.TeamScores.Attach(teamScoreDbModel);
teamScoreDbModel.TeamScoreId = teamScore.TeamScoreId;
teamScoreDbModel.TeamId = teamScore.TeamId;
teamScoreDbModel.MatchId = teamScore.MatchId;
teamScoreDbModel.TotalScore = teamScore.TotalScore;
teamScoreDbModel.Wickets = teamScore.Wickets;
teamScoreDbModel.Wideballs = teamScore.Wideballs;
teamScoreDbModel.NoBalls = teamScore.NoBalls;
teamScoreDbModel.Byes = teamScore.Byes;
teamScoreDbModel.LegByes = teamScore.LegByes;
_context.TeamScores.Update(teamScoreDbModel);
}
await _context.SaveChangesAsync();
return(Json(ResponseHelper.UpdateSuccess()));
}
else
{
return(Json(ResponseHelper.UpdateUnSuccess()));
}
}
public IActionResult MatchScore(int homeTeamId, int oppTeamId, int matchId)
{
var model = new TeamMatchScoredto();
var connection = _context.Database.GetDbConnection();
ViewBag.HowOut = new SelectList(_context.HowOut
.AsNoTracking()
.Select(i => new { i.HowOutId, i.Name })
, "HowOutId", "Name");
var s = connection.Query <Summary2dto>(
"usp_Summary2",
new
{
paramMatchId = matchId,
paramHomeTeamId = homeTeamId,
paramOpponentTeamId = oppTeamId
},
commandType: CommandType.StoredProcedure) ?? new List <Summary2dto>()
{
};
model.Summary2dto = s.SingleOrDefault();
return(View(model));
}
public async Task <IActionResult> HomeTeamUpdate([FromForm] TeamMatchScoredto Matchplayers, int teamId)
{
if (ModelState.IsValid)
{
var model = await _context.PlayerScores.Where(i => i.PlayerScoreId == Matchplayers.HomeTeamScoreCard.PlayerScoreId).SingleOrDefaultAsync();
model.Position = Matchplayers.HomeTeamScoreCard.Position;
model.IsPlayedInning = Matchplayers.HomeTeamScoreCard.IsPlayedInning;
model.PlayerId = Matchplayers.HomeTeamScoreCard.PlayerId;
model.HowOutId = Matchplayers.HomeTeamScoreCard.HowOutId;
model.BowlerId = Matchplayers.HomeTeamScoreCard.Bowler;
model.MatchId = Matchplayers.HomeTeamScoreCard.MatchId;
model.TeamId = Matchplayers.HomeTeamScoreCard.TeamId;
model.Fielder = Matchplayers.HomeTeamScoreCard.Fielder;
model.Bat_Runs = Matchplayers.HomeTeamScoreCard.Bat_Runs;
model.Bat_Balls = Matchplayers.HomeTeamScoreCard.Bat_Balls;
model.Four = Matchplayers.HomeTeamScoreCard.Four;
model.Six = Matchplayers.HomeTeamScoreCard.Six;
model.Ball_Runs = Matchplayers.HomeTeamScoreCard.Ball_Runs;
model.Overs = Matchplayers.HomeTeamScoreCard.Overs;
model.Wickets = Matchplayers.HomeTeamScoreCard.Wickets;
model.Maiden = Matchplayers.HomeTeamScoreCard.Maiden;
model.RunOut = Matchplayers.HomeTeamScoreCard.RunOut;
model.Catches = Matchplayers.HomeTeamScoreCard.Catches;
model.Stump = Matchplayers.HomeTeamScoreCard.Stump;
_context.PlayerScores.Update(model);
return(Json(ResponseHelper.UpdateSuccess()));
}
return(Json(ResponseHelper.UpdateUnSuccess()));
}
public async Task <IActionResult> OpponentTeamSave([FromForm] TeamMatchScoredto OpponentTeamplayers, int teamId)
{
if (ModelState.IsValid)
{
var model = new PlayerScore();
model.Position = OpponentTeamplayers.OppoTeamScoreCard.Position;
model.IsPlayedInning = OpponentTeamplayers.OppoTeamScoreCard.IsPlayedInning;
model.PlayerId = OpponentTeamplayers.OppoTeamScoreCard.PlayerId;
model.HowOutId = OpponentTeamplayers.OppoTeamScoreCard.HowOutId;
model.BowlerId = OpponentTeamplayers.OppoTeamScoreCard.Bowler == -1 ? null : OpponentTeamplayers.OppoTeamScoreCard.Bowler;
model.MatchId = OpponentTeamplayers.OppoTeamScoreCard.MatchId;
model.TeamId = OpponentTeamplayers.OppoTeamScoreCard.TeamId;
model.Fielder = OpponentTeamplayers.OppoTeamScoreCard.Fielder;
model.Bat_Runs = OpponentTeamplayers.OppoTeamScoreCard.Bat_Runs;
model.Bat_Balls = OpponentTeamplayers.OppoTeamScoreCard.Bat_Balls;
model.Four = OpponentTeamplayers.OppoTeamScoreCard.Four;
model.Six = OpponentTeamplayers.OppoTeamScoreCard.Six;
model.Ball_Runs = OpponentTeamplayers.OppoTeamScoreCard.Ball_Runs;
model.Overs = OpponentTeamplayers.OppoTeamScoreCard.Overs;
model.Wickets = OpponentTeamplayers.OppoTeamScoreCard.Wickets;
model.Maiden = OpponentTeamplayers.OppoTeamScoreCard.Maiden;
model.RunOut = OpponentTeamplayers.OppoTeamScoreCard.RunOut;
model.Catches = OpponentTeamplayers.OppoTeamScoreCard.Catches;
model.Stump = OpponentTeamplayers.OppoTeamScoreCard.Stump;
_context.PlayerScores.Add(model);
await _context.SaveChangesAsync();
}
return(Json(ResponseHelper.UnSuccess()));
}
public async Task <IActionResult> UpdateFallOfWicket([FromForm] TeamMatchScoredto model)
{
if (ModelState.IsValid)
{
foreach (var fallOfWicket in model.FallOfWicket)
{
var fallOfWicketDbModel = new FallOfWicket
{
FallOfWicketId = fallOfWicket.FallOfWicketId
};
_context.FallOFWickets.Attach(fallOfWicketDbModel);
fallOfWicketDbModel.FallOfWicketId = fallOfWicket.FallOfWicketId;
fallOfWicketDbModel.First = fallOfWicket.First;
fallOfWicketDbModel.Second = fallOfWicket.Second;
fallOfWicketDbModel.Third = fallOfWicket.Third;
fallOfWicketDbModel.Fourth = fallOfWicket.Fourth;
fallOfWicketDbModel.Fifth = fallOfWicket.Fifth;
fallOfWicketDbModel.Sixth = fallOfWicket.Sixth;
fallOfWicketDbModel.Seventh = fallOfWicket.Seventh;
fallOfWicketDbModel.Eight = fallOfWicket.Eight;
fallOfWicketDbModel.Ninth = fallOfWicket.Ninth;
fallOfWicketDbModel.Tenth = fallOfWicket.Tenth;
fallOfWicketDbModel.TeamId = fallOfWicket.TeamId;
fallOfWicketDbModel.MatchId = fallOfWicket.MatchId;
_context.FallOFWickets.Update(fallOfWicketDbModel);
}
await _context.SaveChangesAsync();
return(Json(ResponseHelper.UpdateSuccess()));
}
else
{
return(Json(ResponseHelper.UpdateUnSuccess()));
}
}
public async Task <IActionResult> OpponentTeamSave([FromForm] TeamMatchScoredto OpponentTeamplayers, int teamId)
{
if (ModelState.IsValid)
{
_context.AddRange(OpponentTeamplayers.OpponentTeamScoreCard.Select(i => new PlayerScore
{
Position = i.Position,
IsPlayedInning = i.IsPlayedInning,
PlayerId = i.PlayerId,
HowOutId = i.HowOutId,
Bowler = i.Bowler,
MatchId = i.MatchId,
TeamId = i.TeamId
}
));
await _context.SaveChangesAsync();
return(Json(ResponseHelper.Success()));
// return RedirectToAction(nameof(Index), new { matchId = Matchplayers.Select(i => i.MatchId).First(), teamId });
}
return(Json(ResponseHelper.UnSuccess()));
}
public async Task <IActionResult> TeamScoreSave([FromForm] TeamMatchScoredto TeamScores)
{
if (ModelState.IsValid)
{
_context.AddRange(TeamScores.TeamScore.Select(i => new TeamScore
{
TeamId = i.TeamId,
MatchId = i.MatchId,
TotalScore = i.TotalScore,
Wickets = i.Wickets,
Wideballs = i.Wideballs,
NoBalls = i.NoBalls,
Byes = i.Byes,
LegByes = i.LegByes
}
));
await _context.SaveChangesAsync();
return(Json(ResponseHelper.Success()));
// return RedirectToAction(nameof(Index), new { matchId = Matchplayers.Select(i => i.MatchId).First(), teamId });
}
return(Json(ResponseHelper.UnSuccess()));
}
public IActionResult Create(int homeTeamId, int oppTeamId, int matchId)
{
ViewBag.Name = "Add Match Players";
ViewBag.HowOut = new SelectList(_context.HowOut
.AsNoTracking()
.Select(i => new { i.HowOutId, i.Name })
, "HowOutId", "Name");
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)
.Select(i => new { i.PlayerId, i.Player_Name })
, "PlayerId", "Player_Name");
var model = new TeamMatchScoredto();
for (int i = 0; i < 2; i++)
{
model.TeamScore.Add(new TeamScoredto
{
MatchId = matchId
});
}
for (int i = 0; i < 2; i++)
{
model.FallOfWicket.Add(new FallOfWicketdto
{
MatchId = matchId
});
}
for (int i = 0; i < 15; i++)
{
model.HomeTeamScoreCard.Add(new MatchSummarydto
{
MatchId = matchId,
});
}
for (int i = 0; i < 15; i++)
{
model.OpponentTeamScoreCard.Add(new MatchSummarydto
{
MatchId = matchId,
});
}
return(View(model));
}
public IActionResult Create(int homeTeamId, int oppTeamId, int matchId)
{
var model = new TeamMatchScoredto();
ViewBag.Name = "Add Match Players";
ViewBag.HowOut = new SelectList(_context.HowOut
.AsNoTracking()
.Select(i => new { i.HowOutId, i.Name })
, "HowOutId", "Name");
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>()
{
};
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)
.Select(i => new { i.PlayerId, i.Player_Name })
, "PlayerId", "Player_Name");
for (int i = 0; i < 2; i++)
{
model.TeamScore.Add(new TeamScoredto
{
MatchId = matchId
});
}
for (int i = 0; i < 2; i++)
{
model.FallOfWicket.Add(new FallOfWicketdto
{
MatchId = matchId
});
}
//for (int i = 0; i < 15; i++)
//{
// model.HomeTeamScoreCard.Add(new MatchSummarydto
// {
// MatchId = matchId,
// });
//}
//for (int i = 0; i < 15; i++)
//{
// model.OpponentTeamScoreCard.Add(new MatchSummarydto
// {
// MatchId = matchId,
// });
//}
model.Summary2dto = s.SingleOrDefault();
model.HomeTeamScoreCard.MatchId = matchId;
return(View(model));
}
