public void OnAfterInitializeTest()
        {
            // checking services be disabled

            TimeSeries_SmallInt_SecondsService service = (TimeSeries_SmallInt_SecondsService)CreateNewTimeSeries_SmallInt_SecondsService();
            DisableServicesEntitySecurity      sec     = (DisableServicesEntitySecurity)service.SecurityCheckers[0];

            Assert.IsTrue(sec is DisableServicesEntitySecurity);
            Assert.IsTrue(sec.InsertDisabled == false);
            Assert.IsTrue(sec.DeleteDisabled == true);
            Assert.IsTrue(sec.GetAllDisabled == true);
            Assert.IsTrue(sec.GetByFilterDisabled == true);
            Assert.IsTrue(sec.GetByIDDisabled == true);
            Assert.IsTrue(sec.GetCountDisabled == true);
            Assert.IsTrue(sec.GetMaxDisabled == true);
            Assert.IsTrue(sec.GetMinDisabled == true);
            Assert.IsTrue(sec.UpdateDisabled == true);
        }
        //[TestMethod()]
        //public void PopulateDatabaseByRandomValues()
        //{
        //    //DateTime startDateTime = new DateTime(2010, 1, 1);
        //    //DateTime startDateTime = DateTime.UtcNow;
        //    PopulateDatabaseByRandomValues(100);
        //}


        //[TestMethod]
        //public void PopulateDatabaseFromFileRealData()
        //{
        //    string fileName = @"I:\iosProjects\HealthCareTracker\Resources\Datasets\ECG-DataSamples\ecg_stream_sample.csv";
        //    //DateTime startDateTime = DateTime.UtcNow;
        //    int samplesPerSecond = 300;
        //    char samplesSeparator = ',';

        //    TimeSeriesStrip strip = InsertStrip();
        //    Guid stripId = strip.TimeSeriesStripID;

        //    TimeSeries_SmallInt_SecondsService service = CreateNewTimeSeries_SmallInt_SecondsService();
        //    int TSDateOffset = strip.StartDateOffset; // DateTimeEpoch.ConvertDateToSecondsEpoch(startDateTime);

        //    string fileContent = System.IO.File.ReadAllText(fileName);
        //    string[] numbers = fileContent.Split(samplesSeparator);
        //    StringBuilder samplesTextSB = new StringBuilder();

        //    int commaCount = 0;
        //    for (int i = 0; i < fileContent.Length; i++)
        //    {
        //        if (fileContent[i] == ',')
        //        {
        //            commaCount++;
        //            if (commaCount == samplesPerSecond) // once we got enough samples
        //            {
        //                // insert samples to database
        //                commaCount = 0;
        //                string samplesText = samplesTextSB.ToString();
        //                TimeSeries_SmallInt_Seconds v = GenerateTimeSeries_SmallInt_Seconds(TSDateOffset, stripId, samplesText);
        //                service.Insert(v, new InsertParameters());

        //                samplesTextSB.Clear();
        //                TSDateOffset++; // add one second
        //                continue;
        //            }
        //        }
        //        samplesTextSB.Append(fileContent[i]);
        //    }

        //}


        //[TestMethod()]
        private void PopulateDatabaseByRandomValues(int numberOfValues)
        {
            TimeSeriesStrip strip   = InsertStrip();
            Guid            stripId = strip.TimeSeriesStripID;

            TimeSeries_SmallInt_SecondsService service = CreateNewTimeSeries_SmallInt_SecondsService();
            //DateTime startDateTime = new DateTime(2014, 1, 1);
            //int TSDateOffset = DateTimeEpoch.ConvertDateToSecondsEpoch(startDateTime);
            int TSDateOffset = strip.StartDateOffset;

            for (int i = 0; i < numberOfValues; i++)
            {
                string samplesText            = GetOneSecondSamples();
                TimeSeries_SmallInt_Seconds v = GenerateTimeSeries_SmallInt_Seconds(TSDateOffset, stripId, samplesText);
                service.Insert(v, new InsertParameters());
                TSDateOffset++; // add one second
            }
        }