public IEnumerable<BankAccount> GetBankAccounts(long userId)
{
using (var db = new Database(_settings))
{
return db.Query<BankAccount>("where UserId = @0", userId);
}
}
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();
}
}
public void CreateUserRating(UserRating userRating)
{
using (var db = new Database(_settings))
using (var transaction = db.GetTransaction())
{
db.Insert(userRating);
var rating = Convert.ToDecimal(db.Query<UserRating>("where UserId = @0", userRating.UserId).Average(r => r.Rating));
db.Update<User>("set Rating = @1 where Id = @0", userRating.UserId, rating);
transaction.Complete();
}
}
private IEnumerable<Event> GetEvents(string sql, params object[] parameters)
{
using (var db = new Database(_settings))
{
var mapper = new EventMapper();
return db.Query<Event>(mapper.Types, mapper.Map, sql, parameters);
}
}
public IList<EventRequest> GetEventRequests(int eventId)
{
using (var db = new Database(_settings))
{
return db.Query<EventRequest>("where EventId = @0", eventId).ToList();
}
}
public IList<Category> GetCategories()
{
using (var db = new Database(_settings))
{
return db.Query<Category>(string.Empty).ToList();
}
}
public IEnumerable<PaymentMethod> GetPaymentMethods(long userId)
{
using (var db = new Database(_settings))
{
return db.Query<PaymentMethod>("where UserId = @0", userId);
}
}
