private void button2_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlConnection conn = konn.GetConn(); try { conn.Open(); string queryDelete1 = "delete Transaksi_Pemesanan where ID_Transaksi = '" + list_Restoran.id + "'"; string queryDelete2 = "delete Mengambil_Data where ID_Transaksi = '" + list_Restoran.id + "'"; SqlCommand cmd = new SqlCommand(queryDelete2, conn); cmd.ExecuteNonQuery(); cmd = new SqlCommand(queryDelete1, conn); cmd.ExecuteNonQuery(); MessageBox.Show("Data Di Keranjang Akan Dihapus"); list_Restoran a = new list_Restoran(); a.Show(); this.Hide(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } }
private void button1_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlConnection conn = konn.GetConn(); try { conn.Open(); SqlDataReader reader = null; string sql = "SELECT * FROM Customer WHERE Nomor_Telepon_Customer = '" + textBox1.Text + "'"; SqlCommand command = new SqlCommand(sql, conn); command.ExecuteNonQuery(); reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { telp = reader["Nomor_Telepon_Customer"].ToString(); } reader.Close(); } if (textBox1.Text.Equals(telp)) { idCus = textBox1.Text; list_Restoran a = new list_Restoran(); a.Show(); this.Hide(); } } catch (Exception ex) { MessageBox.Show("Customer Tidak Ada Pada Database"); } finally { conn.Close(); } }
private void button2_Click(object sender, EventArgs e) { string query = "update Transaksi_Pemesanan set status = 'proses' , Rating_Driver = @r1 where ID_Transaksi = '" + list_Restoran.id + "'"; System.Data.SqlClient.SqlConnection conn = konn.GetConn(); try { conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@r1", numericUpDown1.Value.ToString()); cmd.ExecuteNonQuery(); this.Hide(); list_Restoran a = new list_Restoran(); a.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } }