public HttpResponseMessage Put(int id, [FromBody] Trainer model) { try { using (LearnTodayWebAPIDbContext dbContext = new LearnTodayWebAPIDbContext()) { var entity = dbContext.Trainers.FirstOrDefault(s => s.TrainerId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Searched Data not Found")); } else { entity.TrainerId = model.TrainerId; entity.Password = model.Password; dbContext.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Data updated successfully")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetCourseById(int id) { var db = new LearnTodayWebAPIDbContext(); var course = db.Courses.Find(id); if (course == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Searched Data not found")); } return(Request.CreateResponse(HttpStatusCode.OK, course)); }
public HttpResponseMessage Post([FromBody] Trainer model) { try { using (LearnTodayWebAPIDbContext db = new LearnTodayWebAPIDbContext()) { db.Trainers.Add(model); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, model)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (LearnTodayWebAPIDbContext db = new LearnTodayWebAPIDbContext()) { var entity = db.Students.FirstOrDefault(s => s.StudentId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No enrollement information found")); } else { db.Students.Remove(entity); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <Course> GetAllCourses() { var db = new LearnTodayWebAPIDbContext(); return(db.Courses.ToList().OrderBy(s => s.Start_Date)); }
public IEnumerable <Course> GetAllCourses() { var db = new LearnTodayWebAPIDbContext(); return(db.Courses.ToList()); }