private void cmdDelete_Click(object sender, EventArgs e) { if (dgDetailBKK.SelectedCells.Count > 0 && MessageBox.Show("Data akan dihapus?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { _rowIDDetail = (Guid)dgDetailBKK.SelectedCells[0].OwningRow.Cells["rowID"].Value; try { using (Database db = new Database(GlobalVar.DBName)) { if (_isFromPiutang == false) { BKK.DeleteBuktiDetail(db, _rowIDDetail); frmBKKBrowse frm = new frmBKKBrowse(); frm = (frmBKKBrowse)this.Caller; frm.HeaderRowRefresh(_rowID); frm.FindRowDetail("RowIDD", _rowIDDetail.ToString()); frm.DetailDeleteRefresh(); } else { db.BeginTransaction(); BKK.DeleteBuktiDetail(db, _rowIDDetail); BKK.UpdateUraianPinjaman(db, _rowID); db.CommitTransaction(); Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan(); frmUtang = (frmPiutangKaryawan)this.Caller; frmUtang.RefreshPegawai(_Nip); frmUtang.FindRowPegawsai("NIP", _Nip); //frmUtang.RefreshPiutang(_rowID); frmUtang.FindRowPiutang("RowID", _rowID.ToString()); } } #region "Tambahan" int i = 0; int n = 0; i = dgDetailBKK.SelectedCells[0].RowIndex; n = dgDetailBKK.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)dgDetailBKK.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtBKKDetail.AcceptChanges(); dgDetailBKK.Focus(); dgDetailBKK.RefreshEdit(); if (dgDetailBKK.RowCount > 0) { if (i == 0) { dgDetailBKK.CurrentCell = dgDetailBKK.Rows[0].Cells[n]; dgDetailBKK.RefreshEdit(); } else { dgDetailBKK.CurrentCell = dgDetailBKK.Rows[i - 1].Cells[n]; dgDetailBKK.RefreshEdit(); } } #endregion //Korban editan // DetailRefresh(); } catch (Exception ex) { Error.LogError(ex); } finally { refreshTerbilang(); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (tbUraian.NoPerkiraan == "" || tbUraian.NoPerkiraan == "?") { MessageBox.Show("No Perkiraan masih kosong."); return; } totalPiutang = tbJumlah.GetDoubleValue + tbTotal.GetDoubleValue; if ((tbUraian.NoPerkiraan != "") && (tbUraian.NoPerkiraan != "?") && (tbJumlah.Text != "")) { try { if (detailMode == enumDetailMode.New) { _recordIDDetail = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial); _rowIDDetail = Guid.NewGuid(); using (Database db = new Database(GlobalVar.DBName)) { if (_isFromPiutang == false) { //BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan.Trim().Equals("")? "?":tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text); BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan.Trim().Equals("") ? "?" : tbUraian.NoPerkiraan, txtUraian.Text, tbJumlah.Text); frmBKKBrowse frm = new frmBKKBrowse(); frm = (frmBKKBrowse)this.Caller; frm.HeaderRowRefresh(_rowID); frm.DetailRowRefresh(_rowIDDetail); frm.FindRowDetail("RowIDD", _rowIDDetail.ToString()); } else { db.BeginTransaction(); //BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text); BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan, txtUraian.Text, tbJumlah.Text); //BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, tbUraian.NamaPerkiraan, string.Empty, _jp); BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, txtUraian.Text, _keteranganlain, _jp); db.CommitTransaction(); Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan(); frmUtang = (frmPiutangKaryawan)this.Caller; frmUtang.RefreshPegawai(_Nip); frmUtang.FindRowPegawsai("NIP", _Nip); //frmUtang.RefreshPiutang(_rowID); frmUtang.RefreshPiutang(); frmUtang.FindRowPiutang("RowID", _rowID.ToString()); } tbUraian.NamaPerkiraan = ""; tbUraian.NoPerkiraan = "?"; tbJumlah.Text = "0"; tbAcc.Text = ""; DetailRowRefresh(_rowIDDetail); FindRowDetail("rowID", _rowIDDetail.ToString()); refreshTerbilang(); gbBKKUpdate.Enabled = true; gbUpdateDetailBKK.Visible = false; dgDetailBKK.Focus(); } } else if (detailMode == enumDetailMode.Update) { using (Database db = new Database(GlobalVar.DBName)) { if (_isFromPiutang == false) { BKK.UpdateBuktiDetail(db, _rowIDDetail, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text); frmBKKBrowse frm = new frmBKKBrowse(); frm = (frmBKKBrowse)this.Caller; frm.HeaderRowRefresh(_rowID); frm.DetailRowRefresh(_rowIDDetail); } else { db.BeginTransaction(); BKK.UpdateBuktiDetail(db, _rowIDDetail, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text); BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, tbUraian.NamaPerkiraan, string.Empty, _jp); db.CommitTransaction(); Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan(); frmUtang = (frmPiutangKaryawan)this.Caller; frmUtang.RefreshPegawai(_Nip); frmUtang.FindRowPegawsai("NIP", _Nip); frmUtang.RefreshPiutang(_rowID); frmUtang.FindRowPiutang("RowID", _rowID.ToString()); } tbUraian.NamaPerkiraan = ""; tbUraian.NoPerkiraan = "?"; tbJumlah.Text = "0"; DetailRowRefresh(_rowIDDetail); refreshTerbilang(); gbBKKUpdate.Enabled = true; gbUpdateDetailBKK.Visible = false; } } } catch (Exception ex) { Error.LogError(ex); } } }