private void Shipping_Click(object sender, RoutedEventArgs e)
{
shippingSeller ss = new shippingSeller(username, kode);
ss.Show();
this.Close();
}
private void Submit_Click(object sender, RoutedEventArgs e)
{
if (lapor.Text != "")
{
try
{
conn.Open();
string query = $"insert into mh_report (fk_pelapor, fk_dilapor, alasan) values('{kode}', '{kodeBuyer}', '{lapor.Text}')";
cmd = new OracleCommand(query, conn);
cmd.ExecuteNonQuery();
cmd = new OracleCommand()
{
CommandType = CommandType.StoredProcedure,
Connection = conn,
CommandText = "cek_report"
};
cmd.Parameters.Add(new OracleParameter()
{
Direction = ParameterDirection.Input,
ParameterName = "temp",
OracleDbType = OracleDbType.Varchar2,
Size = 70,
Value = "a"
});
cmd.ExecuteNonQuery();
query = $"update dtrans set reportB = 1 where kode_dtrans in (" +
$"select d.kode_dtrans from htrans h, dtrans d, mh_produk p, mh_user u " +
$"where h.kode_htrans = '{kodeH}' and h.kode_htrans = d.fk_htrans and d.fk_produk = p.kode_produk and p.fk_penjual = u.kode_user and u.kode_user = '******')";
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");
shippingSeller ss = new shippingSeller(username, kode);
ss.Show();
this.Close();
}
else
{
MessageBox.Show("Reason is Required");
}
}
