void AssignQuotes(DateTime finalDate) { _log.AppendEvent(ApplicationEventTypes.Information, "Creating QOTD list until " + finalDate.ToShortDateString()); //pull the stats information from the db WwfdData.GetStatsRow stats = new WwfdDataTableAdapters.GetStatsTableAdapter().GetData().First(); DateTime lastQuoteDate = stats.LastQOTD; TimeSpan span = finalDate - lastQuoteDate; WwfdDataTableAdapters.QOTDTableAdapter qotdAdapter = new WwfdDataTableAdapters.QOTDTableAdapter(); for (int i = 1; i <= span.Days; i++) { Console.WriteLine("Selecting quote for: " + lastQuoteDate.AddDays(i).ToShortDateString()); qotdAdapter.CreateRandomQOTD(); } _log.AppendEvent(ApplicationEventTypes.Information, "finished."); Pause(); ShowPrompt(); }