Esempio n. 1
0
        private void buttonAdd_Click(object sender, EventArgs e)
        {
            MySqlConnection connection = Database.GetConnection();

            connection.Open();

            string       sql     = "INSERT INTO tbl_jobs (customerID, problem, details, computerUsername, computerPassword, backup, format, shouldCallBefore, speakingAuthorisation, receiptKey) VALUES (@customerID, @problem, @details, @computerUsername, @computerPassword, @backup, @format, @shouldCallBefore, @speakingAuthorisation, @receiptKey); INSERT INTO tbl_transactions (jobID, cost, phonedCustomer, leftMessage, amountPaid, paymentMethod, staffUsername) VALUES (LAST_INSERT_ID(), 0.00, 0, 0, 0.00, '', '');";
            MySqlCommand command = new MySqlCommand(sql, connection);

            command.Parameters.AddWithValue("@customerID", customerID);
            command.Parameters.AddWithValue("@problem", textBoxProblem.Text);
            command.Parameters.AddWithValue("@details", textBoxDetails.Text);
            command.Parameters.AddWithValue("@computerUsername", textBoxUsername.Text);
            command.Parameters.AddWithValue("@computerPassword", textBoxPassword.Text);
            command.Parameters.AddWithValue("@backup", Database.BoolToDatabase(checkBoxBackup.Checked));
            command.Parameters.AddWithValue("@format", Database.BoolToDatabase(checkBoxFormat.Checked));
            command.Parameters.AddWithValue("@shouldCallBefore", Database.BoolToDatabase(checkBoxNeedCall.Checked));
            command.Parameters.AddWithValue("@speakingAuthorisation", textBoxSpeakTo.Text);
            command.Parameters.AddWithValue("@receiptKey", Receipts.GenerateReceiptKey());

            command.ExecuteNonQuery();

            connection.Close();

            shouldPopUp = false;

            this.Close();
        }
Esempio n. 2
0
 private void buttonRegenerate_Click(object sender, EventArgs e)
 {
     receiptKey = Receipts.GenerateReceiptKey();
     MessageBox.Show("Receipt key changed");
     shouldPopUp = true;
 }