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