public static string WriteFbLog(FizzBuzzLogDto fbl)
{
string responseMessage = "";
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
SqlCommand cmd = new SqlCommand(insertLogStr, connection);
cmd.Parameters.AddWithValue("@Results", fbl.Results);
cmd.Parameters.AddWithValue("@StatusCode", fbl.StatusCode);
cmd.Connection.Open();
var result = cmd.ExecuteNonQuery();
cmd.Connection.Close();
responseMessage = "success";
}
catch (Exception e)
{
responseMessage = e.Message;
}
}
return(responseMessage);
}
public static FizzBuzzLogDto GetLogById(int Id)
{
FizzBuzzLogDto fbLog = new FizzBuzzLogDto();
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
SqlCommand cmd = new SqlCommand(getLogsByIdStr, connection);
cmd.Parameters.AddWithValue("@ID", Id);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
fbLog = MapResultToDto(reader);
}
cmd.Connection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
return(fbLog);
}
private static FizzBuzzLogDto MapResultToDto(SqlDataReader reader)
{
var log = new FizzBuzzLogDto
{
ID = (int)reader["FizzBuzzLogID"],
LogDate = (DateTime)reader["LogDate"],
Results = (string)reader["Results"],
StatusCode = (int)reader["StatusCode"]
};
return(log);
}
