public store() { InitializeComponent(); m_dbConnection = new SQLiteConnection("Data Source=" + db_name + ";Version=3;"); m_dbConnection.Open(); string sql = "SELECT * FROM Товары ORDER BY Наименование"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { var data = new grid { Наименование = reader["Наименование"].ToString(), Описание = reader["Описание"].ToString(), Стоимость = int.Parse(reader["Стоимость"].ToString()), Количество = int.Parse(reader["Количество"].ToString()) }; things.Items.Add(data); } }
private void Buy_Click(object sender, RoutedEventArgs e) { armorb = false; weaponb = false; healb = false; try { grid val = (grid)things.SelectedItem; int choice = things.SelectedIndex; if (choice != -1) { int ch = val.Количество - 1; if (ch != 0) { things.Items.RemoveAt(choice); //string sql = "UPDATE Товары SET Количество = " + ch + " WHERE Стоимость = " + val.Стоимость; //SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); //command.ExecuteNonQuery(); var data = new grid { Наименование = val.Наименование, Описание = val.Описание, Количество = ch, Стоимость = val.Стоимость }; things.Items.Insert(choice, data); things.Items.Refresh(); } else { //string sql = "DELETE FROM Товары WHERE Стоимость = " + val.Стоимость; //SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); //command.ExecuteNonQuery(); things.Items.RemoveAt(choice); things.Items.Refresh(); } if (val.Стоимость == 12) { armorb = true; armor = armor + 10; gold += 12; } if (val.Стоимость == 10) { weaponb = true; weapon = weapon + 3; gold += 10; } if (val.Стоимость == 5) { healb = true; heal = heal + 1; gold += 5; } if (val.Стоимость == 100) { idk = 1; gold += 100; } } } catch (FormatException) { } catch (SQLiteException) { } catch (ArgumentOutOfRangeException) { } }