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