public List <TimeInterval> GetTimeIntervals()
{
using var command = _connection.CreateCommand();
command.Connection = _connection;
command.CommandText =
$"select {TimeInterval.GetIdColumnName()}, {TimeInterval.GetNameColumnName()}, {TimeInterval.GetTypeColumnName()} " +
$"from {TimeInterval.GetTableName()};";
Console.WriteLine("Execute SQL: " + command.CommandText);
return(Factory.CreateTimeIntervalList(command.ExecuteReader()));
}
public TimeInterval GetTimeInterval(TimeIntervalType timeIntervalType)
{
using var command = _connection.CreateCommand();
command.Connection = _connection;
command.CommandText =
$"select {TimeInterval.GetIdColumnName()}, {TimeInterval.GetNameColumnName()}, {TimeInterval.GetTypeColumnName()} " +
$"from {TimeInterval.GetTableName()} " +
$"where {TimeInterval.GetTypeColumnName()} = :enum_number;";
command.Parameters.AddWithValue("enum_number", (int)timeIntervalType);
Console.WriteLine("Execute SQL: " + command.CommandText);
return(Factory.CreateTimeInterval(command.ExecuteReader()));
}
