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);
}