public GroupTestToIndividualTest(GetSqlServer getSqlServer)
{
groupTestsTable = getSqlServer.FilledTable("SELECT * FROM grouptest"); ;
}
/// <summary>
/// If the Date changes, wipe out the table of orderNumbers and restart ordering
/// </summary>
/// <remarks></remarks>
public static void TruncateOrderNumbersOnDateChange(GetSqlServer getSqlServer)
{
if (DateTime.Now.Day != GlobalMutableState.StartupDate.Day)
{
var dtable = getSqlServer.FilledTable("select * FROM ordernumber");
if (dtable.Rows.Count != 1)
{
getSqlServer.ExecuteNonQuery("truncate TABLE ordernumber");
getSqlServer.ExecuteNonQuery("insert into ordernumber (OrderLast,Ordernumber) VALUES (1, 7500);");
}
GlobalMutableState.StartupDate = System.DateTime.Now;
}
}
