public void UpdatePlot_Stratum() { 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})"); datastore.InsertPlot_Stratum(stratumPlot); stratumPlot.IsEmpty = true; datastore.UpdatePlot_Stratum(stratumPlot); var ourStratumPlot = datastore.GetPlot_Stratum(unitCode, stratumCode, plotNumber); ourStratumPlot.IsEmpty.Should().Be(true); } }
public void DeletePlot_Stratum() { var unitCode = "u1"; var stratumCode = "st1"; var plotNumber = 1; var plotID = Guid.NewGuid().ToString(); 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, }; database.Execute("INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES " + $"('{CruiseID}', '{plotID}', '{unitCode}', {plotNumber});"); datastore.InsertPlot_Stratum(stratumPlot); var echo = datastore.GetPlot_Stratum(unitCode, stratumCode, plotNumber); echo.Should().NotBeNull("where's my echo"); datastore.DeletePlot_Stratum(echo.CuttingUnitCode, echo.StratumCode, echo.PlotNumber); } }
public void InsertStratumPlot() { var plotNumber = 1; var stratumCode = "st1"; var unitCode = "u1"; var isEmpty = true; var kpi = 101; var plotID = Guid.NewGuid().ToString(); var cruiseID = CruiseID; //var remarks = "something"; 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 = isEmpty, KPI = kpi, //Remarks = remarks }; database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES " + $"('{cruiseID}', '{plotID}', '{unitCode}', {plotNumber})"); datastore.InsertPlot_Stratum(stratumPlot); datastore.IsPlotNumberAvalible(unitCode, plotNumber).Should().BeFalse("we just took that plot number"); var plotStratumAgain = datastore.GetPlot_Stratum(unitCode, stratumCode, plotNumber); plotStratumAgain.Should().NotBeNull(); plotStratumAgain.PlotNumber.Should().Be(plotNumber); //ourStratumPlot.Remarks.Should().Be(remarks); plotStratumAgain.KPI.Should().Be(kpi); plotStratumAgain.IsEmpty.Should().Be(isEmpty); plotStratumAgain.StratumCode.Should().Be(stratumCode); } }