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)");
}
}
