//GET:api/CollegeDetails/5 public async Task <IHttpActionResult> GetCollegeDetails(int id) { //db.Configuration.LazyLoadingEnabled = false; CollegeDetail college = new CollegeDetail(); college = db.CollegeDetails.Where(e => e.CollegeID == id).FirstOrDefault(); //college = db.CollegeDetails.Where(e => e.CollegeID == id).FirstOrDefault(); if (college == null) { return(NotFound()); } CollegeData cdata = new CollegeData(); List <Comments> list = new List <Comments>(); foreach (var item in college.Comments) { Comments comment = new Comments(); comment.CollegeID = item.CollegeID; comment.CommentDescription = item.CommentDescription; comment.CommentID = item.CommentID; comment.CreatedDate = item.CreatedDate; list.Add(comment); } cdata.comments = list; return(Ok(cdata)); }
// PUT: api/CollegeDetails/5 public async Task <IHttpActionResult> PutCollegeDetail(int id, CollegeDetail collegeDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != collegeDetail.CollegeID) { return(BadRequest()); } db.Entry(collegeDetail).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CollegeDetailExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// POST: api/CollegeDetails public async Task <IHttpActionResult> PostCollegeDetail(CollegeDetail collegeDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CollegeDetails.Add(collegeDetail); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = collegeDetail.CollegeID }, collegeDetail)); }
public HttpResponseMessage Delete(int id) { try { CollegeDetail student = db.CollegeDetails.Find(id); db.CollegeDetails.Remove(student); db.SaveChanges(); } catch (System.Exception e) { // uncomment dex and log error. // return RedirectToAction("Delete", new { id = id, saveChangesError = true }); } return(Request.CreateResponse(HttpStatusCode.OK, "Deleted Successfully")); }
public IHttpActionResult Edit(CollegeDetail collegeDetail) { try { if (ModelState.IsValid) { db.Entry(collegeDetail).State = EntityState.Modified; db.SaveChanges(); } } catch (System.Exception /* dex */) { //Log the error (uncomment dex variable name after DataException and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return(Ok(collegeDetail)); }