public List <LogMessage> GetLogMessages(string clientGuid, LogMessage.LogStatus status)
{
var query =
"SELECT ClientGuid, Time, Status, Message " +
"FROM dbo.Logs " +
"WHERE ClientGuid = @clientGuid";
if (status != LogMessage.LogStatus.Any)
{
query += " AND Status = @Status";
}
var logMessages = new List <LogMessage>();
using (var connection = new SqlConnection(connectionString))
{
var command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@clientGuid", clientGuid);
command.Parameters.AddWithValue("@Status", status.ToString());
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
logMessages.Add(new LogMessage
(
clientGuid: reader["ClientGuid"].ToString(),
message: reader["Message"].ToString(),
time: (DateTime)reader["Time"],
status: reader["Status"].ToString(),
metadata: reader["Metadata"].ToString()
));
}
return(logMessages);
}
}
public List <LogMessage> GetLogMessages(string clientGuid, LogMessage.LogStatus status, DateTime fromDate, DateTime ToDate)
{
throw new NotImplementedException();
}
