public TeamPlayer AddTeamPlayer(int TeamId, int PlayerId)
{
TeamPlayer tp = new TeamPlayer {
TeamId = TeamId, PlayerId = PlayerId
};
ctx.TeamPlayer.Add(tp);
try
{
ctx.SaveChanges();
return(tp);
}
catch (DbUpdateException e)
{
throw e;
}
}
public Team AddTeam(Team t)
{
t.Id = t.UserId;
ctx.Team.Add(t);
ctx.Database.OpenConnection();
// Disable identity column temporarily to allow teamid = userid, then re-enable.
try
{
ctx.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Team ON");
ctx.SaveChanges();
ctx.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Team OFF");
}
finally
{
ctx.Database.CloseConnection();
}
return(t);
}
public int RegisterUser(User u)
{
// hash the user password
u.Password = BCrypt.Net.BCrypt.HashPassword(u.Password);
try
{
ctx.User.Add(u);
ctx.SaveChanges();
return(u.Id);
}
catch (Exception ex)
{
throw ex;
}
}
public Club AddClub(Club c)
{
ctx.Club.Add(c);
ctx.SaveChanges();
return(c);
}
// Player Service methods
public Player AddPlayer(Player p)
{
ctx.Player.Add(p);
ctx.SaveChanges();
return(p);
}