Exemple #1
0
        private void Shipping_Click(object sender, RoutedEventArgs e)
        {
            shippingBuyer sb = new shippingBuyer(username, kode);

            sb.Show();
            this.Close();
        }
 public void loadData()
 {
     try
     {
         conn.Open();
         string query = "select u.kode_user, u.nama_user, p.kode_produk, p.nama_produk, d.kode_dtrans, d.harga " +
                        "from mh_user u, htrans h, dtrans d, mh_produk p " +
                        "where h.kode_htrans = '" + kodeHTrans + "' and h.kode_htrans = d.fk_htrans and d.status = 1 and d.reportS = 0 and d.fk_produk = p.kode_produk and p.fk_penjual = u.kode_user " +
                        "order by 2";
         cmd = new OracleCommand(query, conn);
         namaSeller.ItemsSource = null;
         using (OracleDataReader reader = cmd.ExecuteReader())
         {
             kodeUserPenjual.Clear();
             while (reader.Read())
             {
                 namaPenjual temp = new namaPenjual();
                 temp.KodeS  = reader.GetString(0);
                 temp.NamaS  = reader.GetString(1);
                 temp.KodeP  = reader.GetString(2);
                 temp.NamaP  = reader.GetString(3);
                 temp.KodeD  = reader.GetString(4);
                 temp.Harga  = reader.GetDecimal(5);
                 temp.Tampil = reader.GetString(1) + " - " + reader.GetString(3);
                 kodeUserPenjual.Add(temp);
             }
             namaSeller.SelectedValuePath = "KodeS";
             namaSeller.DisplayMemberPath = "Tampil";
             namaSeller.ItemsSource       = kodeUserPenjual;
         }
         conn.Close();
     }
     catch (Exception ex)
     {
         conn.Close();
         Console.WriteLine(ex.StackTrace);
     }
     if (kodeUserPenjual.Count == 0)
     {
         try
         {
             conn.Open();
             string query = $"update htrans set status = 2 where kode_htrans = '" + kodeHTrans + "'";
             cmd = new OracleCommand(query, conn);
             cmd.ExecuteNonQuery();
             conn.Close();
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.StackTrace);
             conn.Close();
         }
         MessageBox.Show("Already Done, Thank You For Your Cooperation");
         shippingBuyer sb = new shippingBuyer(username, kode);
         sb.Show();
         this.Close();
     }
 }