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