private void btn_login_Click(object sender, EventArgs e) { string login = "******" + txt_user.Text + "' and password='******'"; dtlogin = conn.BukaTabel(login); if (dtlogin.Rows.Count > 0) { txt_user.Text = ""; //menghilangkan inputan awal teks txt_pass.Text = ""; this.Hide(); //menghilangkan / mengecilkan menu form login koneksi.nmuser = dtlogin.Rows[0][1].ToString(); menu mn = new menu(); mn.Show(); mn.lb_user.Text = koneksi.nmuser; } else { MessageBox.Show("Data Tidak Ditemukan"); } }
private void btn_sav_Click(object sender, EventArgs e) { /*menu mn = new menu(); * * if (this.Text == "Invoice - Tambah data") * { * string transaksi1 = "insert into invoice(noinvoice, tanggal, idcust, username, totalvol, totaltag) " + * " values('" + txt_noinv.Text + "' , '" + pick_time.Text + "' , '" + cb_idcust.Text + "' , '" + koneksi.nmuser + "' , '" + txt_totalvol.Text + "' , '" + txt_totaltag.Text + "') "; * conn.AksiQuery(transaksi1); * string transaksi2 = "insert into detinvoice(noinvoice, kdkayu, kdjasa, volume, tagihan) " + * " values('" +txt_noinv.Text + "' , '" + cb_kayu.Text + "' , '" + cb_jasa.Text + "' , '" + txt_vol.Text + "' , '" + txt_tag.Text + "') "; * conn.AksiQuery(transaksi2); * MessageBox.Show("Simpan Transaksi Sukses.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); * this.Text = "Invoice"; * txt_noinv.Enabled = false; * cb_idcust.Enabled = false; * cb_kayu.Text = null; * cb_jasa.Text = null; * txt_vol.Clear(); txt_tag.Clear(); * TampilDetail(); * btn_add.Focus(); * this.Text = "Invoice - Tambah Data"; * * }*/ string SqlSimpan1; string SqlSimpan2; menu mn = new menu(); if (txt_noinv.Text == "") { MessageBox.Show("No Invoice Tidak Boleh Kosong", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (this.Text == "Invoice - Tambah Data") { SqlSimpan1 = "insert into invoice(noinvoice, tanggal, idcust, username) " + " values('" + txt_noinv.Text + "' , '" + pick_time.Text + "' , '" + cb_idcust.Text + "' , '" + koneksi.nmuser + "') "; conn.AksiQuery(SqlSimpan1); SqlSimpan2 = "insert into detinvoice(noinvoice, kdkayu, kdjasa, volume, tagihan) " + " values('" + txt_noinv.Text + "' , '" + cb_kayu.Text + "' , '" + cb_jasa.Text + "' , '" + txt_vol.Text + "' , '" + txt_tag.Text + "') "; conn.AksiQuery(SqlSimpan2); MessageBox.Show("Data Invoice Berhasil Disimpan"); TampilInvoice(); this.Text = "invoice"; } else if (this.Text == "Invoice - Edit Jasa") { string edit = "update invoice set tanggal='" + pick_time.Text + "', idcust='" + cb_idcust.Text + "' where noinvoice='" + txt_noinv.Text + "'"; conn.AksiQuery(edit); string edit1 = "update detinvoice set kdkayu='" + cb_kayu.Text + "', kdjasa='" + cb_jasa.Text + "', volume='" + txt_vol.Text + "', tagihan='" + txt_tag.Text + "' where detinvoice='" + txt_noinv.Text + "'"; conn.AksiQuery(edit1); MessageBox.Show("Edit Data Berhasil", "SUCCESS", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_noinv.Clear(); pick_time.Text = null; cb_idcust.Text = null; txt_nacust.Clear(); cb_kayu.Text = null; txt_nakayu.Clear(); cb_jasa.Text = null; txt_jenis.Clear(); txt_harga.Clear(); txt_vol.Clear(); TampilInvoice(); } } }