public IGameInningTeam GetCurrentGameInningTeam(Guid gameId)
{
IGameInningTeam gameInningTeam = null;
using (var context = new Data.DartballContext()) {
var items = (from g in context.Games
join gi in context.GameInnings on g.GameId equals gi.GameId
join gt in context.GameTeams on g.GameId equals gt.GameId
join git in context.GameInningTeams on gi.GameInningId equals git.GameInningId
where g.GameId == gameId.ToString() &&
!g.DeleteDate.HasValue &&
!gi.DeleteDate.HasValue &&
!gt.DeleteDate.HasValue &&
!git.DeleteDate.HasValue
orderby gi.InningNumber descending
orderby gt.TeamBattingSequence descending
select git).Take(1);
if (items != null && items.Count() > 0)
{
gameInningTeam = Mapper.Map <GameInningTeamDto>(items.FirstOrDefault());
}
}
return(gameInningTeam);
}
public ChangeResult Save(IGameInningTeam gameInningTeam)
{
bool isAdd = GetGameInningTeam(gameInningTeam.GameTeamId, gameInningTeam.GameInningId) == null;
if (isAdd)
{
return(AddNew(gameInningTeam));
}
return(Update(gameInningTeam));
}
public IGameInningTeam GetGameInningTeam(Guid gameTeamId, Guid gameInningId)
{
IGameInningTeam gameInningTeam = null;
using (var context = new Data.DartballContext())
{
var item = context.GameInningTeams.FirstOrDefault(x => x.GameTeamId == gameTeamId.ToString() && x.GameInningId == gameInningId.ToString());
if (item != null)
{
gameInningTeam = Mapper.Map <GameInningTeamDto>(item);
}
}
return(gameInningTeam);
}
public GameInningTeam(IGameInningTeam gameInningTeam)
{
if (gameInningTeam != null)
{
GameInningTeamId = gameInningTeam.GameInningTeamId;
GameInningId = gameInningTeam.GameInningId;
GameTeamId = gameInningTeam.GameTeamId;
Score = gameInningTeam.Score;
Outs = gameInningTeam.Outs;
IsRunnerOnFirst = gameInningTeam.IsRunnerOnFirst;
IsRunnerOnSecond = gameInningTeam.IsRunnerOnSecond;
IsRunnerOnThird = gameInningTeam.IsRunnerOnThird;
HasData = true;
}
}
public ChangeResult Update(IGameInningTeam gameInningTeam)
{
return(Update(new List <IGameInningTeam> {
gameInningTeam
}));
}
public ChangeResult AddNew(IGameInningTeam gameInningTeam)
{
return(AddNew(new List <IGameInningTeam> {
gameInningTeam
}));
}
