예제 #1
0
        private void Submit_Click(object sender, RoutedEventArgs e)
        {
            if (nominal.Text == "")
            {
                MessageBox.Show("Please Fill in Nominal");
            }
            else
            {
                if (Convert.ToInt32(nominal.Text) < 10000)
                {
                    MessageBox.Show("Minimum Top Up is Rp10000");
                }
                else
                {
                    conn.Open();
                    string        query = "select saldo from mh_user where kode_user ='******'";
                    OracleCommand cmd   = new OracleCommand(query, conn);

                    int db = Convert.ToInt32(cmd.ExecuteScalar().ToString());
                    conn.Close();
                    int t = db + Convert.ToInt32(nominal.Text);
                    query = "update mh_user set saldo = " + t + " where kode_user = '******'";
                    cmd   = new OracleCommand(query, conn);
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    cmd = new OracleCommand("insert into history_emoney values ('', :fk, :emoney, :stat, '','TOP UP')", conn);
                    cmd.Parameters.Add(":fk", kod);
                    cmd.Parameters.Add(":emoney", Convert.ToInt32(nominal.Text));
                    cmd.Parameters.Add(":stat", 2);
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    MessageBox.Show("Top Up Success! +Rp" + nominal.Text);

                    if (from == 1)
                    {
                        Buyer b = new Buyer(user, kod);
                        b.Show();
                        this.Close();
                    }
                    else if (from == 2)
                    {
                        cartBuyer cb = new cartBuyer(user, kod, kodeHTRANS);
                        cb.Show();
                        this.Close();
                    }
                }
            }
        }
예제 #2
0
 private void Back_Click(object sender, RoutedEventArgs e)
 {
     if (from == 1)
     {
         Buyer b = new Buyer(user, kod);
         b.Show();
         this.Close();
     }
     else if (from == 2)
     {
         cartBuyer cb = new cartBuyer(user, kod, kodeHTRANS);
         cb.Show();
         this.Close();
     }
 }
예제 #3
0
        private void Submit_Click(object sender, RoutedEventArgs e)
        {
            conn.Open();
            trans = conn.BeginTransaction();
            string kodeH = "";

            try
            {
                cmd = new OracleCommand()
                {
                    Connection  = conn,
                    CommandText = "autogenht",
                    CommandType = CommandType.StoredProcedure
                };
                cmd.Parameters.Add(new OracleParameter()
                {
                    Direction     = ParameterDirection.ReturnValue,
                    ParameterName = "kodeht",
                    OracleDbType  = OracleDbType.Varchar2,
                    Size          = 13
                });
                cmd.ExecuteNonQuery();
                kodeH = cmd.Parameters["kodeht"].Value.ToString();
                DateTime tanggal_penuh = DateTime.Now;
                string   tanggal       = tanggal_penuh.Day.ToString().PadLeft(2, '0') + "-" + tanggal_penuh.Month.ToString().PadLeft(2, '0') + "-" + tanggal_penuh.Year.ToString();
                cmd = new OracleCommand("INSERT INTO htrans(kode_htrans,tgl_transaksi,berat,subtotal,fk_pelanggan,status) values(:kode,to_date(:tgl,'DD-MM-YYYY'),:brt,:sub,:beli,0)", conn);
                cmd.Parameters.Add(":kode", kodeH);
                cmd.Parameters.Add(":tgl", tanggal);
                cmd.Parameters.Add(":brt", totalberat);
                cmd.Parameters.Add(":sub", totalbeli);
                cmd.Parameters.Add(":beli", kode);
                cmd.ExecuteNonQuery();
                for (int i = 0; i < cart.Rows.Count; i++)
                {
                    DataRow dr  = submitbuy.NewRow();
                    DataRow dr1 = cart.Rows[i];
                    dr["fk_htrans"] = kodeH;
                    dr["fk_produk"] = listbeli[i];
                    dr["jumlah"]    = dr1["AMMOUNT"];
                    dr["harga"]     = dr1["PRICE"];
                    dr["subtotal"]  = dr1["SUBTOTAL"];
                    dr["status"]    = 0;
                    submitbuy.Rows.Add(dr);
                }
                dabuilder.Update(submitbuy);
                buildData();
                trans.Commit();
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                trans.Rollback();
                conn.Close();
                Console.WriteLine(ex.StackTrace);
            }
            cartBuyer cb = new cartBuyer(username, kode, kodeH);

            cb.Show();
            this.Close();
        }