private TimeSeries_SmallInt_Seconds GenerateTimeSeries_SmallInt_Seconds(int timeOffset, Guid stripId, string samplesText)
        {
            TimeSeries_SmallInt_Seconds v = (TimeSeries_SmallInt_Seconds)EntityFactory.GetEntityObject(TimeSeries_SmallInt_Seconds.EntityName, GetSourceTypeEnum.Table);

            v.TSDateOffset      = timeOffset;
            v.TSValue           = Convert.ToInt16(TestUtils.RandomUtils.RandomNumber(0, short.MaxValue));
            v.TimeSeriesTypeID  = (byte)EntityEnums.TimeSeriesTypeEnum.ECG;
            v.UserID            = TestEnums.User.constPatientUserID;
            v.TSValueBinary     = CompressionUtils.SerializeAndCompress(samplesText);
            v.TimeSeriesStripID = stripId;
            return(v);
        }
        //[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
            }
        }