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