public static void AddQuoteToDB(Quote quote) { string tableName = "QUOTES"; string columnNames = "QuoteText, ChannelName, AddedBy, DateAdded"; string parameterNames = @"@quoteText, @channelName, @addedBy, @dateAdded"; Action<SqlCommand> addParameters = (insertCommand) => { insertCommand.Parameters.AddWithValue("@quoteText", quote.QuoteText); insertCommand.Parameters.AddWithValue("@channelName", quote.Channel); insertCommand.Parameters.AddWithValue("@addedBy", quote.AddedBy); insertCommand.Parameters.AddWithValue("@dateAdded", quote.DateAdded); }; Database.InsertEntry(tableName, columnNames, parameterNames, addParameters); }
public static Quote GetQuoteFromDBAtRow(int rowNumber) { Func<SqlDataReader, Quote> getQuoteParameters = (reader) => { Quote quote = new Quote(reader["QuoteText"].ToString(), reader["ChannelName"].ToString(), reader["AddedBy"].ToString(), (DateTime)reader["DateAdded"]); return quote; }; return Database.GetEntryAt("QUOTES", rowNumber, getQuoteParameters); }