public override List <LoggingEntry> GetAll() { using (var connect = new SqlConnection(ConnectionString)) { connect.Open(); IDbCommand command = connect.CreateCommand(); command.CommandText = "SELECT * FROM musterag.v_logentries;"; IDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { LogObjects.Add(new LoggingEntry { Id = (int)dataReader["Id"], Hostname = dataReader["hostname"].ToString(), Location = dataReader["location"].ToString(), Message = dataReader["message"].ToString(), Pod = dataReader["pod"].ToString(), Severity = (int)dataReader["severity"], Timestamp = (DateTime)dataReader["timestamp"] }); } } return(LogObjects.ToList()); }
public Task <TaskLog> CreateLogAsync(Guid scopeIdentifier, string hubName, Guid planId, TaskLog log, CancellationToken cancellationToken) { log.Id = LogObjects.Count + 1; LogObjects.Add(log.Id, log); LogLines.Add(log.Id, new List <string>()); return(Task.FromResult(log)); }
public override List <Location> GetAll() { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM musterag.location"; LogObjects.Clear(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { LogObjects.Add(new Location { Id = reader.GetInt32(0), FK_PointOfDelivery = reader.GetInt32(1), FK_Address = reader.GetInt32(2), }); } } } } return(LogObjects); }