public DataStorageMeterListener(Guid id, DateTime started, MeasurementSettings settings)
{
Id = id;
Settings = settings;
created = started;
initalCreate = Task.Run(async() =>
{
try
{
using (var audioViewEntities = new AudioViewEntities())
{
if (!audioViewEntities.Projects.Any(x => x.Id == id))
{
audioViewEntities.Projects.Add(new Project()
{
Id = id,
Created = started,
MinorDBLimit = settings.MinorDBLimit,
MajorDBLimit = settings.MajorDBLimit,
MajorInterval = settings.MajorInterval.Ticks,
MinorInterval = settings.MinorInterval.Ticks,
Name = settings.ProjectName,
Number = settings.ProjectNumber
});
await audioViewEntities.SaveChangesAsync().ConfigureAwait(false);
}
}
}
catch (Exception exp)
{
logger.Warn(exp, "Unable to add project \"{0}\" to database, do we have internet access?", settings.ProjectName);
}
});
}
public async Task CreateUser(User user, string password)
{
using (var audioViewEntities = new AudioViewEntities())
{
var userObject = user.ToDatabase();
userObject.passwordSalt = getRandomSalt();
userObject.password = generateHash(password, userObject.passwordSalt);
audioViewEntities.Users.Add(userObject);
await audioViewEntities.SaveChangesAsync().ConfigureAwait(false);
}
}
public async Task UpdateExpires(string username, DateTime?expires)
{
using (var audioViewEntities = new AudioViewEntities())
{
var user = await audioViewEntities.Users.FirstOrDefaultAsync(x => x.username.ToLower() == username.ToLower());
if (user == null)
{
return;
}
user.expires = expires;
await audioViewEntities.SaveChangesAsync().ConfigureAwait(false);
}
}
public async Task DeleteUser(string username)
{
using (var audioViewEntities = new AudioViewEntities())
{
var user = await audioViewEntities.Users.FirstOrDefaultAsync(x => x.username.ToLower() == username.ToLower()).ConfigureAwait(false);
if (user == null)
{
return;
}
audioViewEntities.Users.Remove(user);
await audioViewEntities.SaveChangesAsync().ConfigureAwait(false);
}
}
public async Task UpdatePassword(string username, string newPassword)
{
using (var audioViewEntities = new AudioViewEntities())
{
var user = await audioViewEntities.Users.FirstOrDefaultAsync(x => x.username.ToLower() == username.ToLower());
if (user == null)
{
return;
}
user.passwordSalt = getRandomSalt();
user.password = generateHash(newPassword, user.passwordSalt);
await audioViewEntities.SaveChangesAsync().ConfigureAwait(false);
}
}
private async void WriteReading(bool major, DateTime time, ReadingData data)
{
var readingGuid = Guid.NewGuid();
try
{
// Ensure the inital create have finished
if (initalCreate != null)
{
lock (initalCreateLock)
{
if (initalCreate != null)
{
Task.WaitAll(initalCreate);
initalCreate = null;
}
}
}
var reading = new Reading()
{
Id = readingGuid,
Project = this.Id,
Major = major ? (byte)1 : (byte)0,
Time = time,
LAeq = data.LAeq,
LAMax = data.LAMax,
LAMin = data.LAMin,
LZMax = data.LZMax,
LZMin = data.LZMin,
// 1/3
Hz6_3 = data.LAeqOctaveBandOneThird.Hz6_3,
Hz8 = data.LAeqOctaveBandOneThird.Hz8,
Hz10 = data.LAeqOctaveBandOneThird.Hz10,
Hz12_5 = data.LAeqOctaveBandOneThird.Hz12_5,
Hz16 = data.LAeqOctaveBandOneThird.Hz16,
Hz20 = data.LAeqOctaveBandOneThird.Hz20,
Hz25 = data.LAeqOctaveBandOneThird.Hz25,
Hz31_5 = data.LAeqOctaveBandOneThird.Hz31_5,
Hz40 = data.LAeqOctaveBandOneThird.Hz40,
Hz50 = data.LAeqOctaveBandOneThird.Hz50,
Hz63 = data.LAeqOctaveBandOneThird.Hz63,
Hz80 = data.LAeqOctaveBandOneThird.Hz80,
Hz100 = data.LAeqOctaveBandOneThird.Hz100,
Hz125 = data.LAeqOctaveBandOneThird.Hz125,
Hz160 = data.LAeqOctaveBandOneThird.Hz160,
Hz200 = data.LAeqOctaveBandOneThird.Hz200,
Hz250 = data.LAeqOctaveBandOneThird.Hz250,
Hz315 = data.LAeqOctaveBandOneThird.Hz315,
Hz400 = data.LAeqOctaveBandOneThird.Hz400,
Hz500 = data.LAeqOctaveBandOneThird.Hz500,
Hz630 = data.LAeqOctaveBandOneThird.Hz630,
Hz800 = data.LAeqOctaveBandOneThird.Hz800,
Hz1000 = data.LAeqOctaveBandOneThird.Hz1000,
Hz1250 = data.LAeqOctaveBandOneThird.Hz1250,
Hz1600 = data.LAeqOctaveBandOneThird.Hz1600,
Hz2000 = data.LAeqOctaveBandOneThird.Hz2000,
Hz2500 = data.LAeqOctaveBandOneThird.Hz2500,
Hz3150 = data.LAeqOctaveBandOneThird.Hz3150,
Hz4000 = data.LAeqOctaveBandOneThird.Hz4000,
Hz5000 = data.LAeqOctaveBandOneThird.Hz5000,
Hz6300 = data.LAeqOctaveBandOneThird.Hz6300,
Hz8000 = data.LAeqOctaveBandOneThird.Hz8000,
Hz10000 = data.LAeqOctaveBandOneThird.Hz10000,
Hz12500 = data.LAeqOctaveBandOneThird.Hz12500,
Hz16000 = data.LAeqOctaveBandOneThird.Hz16000,
Hz20000 = data.LAeqOctaveBandOneThird.Hz20000,
// 1/1
OOHz16 = data.LAeqOctaveBandOneOne.Hz16,
OOHz31_5 = data.LAeqOctaveBandOneOne.Hz31_5,
OOHz63 = data.LAeqOctaveBandOneOne.Hz63,
OOHz125 = data.LAeqOctaveBandOneOne.Hz125,
OOHz250 = data.LAeqOctaveBandOneOne.Hz250,
OOHz500 = data.LAeqOctaveBandOneOne.Hz500,
OOHz1000 = data.LAeqOctaveBandOneOne.Hz1000,
OOHz2000 = data.LAeqOctaveBandOneOne.Hz2000,
OOHz4000 = data.LAeqOctaveBandOneOne.Hz4000,
OOHz8000 = data.LAeqOctaveBandOneOne.Hz8000,
OOHz16000 = data.LAeqOctaveBandOneOne.Hz16000
};
using (var audioViewEntities = new AudioViewEntities())
{
audioViewEntities.Readings.Add(reading);
await audioViewEntities.SaveChangesAsync();
}
if (isServerDown && OnSQLServerStatusChanged != null)
{
OnSQLServerStatusChanged(false);
}
isServerDown = false;
// Reading ok, try to load offline files
await UploadLocalFiles();
}
catch (Exception exp)
{
logger.Debug(exp, "Got database exception, starting to write offline for \"{0}\".", this.Settings.ProjectName);
WriteOfline(major, time, data, readingGuid);
if (!isServerDown && OnSQLServerStatusChanged != null)
{
OnSQLServerStatusChanged(true);
}
isServerDown = true;
}
}