public void loadData()
{
listDTrans.Items.Clear();
submit.IsEnabled = false;
try
{
conn.Open();
string query = "select distinct h.kode_htrans " +
"from htrans h, dtrans d, mh_user u, mh_produk p " +
"where h.kode_htrans = d.fk_htrans and d.status < 2 and d.reportB = 0 and d.fk_produk = p.kode_produk and p.fk_penjual = u.kode_user and u.kode_user = '******' order by 1 desc";
cmd = new OracleCommand(query, conn);
htrans.ItemsSource = null;
using (OracleDataReader reader = cmd.ExecuteReader())
{
List <headerTrans> kodeHtrans = new List <headerTrans>();
while (reader.Read())
{
headerTrans temp = new headerTrans();
temp.Kode = reader.GetString(0);
temp.Nama = reader.GetString(0);
kodeHtrans.Add(temp);
}
htrans.SelectedValuePath = "Kode";
htrans.DisplayMemberPath = "Nama";
htrans.ItemsSource = kodeHtrans;
}
conn.Close();
}
catch (Exception ex)
{
conn.Close();
Console.WriteLine(ex.StackTrace);
}
}
public void loadData()
{
try
{
conn.Open();
string query = "select kode_htrans from htrans where fk_pelanggan = '" + kode + "' and status < 2 order by 1 desc";
cmd = new OracleCommand(query, conn);
htrans.ItemsSource = null;
using (OracleDataReader reader = cmd.ExecuteReader())
{
List <headerTrans> kodeHtrans = new List <headerTrans>();
while (reader.Read())
{
headerTrans temp = new headerTrans();
temp.Kode = reader.GetString(0);
temp.Nama = reader.GetString(0);
kodeHtrans.Add(temp);
}
htrans.SelectedValuePath = "Kode";
htrans.DisplayMemberPath = "Nama";
htrans.ItemsSource = kodeHtrans;
}
conn.Close();
}
catch (Exception ex)
{
conn.Close();
Console.WriteLine(ex.StackTrace);
}
}
