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