public void SyncStratumTemplates_Add()
{
var fromPath = base.GetTempFilePath(".crz3", "SyncStratumTemplates_Add_fromFile");
var toPath = base.GetTempFilePath(".crz3", "SyncStratumTemplates_Add_toFile");
var syncOptions = new CruiseSyncOptions()
{
Processing = SyncFlags.Insert,
};
var init = new DatabaseInitializer();
var cruiseID = init.CruiseID;
var saleID = init.SaleID;
using var fromDb = init.CreateDatabaseFile(fromPath);
fromDb.CopyTo(toPath, true);
using var toDb = new CruiseDatastore_V3(toPath);
var st = new StratumTemplate
{
CruiseID = cruiseID,
StratumTemplateName = "something",
};
fromDb.Insert(st);
var syncer = new CruiseSyncer();
syncer.Sync(cruiseID, fromDb, toDb, syncOptions);
toDb.From <StratumTemplate>().Count().Should().Be(1);
}
public void UpsertStratumTemplate(StratumTemplate st)
{
Database.Execute2(
@"INSERT INTO StratumTemplate (
StratumTemplateName,
CruiseID,
StratumCode,
Method,
BasalAreaFactor,
FixedPlotSize,
KZ3PPNT,
SamplingFrequency,
Hotkey,
FBSCode,
YieldComponent,
FixCNTField
) VALUES (
@StratumTemplateName,
@CruiseID,
@StratumCode,
@Method,
@BasalAreaFactor,
@FixedPlotSize,
@KZ3PPNT,
@SamplingFrequency,
@Hotkey,
@FBSCode,
@YieldComponent,
@FixCNTField
) ON CONFLICT (StratumTemplateName, CruiseID) DO
UPDATE SET
StratumCode = @StratumCode,
Method = @Method,
BasalAreaFactor = @BasalAreaFactor,
FixedPlotSize = @FixedPlotSize,
KZ3PPNT = @KZ3PPNT,
SamplingFrequency = @SamplingFrequency,
Hotkey = @Hotkey,
FBSCode = @FBSCode,
YieldComponent = @YieldComponent,
FixCNTField = @FixCNTField
WHERE StratumTemplateName = @StratumTemplateName AND CruiseID = @CruiseID;",
new
{
CruiseID,
st.StratumTemplateName,
st.StratumCode,
st.Method,
st.BasalAreaFactor,
st.FixedPlotSize,
st.KZ3PPNT,
st.SamplingFrequency,
st.Hotkey,
st.FBSCode,
st.YieldComponent,
st.FixCNTField,
});
}
public void DeleteStratumTemplate(StratumTemplate st)
{
Database.Execute("DELETE FROM StratumTemplate WHERE StratumTemplateName = @p1 AND CruiseID = @p2;", st.StratumTemplateName, CruiseID);
}
public void ExportStratumTemplate(){
System.Windows.Forms.SaveFileDialog FolderDialog = new System.Windows.Forms.SaveFileDialog ();
FolderDialog.Filter = "scmstratum files (*.scmst)|*.scmst|All files (*.*)|*.*" ;
FolderDialog.FilterIndex = 0 ;
FolderDialog.RestoreDirectory = true ;
FolderDialog.InitialDirectory = EnvPaths.GetMapsPath();
if (FolderDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Debug.Log( FolderDialog.FileName );
StratumTemplate NewTemplate = new StratumTemplate ();
NewTemplate.Stratum0 = Map.Textures [0];
NewTemplate.Stratum1 = Map.Textures [1];
NewTemplate.Stratum2 = Map.Textures [2];
NewTemplate.Stratum3 = Map.Textures [3];
NewTemplate.Stratum4 = Map.Textures [4];
NewTemplate.Stratum5 = Map.Textures [5];
NewTemplate.Stratum6 = Map.Textures [6];
NewTemplate.Stratum7 = Map.Textures [7];
NewTemplate.Stratum8 = Map.Textures [8];
NewTemplate.Stratum9 = Map.Textures [9];
string data = UnityEngine.JsonUtility.ToJson (NewTemplate);
File.WriteAllText (FolderDialog.FileName, data);
}
}
