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 Update(List <ITeam> teams)
{
var result = Validate(teams);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var team in teams)
{
context.Teams.Update(new Domain.Team()
{
TeamId = team.TeamId.ToString(),
LeagueId = team.LeagueId.ToString(),
Name = Helper.CleanString(team.Name),
Password = Helper.CleanString(team.Password), //TODO: add encryption
Handicap = team.Handicap,
ShouldSync = team.ShouldSync ? 1 : 0,
DeleteDate = team.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public ChangeResult Update(List <IGameInningTeam> gameInningTeams)
{
var result = Validate(gameInningTeams, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in gameInningTeams)
{
context.GameInningTeams.Update(new Domain.GameInningTeam()
{
GameInningTeamId = item.GameInningTeamId.ToString(),
GameInningId = item.GameInningId.ToString(),
GameTeamId = item.GameTeamId.ToString(),
Score = item.Score,
Outs = item.Outs,
IsRunnerOnFirst = item.IsRunnerOnFirst ? 1 : 0,
IsRunnerOnSecond = item.IsRunnerOnSecond ? 1 : 0,
IsRunnerOnThird = item.IsRunnerOnThird ? 1 : 0,
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public IGameInningTeamBatter GetCurrentGameInningTeamBatter(Guid gameId)
{
IGameInningTeamBatter gameInningTeamBatter = null;
using (var context = new Data.DartballContext())
{
var currentInning = context.GameInnings
.Where(x => x.GameId == gameId.ToString() && !x.DeleteDate.HasValue)
.OrderByDescending(x => x.InningNumber).FirstOrDefault();
if (currentInning != null)
{
var gameTeamsInReverseSequence = context.GameTeams
.Where(x => x.GameId == gameId.ToString() && !x.DeleteDate.HasValue)
.OrderByDescending(x => x.TeamBattingSequence).ToList();
var inningTeamsBatters = context.GameInningTeamBatters
.Where(x => x.GameInningTeam.GameInningId == currentInning.GameInningId && !x.DeleteDate.HasValue && !x.DeleteDate.HasValue)
.Include(x => x.GameInningTeam)
.OrderByDescending(x => x.Sequence).ToList();
foreach (var gt in gameTeamsInReverseSequence)
{
var teamBatters = inningTeamsBatters.Where(x => x.GameInningTeam.GameTeamId == gt.GameTeamId).ToList();
if (teamBatters.Count > 0)
{
gameInningTeamBatter = Mapper.Map <GameInningTeamBatterDto>(teamBatters.FirstOrDefault());
break;
}
}
}
}
return(gameInningTeamBatter);
}
public ChangeResult Update(List <IPlayer> players)
{
var result = Validate(players);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var player in players)
{
context.Players.Update(new Domain.Player()
{
PlayerId = player.PlayerId.ToString(),
Name = Helper.CleanString(player.Name),
LastName = Helper.CleanString(player.LastName),
EmailAddress = Helper.CleanString(player.EmailAddress),
UserName = Helper.CleanString(player.UserName),
Password = Helper.CleanString(player.Password), //TODO: add encryption
ShouldSync = player.ShouldSync ? 1 : 0,
DeleteDate = player.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public ILeague GetGenericLeague()
{
ILeague league = null;
string leagueName = "Quick Play";
using (var context = new Data.DartballContext()) {
var item = context.Leagues.FirstOrDefault(x => x.Name == leagueName);
if (item == null)
{
LeagueDto dto = new LeagueDto()
{
Name = leagueName,
Password = "******"
};
AddNew(dto);
item = context.Leagues.FirstOrDefault(x => x.Name == leagueName);
league = Mapper.Map <LeagueDto>(item);
}
else
{
league = Mapper.Map <LeagueDto>(item);
}
}
return(league);
}
public ChangeResult Update(List <IGameInningTeamBatter> gameInningTeamBatters)
{
var result = Validate(gameInningTeamBatters, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in gameInningTeamBatters)
{
context.GameInningTeamBatters.Update(new Domain.GameInningTeamBatter()
{
GameInningTeamBatterId = item.GameInningTeamBatterId.ToString(),
GameInningTeamId = item.GameInningTeamId.ToString(),
PlayerId = item.PlayerId.ToString(),
Sequence = item.Sequence,
EventType = item.EventType,
TargetEventType = item.TargetEventType,
RBIs = item.RBIs,
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public List <IGameTeam> GetGameTeams(Guid gameId)
{
List <IGameTeam> gameTeams = new List <IGameTeam>();
using (var context = new Data.DartballContext())
{
var items = context.GameTeams.Where(x => x.GameId == gameId.ToString() && !x.DeleteDate.HasValue).ToList();
foreach (var item in items)
{
gameTeams.Add(Mapper.Map <GameTeamDto>(item));
}
}
return(gameTeams);
}
public List <IGameInning> GetAllGameInnings()
{
List <IGameInning> gameInnings = new List <IGameInning>();
using (var context = new Data.DartballContext())
{
var items = context.GameInnings.ToList().Where(x => !x.DeleteDate.HasValue);
foreach (var item in items)
{
gameInnings.Add(Mapper.Map <GameInningDto>(item));
}
}
return(gameInnings);
}
public List <IPlayer> GetPlayers()
{
List <IPlayer> players = new List <IPlayer>();
using (var context = new Data.DartballContext())
{
var items = context.Players.Where(x => !x.DeleteDate.HasValue).ToList();
foreach (var item in items)
{
players.Add(Mapper.Map <PlayerDto>(item));
}
}
return(players);
}
public List <IPlayerTeam> GetPlayerTeams(Guid playerId)
{
List <IPlayerTeam> playerTeams = new List <IPlayerTeam>();
using (var context = new Data.DartballContext()) {
var items = context.PlayerTeams.Where(x => x.PlayerId == playerId.ToString()).ToList();
foreach (var item in items)
{
playerTeams.Add(Mapper.Map <PlayerTeamDto>(item));
}
}
return(playerTeams);
}
public IGame GetGame(Guid gameId)
{
IGame game = null;
using (var context = new Data.DartballContext())
{
var item = context.Games.FirstOrDefault(x => x.GameId == gameId.ToString());
if (item != null)
{
game = Mapper.Map <GameDto>(item);
}
}
return(game);
}
public List <IGame> GetLeagueGames(Guid leagueId)
{
List <IGame> games = new List <IGame>();
using (var context = new Data.DartballContext())
{
var items = context.Games.Where(x => x.LeagueId == leagueId.ToString() && !x.DeleteDate.HasValue).ToList();
foreach (var item in items)
{
games.Add(Mapper.Map <GameDto>(item));
}
}
return(games);
}
public List <ITeam> GetTeams()
{
List <ITeam> teams = new List <ITeam>();
using (var context = new Data.DartballContext())
{
var items = context.Teams.Where(x => !x.DeleteDate.HasValue).ToList();
foreach (var item in items)
{
teams.Add(Mapper.Map <TeamDto>(item));
}
}
return(teams);
}
public IPlayerTeam GetPlayerTeam(Guid teamId, Guid playerId)
{
IPlayerTeam playerTeam = null;
using (var context = new Data.DartballContext())
{
var item = context.PlayerTeams.FirstOrDefault(x => x.TeamId == teamId.ToString() && x.PlayerId == playerId.ToString());
if (item != null)
{
playerTeam = Mapper.Map <PlayerTeamDto>(item);
}
}
return(playerTeam);
}
public ITeamPlayerLineup GetTeamPlayerLineupItem(Guid teamId, Guid playerId)
{
ITeamPlayerLineup teamPlayerLineup = null;
using (var context = new Data.DartballContext())
{
var item = context.TeamPlayerLineups.FirstOrDefault(x => x.TeamId == teamId.ToString() && x.PlayerId == playerId.ToString());
if (item != null)
{
teamPlayerLineup = Mapper.Map <TeamPlayerLineupDto>(item);
}
}
return(teamPlayerLineup);
}
public IGameInning GetGameInning(Guid gameId, int inningNumber)
{
IGameInning gameInning = null;
using (var context = new Data.DartballContext())
{
var item = context.GameInnings.FirstOrDefault(x => x.GameId == gameId.ToString() && x.InningNumber == inningNumber);
if (item != null)
{
gameInning = Mapper.Map <GameInningDto>(item);
}
}
return(gameInning);
}
public IGameInningTeamBatter GetGameInningTeamBatter(Guid gameInningTeamId, int sequence)
{
IGameInningTeamBatter gameInningTeamBatter = null;
using (var context = new Data.DartballContext())
{
var item = context.GameInningTeamBatters.FirstOrDefault(x => x.GameInningTeamId == gameInningTeamId.ToString() && x.Sequence == sequence);
if (item != null)
{
gameInningTeamBatter = Mapper.Map <GameInningTeamBatterDto>(item);
}
}
return(gameInningTeamBatter);
}
public List <ILeague> GetLeagues()
{
List <ILeague> leagues = new List <ILeague>();
using (var context = new Data.DartballContext())
{
var items = context.Leagues.ToList().Where(x => !x.DeleteDate.HasValue);
foreach (var item in items)
{
leagues.Add(Mapper.Map <LeagueDto>(item));
}
}
return(leagues);
}
public List <ITeamPlayerLineup> GetTeamLineup(Guid teamId)
{
List <ITeamPlayerLineup> teamPlayerLineups = new List <ITeamPlayerLineup>();
using (var context = new Data.DartballContext())
{
var items = context.TeamPlayerLineups.Where(x => x.TeamId == teamId.ToString() && !x.DeleteDate.HasValue).OrderBy(x => x.BattingOrder).ToList();
foreach (var item in items)
{
teamPlayerLineups.Add(Mapper.Map <TeamPlayerLineupDto>(item));
}
}
return(teamPlayerLineups);
}
public ILeague GetLeague(Guid leagueId)
{
ILeague league = null;
using (var context = new Data.DartballContext())
{
var item = context.Leagues.FirstOrDefault(x => x.LeagueId == leagueId.ToString());
if (item != null)
{
league = Mapper.Map <LeagueDto>(item);
}
}
return(league);
}
public ChangeResult Remove(Guid gameInningTeamId, int sequence)
{
ChangeResult result = new ChangeResult();
using (var context = new Data.DartballContext())
{
var item = context.GameInningTeamBatters.FirstOrDefault(x => x.GameInningTeamId == gameInningTeamId.ToString() && x.Sequence == sequence);
if (item != null)
{
context.GameInningTeamBatters.Remove(item);
context.SaveChanges();
}
}
return(result);
}
public ITeam GetTeam(Guid teamId)
{
ITeam team = null;
using (var context = new Data.DartballContext())
{
var item = context.Teams.FirstOrDefault(x => x.TeamId == teamId.ToString());
if (item != null)
{
team = Mapper.Map <TeamDto>(item);
}
}
return(team);
}
public ChangeResult Remove(Guid gameId, int inningNumber)
{
ChangeResult result = new ChangeResult();
using (var context = new Data.DartballContext())
{
var item = context.GameInnings.FirstOrDefault(x => x.GameId == gameId.ToString() && x.InningNumber == inningNumber);
if (item != null)
{
context.GameInnings.Remove(item);
context.SaveChanges();
}
}
return(result);
}
public List <IPlayerTeam> GetTeamPlayers(Guid teamId)
{
List <IPlayerTeam> playerTeams = new List <IPlayerTeam>();
using (var context = new Data.DartballContext())
{
var items = context.PlayerTeams.Where(x => x.TeamId == teamId.ToString() && !x.DeleteDate.HasValue).ToList();
foreach (var item in items)
{
playerTeams.Add(Mapper.Map <PlayerTeamDto>(item));
}
}
return(playerTeams);
}
public IGameTeam GetGameTeam(Guid gameId, Guid teamId)
{
IGameTeam gameTeam = null;
using (var context = new Data.DartballContext())
{
var item = context.GameTeams.FirstOrDefault(x => x.GameId == gameId.ToString() && x.TeamId == teamId.ToString());
if (item != null)
{
gameTeam = Mapper.Map <GameTeamDto>(item);
}
}
return(gameTeam);
}
public ChangeResult Remove(Guid gameId, Guid teamId)
{
ChangeResult result = new ChangeResult();
using (var context = new Data.DartballContext())
{
var item = context.GameTeams.FirstOrDefault(x => x.GameId == gameId.ToString() && x.TeamId == teamId.ToString());
if (item != null)
{
context.GameTeams.Remove(item);
context.SaveChanges();
}
}
return(result);
}
public IPlayer GetPlayer(Guid playerId)
{
IPlayer player = null;
using (var context = new Data.DartballContext())
{
var item = context.Players.FirstOrDefault(x => x.PlayerId == playerId.ToString());
if (item != null)
{
player = Mapper.Map <PlayerDto>(item);
}
}
return(player);
}
public ChangeResult RemoveLeague(Guid leagueAltenateKey)
{
ChangeResult result = new ChangeResult();
using (var context = new Data.DartballContext())
{
var item = context.Leagues.FirstOrDefault(x => x.LeagueId == leagueAltenateKey.ToString());
if (item != null)
{
context.Leagues.Remove(item);
context.SaveChanges();
}
}
return(result);
}
public ChangeResult Remove(Guid playerId)
{
ChangeResult result = new ChangeResult();
using (var context = new Data.DartballContext())
{
var item = context.Players.FirstOrDefault(x => x.PlayerId == playerId.ToString());
if (item != null)
{
context.Players.Remove(item);
context.SaveChanges();
}
}
return(result);
}
