public void saveToDatabase(List <Race> races, SQLiteConnection m_dbConnection)
{
Day d = new Day(date, races);
DataAccessObject.save(m_dbConnection, d, true);
Console.WriteLine("Finished saving: " + d.getSqlDate());
}
/**
* Prints all string representations of days in SQLite database.
*/
public static void printAll()
{
SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=Saratoga.sqlite;Version=3;");
m_dbConnection.Open();
string s = "";
List <Day> dayList = DataAccessObject.retrieve(m_dbConnection);
List <string> stringList = new List <string>();
foreach (Day day in dayList)
{
stringList.Add(day.ToString());
}
File.WriteAllLines(@"C:\Users\Ryan\AllHorsesInTable.txt", stringList);
}
static void Main(string[] args)
{
SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=Saratoga.sqlite;Version=3;");
m_dbConnection.Open();
List <Day> days = DataAccessObject.retrieve(m_dbConnection);
foreach (Day day in days)
{
if (day != null && day.isValid())
{
day.setAllHorseRanks();
}
}
findBestBet(days);
}