private void createinvoice_Click(object sender, RoutedEventArgs e) { InvoiceWindow iw = new InvoiceWindow(); iw.Show(); this.Hide(); }
public void SaveInvoiceToDatabase() { string connectionstring = null; connectionstring = myConnection.connectionString(); MySqlConnection cnn = new MySqlConnection(connectionstring); cnn.Open(); MySqlCommand command = cnn.CreateCommand(); command.Parameters.AddWithValue("@userid", LoginWindow.id); command.Parameters.AddWithValue("@invoiceid", invoiceid.Text); command.Parameters.AddWithValue("@clientname", nameField.Text); string[] tokens = paySUM.Text.Split(' '); command.Parameters.AddWithValue("@totalpay", float.Parse(tokens[0])); command.Parameters.AddWithValue("@totalqu", float.Parse(sumField.Text)); command.Parameters.AddWithValue("@prevbal", float.Parse(oldBalanceField.Text)); command.Parameters.AddWithValue("@newbal", float.Parse(newBalanceField.Text)); command.Parameters.AddWithValue("@date", string.Join("", DateTime.Now.ToString("dd/MM/yyyy HH:mm"))); bool cb = (bool)cbispaid.IsChecked; if (cb == true) { command.Parameters.AddWithValue("@ispaid", 1); } else { command.Parameters.AddWithValue("@ispaid", 0); } command.CommandText = "INSERT INTO SavedInvoices (userid,InvoiceId,Client_Name,Total_Payment,Total_Quantity,Previous_Balance,New_Balance,Date,IsPaid) VALUES (@userid, @invoiceid, @clientname, @totalpay, @totalqu, @prevbal, @newbal, @date, @ispaid)"; if (command.ExecuteNonQuery() > 0) { MessageBox.Show("Invoice was successfuly saved!"); this.Hide(); InvoiceWindow iw = new InvoiceWindow(); iw.Show(); } else { MessageBox.Show("WARNING!!! [Error: Invoive wasn't saved in database.]"); } cnn.Close(); }