public void DeleteTeam(int id) { using (var dbContext = new RosterManagerDataContext()) { var unwantedTeam = (from team in dbContext.Teams where team.teamId == id select team).First(); var unwantedImage = unwantedTeam.Image; if (unwantedImage != null) { dbContext.Images.DeleteOnSubmit(unwantedImage); } foreach (var player in unwantedTeam.Players) { dbContext.Players.DeleteOnSubmit(player); } foreach (var stat in unwantedTeam.Stats) { dbContext.Stats.DeleteOnSubmit(stat); } dbContext.Teams.DeleteOnSubmit(unwantedTeam); dbContext.SubmitChanges(); } }
public void EditPlayer(PlayerModel player) { using (var dbContext = new RosterManagerDataContext()) { var dbPlayer = (from p in dbContext.Players where p.playerId == player.PlayerId select p).First(); if (player.AvatarImageFile != null) { var unwantedImage = dbPlayer.Image; if (unwantedImage != null) { dbContext.Images.DeleteOnSubmit(unwantedImage); } dbPlayer.Image = new Image() { imageFileName = player.AvatarImageFile.FileName, imageContent = ImageController.ConvertToBytes(player.AvatarImageFile), imageContentType = player.AvatarImageFile.ContentType, }; } dbPlayer.playerFirstName = player.FirstName; dbPlayer.playerLastName = player.LastName; dbPlayer.playerScreenName = player.ScreenName; dbPlayer.teamId = player.TeamId; dbContext.SubmitChanges(); } }
public void AddStat(Stat stat) { using (var dbContext = new RosterManagerDataContext()) { dbContext.Stats.InsertOnSubmit(stat); dbContext.SubmitChanges(); } }
public void AddPlayer(Player player) { using (var dbContext = new RosterManagerDataContext()) { dbContext.Players.InsertOnSubmit(player); dbContext.SubmitChanges(); } }
public Image GetImageById(int imageId) { var dbContext = new RosterManagerDataContext(); var result = (from image in dbContext.Images where image.imageId == imageId select image).First(); return(result); }
public void AddTeam(Team team) { using (var dbContext = new RosterManagerDataContext()) { dbContext.Teams.InsertOnSubmit(team); dbContext.SubmitChanges(); } }
public Player GetPlayerById(int id) { var dbContext = new RosterManagerDataContext(); var player = (from p in dbContext.Players where p.playerId == id select p).First(); return(player); }
public Team GetTeamByID(int id) { var dbContext = new RosterManagerDataContext(); var result = (from team in dbContext.Teams where team.teamId == id select team).First(); return(result); }
public Stat GetStatById(int id) { var dbContext = new RosterManagerDataContext(); var stat = (from s in dbContext.Stats where s.statId == id select s).First(); return(stat); }
public IEnumerable <Player> GetPlayers() { var dbContext = new RosterManagerDataContext(); var players = from player in dbContext.Players orderby player.playerScreenName select player; return(players); }
public IEnumerable <Stat> GetStatsByEntity(int entityId) { var dbContext = new RosterManagerDataContext(); var stats = from stat in dbContext.Stats where stat.entityId == entityId orderby stat.statName select stat; return(stats); }
public void DeleteImage(int imageId) { using (var dbContext = new RosterManagerDataContext()) { var unwantedImage = (from image in dbContext.Images where image.imageId == imageId select image).First(); dbContext.Images.DeleteOnSubmit(unwantedImage); dbContext.SubmitChanges(); } }
public IEnumerable <Team> GetTeams() { var dbContext = new RosterManagerDataContext(); var teams = from team in dbContext.Teams join image in dbContext.Images on team.imageId equals image.imageId into teamImage from subTeam in teamImage.DefaultIfEmpty() orderby team.teamName select team; return(teams); }
public void DeleteStat(int statId) { using (var dbContext = new RosterManagerDataContext()) { var dbStat = (from s in dbContext.Stats where s.statId == statId select s).First(); dbContext.Stats.DeleteOnSubmit(dbStat); dbContext.SubmitChanges(); } }
public void EditStat(StatModel stat) { using (var dbContext = new RosterManagerDataContext()) { var dbStat = (from s in dbContext.Stats where s.statId == stat.StatId select s).First(); dbStat.statName = stat.Name; dbStat.statValue = stat.Value; dbContext.SubmitChanges(); } }
public void EditTeam(TeamModel team) { using (var dbContext = new RosterManagerDataContext()) { var dbTeam = dbContext.Teams.Single(t => t.teamId == team.TeamId); if (team.BannerImageFile != null) { var unwantedImage = dbTeam.Image; dbContext.Images.DeleteOnSubmit(unwantedImage); dbTeam.Image = new Image() { imageFileName = team.BannerImageFile.FileName, imageContent = ImageController.ConvertToBytes(team.BannerImageFile), imageContentType = team.BannerImageFile.ContentType, }; } dbTeam.teamName = team.Name; dbContext.SubmitChanges(); } }
public void DeletePlayer(int playerId) { using (var dbContext = new RosterManagerDataContext()) { var unwantedPlayer = (from player in dbContext.Players where player.playerId == playerId select player).First(); var unwantedImage = unwantedPlayer.Image; if (unwantedImage != null) { dbContext.Images.DeleteOnSubmit(unwantedImage); } foreach (var stat in unwantedPlayer.Stats) { dbContext.Stats.DeleteOnSubmit(stat); } dbContext.Players.DeleteOnSubmit(unwantedPlayer); dbContext.SubmitChanges(); } }