public static async Task <string> GetPasswordSalt(PcHealthContext dbContext, Credential credential)
{
var credentials = dbContext.Credentials;
var neededCred = await credentials.Where(c => c.CredentialsUsername == credential.CredentialsUsername)
.Select(c => c.CredentialsSalt).FirstAsync().ConfigureAwait(false);
return(neededCred);
}
public static async Task CreateNewAdmin(PcHealthContext dbContext, NewAccountInfo newAccountInfo)
{
var newAdmin = new Admin()
{
AdminFirstName = newAccountInfo.AdminFirstName,
AdminLastName = newAccountInfo.AdminLastName,
AdminCredentialsUsername = newAccountInfo.CredentialsUsername
};
await dbContext.Admins.AddAsync(newAdmin).ConfigureAwait(false);
await dbContext.SaveChangesAsync().ConfigureAwait(false);
}
public static async Task InitializeStaticStorage(PcHealthContext dbContext)
{
if (StaticStorageServices.PcMapper.Count != 0)
{
return;
}
if (StaticStorageServices.AdminMapper.Count != 0)
{
return;
}
var admins = await dbContext.Credentials.ToListAsync().ConfigureAwait(false);
foreach (var admin in admins)
{
StaticStorageServices.PcMapper.Add(admin.CredentialsUsername, new Dictionary <string, DiagnosticData>());
StaticStorageServices.AdminMapper.Add(admin.CredentialsUsername, admin.PcCredentialPassword);
}
var adminHasPc = await dbContext.AdminHasPcs.ToListAsync().ConfigureAwait(false);
foreach (var adminPc in adminHasPc)
{
StaticStorageServices.PcMapper[adminPc.AdminCredentialsUsername].Add(adminPc.PcId, new DiagnosticData());
}
var pcs = await dbContext.Pcs.ToListAsync().ConfigureAwait(false);
foreach (var pc in pcs)
{
var pcDiagnosticData = new DiagnosticData()
{
AvgNetworkBytesReceived = (double)pc.PcNetworkAverageBytesReceived,
AvgNetworkBytesSent = (double)pc.PcNetworkAverageBytesSend,
CpuUsage = pc.PcCpuUsage,
DiskTotalSpace = pc.PcDiskTotalSpace,
FirewallStatus = pc.PcFirewallStatus,
MemoryUsage = (double)pc.PcMemoryUsage,
Os = pc.PcOs,
PcId = pc.PcId,
PcConfiguration = new PcConfiguration()
{
PcUsername = pc.PcUsername,
PcEmail = pc.PcEmail
},
TotalFreeDiskSpace = pc.PcDiskTotalFreeSpace,
Services = new List <Tuple <string, string> >()
};
foreach (var admin in pc.AdminHasPcs)
{
StaticStorageServices.PcMapper[admin.AdminCredentialsUsername][pc.PcId] = pcDiagnosticData;
}
}
}
public static async Task <string> CreateNewCredentials(PcHealthContext dbContext, NewAccountInfo newAccountInfo)
{
var(salt, passwordHash) = Services.HashServices.Encrypt(newAccountInfo.CredentialsPassword);
var pcCredentialsPassword = ModelCreation.GenerateRandomString();
var newCredential = new Credential()
{
CredentialsUsername = newAccountInfo.CredentialsUsername,
CredentialsPassword = passwordHash,
CredentialsSalt = salt,
PcCredentialPassword = pcCredentialsPassword
};
await dbContext.Credentials.AddAsync(newCredential).ConfigureAwait(false);
StaticStorageServices.AdminMapper.Add(newAccountInfo.CredentialsUsername, pcCredentialsPassword);
await dbContext.SaveChangesAsync().ConfigureAwait(false);
return(pcCredentialsPassword);
}
public static async Task UpdatePcInDatabase(PcHealthContext db, DiagnosticData diagnosticData)
{
var pc = await db.Pcs.Where(p => p.PcId.Equals(diagnosticData.PcId)).FirstOrDefaultAsync().ConfigureAwait(false);
if (pc != null)
{
pc.PcCpuUsage = diagnosticData.CpuUsage;
pc.PcDiskTotalFreeSpace = diagnosticData.TotalFreeDiskSpace;
pc.PcDiskTotalSpace = diagnosticData.DiskTotalSpace;
pc.PcFirewallStatus = diagnosticData.FirewallStatus;
pc.PcId = diagnosticData.PcId;
pc.PcMemoryUsage = diagnosticData.MemoryUsage;
pc.PcNetworkAverageBytesReceived = diagnosticData.AvgNetworkBytesReceived;
pc.PcNetworkAverageBytesSend = diagnosticData.AvgNetworkBytesSent;
pc.PcOs = diagnosticData.Os;
pc.PcUsername = diagnosticData.PcConfiguration.PcUsername;
pc.PcEmail = diagnosticData.PcConfiguration.PcEmail;
await db.SaveChangesAsync();
}
}
public AdminController(PcHealthContext db, IOptions <JWTSettings> jwtSettings)
{
_db = db;
_jwtSettings = jwtSettings.Value;
}
public static async Task <List <Credential> > GetCredentials(PcHealthContext dbContext, Credential credential)
{
return(await dbContext.Credentials.Where(c => c.CredentialsUsername == credential.CredentialsUsername).ToListAsync().ConfigureAwait(false));
}
public static async Task <List <Credential> > GetCredentials(PcHealthContext dbContext, NewAccountInfo newAccountInfo)
{
return(await dbContext.Credentials.Where(c => c.CredentialsUsername == newAccountInfo.CredentialsUsername).ToListAsync().ConfigureAwait(false));
}
public static async Task AddPcToAdmin(DiagnosticData diagnosticData, string admin, PcHealthContext db)
{
var adminFromDb = await db.Admins.Where(a => a.AdminCredentialsUsername.Equals(admin)).FirstOrDefaultAsync().ConfigureAwait(false);
var adminHasPc = new AdminHasPc()
{
PcId = diagnosticData.PcId,
AdminCredentialsUsername = admin
};
adminFromDb.AdminHasPcs.Add(adminHasPc);
}
public static async Task InitializePcLastMinute(DiagnosticData diagnosticData, PcHealthContext db)
{
await db.LastMinutes.AddAsync(ModelCreation.CreateOrUpdateLastMinute(diagnosticData)).ConfigureAwait(false);
for (var i = 1; i < 60; i++)
{
await db.LastMinutes.AddAsync(new LastMinute()
{
Second = i,
PcId = diagnosticData.PcId,
PcNetworkAverageBytesSend = 0,
PcCpuUsage = 0,
PcMemoryUsage = 0,
PcNetworkAverageBytesReceived = 0
}).ConfigureAwait(false);
}
}
public static async Task ChangePasswordInDb(string userName, string newPassword, PcHealthContext db)
{
var credentialFromDb = await
db.Credentials.Where(c => c.CredentialsUsername.Equals(userName)).FirstOrDefaultAsync();
var(salt, passwordHash) = HashServices.Encrypt(newPassword);
credentialFromDb.CredentialsPassword = passwordHash;
credentialFromDb.CredentialsSalt = salt;
await db.SaveChangesAsync();
}
public static async Task UpdatePcLastCurrentSecond(DiagnosticData diagnosticData, PcHealthContext db)
{
var lastMinutePc = await db.LastMinutes.Where(lm =>
lm.PcId.Equals(diagnosticData.PcId) && lm.Second == diagnosticData.CurrentSecond)
.FirstOrDefaultAsync().ConfigureAwait(false);
ModelCreation.CreateOrUpdateLastMinute(diagnosticData, lastMinutePc);
}
public PcController(PcHealthContext db)
{
_db = db;
}
