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")); } } }