// GET api/Tornir public HttpResponseMessage Get() { using (TornirDBEntities entity = new TornirDBEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, entity.Tornirs.ToList())); } }
// POST api/Tornir public HttpResponseMessage Post([FromBody] Tornir value) { using (TornirDBEntities entity = new TornirDBEntities()) { entity.Tornirs.Add(value); entity.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, new Uri(Request.RequestUri + value.ID.ToString()))); } }
public HttpResponseMessage GetByName(string namePlayer) { using (TornirDBEntities entity = new TornirDBEntities()) { List <Tornir> tornirsList = entity.Tornirs.Where(x => x.Player1.ToUpper() == namePlayer.ToUpper() || x.Player2.ToUpper() == namePlayer.ToUpper()).ToList(); if (tornirsList.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, tornirsList)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }
// GET api/Tornir/5 public HttpResponseMessage Get(int id) { using (TornirDBEntities entity = new TornirDBEntities()) { Tornir tornir = entity.Tornirs.FirstOrDefault(x => x.ID == id); if (tornir != null) { return(Request.CreateResponse(HttpStatusCode.OK, tornir)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }
// DELETE api/Tornir/5 public HttpResponseMessage Delete(int id) { using (TornirDBEntities entity = new TornirDBEntities()) { Tornir tornirToDeleate = entity.Tornirs.FirstOrDefault(x => x.ID == id); if (tornirToDeleate != null) { entity.Tornirs.Remove(tornirToDeleate); entity.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, string.Format($"tornir with id:{id} delated"))); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format($"tornir with id:{id} was not found"))); } } }
// PUT api/Tornir/5 public HttpResponseMessage Put(int id, [FromBody] Tornir value) { using (TornirDBEntities entity = new TornirDBEntities()) { Tornir tornirToUpdate = entity.Tornirs.FirstOrDefault(x => x.ID == id); if (tornirToUpdate != null) { tornirToUpdate.Game_Name = value.Game_Name; tornirToUpdate.Player1 = value.Player1; tornirToUpdate.Player2 = value.Player2; tornirToUpdate.Who_Won = value.Who_Won; entity.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, string.Format($"tornir with id: {id} updeted"))); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format($"tornir with id:{id} was not found"))); } } }
public HttpResponseMessage GetByFilter(int id = -1, string gameName = null, string player1 = null, string player2 = null, string whoWon = null) { using (TornirDBEntities entity = new TornirDBEntities()) { List <Tornir> tornirSearch = entity.Tornirs.Where(x => id > -1 ? x.ID.Equals(id) : true) .Where(x => gameName != null? x.Game_Name.ToUpper().Equals(gameName.ToUpper()):true) .Where(x => player1 != null ? x.Player1.ToUpper().Equals(player1.ToUpper()) : true) .Where(x => player2 != null ? x.Player2.ToUpper().Equals(player2.ToUpper()) : true) .Where(x => whoWon != null ? x.Who_Won.ToUpper().Equals(whoWon.ToUpper()) : true) .ToList(); if (tornirSearch.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, tornirSearch)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }