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