public IEnumerable <Course> Get() { using (LearnTodayWebAPIDb1Context dbContext = new LearnTodayWebAPIDb1Context()) { dbContext.Configuration.ProxyCreationEnabled = false; return(dbContext.Courses.ToList()); } }
public HttpResponseMessage Get(int id) { using (LearnTodayWebAPIDb1Context dbContext = new LearnTodayWebAPIDb1Context()) { dbContext.Configuration.ProxyCreationEnabled = false; var entity = dbContext.Courses.FirstOrDefault(s => s.CourseId == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Searched data not found")); } } }
public HttpResponseMessage Post([FromBody] Trainer trainer) { try { using (LearnTodayWebAPIDb1Context dbContext = new LearnTodayWebAPIDb1Context()) { dbContext.Trainers.Add(trainer); dbContext.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, trainer); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(int id, [FromBody] Trainer trainer) { try { using (LearnTodayWebAPIDb1Context dbContext = new LearnTodayWebAPIDb1Context()) { var entity = dbContext.Trainers.FirstOrDefault(s => s.TrainerId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Searched data not found")); } else { entity.Password = trainer.Password; dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (LearnTodayWebAPIDb1Context dbContext = new LearnTodayWebAPIDb1Context()) { var entity = dbContext.Students.FirstOrDefault(s => s.StudentId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No enrollement information found")); } else { dbContext.Students.Remove(entity); dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }