public async Task AddSearch(NavigatorSearch search) { if (!Searches.ContainsKey(search.Id)) { await _dao.AddPlayerSearchAsync(search, _player.Id); Searches.Add(search.Id, search); } }
internal async Task <Dictionary <int, NavigatorSearch> > ReadPlayerSearchesAsync(int id) { Dictionary <int, NavigatorSearch> searches = new Dictionary <int, NavigatorSearch>(); await SelectAsync(async reader => { while (await reader.ReadAsync()) { NavigatorSearch search = new NavigatorSearch(reader); if (searches.ContainsKey(search.Id)) { searches.Add(search.Id, search); } } }, "SELECT * FROM `habbo_saved_searches` WHERE `user_id` = @0", id); return(searches); }
internal async Task AddPlayerSearchAsync(NavigatorSearch search, int userId) { search.Id = await InsertAsync("INSERT INTO `habbo_saved_searches` (`page`, `code`, `user_id`) VALUES (@0, @1, @2);", search.Page, search.Code, userId); }