private void frmBuktiTransferKeluarUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (_rowIDTransferBank.ToString() != "00000000-0000-0000-0000-000000000000")
{
if (_isFromPiutang == false)
{
Kasir.frmBuktiTransferKeluar frmCaller = (Kasir.frmBuktiTransferKeluar) this.Caller;
frmCaller.RefreshRowBuktiTransfer(_rowIDTransferBank);
if (formMode == enumFormMode.New)
{
frmCaller.FindRowHeader("RowID", _rowIDTransferBank.ToString());
}
frmCaller.RefreshBuktiTransferDetail();
}
else
{
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(_nip);
frmUtang.FindRowPegawsai("NIP", _nip);
frmUtang.RefreshPiutang(_rowIDTransferBank);
frmUtang.FindRowPiutang("RowID", _rowIDTransferBank.ToString());
}
}
}
private void cmdClose_Click(object sender, EventArgs e)
{
//jika dari TSL Piutang Karyawan, buka form IndenDetail
if (_isFromPiutang == true)
{
if (MessageBox.Show("Batalkan Inputan Piutang Karyawan ?", "Informasi", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_PinjamanPegawaiBukti_DELETE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowIDPK));
db.Commands[0].ExecuteNonQuery();
}
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
// frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(_nip);
frmUtang.FindRowPegawsai("NIP", _nip);
frmUtang.RefreshPiutang();
//frmUtang.FindRowPiutang("RowID", _rowIDPK.ToString());
}
else
{
return;
}
}
this.Close();
}
private void updateHeader()
{
try
{
StringBuilder sb = GetMessages();
if (sb.Length > 0)
{
MessageBox.Show(sb.ToString());
return;
}
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Staff_Update"));
db.Commands[0].Parameters.Add(new Parameter("@NIP", SqlDbType.VarChar, txtNIP.Text));
db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text));
db.Commands[0].Parameters.Add(new Parameter("@Jabatan", SqlDbType.VarChar, txtJabatan.Text));
db.Commands[0].Parameters.Add(new Parameter("@UnitKerja", SqlDbType.VarChar, txtUnitKerja.Text));
db.Commands[0].Parameters.Add(new Parameter("@LP", SqlDbType.VarChar, cmbLP.Text));
db.Commands[0].Parameters.Add(new Parameter("@Alamat", SqlDbType.VarChar, txtAlamat.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoTelp", SqlDbType.VarChar, txtNoTlp.Text));
db.Commands[0].Parameters.Add(new Parameter("@TglLahir", SqlDbType.DateTime, dtbTglLahir.DateValue.HasValue ? dtbTglLahir.DateValue.Value : SqlDateTime.Null));
db.Commands[0].Parameters.Add(new Parameter("@TglMasuk", SqlDbType.DateTime, dtbTglMasuk.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@TglKeluar", SqlDbType.DateTime, dtbTglKeluar.DateValue.HasValue ? dtbTglKeluar.DateValue.Value : SqlDateTime.Null));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(txtNIP.Text);
frmUtang.FindRowPegawsai("NIP", txtNIP.Text);
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void cmdDelete_Click(object sender, EventArgs e)
{
if (dgDetailBKM.SelectedCells.Count > 0 && MessageBox.Show("Data akan dihapus?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
_rowIDDetail = (Guid)dgDetailBKM.SelectedCells[0].OwningRow.Cells["rowID"].Value;
try
{
using (Database db = new Database(GlobalVar.DBName))
{
if (_isFromPiutang == false)
{
BKM.DeleteBuktiDetail(db, _rowIDDetail);
frmBKMBrowse frm = new frmBKMBrowse();
frm = (frmBKMBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowDetail("RowIDD", _rowIDDetail.ToString());
frm.DetailDeleteRefresh();
}
else
{
BKM.DeleteBuktiDetail(db, _rowIDDetail);
BKM.UpdateUraianPinjaman(db, _rowID);
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 = dgDetailBKM.SelectedCells[0].RowIndex;
n = dgDetailBKM.SelectedCells[0].ColumnIndex;
DataRowView dv = (DataRowView)dgDetailBKM.SelectedCells[0].OwningRow.DataBoundItem;
DataRow dr = dv.Row;
dr.Delete();
dtBKMDetail.AcceptChanges();
dgDetailBKM.Focus();
dgDetailBKM.RefreshEdit();
if (dgDetailBKM.RowCount > 0)
{
if (i == 0)
{
dgDetailBKM.CurrentCell = dgDetailBKM.Rows[0].Cells[n];
dgDetailBKM.RefreshEdit();
}
else
{
dgDetailBKM.CurrentCell = dgDetailBKM.Rows[i - 1].Cells[n];
dgDetailBKM.RefreshEdit();
}
}
#endregion
//DetailRefresh();
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
DetailRefresh();
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.NamaPerkiraan != "") && (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)
{
//BKM.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", "", tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
BKM.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", "", tbUraian.NoPerkiraan, txtUraian.Text, tbJumlah.Text);
frmBKMBrowse frm = new frmBKMBrowse();
frm = (frmBKMBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.DetailRowRefresh(_rowIDDetail);
frm.FindRowDetail("RowIDD", _rowIDDetail.ToString());
}
else
{
//BKM.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", "", tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
BKM.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", "", tbUraian.NoPerkiraan, txtUraian.Text, tbJumlah.Text);
//BKM.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKM", _noBukti, tbUraian.NamaPerkiraan, string.Empty, _jp);
BKM.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKM", _noBukti, txtUraian.Text, string.Empty, _jp);
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();
gbBKMUpdate.Enabled = true;
gbUpdateDetailBKM.Visible = false;
dgDetailBKM.Focus();
}
}
else if (detailMode == enumDetailMode.Update)
{
using (Database db = new Database(GlobalVar.DBName))
{
if (_isFromPiutang == false)
{
BKM.UpdateBuktiDetail(db, _rowIDDetail, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
frmBKMBrowse frm = new frmBKMBrowse();
frm = (frmBKMBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.DetailRowRefresh(_rowIDDetail);
frm.FindRowDetail("RowIDD", _rowIDDetail.ToString());
}
else
{
BKM.UpdateBuktiDetail(db, _rowIDDetail, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
BKM.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKM", _noBukti, tbUraian.NamaPerkiraan, string.Empty, _jp);
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();
gbBKMUpdate.Enabled = true;
gbUpdateDetailBKM.Visible = false;
}
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("Nomor Perkiraan harus diisi");
return;
}
}
private void tbTerima_Leave(object sender, EventArgs e)
{
string src = "";
if ((tbTerima.Text != "") && (tbTerima.Text != _Terima))
{
_Tanggal = (DateTime)tbTanggal.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
if (MessageBox.Show("Data Akan Disimpan?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (formMode == enumFormMode.New)
{
_recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
if (_isFromPiutang != true)
{
src = "IN";
}
else
{
src = "PIK";
}
_recordID = BKM.GetRecordIDBukti(_recordID, src);
_noBukti = Numerator.BookNumerator("BKM");
_rowID = Guid.NewGuid();
try
{
using (Database db = new Database(GlobalVar.DBName))
{
BKM.AddHeader(db, _rowID, _rowID, _recordID, _noBukti, "", src, _Tanggal, tbTerima.Text, "", "", SecurityManager.UserName, "");
if (_isFromPiutang == true)
{
BKM.AddPinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKM", _noBukti, "", string.Empty, 0, totalPiutang, _jp);
}
}
tbNoBKM.Text = _noBukti;
_Terima = tbTerima.Text;
cmdAdd.Enabled = true;
cmdEdit.Enabled = true;
cmdDelete.Enabled = true;
cmdPrint.Enabled = true;
dgDetailBKM.Enabled = true;
if (_isFromPiutang != true)
{
frmBKMBrowse frm = new frmBKMBrowse();
frm = (frmBKMBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowHeader("RowID", _rowID.ToString());
}
else
{
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());
}
dtBKMDetail = new DataTable();
dgDetailBKM.DataSource = dtBKMDetail.DefaultView;
dgDetailBKM.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else if (formMode == enumFormMode.Update)
{
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Bukti_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@Kepada", SqlDbType.VarChar, tbTerima.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmBKMBrowse frm = new frmBKMBrowse();
frm = (frmBKMBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowHeader("RowID", _rowID.ToString());
dgDetailBKM.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
totalPiutang = tbJumlah.GetDoubleValue + tbTotal.GetDoubleValue;
if ((tbUraian.Text != "") && (tbJumlah.Text != ""))
{
try
{
if (detailMode == enumDetailMode.New)
{
_recordIDDetail = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_rowIDDetail = Guid.NewGuid();
using (Database db = new Database(GlobalVar.DBFinance))
{
if (linkPembelian)
{
BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, "".Trim().Equals("") ? "?" : "", tbUraian.Text, tbJumlah.Text);
}
else if (_isFromPiutang == false)
{
BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, "".Trim().Equals("")? "?":"", tbUraian.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.Text, tbJumlah.Text);
BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, tbUraian.Text, 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.RefreshPiutang();
frmUtang.FindRowPiutang("RowID", _rowID.ToString());
}
tbUraian.Text = "";
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.DBFinance))
{
if (linkPembelian)
{
BKK.UpdateBuktiDetail(db, _rowIDDetail, "", tbUraian.Text, tbJumlah.Text);
}
else if (_isFromPiutang == false)
{
BKK.UpdateBuktiDetail(db, _rowIDDetail, "", tbUraian.Text, tbJumlah.Text);
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.DetailRowRefresh(_rowIDDetail);
}
else
{
db.BeginTransaction();
BKK.UpdateBuktiDetail(db, _rowIDDetail, "", tbUraian.Text, tbJumlah.Text);
BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, tbUraian.Text, 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.Text = "";
//"" = "?";
tbJumlah.Text = "0";
DetailRowRefresh(_rowIDDetail);
refreshTerbilang();
gbBKKUpdate.Enabled = true;
gbUpdateDetailBKK.Visible = false;
}
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void tbKepada_Leave(object sender, EventArgs e)
{
string src = "";
if (lookupStafAdm1.Kode != "" & lookupStafAdm1.Kode != "[CODE]")
{
_Tanggal = (DateTime)tbTanggal.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing! Tidak Bisa Tambah Data.");
return;
}
if (MessageBox.Show("Data Akan Disimpan?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (formMode == enumFormMode.New)
{
_recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
if (_isFromPiutang != true)
{
src = "OUT";
}
else
{
src = "PIK";
}
_recordID = BKK.GetRecordIDBukti(_recordID, src);
_rowID = Guid.NewGuid();
//_noBukti = Tools.AutoNumbering("NoBukti", "ISADbDepoFinance.dbo.Bukti");
_noBukti = Numerator.BookNumerator("BKK");
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
db.BeginTransaction();
BKK.AddHeader(db, _rowID, _rowID, _recordID, _noBukti, "", src, _Tanggal, lookupStafAdm1.Kode, "", "", SecurityManager.UserName, "");
if (_isFromPiutang == true)
{
BKK.AddPinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, "", string.Empty, totalPiutang, 0, _jp);
}
db.CommitTransaction();
}
tbNoBKK.Text = _noBukti;
_Kepada = lookupStafAdm1.Kode;
cmdAdd.Enabled = true;
cmdEdit.Enabled = true;
cmdDelete.Enabled = true;
cmdPrint.Enabled = true;
dgDetailBKK.Enabled = true;
if (linkPembelian)
{
//cmdAdd.Enabled = false;
}
else if (_isFromPiutang != true)
{
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowHeader("RowID", _rowID.ToString());
}
else
{
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());
}
dtBKKDetail = new DataTable();
dgDetailBKK.DataSource = dtBKKDetail.DefaultView;
dgDetailBKK.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else if (formMode == enumFormMode.Update)
{
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("usp_Bukti_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@Kepada", SqlDbType.VarChar, lookupStafAdm1.Kode));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
dgDetailBKK.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
cmdAdd.PerformClick();
}
}
}
private void tbKepada_Leave(object sender, EventArgs e)
{
string src = "";
if ((tbKepada.Text != "") && (tbKepada.Text != _Kepada))
{
_Tanggal = (DateTime)tbTanggal.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing! Tidak Bisa Tambah Data.");
return;
}
if (imgBase64 != null)
{
if (MessageBox.Show("Data Akan Disimpan?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (formMode == enumFormMode.New)
{
////tambahan
if (_isFromPiutang)
{
if (_jp == "2" || _jp == "5")
{
try
{
DataTable dtc = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_PinjamanPegawai_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _kpid));
db.Commands[0].Parameters.Add(new Parameter("@Nip", SqlDbType.VarChar, _Nip));
dtc = db.Commands[0].ExecuteDataTable();
}
if (dtc.Rows.Count > 0)
{
MessageBox.Show("Data sudah dinput.");
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
_keteranganlain = "";
}
}
else
{
_keteranganlain = "";
}
if (_isFromPiutang != true)
{
src = "OUT";
}
else
{
src = "PIK";
}
//_recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
string _rcid = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_recordID = BKK.GetRecordIDBukti(_rcid, src);
if (_isFromPiutang)
{
if (_recordID.Length > 0 && !string.IsNullOrEmpty(_Nip))
{
_recIDPiutangKaryawan = _recordID.Replace(_recordID.Substring(22, 1), _jp);
}
}
if (_isFromPiutang)
{
if (_jp == "2" || _jp == "5")
{
_rowID = _kpid;
}
else
{
_rowID = Guid.NewGuid();
}
}
else
{
_rowID = Guid.NewGuid();
}
//_rowID = Guid.NewGuid();
_noBukti = Numerator.BookNumerator("BKK");
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
BKK.AddHeader(db, _rowID, _rowID, _recordID, _noBukti, "", src, _Tanggal, tbKepada.Text, "", "", SecurityManager.UserName, " ", imgBase64);
if (_isFromPiutang == true)
{
BKK.AddPinjamanPegawai(db, _rowID, _recIDPiutangKaryawan, _Nip, _Tanggal, "BKK", _noBukti, "", _keteranganlain, totalPiutang, 0, _jp);
}
//BKK.AddPinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, "", _keteranganlain, totalPiutang, 0, _jp);
//BKK.AddPinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, "", string.Empty, totalPiutang, 0, _jp);
db.CommitTransaction();
}
tbNoBKK.Text = _noBukti;
_Kepada = tbKepada.Text;
cmdAdd.Enabled = true;
cmdEdit.Enabled = true;
cmdDelete.Enabled = true;
cmdPrint.Enabled = true;
dgDetailBKK.Enabled = true;
if (_isFromPiutang != true)
{
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowHeader("RowID", _rowID.ToString());
}
else
{
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());
}
dtBKKDetail = new DataTable();
dgDetailBKK.DataSource = dtBKKDetail.DefaultView;
dgDetailBKK.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else if (formMode == enumFormMode.Update)
{
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Bukti_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@Kepada", SqlDbType.VarChar, tbKepada.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
dgDetailBKK.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
}
else
{
MessageBox.Show("Attachment belum ditambahkan !!");
return;
}
}
}
private void cmdExit_Click(object sender, EventArgs e)
{
//jika dari TSL Piutang Karyawan, buka form Inden
if (_jp == "2" || _jp == "5")
{
if (dgDetailBKK.Rows.Count > 0)
{
if (MessageBox.Show("Selesai isi BKK dan Melanjutkan Buat Inden ?", "Informasi", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
frmIndenUpdate frm = new frmIndenUpdate(this, true, _rpsisa, _rowID, _Nip, _recIDPiutangKaryawan);
frm.ShowDialog();
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());
keluar = 1;
}
else
{
if (MessageBox.Show("Batalkan Inputan Piutang Karyawan " + tbKepada.Text + " ?", "Informasi", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_PinjamanPegawaiBukti_DELETE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].ExecuteNonQuery();
}
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());
keluar = 1;
this.Close();
return;
}
else
{
return;
}
}
}
else
{
if (MessageBox.Show("Batalkan Inputan Piutang Karyawan " + tbKepada.Text + " ?", "Informasi", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_PinjamanPegawaiBukti_DELETE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].ExecuteNonQuery();
}
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());
keluar = 1;
this.Close();
return;
}
else
{
return;
}
}
}
this.Close();
}
