public void CreateEventRating(EventRating eventRating)
{
eventRating.Created = DateTime.Now;
eventRating.UserId = UserIdentity.Current.User.Id;
_eventRepository.CreateEventRating(eventRating);
}
public void CreateEventRating(EventRating eventRating)
{
using (var db = new Database(_settings))
using (var transaction = db.GetTransaction())
{
db.Insert(eventRating);
var rating = Convert.ToDecimal(db.Query<EventRating>("where EventId = @0", eventRating.EventId).Average(r => r.Rating));
db.Update<Event>("set Rating = @1 where Id = @0", eventRating.EventId, rating);
transaction.Complete();
}
}
