public void InsertIntoTurnipsTable(TurnipInfo turnipInfo)
{
try
{
string sqlString = "INSERT INTO Turnips (WeekNum, Id, Name, BuyPrice, SellPrices, Pattern, FirstTime) VALUES " +
"(@WeekNum, @Id, @Name, @BuyPrice, @SellPrices, @Pattern, @FirstTime)";
using SqliteConnection connection = new SqliteConnection(_connectionString);
connection.Open();
SqliteCommand command = connection.CreateCommand();
command.CommandText = sqlString;
command.Parameters.AddWithValue("@WeekNum", turnipInfo.WeekNum);
command.Parameters.AddWithValue("@Id", turnipInfo.Id);
command.Parameters.AddWithValue("@Name", turnipInfo.Name);
command.Parameters.AddWithValue("@BuyPrice", turnipInfo.BuyPrice);
command.Parameters.AddWithValue("@SellPrices", turnipInfo.SellPricesString());
command.Parameters.AddWithValue("@Pattern", turnipInfo.Pattern.ToString());
command.Parameters.AddWithValue("@FirstTime", turnipInfo.FirstTime);
command.ExecuteNonQuery();
connection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void UpdateTurnipTableEntry(TurnipInfo turnipInfo)
{
try
{
string sqlString = "UPDATE Turnips SET Name = @Name, BuyPrice = @BuyPrice, SellPrices = @SellPrices, Pattern = @Pattern, FirstTime = @FirstTime Where Id = @Id";
using SqliteConnection connection = new SqliteConnection(_connectionString);
connection.Open();
SqliteCommand command = connection.CreateCommand();
command.CommandText = sqlString;
command.Parameters.AddWithValue("@Name", turnipInfo.Name);
command.Parameters.AddWithValue("@BuyPrice", turnipInfo.BuyPrice);
command.Parameters.AddWithValue("@SellPrices", turnipInfo.SellPricesString());
command.Parameters.AddWithValue("@Pattern", turnipInfo.Pattern);
command.Parameters.AddWithValue("@FirstTime", turnipInfo.FirstTime);
command.Parameters.AddWithValue("@Id", turnipInfo.Id);
command.ExecuteNonQuery();
connection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}