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