public HttpResponseMessage Get()
{
using (GameDBEntities entities = new GameDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.Games.ToList()));
}
}
public async Task <List <QuestionOptionView> > QuestionOptions()
{
using (GameDBEntities db = new GameDBEntities())
{
var questionOptions = new List <QuestionOptionView>().ToList();
var result = from qo in db.QuestionOptions
join q in db.Questions on qo.QuestionID equals q.QuestionID
join o in db.Options on qo.OptionID equals o.OptionID
select new
{
qo.QuestionOptionID,
qo.QuestionID,
qo.OptionID,
qo.AnswerStatus,
qo.AnswerText,
q.QuestionName,
o.OptionName
};
foreach (var que in result)
{
questionOptions.Add(new QuestionOptionView
{
QuestionID = que.QuestionID,
OptionID = que.OptionID,
QuestionOptionID = que.QuestionOptionID,
AnswerStatus = que.AnswerStatus,
AnswerText = que.AnswerText,
QuestionName = que.QuestionName,
OptionName = que.OptionName
});
}
return(questionOptions);
}
}
public async Task <List <RankViewModel> > Ranks()
{
using (GameDBEntities db = new GameDBEntities())
{
var rank = new List <RankViewModel>().ToList();
var result = from r in db.Rankings
join u in db.Users on r.UserID equals u.UserID
join p in db.Prizes on r.PrizeId equals p.PrizeID
select new
{
r.RankingID,
r.PrizeId,
r.UserID,
u.UserName,
p.PrizeTotal
};
foreach (var ranking in result)
{
rank.Add(new RankViewModel
{
RankingID = ranking.RankingID,
PrizeId = ranking.PrizeId,
UserID = ranking.UserID,
Username = ranking.UserName,
PrizeTotal = Convert.ToInt32(ranking.PrizeTotal)
});
}
return(rank);
}
}
public HttpResponseMessage Post([FromBody] Game gamematch)
{
using (GameDBEntities entities = new GameDBEntities())
{
entities.Games.Add(gamematch);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, new Uri(Request.RequestUri + "/" + gamematch.ID.ToString())));
}
}
public HttpResponseMessage Get(int selectID)
{
using (GameDBEntities entities = new GameDBEntities())
{
Game gamematch = entities.Games.FirstOrDefault(g => g.ID.Equals(selectID));
if (gamematch != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, gamematch));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, String.Format("Game match with ID {0} not found", selectID)));
}
}
}
public HttpResponseMessage GetByPlayer(string player)
{
using (GameDBEntities entities = new GameDBEntities())
{
List <Game> gameList = entities.Games
.Where(g => g.Player1.ToLower().StartsWith(player.ToLower()) || g.Player2.ToLower().StartsWith(player.ToLower())).ToList();
if (gameList.Count > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, gameList));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, String.Format("The parameters requested are not found")));
}
}
}
public HttpResponseMessage Delete(int id)
{
using (GameDBEntities entities = new GameDBEntities())
{
Game gamematch = entities.Games.FirstOrDefault(g => g.ID == id);
if (gamematch != null)
{
entities.Games.Remove(gamematch);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Accepted, String.Format("Game match with ID {0} was deleted", id)));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, String.Format("Game match with ID {0} not found", id)));
}
}
}
public HttpResponseMessage Put(int id, [FromBody] Game gamematch)
{
using (GameDBEntities entities = new GameDBEntities())
{
Game gameToUpdate = entities.Games.FirstOrDefault(g => g.ID == id);
if (gameToUpdate != null)
{
gameToUpdate.GameType = gamematch.GameType;
gameToUpdate.Player1 = gamematch.Player1;
gameToUpdate.Player2 = gamematch.Player2;
gameToUpdate.Winner_Is = gamematch.Winner_Is;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Accepted, gamematch));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, String.Format("Game match with ID {0} not found", id)));
}
}
}
public HttpResponseMessage GetBySearch([FromUri] int id = -1, [FromUri] string gameType = null, [FromUri] string player1 = null,
[FromUri] string player2 = null, [FromUri] string winner_is = null)
{
using (GameDBEntities entities = new GameDBEntities())
{
IQueryable <Game> gameMatch = entities.Games;
if (id != -1)
{
gameMatch = gameMatch.Where(g => g.ID == id);
}
if (gameType != null)
{
gameMatch = gameMatch.Where(g => g.GameType.ToLower().StartsWith(gameType.ToLower()));
}
if (player1 != null)
{
gameMatch = gameMatch.Where(g => g.Player1.ToLower().StartsWith(player1.ToLower()));
}
if (player2 != null)
{
gameMatch = gameMatch.Where(g => g.Player2.ToLower().StartsWith(player2.ToLower()));
}
if (winner_is != null)
{
gameMatch = gameMatch.Where(g => g.Winner_Is.ToLower().StartsWith(winner_is.ToLower()));
}
List <Game> SearchResult = gameMatch.ToList();
if (SearchResult.Count > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, SearchResult));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "The parameters requested are not found"));
}
}
}
