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));
}
