public void AddPlotRemarks() { var remarks = "something"; var unitCode = Units.First(); var plotNumber = 1; using (var database = CreateDatabase()) { var datastore = new CuttingUnitDatastore(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID)); var plotID = datastore.AddNewPlot(unitCode); validatePlot(datastore, unitCode, plotID, plotNumber); var plot = datastore.GetPlot(plotID); datastore.AddPlotRemark(plot.CuttingUnitCode, plot.PlotNumber, remarks); var stuff = database.QueryGeneric("select * from plot").ToArray(); var plotAgain = datastore.GetPlot(plotID); plotAgain.Remarks.Should().Be(remarks); datastore.AddPlotRemark(plot.CuttingUnitCode, plot.PlotNumber, remarks); plotAgain = datastore.GetPlot(plotID); plotAgain.Remarks.Should().Be(remarks + ", " + remarks); } }
public void UpdatePlot() { var random = new Bogus.Randomizer(); var unitCode = "u1"; var stratumCode = "st1"; var plotNumber = 1; var plotID = Guid.NewGuid().ToString(); var cruiseID = CruiseID; using (var database = CreateDatabase()) { var datastore = new CuttingUnitDatastore(database, cruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID)); var stratumPlot = new Plot_Stratum() { CuttingUnitCode = unitCode, PlotNumber = plotNumber, StratumCode = stratumCode, IsEmpty = false, }; database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES " + $"('{cruiseID}', '{plotID}', '{unitCode}', {plotNumber})"); var plot = datastore.GetPlot(unitCode, plotNumber); var slope = random.Double(); plot.Slope = slope; var aspect = random.Double(); plot.Aspect = aspect; var remarks = random.String2(24); plot.Remarks = remarks; datastore.UpdatePlot(plot); var plotAgain = datastore.GetPlot(unitCode, plotNumber); plotAgain.Slope.Should().Be(slope); plotAgain.Aspect.Should().Be(aspect); plotAgain.Remarks.Should().Be(remarks); } }
private static void validatePlot(CuttingUnitDatastore datastore, string unitCode, string plotID, int expectedPlotNumber) { plotID.Should().NotBeNullOrEmpty(); var plot = datastore.GetPlot(plotID); plot.Should().NotBeNull(); plot.PlotNumber.Should().Be(expectedPlotNumber); var strat_plots = datastore.GetPlot_Strata(unitCode, plot.PlotNumber); strat_plots.Should().NotBeEmpty(); strat_plots.All(x => x.PlotNumber == expectedPlotNumber).Should().BeTrue(); }
public void GetPlot_ByUnitPlotNumber() { var unitCode = "u1"; var plotNumber = 1; var plotID = Guid.NewGuid().ToString(); var cruiseID = CruiseID; using (var database = CreateDatabase()) { var datastore = new CuttingUnitDatastore(database, cruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID)); database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES " + $"('{cruiseID}', '{plotID}', '{unitCode}', {plotNumber})"); var plot = datastore.GetPlot(unitCode, plotNumber); plot.Should().NotBeNull(); } }