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); }
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); }
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)); }