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