Esempio n. 1
0
 private void btnDialogOk_Click(object sender, RoutedEventArgs e)
 {
     Items item = new Items(-1, (lbParent.SelectedItem as Products).Id, txtName.Text, Convert.ToDouble(txtPrice.Text));
     DBController.AddItem(item);
     this.DialogResult = true;
     this.Close();
 }
Esempio n. 2
0
 internal static void AddItem(Items item)
 {
     DBOpenClose(() =>
     {
         //string sql = "insert into users (name, password) values ('" + name + "', '" + password + "')";
         string sql = "insert into items (name,parent_id,price) values ('" + item.Name + "', '" + item.Parent_id + "', " + item.Price.ToString(CultureInfo.InvariantCulture) + ")";
         SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
         command.ExecuteNonQuery();
     });
 }