public void IsPlotNumberAvalible()
{
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));
datastore.IsPlotNumberAvalible(unitCode, plotNumber).Should().BeTrue("no plots in unit yet");
database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES ('{cruiseID}', '{plotID}', '{unitCode}', {plotNumber});");
datastore.IsPlotNumberAvalible(unitCode, plotNumber).Should().BeFalse("we just inserted a plot");
}
}
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);
}
}
