private void btnProses_Click(object sender, EventArgs e) { int i, idx = dipinjam.Rows.Count, error = 1; string newDate = DateTime.Now.Date.ToString().Substring(0, 10); for (i = 0; i < idx; i++) { if (daftarPinjaman.Rows[i].ItemArray[3].ToString() == "Baik" || daftarPinjaman.Rows[i].ItemArray[3].ToString() == "Buruk") { error = 0; } } if (error == 0) { frmBayarKembali formBayarKembali = new frmBayarKembali(lblNmrNota.Text, int.Parse(lblBiayaDenda.Text)); formBayarKembali.ShowDialog(this); if (formBayarKembali.getHasil() == true) { for (i = 0; i < idx; i++) { if (daftarPinjaman.Rows[i].ItemArray[3].ToString() == "Baik") { Program.conn.ExecuteNonQuery("UPDATE stokkoleksi SET kondisi = 0, status = 0 WHERE kodestok = '" + daftarPinjaman.Rows[i].ItemArray[2].ToString() + "'"); } else { Program.conn.ExecuteNonQuery("UPDATE stokkoleksi SET kondisi = 1, status = 0 WHERE kodestok = '" + daftarPinjaman.Rows[i].ItemArray[2].ToString() + "'"); } Program.conn.ExecuteNonQuery("UPDATE dipinjam SET hargadenda = " + int.Parse(daftarPinjaman.Rows[i].ItemArray[6].ToString()) + " WHERE nonota = '" + lblNmrNota.Text + "' AND kodestok = '" + daftarPinjaman.Rows[i].ItemArray[2].ToString() + "'"); } Program.conn.ExecuteNonQuery("UPDATE nota SET tglrealisasikembali = sysdate WHERE nonota = '" + lblNmrNota.Text + "'"); MessageBox.Show("Transaksi Berhasil"); frmLaporanNota notaTransaksi = new frmLaporanNota(lblNmrNota.Text); notaTransaksi.ShowDialog(this); daftarPinjaman.Clear(); tampilanAwal(); } else { tampilanAwal(); } } else { MessageBox.Show("Silahkan update kondisi"); } }
private void btnProses_Click(object sender, EventArgs e) { // Cek lagi apakah jumlah hari penyewaan tidak minus if (Int16.Parse(lblLamaPenyewaan.Text) > 0) { frmBayarKembali formBayarKembali = new frmBayarKembali(lblNmrNota.Text, int.Parse(lblBiayaSewa.Text)); formBayarKembali.ShowDialog(this); if (formBayarKembali.getHasil() == true) { string newDate = Program.convertTglkeOracle(System.DateTime.Now); string newTglKembali = Program.convertTglkeOracle(dtpTanggalKembali.Value); //insert belanjaan ke tabel string insertNota = "INSERT INTO nota (nonota,kodeoperator,kodepenawaranspesial,kodemember,tgltransaksi,tglkembali)VALUES ('" + Program.escapeQuoteSQL(lblNmrNota.Text) + "','" + Program.session.getKodeOperator().ToString() + "','" + Program.so.getSpecialOfferCode() + "','" + Program.escapeQuoteSQL(lblKodeMember.Text) + "','" + newDate + "','" + newTglKembali + "')"; Program.conn.ExecuteNonQuery(insertNota); string kodeDipinjam = randomNota(); int i, idx = belanja.Rows.Count; for (i = 0; i < idx; i++) { string insertDipinjam = "INSERT INTO dipinjam (kodedipinjam, kodestok, nonota, hargasewa) VALUES('" + randomNota() + "','" + belanja.Rows[i].ItemArray[2].ToString() + "','" + lblNmrNota.Text + "'," + int.Parse(belanja.Rows[i].ItemArray[4].ToString()) + ")"; Program.conn.ExecuteNonQuery(insertDipinjam); string updateStok = "UPDATE stokkoleksi SET status = 1 WHERE kodestok = '" + belanja.Rows[i].ItemArray[2].ToString() + "'"; Program.conn.ExecuteNonQuery(updateStok); } MessageBox.Show("Transaksi Berhasil"); frmLaporanNota laporanNota = new frmLaporanNota(Program.escapeQuoteSQL(lblNmrNota.Text)); laporanNota.ShowDialog(this); tampilanAwal(); } else { tampilanAwal(); } } else { MessageBox.Show("Pastikan tanggal pengembalian diatur dengan benar (tidak diatur hari ini atau tanggal sebelumnya)"); } }
private void btnProses_Click(object sender, EventArgs e) { frmBayarKembali formBayarKembali = new frmBayarKembali(lblNmrNota.Text, int.Parse(lblBiayaSewa.Text)); formBayarKembali.ShowDialog(this); if (formBayarKembali.getHasil() == true) { string date = System.DateTime.Now.Date.ToString(); string newDate = date.Substring(0, 10); string tglKembali = dtpTanggalKembali.Value.Date.ToString(); string newTglKembali = tglKembali.Substring(0, 10); //insert belanjaan ke tabel string insertNota = "INSERT INTO nota (nonota,kodeoperator,kodepenawaranspesial,kodemember,tgltransaksi,tglkembali)VALUES ('" + lblNmrNota.Text + "','" + Program.session.getKodeOperator().ToString() + "'," + Program.so.getSpecialOfferCode() + ",'" + lblKodeMember.Text + "',to_date('" + newDate + "','mm/dd/yyyy'),to_date('" + newTglKembali + "','mm/dd/yyyy'))"; Program.conn.ExecuteNonQuery(insertNota); string kodeDipinjam = randomNota(); int i, idx = belanja.Rows.Count; for (i = 0; i < idx; i++) { string insertDipinjam = "INSERT INTO dipinjam (kodedipinjam, kodestok, nonota, hargasewa) VALUES('" + randomNota() + "','" + belanja.Rows[i].ItemArray[2].ToString() + "','" + lblNmrNota.Text + "'," + int.Parse(belanja.Rows[i].ItemArray[4].ToString()) + ")"; Program.conn.ExecuteNonQuery(insertDipinjam); string updateStok = "UPDATE stokkoleksi SET status = 1 WHERE kodestok = '" + belanja.Rows[i].ItemArray[2].ToString() + "'"; Program.conn.ExecuteNonQuery(updateStok); } MessageBox.Show("Transaksi Berhasil"); tampilanAwal(); } else { tampilanAwal(); } }
private void btnProses_Click(object sender, EventArgs e) { int i, idx = dipinjam.Rows.Count, error = 1; string newDate = DateTime.Now.Date.ToString().Substring(0, 10); MessageBox.Show(newDate); for (i = 0; i < idx; i++) { if (daftarPinjaman.Rows[i].ItemArray[3].ToString() == "Baik" || daftarPinjaman.Rows[i].ItemArray[3].ToString() == "Buruk") error = 0; } if (error == 0) { frmBayarKembali formBayarKembali = new frmBayarKembali(lblNmrNota.Text, int.Parse(lblBiayaDenda.Text)); if (int.Parse(lblBiayaDenda.Text) == 0) { formBayarKembali.ShowDialog(this); } if (formBayarKembali.getHasil() == true) { for (i = 0; i < idx; i++) { if (daftarPinjaman.Rows[i].ItemArray[3].ToString() == "Baik") { Program.conn.ExecuteNonQuery("UPDATE stokkoleksi SET kondisi = 0, status = 0 WHERE kodestok = '" + daftarPinjaman.Rows[i].ItemArray[2].ToString() + "'"); } else { Program.conn.ExecuteNonQuery("UPDATE stokkoleksi SET kondisi = 1, status = 0 WHERE kodestok = '" + daftarPinjaman.Rows[i].ItemArray[2].ToString() + "'"); } Program.conn.ExecuteNonQuery("UPDATE dipinjam SET hargadenda = " + int.Parse(daftarPinjaman.Rows[i].ItemArray[6].ToString()) + " WHERE nonota = '" + lblNmrNota.Text + "' AND kodestok = '" + daftarPinjaman.Rows[i].ItemArray[2].ToString() + "'"); } Program.conn.ExecuteNonQuery("UPDATE nota SET tglrealisasikembali = to_date('" + newDate + "','MM/dd/yyyy') WHERE nonota = '" + lblNmrNota.Text + "'"); MessageBox.Show("Transaksi Berhasil"); daftarPinjaman.Clear(); tampilanAwal(); } else { tampilanAwal(); } } else { MessageBox.Show("Silahkan update kondisi"); } }
private void btnProses_Click(object sender, EventArgs e) { // Cek lagi apakah jumlah hari penyewaan tidak minus if (Int16.Parse(lblLamaPenyewaan.Text) > 0) { frmBayarKembali formBayarKembali = new frmBayarKembali(lblNmrNota.Text, int.Parse(lblBiayaSewa.Text)); formBayarKembali.ShowDialog(this); if (formBayarKembali.getHasil() == true) { string newDate = Program.convertTglkeOracle(System.DateTime.Now); string newTglKembali = Program.convertTglkeOracle(dtpTanggalKembali.Value); //insert belanjaan ke tabel string insertNota = "INSERT INTO nota (nonota,kodeoperator,kodepenawaranspesial,kodemember,tgltransaksi,tglkembali)VALUES ('" + Program.escapeQuoteSQL(lblNmrNota.Text) + "','" + Program.session.getKodeOperator().ToString() + "','" + Program.so.getSpecialOfferCode() + "','" + Program.escapeQuoteSQL(lblKodeMember.Text) + "','" + newDate + "','" + newTglKembali + "')"; Program.conn.ExecuteNonQuery(insertNota); string kodeDipinjam = randomNota(); int i, idx = belanja.Rows.Count; for (i = 0; i < idx; i++) { string insertDipinjam = "INSERT INTO dipinjam (kodedipinjam, kodestok, nonota, hargasewa) VALUES('" + randomNota() +"','" + belanja.Rows[i].ItemArray[2].ToString() + "','" + lblNmrNota.Text + "'," + int.Parse(belanja.Rows[i].ItemArray[4].ToString()) + ")"; Program.conn.ExecuteNonQuery(insertDipinjam); string updateStok = "UPDATE stokkoleksi SET status = 1 WHERE kodestok = '" + belanja.Rows[i].ItemArray[2].ToString() + "'"; Program.conn.ExecuteNonQuery(updateStok); } MessageBox.Show("Transaksi Berhasil"); frmLaporanNota laporanNota = new frmLaporanNota(Program.escapeQuoteSQL(lblNmrNota.Text)); laporanNota.ShowDialog(this); tampilanAwal(); } else { tampilanAwal(); } } else { MessageBox.Show("Pastikan tanggal pengembalian diatur dengan benar (tidak diatur hari ini atau tanggal sebelumnya)"); } }