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 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 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 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 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 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 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);
}
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 Update(List <IGameTeam> gameTeams)
{
var result = Validate(gameTeams, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in gameTeams)
{
context.GameTeams.Update(new Domain.GameTeam()
{
GameId = item.GameId.ToString(),
TeamId = item.TeamId.ToString(),
TeamBattingSequence = item.TeamBattingSequence,
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public ChangeResult Update(List <IGameInning> gameInnings)
{
var result = Validate(gameInnings, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in gameInnings)
{
context.GameInnings.Update(new Domain.GameInning()
{
GameInningId = item.GameInningId.ToString(),
GameId = item.GameId.ToString(),
InningNumber = item.InningNumber,
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public ChangeResult AddNew(List <ILeague> leagues)
{
var result = Validate(leagues);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var league in leagues)
{
context.Leagues.Add(new Domain.League()
{
Name = Helper.CleanString(league.Name),
LeagueId = league.LeagueId == Guid.Empty ? Guid.NewGuid().ToString() : league.LeagueId.ToString(),
Password = Helper.CleanString(league.Password), //TODO: add encryption
DeleteDate = null
});
}
context.SaveChanges();
}
}
return(result);
}
public ChangeResult Update(List <IPlayerTeam> playerTeams)
{
var result = Validate(playerTeams, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in playerTeams)
{
context.PlayerTeams.Update(new Domain.PlayerTeam()
{
PlayerTeamId = item.PlayerTeamId.ToString(),
PlayerId = item.PlayerId.ToString(),
TeamId = item.TeamId.ToString(),
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public ChangeResult Update(List <ITeamPlayerLineup> teamPlayerLineups)
{
var result = Validate(teamPlayerLineups, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in teamPlayerLineups)
{
context.TeamPlayerLineups.Update(new Domain.TeamPlayerLineup()
{
TeamId = item.TeamId.ToString(),
PlayerId = item.PlayerId.ToString(),
BattingOrder = item.BattingOrder,
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}
public ChangeResult Update(List <IGame> games)
{
var result = Validate(games, isAddNew: false);
if (result.IsSuccess)
{
using (var context = new Data.DartballContext())
{
foreach (var item in games)
{
context.Games.Update(new Domain.Game()
{
GameId = item.GameId == Guid.Empty ? Guid.NewGuid().ToString() : item.GameId.ToString(),
LeagueId = item.LeagueId.ToString(),
GameDate = item.GameDate,
DeleteDate = item.DeleteDate
});
}
context.SaveChanges();
}
}
return(result);
}