public ActionResult <RatingDto> DeleteRating(long ratingid) { School_Rating rating = _db.School_Rating.Find(ratingid); if (rating == null) { return(BadRequest()); } _db.Entry(rating).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; _db.SaveChanges(); return(Ok()); }
public ActionResult <RatingDto> ChangeRating(long ratingid, RatingDto newRating) { DateTime today = DateTime.Now.Date; School_Rating rating = _db.School_Rating.FirstOrDefault(sr => sr.SR_ID == ratingid && sr.SR_Date < today); if (rating == null) { return(BadRequest()); } rating.SR_Value = newRating.Id; rating.SR_Date = today; rating.SR_Value = newRating.Value; _db.Entry(rating).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _db.SaveChanges(); return(new RatingDto { Date = rating.SR_Date, Id = rating.SR_ID, PhoneNr = rating.SR_User_Phonenr, School = rating.SR_User_School, Value = rating.SR_Value }); }
public ActionResult <RatingDto> Post(RatingDto rating) { User user = _db.User.FirstOrDefault(u => u.U_Phonenr == rating.PhoneNr && u.U_School == rating.School); if (user == null) { return(BadRequest()); } if (_db.School_Rating.Any(sr => sr.SR_User_Phonenr == rating.PhoneNr && sr.SR_User_School == rating.School)) { return(BadRequest()); } School_Rating newRating = new School_Rating { SR_Date = DateTime.Now.Date, SR_User_Navigation = user, SR_Value = rating.Value }; _db.Entry(newRating).State = Microsoft.EntityFrameworkCore.EntityState.Added; _db.SaveChanges(); rating.Id = newRating.SR_ID; return(Ok(rating)); }