///<summary>Deletes everything from the Unit Test ProgramProperty table.</summary>
public static void ClearProgamPropertyTable()
{
string command = "DELETE FROM programproperty WHERE ProgramPropertyNum > 0";
DataCore.NonQ(command);
ProgramProperties.RefreshCache();
}
///<summary>Generates a single Unit Test ProgramProperty. This method refreshes the cache.</summary>
public static ProgramProperty CreateProgramProperty(long programNum, string propertyDesc, long clinicNum, string propertyValue = "",
string computerName = "")
{
ProgramProperty prop = new ProgramProperty();
prop.ProgramNum = programNum;
prop.PropertyDesc = propertyDesc;
prop.PropertyValue = propertyValue;
prop.ComputerName = computerName;
prop.ClinicNum = clinicNum;
ProgramProperties.Insert(prop);
ProgramProperties.RefreshCache();
return(prop);
}
///<summary>Tests the Delete method in ProgramProperties to ensure it will delete when the PropertyDesc is one of those in
///the GetDeletablePropertyDescriptions() list, in this case ProgramProperties.PropertyDescs.ClinicHideButton.</summary>
public void ProgramProperties_Delete_DeletesWhenDescriptionInGetDeletablePropertyDescriptions()
{
ProgramProperty prop = ProgramPropertyT.CreateProgramProperty(10, ProgramProperties.PropertyDescs.ClinicHideButton, 1);
ProgramProperty getPropBefore = ProgramProperties.GetPropForProgByDesc(prop.ProgramNum, prop.PropertyDesc);
Assert.IsNotNull(getPropBefore);
Assert.AreEqual(prop.ProgramPropertyNum, getPropBefore.ProgramPropertyNum);
try {
ProgramProperties.Delete(prop);
}
catch (Exception ex) {
ex.DoNothing();
}
ProgramProperties.RefreshCache(); //Make sure data is as current as it can be.
//Ensure it was deleted.
ProgramProperty getPropAfter = ProgramProperties.GetPropForProgByDesc(prop.ProgramNum, prop.PropertyDesc);
Assert.IsNull(getPropAfter); //No longer in DB
}
///<summary>Tests the Delete method in ProgramProperties to ensure it does not delete a ProgramProperty when the PropertyDesc is outside of those
///in GetDeletablePropertyDescriptions(), instead it throws an exception (which we catch here) and then remains in the db.</summary>
public void ProgramProperties_Delete_DoesNotDeleteWhenDescriptionIsNotInGetDeletablePropertyDescriptions()
{
ProgramProperty prop = ProgramPropertyT.CreateProgramProperty(20, "Stuff", 2);
ProgramProperty getPropBefore = ProgramProperties.GetPropForProgByDesc(prop.ProgramNum, prop.PropertyDesc);
Assert.IsNotNull(getPropBefore);
Assert.AreEqual(prop.ProgramPropertyNum, getPropBefore.ProgramPropertyNum);
try {
ProgramProperties.Delete(prop);
}
catch (Exception ex) {
ex.DoNothing();
}
ProgramProperties.RefreshCache(); //Make sure data is as current as it can be.
//Ensure it was NOT deleted since the description is most certainly not in GetDeletablePropertyDescriptions().
ProgramProperty getPropAfter = ProgramProperties.GetPropForProgByDesc(prop.ProgramNum, prop.PropertyDesc);
Assert.IsNotNull(getPropAfter); //Still in DB
Assert.AreEqual(prop.ProgramPropertyNum, getPropAfter.ProgramPropertyNum); //And we know its the ProgramProperty we put in.
}
public void TearDownTest()
{
ProgramPropertyT.ClearProgamPropertyTable();
ProgramProperties.InsertMany(_listProgramProperties);
ProgramProperties.RefreshCache();
}
