public Settings this[int day] { get { return(DailySettings.FirstOrDefault(s => s.Date.Day == day)); } }
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 IList <DailySettings> SelectDailySettings(int id) { List <DailySettings> settings = new List <DailySettings>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(getDailySettingsById, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DailySettings daily = ConvertReaderToDailySettings(reader); settings.Add(daily); } } } catch (SqlException ex) { Console.WriteLine("An error occured communicating with the database. "); Console.WriteLine(ex.Message); throw; } return(settings); }
public void AddDailySettings(DailySettings dailySettings) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(insertIntoDailySettings, conn); cmd.Parameters.AddWithValue("@dayofyear", dailySettings.DayOfYear); cmd.Parameters.AddWithValue("@timeperiod", dailySettings.TimePeriod); cmd.Parameters.AddWithValue("@rotors", dailySettings.Rotors); cmd.Parameters.AddWithValue("@reflectors", dailySettings.Reflector); cmd.Parameters.AddWithValue("@betaorgamma", dailySettings.BetaOrGamma); cmd.Parameters.AddWithValue("@offsets", dailySettings.Offsets); cmd.Parameters.AddWithValue("@plugs", dailySettings.Plugs); cmd.Parameters.AddWithValue("@startposition", dailySettings.StartingPositions); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { Console.WriteLine("An error occured communicating with the database. "); Console.WriteLine(ex.Message); throw; } }
public Settings this[string indicator] { get { if (indicator.All(c => char.IsNumber(c))) { return(DailySettings.FirstOrDefault(s => s.NumericIndicator == indicator)); } else { return(DailySettings.FirstOrDefault(s => s.Indicator == indicator)); } } }
private DailySettings ConvertReaderToDailySettings(SqlDataReader reader) { DailySettings daily = new DailySettings(); daily.DayOfYear = Convert.ToInt32(reader["day_of_year"]); daily.TimePeriod = Convert.ToInt32(reader["time_period"]); daily.Rotors = Convert.ToString(reader["rotors"]); daily.Reflector = Convert.ToString(reader["reflectors"]); daily.BetaOrGamma = Convert.ToString(reader["beta_or_gamma"]); daily.StartingPositions = Convert.ToString(reader["start_position"]); daily.Offsets = Convert.ToString(reader["offset"]); daily.Plugs = Convert.ToString(reader["plugs"]); return(daily); }