private void verifyReceiptToolStripMenuItem_Click(object sender, EventArgs e) { Misc.GetReceiptString receiptString = new Misc.GetReceiptString(); receiptString.ShowDialog(); if (receiptString.confirmed) { string receiptCode = receiptString.receiptCode; MySqlConnection connection = Database.GetConnection(); connection.Open(); string sql = "SELECT * FROM tbl_jobs WHERE receiptKey = @receiptCode"; MySqlCommand command = new MySqlCommand(sql, connection); command.Parameters.AddWithValue("@receiptcode", receiptCode); MySqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { DialogResult result = MessageBox.Show("Job Found, would you like to open?", "Success", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { Jobs.View viewJob = new Jobs.View(reader.GetInt32("jobID")); viewJob.ShowDialog(); } } else { MessageBox.Show("Invalid receipt code, please try again"); } } }
private void buttonVerify_Click(object sender, EventArgs e) { Misc.GetReceiptString getReceiptString = new Misc.GetReceiptString(); getReceiptString.ShowDialog(); if (getReceiptString.confirmed) { MySqlConnection connection = Database.GetConnection(); connection.Open(); string sql = "SELECT jobID FROM tbl_jobs WHERE receiptKey = @receiptKey"; MySqlCommand command = new MySqlCommand(sql, connection); command.Parameters.AddWithValue("@receiptKey", getReceiptString.receiptCode); MySqlDataReader data = command.ExecuteReader(); if (data.Read()) { if (data.GetInt32(data.GetOrdinal("jobID")) == jobID) { MessageBox.Show("Receipt is valid"); } else { MessageBox.Show("Receipt is invalid"); } } else { MessageBox.Show("Receipt is invalid"); } } }