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())); }
public void SaveOrUpdate(TimeInterval timeInterval) { if (IsTimeIntervalAlreadySaved(timeInterval)) { Update(timeInterval); } else { using var command = _connection.CreateCommand(); command.Connection = _connection; command.CommandText = $"insert into {TimeInterval.GetTableName()}({TimeInterval.GetNameColumnName()}, {TimeInterval.GetTypeColumnName()}) " + "values (:name, :type);"; command.Parameters.AddWithValue("name", timeInterval.Name); command.Parameters.AddWithValue("type", (int)timeInterval.Type); Console.WriteLine("Execute SQL: " + command.CommandText); command.ExecuteNonQuery(); } }
private void Update(TimeInterval timeInterval) { var id = timeInterval.Id; if (id == 0) { id = GetTimeInterval(timeInterval.Type).Id; } using var command = _connection.CreateCommand(); command.Connection = _connection; command.CommandText = $"update {TimeInterval.GetTableName()} " + $"set {TimeInterval.GetNameColumnName()} = :new_name, {TimeInterval.GetTypeColumnName()} = :new_enum_number " + "where id = :id;"; command.Parameters.AddWithValue("new_name", timeInterval.Name); command.Parameters.AddWithValue("new_enum_number", (int)timeInterval.Type); command.Parameters.AddWithValue("id", id); Console.WriteLine("Execute SQL: " + command.CommandText); command.ExecuteNonQuery(); }