public TurnipInfo GetTurnipTableEntry(int id) { TurnipInfo turnipInfo = null; try { string sqlString = "SELECT WeekNum, Id, Name, BuyPrice, SellPrices, Pattern, FirstTime FROM Turnips WHERE Id = @Id"; using SqliteConnection connection = new SqliteConnection(_connectionString); connection.Open(); SqliteCommand command = connection.CreateCommand(); command.CommandText = sqlString; command.Parameters.AddWithValue("@Id", id); SqliteDataReader dataReader = command.ExecuteReader(); if (dataReader.Read()) { turnipInfo = TurnipInfo.Create(dataReader); } connection.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } return(turnipInfo); }
public List <TurnipInfo> GetAllTurnipsTableEntries() { List <TurnipInfo> turnipInfos = new List <TurnipInfo>(); try { string sqlString = "SELECT WeekNum, Id, Name, BuyPrice, SellPrices, Pattern, FirstTime FROM Turnips"; using SqliteConnection connection = new SqliteConnection(_connectionString); connection.Open(); SqliteCommand command = connection.CreateCommand(); command.CommandText = sqlString; SqliteDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { turnipInfos.Add(TurnipInfo.Create(dataReader)); } connection.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } return(turnipInfos); }