// // Returns a quote given a quote ID. // public Quote Find(string quoteId) { if (null == _dbConn) { return(null); } Quote quote = null; if (PrincipalTable.TableExists()) { quote = PrincipalTable.GetQuoteByQid(quoteId); } return(quote); }
// // Output via the console a single quote given the quote ID // from the commandline argument "--qid". // public static void GetQuoteByQid(IConfiguration config) { _logger.Trace("Retrieving quote..."); string cs = null; try { cs = GetConnectionString(); } catch (System.ArgumentException ex) { _logger.Fatal($"Cannot get connection string: {ex.Message}"); Console.WriteLine($"Error: Operation aborted - {ex.Message}."); return; } catch (Exception ex) { _logger.Fatal($"Unable to access database : {ex.Message}"); Console.WriteLine($"Error: Operation aborted - {ex.Message}."); return; } MySqlConnection conn = new MySqlConnection(cs); PrincipalTable.DatabaseConnection = conn; if (!PrincipalTable.TableExists()) { _logger.Fatal("Table does not already exist, " + "cannot locate quotes by ID."); Console.WriteLine("Error: Operation aborted."); return; } string quoteId = config["qid"]; string qid = config["qid"]; Quote quote = null; if (null != qid) { quote = PrincipalTable.GetQuoteByQid(qid); } if (null == quote) { string message = $"No quote with ID '{qid}' found."; _logger.Info(message); Console.WriteLine(message); return; } _logger.Info("Quote = " + quote.ToString()); Console.WriteLine("-- Quote ID = {0}.", quote.ID); Console.WriteLine("-- Ext Ref ID = {0}.", quote.ExternalRefID); Console.WriteLine("-- Quote text = {0}.", quote.Content); Console.WriteLine("-- Quote source = {0}.", quote.Source); Console.WriteLine("-- Source URL = {0}.", quote.SourceUrl); Console.WriteLine("-- Quote entry datetime = {0}.", quote.EntryDatetime); Console.WriteLine("-- Quote last mod = {0}.", quote.ModTimestamp); Console.WriteLine("-- Quote = {0}.", quote.ToString()); }