public void Simulation_Method_SaveToSQLDB_WithDateTime(string Name, string Description, string SimSigWikiLink, string SimSigCode)
{
Core.SimSig.Simulation TestSim = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
DateTimeOffset TestDateTime = new DateTimeOffset(new DateTime(2019, 1, 1), TimeSpan.FromHours(-8));
TestSim.SaveToSQLDB(TestDateTime);
Assert.Equal(Name, TestSim.Name);
Assert.Equal(Description, TestSim.Description);
Assert.Equal(SimSigWikiLink, TestSim.SimSigWikiLink);
Assert.Equal(SimSigCode, TestSim.SimSigCode);
Assert.NotEqual(0, TestSim.ID);
this._SQLConnection.Open();
SqlCommand Cmd = this._SQLConnection.SQLCommand("SELECT createdon, modifiedon FROM [simsig].[TSIM] WHERE [id] = @id", System.Data.CommandType.Text);
Cmd.Parameters.Add(new SqlParameter("@id", TestSim.ID));
SqlDataReader DataReader = Cmd.ExecuteReader();
DateTimeOffset TestCreatedOnDateTime = DateTimeOffset.UtcNow;
DateTimeOffset TestModifiedOnDateTime = DateTimeOffset.UtcNow;
while (DataReader.Read())
{
TestCreatedOnDateTime = DataReader.GetDateTimeOffset(0);
TestModifiedOnDateTime = DataReader.GetDateTimeOffset(1);
}
this._SQLConnection.Close();
Assert.Equal(TestDateTime, TestCreatedOnDateTime);
Assert.Equal(TestDateTime, TestModifiedOnDateTime);
}
public void Simulation_Method_Exists(string Name, string Description, string SimSigWikiLink, string SimSigCode)
{
Core.SimSig.Simulation TestSim = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
Assert.False(TestSim.Exists());
TestSim.SaveToSQLDB();
//Now create a new Simulation object with the same arguments and see if it exists.
Core.SimSig.Simulation TestSimExists = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
Assert.True(TestSimExists.Exists());
}
public void Simulation_Method_SaveToSQLDB_NoDateTime(string Name, string Description, string SimSigWikiLink, string SimSigCode)
{
Core.SimSig.Simulation TestSim = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
TestSim.SaveToSQLDB();
Assert.Equal(Name, TestSim.Name);
Assert.Equal(Description, TestSim.Description);
Assert.Equal(SimSigWikiLink, TestSim.SimSigWikiLink);
Assert.Equal(SimSigCode, TestSim.SimSigCode);
Assert.NotEqual(0, TestSim.ID);
}
public void Simulation_Method_SaveToSQLDB_NoDateTime_CheckDuplicateUpdatesExistingRecord(string Name, string Description, string SimSigWikiLink, string SimSigCode)
{
Core.SimSig.Simulation TestSim = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
TestSim.SaveToSQLDB();
int TestID = TestSim.ID;
//Create a new object with same properties. The ID returned when saving should be the same as the first record saved
Core.SimSig.Simulation DupeTestSim = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
DupeTestSim.SaveToSQLDB();
Assert.Equal(TestID, DupeTestSim.ID);
}
public void Simulation_Method_SaveToSQLDB_NoDateTime_CheckGetFromSQLDatabase(string Name, string Description, string SimSigWikiLink, string SimSigCode)
{
Core.SimSig.Simulation SetUpSim = new Core.SimSig.Simulation(Name, Description, SimSigWikiLink, SimSigCode, this._SQLConnection);
SetUpSim.SaveToSQLDB();
int SetupSimID = SetUpSim.ID;
//Retrieve the simulation record from the Groundframe.SQL database
Core.SimSig.Simulation TestSim = new Core.SimSig.Simulation(SetupSimID, this._SQLConnection);
Assert.Equal(Name, TestSim.Name);
Assert.Equal(Description, TestSim.Description);
Assert.Equal(SimSigWikiLink, TestSim.SimSigWikiLink);
Assert.Equal(SimSigCode.ToLower(), TestSim.SimSigCode);
Assert.Equal(SetupSimID, TestSim.ID);
}
public void LocationCollection_Constructor_Default()
{
//Populate some data
Core.SimSig.Simulation TestSim = new Core.SimSig.Simulation("LocColl Sim Name", "LocColl Sim Desc", null, "LocCollCode", this._SQLConnection);
TestSim.SaveToSQLDB();
Core.SimSig.Location TestLocation1 = new Core.SimSig.Location(TestSim, "LocColl Loc Name", null, "LocCollLocCode1", true, Core.SimSig.SimSigLocationType.Station, this._SQLConnection);
TestLocation1.SaveToSQLDB();
Core.SimSig.Location TestLocation2 = new Core.SimSig.Location(TestSim, "LocCol2 Loc Name", "LocCollTIPLOC2", "LocCollLocCode2", false, Core.SimSig.SimSigLocationType.Station, this._SQLConnection);
TestLocation2.SaveToSQLDB();
//Get Collection
Core.SimSig.LocationCollection TestLocCollection = new Core.SimSig.LocationCollection(TestSim, this._SQLConnection);
//Check 5 records are returned
Assert.Equal(2, TestLocCollection.Count);
}