public async Task <DatabaseModel.Staff> Find(string steamId) { var query = _staffQueries.GetStaffFromSteamId(steamId); var res = await _databaseConnection.ExecuteSqlQueryAsync(query); return(await res.GetSingleAsync <DatabaseModel.Staff>()); }
public async Task <List <DatabaseModel.Level> > GetAll() { var query = _levelQueries.GetAll(); var res = await _databaseConnection.ExecuteSqlQueryAsync(query); return(await res.GetListAsync <DatabaseModel.Level>()); }
public async Task <DatabaseModel.Settings> GetSettingsAsync() { var query = new SqlQuery("SELECT * FROM [Settings] WHERE Id = 1", new Dictionary <string, object>()); var res = await _databaseConnection.ExecuteSqlQueryAsync(query); return(await res.GetSingleAsync <DatabaseModel.Settings>()); }
public async Task <DatabaseModel.Bot> FindAsync(string steamId) { var query = _botQueries.GetFromSteamId(steamId); using (var sqlResult = await _databaseConnection.ExecuteSqlQueryAsync(query)) { return(await sqlResult.GetSingleAsync <DatabaseModel.Bot>()); } }
public async Task <List <DatabaseModel.ItemDescription> > GetAll() { var query = _itemDescriptionQueries.GetAll(); using (var sqlResult = await _databaseConnection.ExecuteSqlQueryAsync(query)) { return(await sqlResult.GetListAsync <DatabaseModel.ItemDescription>()); } }
public async Task <List <DatabaseModel.ItemBetted> > FindAsync(DatabaseModel.Bet bet) { var query = _itemBetQueries.GetItemBetsOnBet(bet.Id); using (var sqlResult = await _databaseConnection.ExecuteSqlQueryAsync(query)) { return(await sqlResult.GetListAsync <DatabaseModel.ItemBetted>()); } }
public async Task <DatabaseModel.User> FindAsync(string steamId) { var query = _userQueries.GetUserWithSteamId(steamId); using (var sqlRes = await _databaseConnection.ExecuteSqlQueryAsync(query)) { var user = await sqlRes.GetSingleAsync <DatabaseModel.User>(); return(user); } }
public async Task <List <DatabaseModel.OfferTransaction> > FindAsync(DatabaseModel.User user) { var query = _offerTransationQueries.GetFromUserId(user.Id); using (var sqlRes = await _databaseConnection.ExecuteSqlQueryAsync(query)) { var offerTransaction = await sqlRes.GetListAsync <DatabaseModel.OfferTransaction>(); return(offerTransaction); } }
public async Task <List <DatabaseModel.ItemInOfferTransaction> > FindAsync(List <DatabaseModel.OfferTransaction> offerTransactions) { if (offerTransactions.Count == 0) { return(new List <DatabaseModel.ItemInOfferTransaction>()); } var ids = offerTransactions.Select(offerTransaction => offerTransaction.Id).ToList(); var query = _itemInOfferTransactionQueries.GetFromTransactionsIds(ids); using (var sqlRes = await _databaseConnection.ExecuteSqlQueryAsync(query)) { var items = await sqlRes.GetListAsync <DatabaseModel.ItemInOfferTransaction>(); return(items); } }
public async Task <DatabaseModel.RakeItem> FindAsync(int id) { var query = _rakeItemQueries.GetFromId(id); using (var sqlResult = await _databaseConnection.ExecuteSqlQueryAsync(query)) { return(await sqlResult.GetSingleAsync <DatabaseModel.RakeItem>()); } }
public async Task <List <DatabaseModel.Match> > FindRangeAsync(int id, int i) { var query = _matchQueries.FindRange(id, i); var res = await _databaseConnection.ExecuteSqlQueryAsync(query); return(await res.GetListAsync <DatabaseModel.Match>()); }
public async Task <List <DatabaseModel.Bet> > FindAsync(DatabaseModel.User user) { var query = _betQueries.GetAllBetsFromUser(user.Id); using (var sqlResult = await _databaseConnection.ExecuteSqlQueryAsync(query)) { return(await sqlResult.GetListAsync <DatabaseModel.Bet>()); } }