public int GetOrAdd(IDbConnection connection, string authId, IUserLocalStorageCache cache) { _checkAndInit(connection, cache); int val; _storage.TryGetValue(authId, out val); if (val != 0) { return(val); } var cacheUser = cache.LocalOperation(connection, col => col.FirstOrDefault(i => i.AuthId == authId)); if (cacheUser != null && cacheUser.Id != 0) { return(_storage.AddOrUpdateSimple(cacheUser.AuthId, cacheUser.Id)); } var repo = cache.GetRepository(); var tableName = repo.SchemeTableName; var sql = $"SELECT TOP(1) * FROM {tableName} WHERE authId=@authId"; var user = repo.Provider.Text <user>(connection, sql, new { authId }).ToList(); if (user.Any()) { var u = user.First(); cache.UpdateLocalItem(connection, repo.ConvertToWorkModel(u)); return(_storage.AddOrUpdateSimple(u.authId, u.Id)); } return(0); }
public bool AddVote(IDbProvider provider, IDbConnection connection, int candidateUserId, int voterUserId) { provider.ThrowIfConnectionIsNull(connection); var hasValue = _candidates.TryGetValue(candidateUserId, out var candidate); if (!hasValue) { return(false); } var voteTableName = provider.GetTableName(nameof(c_vote)); var officerCandidatTableName = provider.GetTableName(nameof(c_officer_candidat)); var sqlAddVote = $"INSERT INTO {voteTableName}(voterUserId,candidatUserId) VALUES({voterUserId},{candidateUserId}); "; if (provider._isExistVote(connection, voterUserId)) { throw new Exception(Error.UserHasAlreadyCastVote); } var updateVoce = sqlAddVote + $"UPDATE {officerCandidatTableName} SET voices=voices+1 WHERE userId = {candidateUserId}"; provider.Exec(connection, updateVoce); candidate.Voices++; candidate.SetPersent(); _totalCount++; _candidates.AddOrUpdateSimple(candidate.UserId, candidate); return(true); }
public static ApplicationUser Update(ApplicationUser user) { var existUser = GetUser(user.UserName); existUser.Update(user); _users.AddOrUpdateSimple(existUser.NikName, existUser); return(existUser.CreeateAsBase()); }
public static object AddOrUpdate(string guid, object data, int maxTimeSecToRemove) { var resultData = _storage.AddOrUpdateSimple(guid, data); if (resultData != default(object)) { _startCleanTimer(guid, maxTimeSecToRemove * 1000); } return(resultData); }
private void InitHomeSlides() { var relativePath = "art/screens/webp/"; var homePath = "/Content/images/" + relativePath; var cdnPath = StorageEternPlayPublicProvider.CdnUrl + relativePath; var catalog = MapPath(homePath); var files = Directory.GetFiles(catalog).OrderBy(i => i).Select(i => homePath + Path.GetFileName(i)).ToList();//.Select(i => cdnPath + Path.GetFileName(i)).ToList(); Files.AddOrUpdateSimple(_homeSlidesKey, files); _homeSlidesString = files.Aggregate("", (current, f) => current + (f + ",")).RemoveLastSimbol(); }
private static void _startCleanTimer(string guid, int maxTimeMsToRemove) { var timer = new Timer { Interval = maxTimeMsToRemove, AutoReset = false }; timer.Elapsed += (sender, args) => { Remove(guid); }; timer.Start(); _timers.AddOrUpdateSimple(guid, timer); }
public int GetOrAdd(IDbConnection connection, string systemName, IGDetailSystemLocalStorageCache cache) { var val = TryGetValue(connection, systemName, cache); if (val != 0) { return(val); } var cacheSystem = cache.LocalOperation(connection, col => col.FirstOrDefault(i => i.Name == systemName)); if (cacheSystem != null && cacheSystem.Id != 0) { return(_storage.AddOrUpdateSimple(cacheSystem.Name, cacheSystem.Id)); } var repo = cache.GetRepository(); var tableName = repo.SchemeTableName; var sql = $"SELECT TOP(1) * FROM {tableName} WHERE name=@systemName"; var system = repo.Provider.Text <g_detail_system>(connection, sql, new { systemName }).Single(); cache.UpdateLocalItem(connection, repo.ConvertToWorkModel(system)); return(_storage.AddOrUpdateSimple(system.name, system.Id)); }
public int GetOrAdd(IDbConnection connection, string userName, IUserLocalStorageCache cache) { _checkAndInit(connection, cache); int val; _storage.TryGetValue(userName, out val); if (val != 0) { return(val); } var cacheUser = cache.LocalOperation(connection, col => col.FirstOrDefault(i => i.Nickname == userName)); if (cacheUser != null && cacheUser.Id != 0) { return(_storage.AddOrUpdateSimple(cacheUser.Nickname, cacheUser.Id)); } var repo = cache.GetRepository(); var tableName = repo.SchemeTableName; var sql = $"SELECT TOP(1) * FROM {tableName} WHERE nickname=@userName"; var user = repo.Provider.Text <user>(connection, sql, new { userName }).Single(); cache.UpdateLocalItem(connection, repo.ConvertToWorkModel(user)); return(_storage.AddOrUpdateSimple(user.authId, user.Id)); }
public int AddOrUpdate(IDbConnection connection, string planetName, int planetId, IGDetailPlanetLocalStorageCache cache) { _checkAndInit(connection, cache); return(_storage.AddOrUpdateSimple(planetName, planetId)); }
public IAllianceNameSerchItem AddOrUpdate(IDbConnection connection, string allianceName, IAllianceNameSerchItem val, IAllianceLocalStorageCache cache) { _checkAndInit(connection, cache); return(_storage.AddOrUpdateSimple(allianceName, val)); }
public static TimerExecutorItem AddOrUpdate(TimerExecutorItem item) { return(_timers.AddOrUpdateSimple(item.Id, item)); }
public static void UpdateNpc(string npcNativeName, NpcModel newNpcModel) { Npses.AddOrUpdateSimple(newNpcModel.NpcUser.Nickname, newNpcModel); }