public static Player find(int playerId) {
try
{
var context = new CurseDBDataContext();
return context.Players.SingleOrDefault(p => p.id == playerId);
}
catch (Exception ex)
{
throw ex;
}
}
public static Team find(int teamId) {
try
{
var context = new CurseDBDataContext();
return context.Teams.SingleOrDefault(t => t.id == teamId);
}
catch (Exception ex)
{
throw ex;
}
}
public static List<Team> list()
{
try
{
var context = new CurseDBDataContext();
var result = (from t in context.Teams select t);
return result.ToList<Team>();
}
catch (Exception ex)
{
throw ex;
}
}
public static Team insert(String name)
{
try{
var context = new CurseDBDataContext();
var team = new Team() {
name = name
};
context.Teams.InsertOnSubmit(team);
context.SubmitChanges();
return team;
}catch(Exception ex){
throw ex;
}
}
public static void delete(int id)
{
try
{
var context = new CurseDBDataContext();
var team = context.Teams.Single(t => t.id == id);
if(team != null){
context.Teams.DeleteOnSubmit(team);
context.SubmitChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void delete(int id)
{
try
{
var context = new CurseDBDataContext();
var player = context.Players.Single(t => t.id == id);
if (player != null) {
context.Players.DeleteOnSubmit(player);
context.SubmitChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Team update(int id, String name)
{
try
{
var context = new CurseDBDataContext();
var team = context.Teams.Single(t => t.id == id);
if (team != null){
team.name = name;
context.SubmitChanges();
}
return team;
}
catch (Exception ex)
{
throw ex;
}
}
public static Player insert(string name, int gamesPlayed, int gamesWon, int kills, int deaths, int assists, int idTeam) {
try{
var context = new CurseDBDataContext();
var player = new Player() {
name = name,
games_played = gamesPlayed,
games_won = gamesWon,
kills = kills,
deaths = deaths,
assists = assists,
id_team = idTeam
};
context.Players.InsertOnSubmit(player);
context.SubmitChanges();
return player;
}catch(Exception ex){
throw ex;
}
}
public static Player update(int id, string name, int gamesPlayed, int gamesWon, int kills, int deaths, int assists)
{
try
{
var context = new CurseDBDataContext();
var player = context.Players.Single(p => p.id == id);
if (player != null) {
player.name = name;
player.games_played = gamesPlayed;
player.games_won = gamesWon;
player.kills = kills;
player.deaths = deaths;
player.assists = assists;
context.SubmitChanges();
}
return player;
}
catch (Exception ex)
{
throw ex;
}
}
public static List<Player> list(int teamId)
{
try
{
var context = new CurseDBDataContext();
var result = (from p in context.Players where p.id_team == teamId select p);
return result.ToList<Player>();
}
catch (Exception ex)
{
throw ex;
}
}
