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