private void btnSimpan_Click(object sender, EventArgs e) { lib.conn_open(); lib.begintransaction(); try { NameValueCollection nvc = new NameValueCollection(); NameValueCollection key = new NameValueCollection(); lib.addToNVC(key, "kontrakid", txtNoKontrak.Value); lib.addToNVC(nvc, "nama", txtNama.Text); lib.addToNVC(nvc, "ktp", txtKtp.Value); lib.addToNVC(nvc, "status_pernikahan", txtStatusPernikahan.Text); lib.addToNVC(nvc, "limit", txtLimit.Value); lib.addToNVC(nvc, "tenor", txtTenor.Value); lib.addToNVC(nvc, "bunga", txtBunga.Value); lib.addToNVC(nvc, "angsuran", txtAngsuran.Value); lib.addToNVC(nvc, "alamat", txtAlamat.Text); lib.addToNVC(nvc, "created_date", DateTime.Now.ToString("yyyy-MM-dd dd:mm:ss.fff")); lib.addToNVC(nvc, "created_by", "yusron"); DataTable dtExisting = lib.getDataTable("SELECT *FROM kredit where kontrakid=@1", new object[] { txtNoKontrak.Value }); if (lib.saveNVC(key, nvc, "kredit") > 0) { MessageBox.Show("Data disimpan!"); if (dtExisting.Rows.Count == 0) { lib.executeNonQuery("exec sp_updateidinc 'kredit'"); } clearAll(); } lib.committransaction(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Error); lib.rollbackTransaction(); } lib.conn_close(); }
private void btnSimpan_Click(object sender, EventArgs e) { lib.conn_open(); try { lib.begintransaction(); NameValueCollection nvc = new NameValueCollection(); NameValueCollection key = new NameValueCollection(); lib.addToNVC(key, "bayarid", txtIDBayar.Value); lib.addToNVC(nvc, "nama", txtNama.Value); lib.addToNVC(nvc, "kontrakid", txtNoKontrak.Value); lib.addToNVC(nvc, "tgl", txtTgl.Text + DateTime.Now.ToString(" HH:mm:ss.fff")); lib.addToNVC(nvc, "bayarke", txtBayarKe.Value); lib.addToNVC(nvc, "sisaangsuranbln", lblSisaBulan.Text.Replace(" bulan", "")); lib.addToNVC(nvc, "sisaangsurannominal", lblSisaTagihan.Text.Replace(".", "").Replace("Rp", "").Replace(" ", "")); lib.addToNVC(nvc, "bayarke", txtBayarKe.Value); if (lib.saveNVC(key, nvc, "pembayaran") > 0) { MessageBox.Show("Pembayaran berhasil!", "Perhatian"); lib.executeNonQuery("exec sp_updateidinc 'bayar'"); } clearAll(); lib.committransaction(); } catch (Exception ex) { lib.rollbackTransaction(); MessageBox.Show(ex.Message, "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Error); } lib.conn_close(); }