public void DeleteStadium(StadiumDomainModel stadium)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cStadium = (from n in context.Stadia where n.StadiumID == stadium.StadiumID select n).FirstOrDefault();
context.Stadia.Remove(cStadium);
context.SaveChanges();
}
}
public void DeletePlayer(PlayerDomainModel player)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cPlayer = (from n in context.Players where n.PlayerGUID == player.PlayerGUID select n).FirstOrDefault();
context.Players.Remove(cPlayer);
context.SaveChanges();
}
}
public void DeleteSeason(SeasonDomainModel season)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cSeason = (from n in context.Seasons where n.SeasonID == season.SeasonID select n).FirstOrDefault();
context.Seasons.Remove(cSeason);
context.SaveChanges();
}
}
public void DeletePositionType(PositionTypeDomanModel positionType)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cPositionType = (from n in context.PositionTypes where n.PositionTypeID == positionType.PositionTypeID select n).FirstOrDefault();
context.PositionTypes.Remove(cPositionType);
context.SaveChanges();
}
}
public void DeletePosition(PositionDomainModel position)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cPosition = (from n in context.Positions where n.PositionID == position.PositionID select n).FirstOrDefault();
context.Positions.Remove(cPosition);
context.SaveChanges();
}
}
public void UpdatePositionType(PositionTypeDomanModel positionType)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cpositionType = context.PositionTypes.Find(positionType.PositionTypeID);
if (_cpositionType != null)
{
_cpositionType.PositionTypeDescr = positionType.PositionTypeDescr;
context.SaveChanges();
}
}
}
public void UpdatePlayer(PlayerDomainModel player)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cPlayer = context.Players.Find(player.PlayerGUID);
if (cPlayer != null)
{
cPlayer.PlayerName = player.PlayerName;
cPlayer.PlayerImage = player.PlayerImage;
context.SaveChanges();
}
}
}
public void UpdateStadium(StadiumDomainModel stadium)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cstadium = context.Stadia.Find(stadium.StadiumID);
if (cstadium != null)
{
cstadium.StadiumName = stadium.StadiumName;
cstadium.Active_Flg = stadium.Active_Flg;
cstadium.StadiumImage = stadium.StadiumImage;
context.SaveChanges();
}
}
}
public void UpdatePosition(PositionDomainModel position)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cPosition = context.Positions.Find(position.PositionID);
if (cPosition != null)
{
cPosition.PositionName = position.PositionName;
cPosition.MaxCount = position.MaxCount;
cPosition.PositionNameLong = position.PositionNameLong;
context.SaveChanges();
}
}
}
public void InsertPlayerPosition(PlayerPositionDomainModel _playerPosition)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cPlayerPosition = new PlayerPosition
{
PlayerGUID = _playerPosition.PlayerGUID,
PrimaryPositionID = Convert.ToInt32(_playerPosition.PrimaryPositionID),
SecondaryPostiionID = _playerPosition.SecondaryPostiionID
};
context.PlayerPositions.Add(_cPlayerPosition);
context.SaveChanges();
}
}
public void DraftPlayer(SeasonTeamPlayerDomainModel STP)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cSTP = new SeasonTeamPlayer
{
PlayerGUID = STP.PlayerGUID,
SeasonID = STP.SeasonID,
TeamID = STP.TeamID,
Points = STP.Points
};
context.SeasonTeamPlayers.Add(_cSTP);
context.SaveChanges();
}
}
public void InsertSeasonTeam(SeasonTeamDomainModel _SeasonTeam)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cSeasonTeam = new SeasonTeam
{
SeasonID = _SeasonTeam.SeasonID,
TeamID = _SeasonTeam.TeamID,
ActiveFlg = _SeasonTeam.ActiveFlg,
StadiumOrder = _SeasonTeam.StadiumOrder
};
context.SeasonTeams.Add(cSeasonTeam);
context.SaveChanges();
}
}
public void UpdateTeam(TeamDomainModel team)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cTeam = context.Teams.Find(team.TeamID);
if (cTeam != null)
{
cTeam.OwnerEmail = team.OwnerEmail;
cTeam.OwnerName = team.OwnerName;
cTeam.OwnerUserID = team.OwnerUserID;
cTeam.TeamName = team.TeamName;
cTeam.TeamImage = team.TeamImage;
context.SaveChanges();
}
}
}
public void InsertStatValue(SeasonPlayerPositionStatDomainModel statvalue)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cStatVal = new SeasonPlayerPositionStat
{
SeasonID = statvalue.SeasonID,
PlayerGUID = (Guid)statvalue.PlayerGUID,
PositionID = statvalue.PositionID,
StatID = statvalue.StatID,
StatValue = statvalue.StatValue
};
context.SeasonPlayerPositionStats.Add(_cStatVal);
context.SaveChanges();
}
}
public void UpdateSeason(SeasonDomainModel season)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cSeason = context.Seasons.Find(season.SeasonID);
if (cSeason != null)
{
cSeason.SeasonName = season.SeasonName;
cSeason.DraftDate = season.DraftDate;
cSeason.MinBid = season.MinBid;
cSeason.Active = season.Active;
cSeason.CurrentSeason = season.CurrentSeason;
cSeason.StartPoints = season.StartPoints;
context.SaveChanges();
}
}
}
public PositionTypeDomanModel InsertPositionType(PositionTypeDomanModel positionType)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cpositionType = new PositionType
{
PositionTypeDescr = positionType.PositionTypeDescr
};
context.PositionTypes.Add(_cpositionType);
context.SaveChanges();
// pass VolID back to BLL
positionType.PositionTypeID = _cpositionType.PositionTypeID;
return(positionType);
}
}
public void UpdatePlayerPosition(PlayerPositionDomainModel _playerPosition)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cplayerPosition = context.PlayerPositions.Find(_playerPosition.PlayerGUID);
if (cplayerPosition != null)
{
cplayerPosition.PlayerGUID = _playerPosition.PlayerGUID;
cplayerPosition.PrimaryPositionID = Convert.ToInt32(_playerPosition.PrimaryPositionID);
cplayerPosition.SecondaryPostiionID = _playerPosition.SecondaryPostiionID;
context.SaveChanges();
}
else
{
InsertPlayerPosition(_playerPosition);
}
}
}
public StatDomainModel InsertStat(StatDomainModel stat)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cStat = new Stat
{
StatName = stat.StatName,
PositionTypeID = stat.PositionTypeID
};
context.Stats.Add(_cStat);
context.SaveChanges();
// pass TeamID back to BLL
stat.StatID = _cStat.StatID;
return(stat);
}
}
public PlayerDomainModel InsertPlayer(PlayerDomainModel player)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cPlayer = new Player
{
PlayerName = player.PlayerName,
PlayerImage = player.PlayerImage
};
context.Players.Add(_cPlayer);
context.SaveChanges();
// pass TeamID back to BLL
player.PlayerGUID = _cPlayer.PlayerGUID;
return(player);
}
}
public void UpdateTrade(TradeDomainModel Trade)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cTrade = context.Trades.Find(Trade.TradeGUID);
if (cTrade != null)
{
cTrade.ActionDate = Trade.ActionDate;
cTrade.ProposedDate = Trade.ProposedDate;
cTrade.SeasonID = Trade.SeasonID;
cTrade.TeamID = Trade.TeamID;
cTrade.TradeGUID = Trade.TradeGUID;
cTrade.TradeStatusID = Trade.TradeStatusID;
context.SaveChanges();
}
}
#endregion
}
public StadiumDomainModel InsertStadium(StadiumDomainModel stadium)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cStadium = new Stadium
{
StadiumName = stadium.StadiumName,
Active_Flg = stadium.Active_Flg,
StadiumImage = stadium.StadiumImage
};
context.Stadia.Add(_cStadium);
context.SaveChanges();
// pass StadiumID back to BLL
stadium.StadiumID = _cStadium.StadiumID;
return(stadium);
}
}
public PositionDomainModel InsertPosition(PositionDomainModel position)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cPosition = new Position
{
MaxCount = position.MaxCount,
PositionName = position.PositionName,
PositionNameLong = position.PositionNameLong,
PositionTypeID = position.PositionTypeID
};
context.Positions.Add(_cPosition);
context.SaveChanges();
// pass TeamID back to BLL
position.PositionID = _cPosition.PositionID;
return(position);
}
}
public TeamDomainModel InsertTeam(TeamDomainModel team)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cTeam = new Team
{
TeamName = team.TeamName,
OwnerEmail = team.OwnerEmail,
OwnerUserID = team.OwnerUserID,
OwnerName = team.OwnerName,
TeamImage = team.TeamImage
};
context.Teams.Add(_cTeam);
context.SaveChanges();
// pass TeamID back to BLL
team.TeamID = _cTeam.TeamID;
return(team);
}
}
public TradeDomainModel InsertTrade(TradeDomainModel Trade)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cTrade = new Trade
{
ActionDate = Trade.ActionDate,
ProposedDate = Trade.ProposedDate,
SeasonID = Trade.SeasonID,
TeamID = Trade.TeamID,
TradeStatusID = Trade.TradeStatusID
};
context.Trades.Add(_cTrade);
context.SaveChanges();
// pass TeamID back to BLL
Trade.TradeGUID = _cTrade.TradeGUID;
return(Trade);
}
}
public SeasonDomainModel InsertSeason(SeasonDomainModel season)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cSeason = new Season
{
SeasonName = season.SeasonName,
DraftDate = season.DraftDate,
StartPoints = season.StartPoints,
MinBid = season.MinBid,
Active = season.Active,
CurrentSeason = season.CurrentSeason
};
context.Seasons.Add(_cSeason);
context.SaveChanges();
// pass VolID back to BLL
season.SeasonID = _cSeason.SeasonID;
return(season);
}
}
