コード例 #1
0
ファイル: ApiCrudTests.cs プロジェクト: usbr/HdbApi
        public void SeriesMtableInsertEndPoint()
        {
            var hdbProcessor = new HdbApi.App_Code.HdbCommands();
            var result       = hdbProcessor.modify_m_table_raw(conx, testMRID, Convert.ToInt16(testSDI), testT, testVal, testInterval, testBool);

            var seriesProcessor = new DataAccessLayer.SeriesRepository();
            var verification    = seriesProcessor.GetSeries(conx, testSDI, testInterval, testT, testT, "M", testMRID);

            Assert.AreEqual(testVal.ToString(), verification.data[0].value);
            hdbProcessor.delete_from_hdb(conx, Convert.ToInt16(testSDI), testT, testInterval, testMRID);
        }
コード例 #2
0
ファイル: ApiCrudTests.cs プロジェクト: usbr/HdbApi
        public void SeriesRtableDeleteEndPoint()
        {
            var hdbProcessor = new HdbApi.App_Code.HdbCommands();
            var result       = hdbProcessor.modify_r_base_raw(conx, Convert.ToInt16(testSDI), testInterval, testT, testVal, testBool, testFlag, testBool);//, testLoadingApplicationId);

            hdbProcessor.delete_from_hdb(conx, Convert.ToInt16(testSDI), testT, testInterval);

            var seriesProcessor = new DataAccessLayer.SeriesRepository();
            var verification    = seriesProcessor.GetSeries(conx, testSDI, testInterval, testT, testT);

            Assert.AreEqual(null, verification.data[0].value);
        }
コード例 #3
0
        public IHttpActionResult Delete([FromBody] List <Models.PointModel.ModeledPoint> input)
        {
            IDbConnection db = HdbController.Connect(this.Request.Headers);

            var hdbProcessor = new HdbApi.App_Code.HdbCommands();

            foreach (Models.PointModel.ModeledPoint point in input)
            {
                var result = hdbProcessor.delete_from_hdb(db, point.site_datatype_id, point.start_date_time, point.interval, point.model_run_id);
            }

            try
            {
                db.Close();
                db.Dispose();
            }
            catch
            {
            }

            return(Ok(input));
        }