public async Task SaveVkAcc(VkAcc vkAcc) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { db.VkAccs.Update(vkAcc); await db.SaveChangesAsync(); } }
private async Task IncrementAddedFriends(VkAcc vkAcc) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { vkAcc.CountAddedFriends++; db.VkAccs.Update(vkAcc); await db.SaveChangesAsync(); } }
public async Task ClearUncheckedClients(VkAcc vkAcc) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { var clients = db.VkClients.Where(e => e.VkAccId == vkAcc.VkAccId && e.ClientStatus == VkClient.Status.Unchecked); db.VkClients.RemoveRange(clients); await db.SaveChangesAsync(); } }
public async Task SetClientStatus(int id, VkClient.Status Status) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { db.VkClients .FirstOrDefault(e => e.VkClientId == id) .ClientStatus = Status; await db.SaveChangesAsync(); } }
public async Task RemoveVkAcc(VkAcc vkAcc) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { var user = await db.Users .Include(e => e.VkAccs) .FirstOrDefaultAsync(e => e.UserId == User.UserId); user.VkAccs.RemoveAll(e => e.VkAccId == vkAcc.VkAccId); await db.SaveChangesAsync(); } }
public async Task<Models.VkAcc> GetVkAcc(long VkAccId) { Models.VkAcc vkAcc; using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { vkAcc = db.VkAccs.FirstOrDefault(e => e.VkAccId == VkAccId); await UpdateVkAccStatus(vkAcc); await db.SaveChangesAsync(); } return vkAcc; }
private async Task UpdateClients(VkAcc vkAcc) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { int Count = 50; var acc = db.VkAccs.FirstOrDefault(e => e.VkAccId == vkAcc.VkAccId); vkAcc.VkClients.AddRange(await VkApisManager.GetNewClients( acc, Count, this, db)); await db.SaveChangesAsync(); } }
public async Task<VkAcc> CreateVkAcc(string Token) { VkAcc vkAcc; var result = await VkApisManager.TryAuthorize(Token); if (result == true) { using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { var user = await db.Users.FirstOrDefaultAsync(e => e.UserId == User.UserId); vkAcc = new VkAcc() { AccessToken = Token, FriendsLimit = 40, CountAddedFriends = 0, }; await this.UpdateVkAccStatus(vkAcc); user.VkAccs.Add(vkAcc); await db.SaveChangesAsync(); } return vkAcc; } return null; }
public async Task<List<Models.VkAcc>> GetVkAccs(bool NeedUpdate = false) { List<Models.VkAcc> vkAccs; using (var db = new ModelScoutDbContext(this._dbOptionsBuilder.Options)) { if (User == null) vkAccs = db.VkAccs .Include(e => e.User) .ToList(); else vkAccs = db.VkAccs .Where(e => e.UserId == this.User.UserId) .Include(e => e.User) .ToList(); if (NeedUpdate) { foreach (var vkAcc in vkAccs) await UpdateVkAccStatus(vkAcc); await db.SaveChangesAsync(); } } return vkAccs; }