예제 #1
0
        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);
                }
            });
        }
예제 #2
0
 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);
     }
 }
예제 #3
0
        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);
            }
        }
예제 #4
0
        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);
            }
        }
예제 #5
0
        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);
            }
        }
예제 #6
0
        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;
            }
        }