public IHttpActionResult GetTeams(int tournamentId, int matchId)
{
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
List <Team> allTeams = DatabaseAccessModel.GetTeamListByMatchId(matchId).ToList();
if (allTeams.Any())
{
return(Content(HttpStatusCode.OK, allTeams));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Teams for specific tournament and match not found."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Match with id " + matchId + " not found in tournament match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult Authenticate(User user)
{
var loginRequest = new User
{
Username = user.Username,
Password = user.Password
};
User databaseUser;
if (user != null)
{
databaseUser = DatabaseAccessModel.GetUserByUsername(loginRequest.Username);
var isUsernamePasswordValid = SecurePasswordHasher.Verify(loginRequest.Password, databaseUser.Password);
if (isUsernamePasswordValid)
{
//loginRequest.id = databaseUser.id;
loginRequest.Role = databaseUser.Role;
//var token = CreateToken(loginRequest.Username);
var token = CreateToken(loginRequest.Role, loginRequest.Username);
return(Ok(token));
}
}
return(Unauthorized());
}
public IHttpActionResult DeleteUser(int id)
{
if (DatabaseAccessModel.GetUserByUsername(Thread.CurrentPrincipal.Identity.Name).id != id && !Thread.CurrentPrincipal.IsInRole(UserRoles.Admin))
{
return(Content(HttpStatusCode.Forbidden, new Error
{
Message = "Your id doesn't match with this user.",
Code = HttpStatusCode.Forbidden.ToString()
}));
}
if (DatabaseAccessModel.CheckUserExists(id))
{
try
{
if (DatabaseAccessModel.DeleteUser(id))
{
return(Ok());
}
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
return(Content(HttpStatusCode.NotAcceptable, ex.Message));
}
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "User with id " + id + " not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult GetMatchById(int tournamentId, int matchId)
{
//select from match sujungto su tournament kur match>fk_tourId = tourId
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
Match match = DatabaseAccessModel.GetMatchDataListFromSqlbyId(matchId);
if (match.id != null)
{
return(Content(HttpStatusCode.OK, match));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Matches for specified tournament with id " + tournamentId + " not found."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "No match found with id " + matchId + " in tournament with id " + tournamentId + "."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult RegisterUser(int tournamentId, Match match)
{
//check if tournament by tournamentID exists and create a match with fk_tour = tourId
if (!ModelState.IsValid)
{
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid Data",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.AddNewMatchToDatabaseByTournament(match, tournamentId))
{
return(Ok(match));
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid team data/could not insert.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult DeleteUser(int tournamentId, int matchId)
{
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
try
{
if (DatabaseAccessModel.DeleteMatchFromTournament(matchId))
{
return(Ok());
}
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
return(Content(HttpStatusCode.NotAcceptable, ex.Message));
}
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Match with id " + matchId + " not found in tournament match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult GetUserById(int id)
{
User user = DatabaseAccessModel.GetUserDataListFromSqlById(id);
if (user.id != null)
{
return(Ok(user));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "User with id " + id + " not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult GetUsers()
{
List <User> allUsers = DatabaseAccessModel.GetUserDataListFromSql().ToList();
if (allUsers.Any())
{
return(Content(HttpStatusCode.OK, allUsers));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "Users not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult GetTournaments()
{
List <Tournament> allTournaments = DatabaseAccessModel.GetTournamentListFromSql().ToList();
if (allTournaments.Any())
{
return(Content(HttpStatusCode.OK, allTournaments));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "Tournaments not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult GetTournamentById(int id)
{
Tournament tournament = DatabaseAccessModel.GetTournamentListFromSqlbyId(id);
if (tournament.id != null)
{
return(Ok(tournament));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "Tournament with id " + id + " not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult DeleteTournament(int tournamentId)
{
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
try
{
if (DatabaseAccessModel.DeleteTournament(tournamentId))
{
return(Ok());
}
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
return(Content(HttpStatusCode.NotAcceptable, ex.Message));
}
}
return(Ok());
}
public IHttpActionResult PutUser(int tournamentId, int matchId, int teamId, Team team)
{
//if (!ModelState.IsValid)
//{
// return Content(HttpStatusCode.BadRequest, new Error
// {
// Message = "Invalid Data",
// Code = HttpStatusCode.BadRequest.ToString()
// });
//}
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
if (DatabaseAccessModel.CheckTeamInMatchExists(matchId, teamId))
{
if (DatabaseAccessModel.UpdateTeamToDatabase(teamId, team))
{
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Invalid team data/could not update."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Team with id " + teamId + " not found in match " + matchId + " team list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Match with id " + matchId + " not found in tournament match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult UserTeamCreate(int userId, Team team)
{
if (DatabaseAccessModel.CheckUserExists(userId))
{
if (DatabaseAccessModel.AddTeamToDatabaseByUser(team, userId))
{
return(Ok(team));
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Code = HttpStatusCode.BadRequest.ToString(),
Message = "Invalid team data/could not insert."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "User with id " + userId + " not found."
}));
}
public IHttpActionResult putTournament(Tournament tournament, int id)
{
if (DatabaseAccessModel.CheckTournamentExists(id))
{
if (DatabaseAccessModel.UpdateTournamentToDatabase(id, tournament))
{
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid tournament data/could not update.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "Tournament with id " + id + " not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult AddTournament(Tournament tournament)
{
if (!ModelState.IsValid)
{
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid data.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
if (DatabaseAccessModel.AddTournamentToDatabase(tournament))
{
return(Ok(tournament));
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid tournament data/could not insert.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
public IHttpActionResult getUserTeam(int userId)
{
if (DatabaseAccessModel.CheckUserExists(userId))
{
Team userTeam = DatabaseAccessModel.GetTeamByOwner(userId);
if (userTeam.id != null)
{
return(Ok(userTeam));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "No team ownership of user with id " + userId + " found."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "User with id " + userId + " not found."
}));
}
public IHttpActionResult RegisterUser(User user)
{
if (!ModelState.IsValid)
{
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid data.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
user.Password = SecurePasswordHasher.Hash(user.Password);
if (DatabaseAccessModel.AddUserToDatabase(user))
{
return(Ok(User));
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid user data/could not insert.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
public IHttpActionResult GetMatchesByTournamentId(int tournamentId)
{
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
List <Match> allMatches = DatabaseAccessModel.GetMatchListByTournamentId(tournamentId).ToList();
if (allMatches.Any())
{
return(Content(HttpStatusCode.OK, allMatches));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Matches for tournament with id " + tournamentId + " not found."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult PutMatch(int tournamentId, int matchId, Match match)
{
//check if tournament with id exists
//check if match with id exists
//update match by id
//if (!ModelState.IsValid)
//{
// return Content(HttpStatusCode.BadRequest, new Error
// {
// Message = "Invalid Data",
// Code = HttpStatusCode.BadRequest.ToString()
// });
//}
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
if (DatabaseAccessModel.UpdateMatchToDatabase(matchId, match))
{
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Invalid team data/could not update."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Match with id " + matchId + " not found in tournament match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult PutUser(int id, User user)
{
//var a = Thread.CurrentPrincipal.Identity.Name;
if (DatabaseAccessModel.GetUserByUsername(Thread.CurrentPrincipal.Identity.Name).id != id && !Thread.CurrentPrincipal.IsInRole(UserRoles.Admin))
{
return(Content(HttpStatusCode.Forbidden, new Error
{
Message = "Your id doesn't match with this user.",
Code = HttpStatusCode.Forbidden.ToString()
}));
}
if (!ModelState.IsValid)
{
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid data.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
if (DatabaseAccessModel.CheckUserExists(id))
{
//user.Password = SecurePasswordHasher.Hash(user.Password);
if (DatabaseAccessModel.UpdateUserToDatabase(user, id))
{
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid user data/could not update.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Message = "User with id " + id + " not found.",
Code = HttpStatusCode.NotFound.ToString()
}));
}
public IHttpActionResult AddUserToTeam(int userId, int teamId)
{
//teamid owner - principal user id
if (DatabaseAccessModel.GetUserByUsername(Thread.CurrentPrincipal.Identity.Name).id != (DatabaseAccessModel.GetTeamById(teamId)).ownerId && !Thread.CurrentPrincipal.IsInRole(UserRoles.Admin))
{
return(Content(HttpStatusCode.Forbidden, new Error
{
Message = "Your id doesn't match with this user.",
Code = HttpStatusCode.Forbidden.ToString()
}));
}
if (DatabaseAccessModel.CheckTeamExists(teamId))
{
if (DatabaseAccessModel.CheckUserExists(userId))
{
if (DatabaseAccessModel.AddUserToTeam(userId, teamId))
{
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Code = HttpStatusCode.BadRequest.ToString(),
Message = "Bad data/could not update."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "User with id " + userId + " not found."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Team with id " + teamId + " not found."
}));
}
public IHttpActionResult GetTeamById(int tournamentId, int matchId, int teamId)
{
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
if (DatabaseAccessModel.CheckTeamInMatchExists(matchId, teamId))
{
Team team = DatabaseAccessModel.GetTeamDataListFromSqlbyId(teamId);
if (team.id != null)
{
return(Content(HttpStatusCode.OK, team));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Teams for specific tournament and match not found."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Team with id " + teamId + " not found in match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Match with id " + matchId + " not found in tournament match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
public IHttpActionResult AddTeam(int tournamentId, int matchId, Team team)
{
if (!ModelState.IsValid)
{
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid Data",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
if (DatabaseAccessModel.CheckTournamentExists(tournamentId))
{
if (DatabaseAccessModel.CheckMatchInTournamentExists(tournamentId, matchId))
{
if (DatabaseAccessModel.AddTeamToDatabaseByMatch(team, matchId))
{
return(Ok(team));
}
return(Content(HttpStatusCode.BadRequest, new Error
{
Message = "Invalid team data/could not insert.",
Code = HttpStatusCode.BadRequest.ToString()
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Match with id " + matchId + " not found in tournament match list."
}));
}
return(Content(HttpStatusCode.NotFound, new Error
{
Code = HttpStatusCode.NotFound.ToString(),
Message = "Tournament with id " + tournamentId + " not found."
}));
}
