private List <T002_Player> getRawPlayers()
{
using (var dbc = new TeamDBEntities())
{
return(dbc.T002_Player.ToList());
}
}
public List <T001_Teams> getTeams()
{
using (var dbc = new TeamDBEntities())
{
return(dbc.T001_Teams.ToList());
}
}
public T003_Event getEventById(int id)
{
using (var dbc = new TeamDBEntities())
{
return(dbc.T003_Event.Where(ev => ev.Id == id).First());
}
}
public List <T003_Event> GetEvents()
{
using (var dbc = new TeamDBEntities())
{
return(dbc.T003_Event.ToList());
}
}
public IEnumerable <T004_Match> GetAllMatches()
{
using (var dbc = new TeamDBEntities())
{
return(dbc.T004_Match.ToList());
}
}
public void DeleteEvent(int id)
{
using (var dbc = new TeamDBEntities())
{
var ev = dbc.T003_Event.Where(e => e.Id == id).First();
dbc.T003_Event.Remove(ev);
}
}
public void CreateEvent(T003_Event ev)
{
using (var dbc = new TeamDBEntities())
{
dbc.T003_Event.Add(ev);
dbc.SaveChanges();
}
}
public void Create(T002_Player player, string imageUrl)
{
using (var dbc = new TeamDBEntities())
{
dbc.T002_Player.Add(player);
dbc.SaveChanges();
}
ss.UploadElement(imageUrl, player.Id);
}
public void Delete(int Id)
{
T002_Player player;
using (var dbc = new TeamDBEntities())
{
player = dbc.T002_Player.Where(p => p.Id == Id).First();
dbc.T002_Player.Remove(player);
dbc.SaveChanges();
}
}
public void Edit(EditPlayer editPlayer)
{
T002_Player player;
using (var dbc = new TeamDBEntities())
{
player = dbc.T002_Player.Where(p => p.Id == editPlayer.Id).First();
player.Surname = editPlayer.Surname;
player.Prename = editPlayer.Prename;
player.Number = editPlayer.Number;
player.TeamId = editPlayer.TeamId;
dbc.SaveChanges();
}
}
public DisplayPlayer GetDisplayPlayer(int id)
{
DisplayPlayer displayPlayer = new DisplayPlayer();
T002_Player rawPlayer = new T002_Player();
using (var dbc = new TeamDBEntities())
{
rawPlayer = dbc.T002_Player.Where(p => p.Id == id).First();
}
displayPlayer.importRawPlayer(rawPlayer);
displayPlayer.TeamName = ts.getTeamNameById(rawPlayer.TeamId);
displayPlayer.profilePictureURL = ss.getURL(rawPlayer.Id.ToString());
return(displayPlayer);
}
