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);
}
