public void AddDailySettingsShouldInsert() { // arrage DailySettings daily = new DailySettings(); daily.DayOfYear = 3; daily.TimePeriod = 0; daily.Rotors = "I V II"; daily.Reflector = "B"; daily.BetaOrGamma = "Beta"; daily.Offsets = "0 9 21"; daily.Plugs = "I H L P Y S R D M W O Z B N U F Q K C A"; daily.StartingPositions = "W O L F"; DailySettingsDAO dao = new DailySettingsDAO(databaseConnectionString); int starting = dao.GetDailySettings().Count; // act dao.AddDailySettings(daily); // assert int ending = dao.GetDailySettings().Count; Assert.AreNotEqual(starting, ending); }
public void PopulateDailySettings() { int count = 1; List <int> period = new List <int>() { 0, 8, 16 }; Program program = new Program(); DailySettingsDAO dao = new DailySettingsDAO(program.ReturnConnectionString()); Console.WriteLine($"Total rows before inserts: {dao.GetDailySettings().Count}"); while (count < 1098) { DailySettings daily = new DailySettings(); daily.DayOfYear = 1 + count / 3; daily.TimePeriod = period[count % 3]; daily.Rotors = string.Join(" ", lister.Randomizer(lister.GetRotors(), 3)); daily.Reflector = string.Join(" ", lister.Randomizer(lister.GetReflector(), 1)); daily.BetaOrGamma = string.Join(" ", lister.Randomizer(lister.GetFourth(), 1)); daily.Offsets = string.Join(" ", lister.OffsetMaker()); daily.Plugs = string.Join(" ", lister.Randomizer(lister.GetAlphabet(), 20)); daily.StartingPositions = string.Join(" ", lister.KeyMaker()); dao.AddDailySettings(daily); count++; } Console.WriteLine($"Total rows after inserts: {dao.GetDailySettings().Count}"); }
public void SelectDailySettingsShouldReturnOne(int id) { // arrage DailySettingsDAO dao = new DailySettingsDAO(databaseConnectionString); IList <DailySettings> settings = dao.SelectDailySettings(id); // act int result = settings.Count; // assert Assert.AreEqual(1, result); }
public void GetDailySettingsShouldReturnListCountSix() { // arrage DailySettingsDAO dao = new DailySettingsDAO(databaseConnectionString); IList <DailySettings> settings = dao.GetDailySettings(); // act int result = settings.Count; // assert Assert.AreEqual(6, result); }
static void Main(string[] args) { var services = ServiceProviderBuilder.GetServiceProvider(args); var options = services.GetRequiredService <IOptions <MyOptions> >(); string connectionString = options.Value.SecretOption; databaseConnectionString = connectionString; IDailySettingsDAO dailyDAO = new DailySettingsDAO(connectionString); // options.Value.SecretOption will be SQL Connection String and editable via secrets.json // options.Value.OpenOption is in appsettings.json UserInterface userInterface = new UserInterface(); userInterface.Menus(); }