public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.Id)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpStatusCode AddOrUpdateUserRating([FromBody] Rating item)
{
if (item == null || item.Score < 1 || item.Score > 5)
{
return(HttpStatusCode.BadRequest);
}
if (!_movieContext.Movies.Any(m => m.Id == item.Id) || !_userContext.Users.Any(u => u.Id == item.Id))
{
return(HttpStatusCode.NotFound);
}
var usersRatingForThisMovie = _ratingContext.Ratings.Where(m => m.MovieId == item.MovieId).Where(u => u.UserId == item.UserId);
if (!usersRatingForThisMovie.Any())
{
_ratingContext.Ratings.Add(item);
_ratingContext.SaveChanges();
}
else
{
var oldRating = usersRatingForThisMovie.FirstOrDefault();
_ratingContext.Remove(oldRating);
_ratingContext.Ratings.Add(item);
_ratingContext.SaveChanges();
}
return(HttpStatusCode.OK);
}
public IHttpActionResult PutProductRating(int productId, int userId, ProductRating productRating)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (productId != productRating.ProductId && userId != productRating.UserId)
{
return(BadRequest());
}
db.Entry(productRating).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (db.ProductRatings.Count(e => e.ProductId == productId && e.UserId == userId) == 0)
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void UpdateRating(BookRating bookRating)
{
var result = _dbContext.BookRating.SingleOrDefault(b => b.Isbn == bookRating.Isbn);
if (result != null)
{
decimal updateRating;
if (result.Rating >= 1)
{
if (bookRating.Rating >= result.Rating)
{
updateRating = 0.5m;
result.Rating = result.Rating + updateRating;
}
else
{
updateRating = 0.5m;
result.Rating = result.Rating - updateRating;
}
_dbContext.SaveChanges();
}
}
else
{
_dbContext.BookRating.Add(bookRating);
_dbContext.SaveChanges();
}
}
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));
}
/// <summary>
/// Update a cat by passing its Id and the new score
/// </summary>
/// <param name="id"></param>
/// <param name="score"></param>
public static void UpdateCat(string id, int score)
{
log.Info(String.Format("In : UpdateCat : id = {0} ; score = {1}", id, score));
using (RatingContext context = new RatingContext())
{
var record = context.Cats.SingleOrDefault(c => c.Id == id);
if (record != null)
{
record.Score = score;
context.SaveChanges();
}
}
log.Info("Out : UpdateCat");
}
static void SeedDb()
{
using (RatingContext db = new RatingContext())
{
db.School_Rating.RemoveRange(db.School_Rating.Where(sr => sr.SR_User_School <= 9999));
db.User.RemoveRange(db.User.Where(u => u.U_School <= 9999));
db.School.RemoveRange(db.School.Where(s => s.S_Nr <= 9999));
db.SaveChanges();
}
using (RatingContext db = new RatingContext())
{
db.School.Add(new School {
S_Nr = 9998, S_Name = "Testschule 1"
});
db.School.Add(new School {
S_Nr = 9999, S_Name = "Testschule 2"
});
var users = Enumerable.Range(0, 3).Select(i => new User()
{
U_School = 9999,
U_Phonenr = "0999" + i
}).ToArray();
db.User.AddRange(users);
db.School_Rating.Add(new School_Rating
{
SR_Date = DateTime.Now.Date.AddDays(-1),
SR_User_Navigation = users[0],
SR_Value = 5
});
db.School_Rating.Add(new School_Rating
{
SR_Date = DateTime.Now.Date.AddDays(0),
SR_User_Navigation = users[1],
SR_Value = 5
});
db.SaveChanges();
}
}
public RatingController(RatingContext ratingContext, MovieContext movieContext, UserContext userContext)
{
_ratingContext = ratingContext;
_movieContext = movieContext;
_userContext = userContext;
if (!_ratingContext.Ratings.Any())
{
_ratingContext.Ratings.Add(new Rating {
MovieId = 1, Score = 3, UserId = 1
});
_ratingContext.Ratings.Add(new Rating {
MovieId = 2, Score = 2, UserId = 2
});
_ratingContext.Ratings.Add(new Rating {
MovieId = 3, Score = 1, UserId = 1
});
_ratingContext.Ratings.Add(new Rating {
MovieId = 4, Score = 4, UserId = 2
});
_ratingContext.SaveChanges();
}
}
