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