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; } }