private void AddBuktiBankKeluar()
{
_rowIDBBK = Guid.NewGuid();
_BankID = lookupBank1.BankID;
_NoBBK = Numerator.BookNumerator("BBK");
_RecordIDBBK = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_TglBBK = DateTime.Now.Date;
_Penerima = txtKepada.Text;
using (Database db = new Database(GlobalVar.DBFinance))
{
Class.BBK.AddBBK(db,
_rowIDBBK,
_RecordIDBBK,
_TglBBK,
_NoBBK,
_BankID,
string.Empty,
string.Empty,
_Penerima,
0,
0,
0);
}
lblNo.Visible = true;
lblNo.Text = _NoBBK;
}
private void tbTglCair_Leave(object sender, EventArgs e)
{
//cair slip
try
{
string _noGiro = gridDetail.SelectedCells[0].OwningRow.Cells["Nomor"].Value.ToString();
if (MessageBox.Show("Proses Cair Slip " + _noGiro + " ??", "", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
DataTable dtCekBukti = new DataTable();
dtCekBukti = Inden.CekRelasiInden("Bukti", "RowID", _titipID.ToString(), "", "");
string RecordIDBKM = _titipRecID.Substring(0, 22) + "S";
Guid _GiroID = (Guid)gridDetail.SelectedCells[0].OwningRow.Cells["GiroID"].Value;
string _GiroRecID = gridDetail.SelectedCells[0].OwningRow.Cells["GiroRecID"].Value.ToString();
string noPerk = Perkiraan.GetPerkiraanKoneksiDetail("BGTRM").Rows[0]["NoPerkiraan"].ToString();
string uraian = "SLIP #" + _noGiro + " (" + _noVoucher + ")";
string jumlah = gridDetail.SelectedCells[0].OwningRow.Cells["Nominal"].Value.ToString();
tglCair = (DateTime)tbTglCair.DateValue;
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
if (dtCekBukti.Rows.Count == 0)
{
noBKM = Numerator.BookNumerator("BKM");
asalGiro = gridDetail.SelectedCells[0].OwningRow.Cells["_asalgiro"].Value.ToString();
BKM.AddHeader(db, _titipID, _titipID, RecordIDBKM, noBKM, "K", "SLP", tglCair, asalGiro, "", "", SecurityManager.UserName, "");
}
else
{
dtBKMHeader = new DataTable();
dtBKMHeader = BKM.ListHeaderperRow(_titipID);
asalGiro = dtBKMHeader.Rows[0]["Kepada"].ToString();
noBKM = dtBKMHeader.Rows[0]["NoBukti"].ToString();
tglCair = (DateTime)dtBKMHeader.Rows[0]["TglBukti"];
}
BKM.AddDetail(db, _GiroID, _titipID, _GiroRecID, RecordIDBKM, "", "", "", "", noPerk, uraian, jumlah);
db.CommitTransaction();
dtBKMDetail = new DataTable();
dtBKMDetail = BKM.ListDetail(db, _titipID);
}
titipGiro();
}
else
{
jnsSlip = "";
cmdTitip.Enabled = true;
gbTglCair.Enabled = false;
gbSlip.Visible = false;
gbLookup.Enabled = true;
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void frmJournalUpdate_Load(object sender, EventArgs e)
{
this.Title = "";
try
{
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database(GlobalVar.DBHoldingName))
{
dtRowHeader = Class.Journal.GetHeader_dv(db, _rowID, GlobalVar.PerusahaanRowID, cboUnitUsaha.SelectedValue.ToString());
dtRowDetail = Class.Journal.ListDetail_dv(db, _rowID, cboUnitUsaha.SelectedValue.ToString());
}
if (formMode == enumFormMode.Update)
{
//retrieving data
if (dtRowHeader.Rows.Count > 0)
{
//display data
txtTanggal.Text = ((DateTime)dtRowHeader.Rows[0]["Tanggal"]).ToString("dd/MM/yyyy");
txtNoReff.Text = dtRowHeader.Rows[0]["NoReff"].ToString();
txtUraian.Text = dtRowHeader.Rows[0]["Uraian"].ToString();
lookupGudang1.GudangID = dtRowHeader.Rows[0]["KodeGudang"].ToString();
//Tambahan UnitUsaha
//if ((Tools.isNull(dtRowHeader.Rows[0]["UnitUsaha"], "").ToString()) != "")
//{
// cboUnitUsaha.SelectedItem = dtRowHeader.Rows[0]["UnitUsaha"].ToString();
//}
dtRowDetail.DefaultView.Sort = "RecordID";
customGridView1.DataSource = dtRowDetail.DefaultView;
}
}
else
{
txtTanggal.Text = GlobalVar.GetServerDate.ToString("dd/MM/yyyy");
txtNoReff.Text = Numerator.BookNumerator("VJU");
lookupGudang1.GudangID = GlobalVar.Gudang;
dtRowDetail.DefaultView.Sort = "RecordID";
customGridView1.DataSource = dtRowDetail.DefaultView;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void Link2BKM()
{
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
string noBKM = Numerator.BookNumerator("BKM");
String HRecordID = BKM.GetRecordIDBukti(_RecordIDInden, "IND");
using (Database db = new Database(GlobalVar.DBName))
//BKM.AddHeader(db, _RowIDInden, _RowIDInden, BKM.GetRecordIDBukti(_RecordIDInden, "IND"), noBKM, "K", "IND", GlobalVar.DateOfServer, _NamaCollector, "", "", SecurityManager.UserName, "");
BKM.AddHeader(db, _RowIDInden, _RowIDInden, HRecordID, noBKM, "K", "IND", GlobalVar.DateOfServer, _NamaCollector, "", "", SecurityManager.UserName, "");
//BKM.AddHeader(db, _RowIDInden, _RowIDInden, HRecordID, noBKM, "K", "IND", _TglTerima, _NamaCollector, "", "", SecurityManager.UserName, "");
using (Database db = new Database(GlobalVar.DBName))
// BKM.AddDetail(db, _RowIDIndenDetail, _RowIDInden, _RecordIDInden, BKM.GetRecordIDBukti(_RecordIDIndenDetail, "IND"), "", "", "", "", _noPerk, "PENERIMAAN BELUM IDENTIFIKASI (" + _NoBukti + ")", _Nominal);
BKM.AddDetail(db, _RowIDIndenDetail, _RowIDInden, _RecordIDInden, HRecordID, "", "", "", "", _noPerk, "PENERIMAAN BELUM IDENTIFIKASI (" + _NoBukti + ")", _Nominal);
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (!validate())
{
return;
}
try
{
if (MessageBox.Show("Data Sudah Benar ?", "", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
{
return;
}
if ((DateTime)dbTglJTTempo.DateValue < _TglBBK)
{
MessageBox.Show("Tanggal Jatuh Tempo Tidak Boleh Kurang Dari " + String.Format("{0:dd-MMM-yyy}", _TglBBK));
dbTglJTTempo.Focus();
return;
}
if ((DateTime)dbTglCair.DateValue < _TglBBK)
{
MessageBox.Show("Tanggal Cair Tidak Boleh Kurang Dari " + String.Format("{0:dd-MMM-yyy}", _TglBBK));
dbTglCair.Focus();
return;
}
switch (formMode)
{
case enumFormMode.New:
AddGiroInternal();
string newNumber = Numerator.BookNumerator("GIROIN");
this.Close();
break;
case enumFormMode.Update:
UpdateGiroInternal();
Numerator.BookNumerator("GIROIN");
this.Close();
break;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void UpdateDKN()
{
try
{
frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller;
//string HRecordID = Tools.isNull(frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["RecordID"].Value, "").ToString();
string CollectorID = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["KodeKolektor"].Value, "").ToString();
string NamaCollector = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["Nama"].Value, "").ToString();
string noBuktiKasir = Numerator.BookNumerator("IND");
string NomorKN = Tools.isNull(frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["No_dkn"].Value, "").ToString();
string NoPerkiraan = Tools.isNull(frmCaller.gridDetail.SelectedCells[0].OwningRow.Cells["No_perk"].Value, "").ToString();
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("psp_DKN_LINK"));
db.Commands[0].Parameters.Add(new Parameter("@NomorKN", SqlDbType.VarChar, txtNoDKN.Text));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _HeaderID));
db.Commands[0].Parameters.Add(new Parameter("@RecID", SqlDbType.VarChar, _RecID));
db.Commands[0].Parameters.Add(new Parameter("@RecIDDetail", SqlDbType.VarChar, _RecIDDetail));
db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, DateTime.Now));
db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, noBuktiKasir));
db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, NoPerkiraan));
//db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID));
//db.Commands[0].Parameters.Add(new Parameter("@NamaCollector", SqlDbType.VarChar, NamaCollector));
db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, NomorKN));
db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserInitial));
db.Commands[0].ExecuteNonQuery();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void AddBBMGiroCairTolakBatal()
{
_rowID = Guid.NewGuid();
string recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
string noBBM = Numerator.BookNumerator("BBM");
string bankID = lookupBank1.BankID;
string diBukukan = lookupStafAdm1.Kode;
string diKetahui = lookupStafAdm2.Kode;
string kasir = txtKasir.Text;
string penyetor = lookupStafAdm3.Kode;
double nominalGiro = numGiro.GetDoubleValue;
double nominalCair = numCair.GetDoubleValue;
double nominalTolak = numTolak.GetDoubleValue;
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
Class.BBM.AddBBM(db,
_rowID,
recordID,
txtTglBBM.DateValue.Value,
noBBM,
bankID,
diBukukan,
diKetahui,
kasir,
penyetor,
nominalGiro,
nominalCair,
nominalTolak);
this.Close();
}
}
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 cmdSave_Click(object sender, EventArgs e)
{
#region lama
//try
//{
// TglKasir = (DateTime)tbTanggal.DateValue;
// this.Cursor = Cursors.WaitCursor;
// using (Database db = new Database(GlobalVar.DBName))
// {
// db.Commands.Add(db.CreateCommand("fsp_IsClosingKasir"));
// db.Commands[0].Parameters.Add(new Parameter("@checkDate", SqlDbType.DateTime, TglKasir));
// object cek = db.Commands[0].ExecuteScalar();
// if (cek.ToString() == "True")
// {
// MessageBox.Show("Sudau Closing Kasir.");
// tbTanggal.Focus();
// return;
// }
// }
//}
//catch (Exception ex)
//{
// Error.LogError(ex);
//}
//finally
//{
// this.Cursor = Cursors.Default;
//}
#endregion
try
{
if (tbTanggal.DateValue.ToString() != "" && tbCollector.Text != "")
{
TglKasir = (DateTime)tbTanggal.DateValue;
Acc = tbMengetahui.Text;
NamaCollector = tbCollector.Text;
if (formMode == enumFormMode.New)
{
if (PeriodeClosing.IsKasirClosed(TglKasir))
{
MessageBox.Show("Sudah Closing!");
return;
}
noBukti = Numerator.BookNumerator("IND");
//if (_isFromPiutang)
// RowIDI = _rowIDPK;
//else
// RowIDI = Guid.NewGuid();
string RecordIDI;
RowIDI = Guid.NewGuid();
if (_isFromPiutang)
{
RecordIDI = _recID;
}
else
{
RecordIDI = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
}
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Inden_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowIDI));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, RecordIDI));
db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, TglKasir));
db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, noBukti));
db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID));
db.Commands[0].Parameters.Add(new Parameter("@NamaCollector", SqlDbType.VarChar, NamaCollector));
db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, Acc));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
if (_isFromPiutang == true)
{
frmIndenDetailUpdate frm = new frmIndenDetailUpdate(this, RowIDI, RecordIDI, NamaCollector, TglKasir, noBukti, CollectorID, true, _rpsisa, _rowIDPK, _nip);
frm.ShowDialog();
this.Close();
}
else
{
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRefresh();
frm.IndenFindRow("RowIDI", RowIDI.ToString());
this.Close();
}
}
else
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Inden_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowIDI));
db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, TglKasir));
db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID));
db.Commands[0].Parameters.Add(new Parameter("@NamaCollector", SqlDbType.VarChar, NamaCollector));
db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, Acc));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRefresh();
frm.IndenFindRow("RowIDI", RowIDI.ToString());
this.Close();
}
}
else
{
MessageBox.Show(Messages.Error.InputRequired);
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
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 addIndenDetail(
Database db
)
{
DataTable dtCekRelasi = new DataTable();
db.Commands.Clear();
db.Commands.Add(db.CreateCommand("usp_IndenDetail_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, HeaderID));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, RecordID));
db.Commands[0].Parameters.Add(new Parameter("@HRecordID", SqlDbType.VarChar, HRecordID));
db.Commands[0].Parameters.Add(new Parameter("@TglTrf", SqlDbType.DateTime, tglRK));
db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, bankID));
db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, NamaBank));
db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, Lokasi));
db.Commands[0].Parameters.Add(new Parameter("@CHBG", SqlDbType.VarChar, cara));
db.Commands[0].Parameters.Add(new Parameter("@Nomor", SqlDbType.VarChar, noBGC));
db.Commands[0].Parameters.Add(new Parameter("@TglGiro", SqlDbType.DateTime, tglGiro));
db.Commands[0].Parameters.Add(new Parameter("@TglJt", SqlDbType.DateTime, tglJTempo));
db.Commands[0].Parameters.Add(new Parameter("@Ket", SqlDbType.VarChar, ket));
db.Commands[0].Parameters.Add(new Parameter("@NoAcc", SqlDbType.VarChar, noAcc));
db.Commands[0].Parameters.Add(new Parameter("@RpCash", SqlDbType.Money, RpCash));
db.Commands[0].Parameters.Add(new Parameter("@RpGiro", SqlDbType.Money, RpGiro));
db.Commands[0].Parameters.Add(new Parameter("@RpTrf", SqlDbType.Money, RpTrn));
db.Commands[0].Parameters.Add(new Parameter("@RpCrd", SqlDbType.Money, RpCrd));
db.Commands[0].Parameters.Add(new Parameter("@RpDbt", SqlDbType.Money, RpDbt));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
if (RowIDOrderPenjualan != Guid.Empty)
{
db.Commands[0].Parameters.Add(new Parameter("@RowIDOrderPenjualan", SqlDbType.UniqueIdentifier, RowIDOrderPenjualan));
}
db.Commands[0].ExecuteNonQuery();
if (cara == "")
{
string _noPerk;
_noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
dtCekRelasi = Inden.CekRelasiInden("Bukti", "SrcID", HeaderID.ToString(), "", "").Copy();
Guid _RowID = new Guid();
if (dtCekRelasi.Rows.Count == 0)
{
_RowID = HeaderID;
string noBKM = Numerator.BookNumerator("BKM");
BKM.AddHeader(db, _RowID, HeaderID, BKM.GetRecordIDBukti(HRecordID, "IND"), noBKM, "K", "IND", tglInden, namaCollector, "", noAcc, SecurityManager.UserName, "");
}
else
{
_RowID = (Guid)dtCekRelasi.Rows[0][0];
}
BKM.AddDetail(db, RowID, _RowID, RecordID, BKM.GetRecordIDBukti(HRecordID, "IND"), "", "", "", noAcc, _noPerk, "PENERIMAAN BELUM IDENTIFIKASI (" + noBukti + ")", RpCash);
}
else if (cara == "T")
{
string recordIDTB = HRecordID + "I";
string noBBK = "";
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
Guid _RowID = new Guid();
dtCekRelasi = Inden.CekRelasiInden("TransferBank", "SrcID", HeaderID.ToString(), "", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
_RowID = HeaderID;
noBBK = Numerator.BookNumerator("BBM");
TransferBank.addHeader(db, _RowID, HeaderID, recordIDTB, tglInden, noBBK, "M", "", "IND. No " + noBukti, "", "", SecurityManager.UserName, "");
}
else
{
_RowID = (Guid)dtCekRelasi.Rows[0][0];
noBBK = dtCekRelasi.Rows[0][1].ToString();
}
TransferBank.addDetail(db, RowID, _RowID, RecordID, recordIDTB, collectorID, namaCollector, NamaBank, Lokasi, noAcc, (DateTime)tglRK, RpTrn, "", "", "", "", bankID, _noPerk, "");
Bank.AddBankDetail(db, RowID, Guid.Empty, noBBK, noAcc, rowIDBankTujuan, "", tglInden, "BBM", "TRANSFER DARI : " + namaCollector + " (BANK TRANSFER)", "IDR", RpTrn, "0", DateTime.Today, (DateTime)tglRK, "", "", "", "", _noPerk, bankID, RecordID);
}
else if (cara == "G" || cara == "C" || cara == "S")
{
string recordIDVJ = "";
Guid _VJRowID = new Guid();
string noVoucher = Numerator.BookNumerator("VPG");
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
dtCekRelasi = new DataTable();
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "PG", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVJ = HRecordID + "I";
_VJRowID = Guid.NewGuid();
VoucherJournal.AddHeader(db, _VJRowID, HeaderID, recordIDVJ, "PG", tglInden, noVoucher,
"PENERIMAAN GIRO IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true);
}
else
{
recordIDVJ = dtCekRelasi.Rows[0][1].ToString();
_VJRowID = (Guid)dtCekRelasi.Rows[0][0];
}
//VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector,
// Convert.ToDouble(RpGiro), 0, true);
Giro.Add(db, RowID, _VJRowID, Guid.Empty, Guid.Empty, recordIDVJ, "", "", RecordID, "", NamaBank, Lokasi,
cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpGiro), "", SqlDateTime.Null,
"", "", "", "", "", "", _noPerk, SqlDateTime.Null, true, noAcc, "");
}
else if (cara == "R")
{
string recordIDVPG = "", noVoucherPG = "", noVoucherTT = "";
string recordIDVTT = "";
Guid _VJRowIDPG = new Guid();
Guid _VJRowIDTT = new Guid();
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
//VOUCHER PENERIMAAN CRD
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "CRD", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVPG = HRecordID + "R";
_VJRowIDPG = Guid.NewGuid();
noVoucherPG = Numerator.BookNumerator("VPG");
VoucherJournal.AddHeader(db, _VJRowIDPG, HeaderID, recordIDVPG, "CC", tglInden, noVoucherPG,
"PENERIMAAN CREDIT CARD IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true);
}
else
{
recordIDVPG = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDPG = (Guid)dtCekRelasi.Rows[0][0];
}
//VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector,
// Convert.ToDouble(RpGiro), 0, true);
//VOUCHER TITIP CRD
dtCekRelasi = new DataTable();
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "TT", bankID).Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVTT = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial).TrimEnd() + "R";
_VJRowIDTT = Guid.NewGuid();
noVoucherTT = Numerator.BookNumerator("VTG");
VoucherJournal.AddHeader(db, _VJRowIDTT, HeaderID, recordIDVTT, "TT", tglInden, noVoucherTT,
"OTOMATIS TITIP DR CRD", "", "", "", "", "", bankID, namaBanki, 0, true);
}
else
{
recordIDVTT = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDTT = (Guid)dtCekRelasi.Rows[0][0];
}
//INSERT TABLE GIRO
Giro.Add(db, RowID, _VJRowIDPG, Guid.Empty, _VJRowIDTT, recordIDVPG, "", recordIDVTT, RecordID, "", NamaBank, Lokasi,
cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpCrd), "", (DateTime)SqlDateTime.Null,
"", "", "", "", bankID, namaBanki, _noPerk, tglInden, true, noAcc, "");
}
else if (cara == "D")
{
string recordIDVPG = "", noVoucherPG = "", noVoucherTT = "";
string recordIDVTT = "";
Guid _VJRowIDPG = new Guid();
Guid _VJRowIDTT = new Guid();
string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString();
//VOUCHER PENERIMAAN CRD
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "DBT", "").Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVPG = HRecordID + "D";
_VJRowIDPG = Guid.NewGuid();
noVoucherPG = Numerator.BookNumerator("VPG");
VoucherJournal.AddHeader(db, _VJRowIDPG, HeaderID, recordIDVPG, "DB", tglInden, noVoucherPG,
"PENERIMAAN DEBIT CARD IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true);
}
else
{
recordIDVPG = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDPG = (Guid)dtCekRelasi.Rows[0][0];
}
//VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector,
// Convert.ToDouble(RpGiro), 0, true);
//VOUCHER TITIP CRD
dtCekRelasi = new DataTable();
dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "TT", bankID).Copy();
if (dtCekRelasi.Rows.Count == 0)
{
recordIDVTT = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial).TrimEnd() + "D";
_VJRowIDTT = Guid.NewGuid();
noVoucherTT = Numerator.BookNumerator("VTG");
VoucherJournal.AddHeader(db, _VJRowIDTT, HeaderID, recordIDVTT, "TT", tglInden, noVoucherTT,
"OTOMATIS TITIP DR DBT", "", "", "", "", "", bankID, namaBanki, 0, true);
}
else
{
recordIDVTT = dtCekRelasi.Rows[0][1].ToString();
_VJRowIDTT = (Guid)dtCekRelasi.Rows[0][0];
}
//INSERT TABLE GIRO
Giro.Add(db, RowID, _VJRowIDPG, Guid.Empty, _VJRowIDTT, recordIDVPG, "", recordIDVTT, RecordID, "", NamaBank, Lokasi,
cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpDbt), "", (DateTime)SqlDateTime.Null,
"", "", "", "", bankID, namaBanki, _noPerk, tglInden, true, noAcc, "");
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (!validate())
{
return;
}
if (updateMode == enumUpdateMode.Header)
{
string kode = "";
if (Tools.isNull(cboPT.Text, "").ToString() != "")
{
kode = cboPT.Text;
}
if (frmMode == enumFrmMode.New)
{
try
{
Guid _RowID = Guid.NewGuid();
string _BankID=Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
using(Database db=new Database(GlobalVar.DBName))
{
Bank.addBank(db
,_RowID
,_BankID
,tbJenisRek.Text
,tbNamaBank.Text
,"" //namaaccount
,tbNoAccount.Text
,tbAlamat1.Text
,tbAlamat2.Text
,tbKota.Text
,tbTelepon.Text
,tbCusService.Text
,tbNoTerakhirBG.Text
,tbCheque.Text
,"" //nobkk
,"IDR"
,tbSaldo.Text
,tbLimitSaldo.Text
,(DateTime)SqlDateTime.Null //tglrek
,kode //kode
,"" //sub
,"" //maintitip
,"" //subtitip
,tbNoPerkiraan.Text
,tbPerkiraanTP.Text);
//Bank.addBank(db, _RowID, _BankID, tbJenisRek.Text, tbNamaBank.Text, "", tbNoAccount.Text, tbAlamat1.Text, tbAlamat2.Text, tbKota.Text, tbTelepon.Text, tbCusService.Text, tbNoTerakhirBG.Text, tbCheque.Text, "", "IDR", tbSaldo.Text, tbLimitSaldo.Text, (DateTime)SqlDateTime.Null, "", "", "", "", tbNoPerkiraan.Text, tbPerkiraanTP.Text);
}
frmBukuBankBrowse frm = new frmBukuBankBrowse();
frm = (frmBukuBankBrowse)Caller;
frm.HeaderRefresh(_RowID);
frm.HeaderFindRow("RowIDH", _RowID.ToString());
this.Close();
}
catch(Exception ex)
{
Error.LogError(ex);
}
}
else
{
//SAVE UPDATE HEADER
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Bank_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID));
db.Commands[0].Parameters.Add(new Parameter("@JRek", SqlDbType.VarChar, tbJenisRek.Text));
db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, tbNamaBank.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoAccount", SqlDbType.VarChar, tbNoAccount.Text));
db.Commands[0].Parameters.Add(new Parameter("@Alamat1", SqlDbType.VarChar, tbAlamat1.Text));
db.Commands[0].Parameters.Add(new Parameter("@Alamat2", SqlDbType.VarChar, tbAlamat2.Text));
db.Commands[0].Parameters.Add(new Parameter("@Kota", SqlDbType.VarChar, tbKota.Text));
db.Commands[0].Parameters.Add(new Parameter("@Telp", SqlDbType.VarChar, tbTelepon.Text));
db.Commands[0].Parameters.Add(new Parameter("@CService", SqlDbType.VarChar, tbCusService.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoGiro", SqlDbType.VarChar, tbNoTerakhirBG.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoCheck", SqlDbType.VarChar, tbCheque.Text));
db.Commands[0].Parameters.Add(new Parameter("@SaldoAwal", SqlDbType.Money, tbSaldo.Text));
db.Commands[0].Parameters.Add(new Parameter("@Limit", SqlDbType.Money, tbLimitSaldo.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, tbNoPerkiraan.Text));
db.Commands[0].Parameters.Add(new Parameter("@MainPerkiraan", SqlDbType.VarChar, tbPerkiraanTP.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].Parameters.Add(new Parameter("@Kode", SqlDbType.VarChar, kode));
db.Commands[0].ExecuteNonQuery();
}
frmBukuBankBrowse frm = new frmBukuBankBrowse();
frm = (frmBukuBankBrowse)Caller;
frm.HeaderRefresh(rowID);
frm.HeaderFindRow("RowIDH", rowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
else
{
if (frmMode == enumFrmMode.New)
{
//SAVE NEW DETAIL
DateTime _Tanggal = (DateTime)tbTglBank.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
rowIDDetail =Guid.NewGuid();
string recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
try
{
DateTime tglBank=(DateTime)tbTglBank.DateValue;
DateTime tglRK=(DateTime)tbTglRK.DateValue;
if (kdTransaksi == "KM1")
{
nobbk = Numerator.BookNumerator("BBK");
nobgch = Numerator.BookNumerator("BKM");
string recordIDBKM = recordID.TrimEnd() + "B";
string recordIDBKMDetail = recordIDBKM;
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Bank.AddBankDetail(db, rowIDDetail, Guid.Empty, nobbk, nobgch, rowID, "", tglBank, "BBK", tbKeterangan.Text, "IDR", tbDebet.Text, tbKredit.Text, tglBank, tglRK, "", "", "", "", noPerkiraan,bankID,recordID.TrimEnd()+"T");
BKM.AddHeader(db, rowIDDetail, rowIDDetail, recordIDBKM, nobgch, "", "BNK", tglBank, "Mutasi Dari " + namaBank, "", "", SecurityManager.UserName, "");
BKM.AddDetail(db, Guid.NewGuid(), rowIDDetail, recordIDBKMDetail, recordIDBKM, "", "", "", "", noPerkiraan, tbKeterangan.Text, tbKredit.Text);
db.CommitTransaction();
}
}
else if (kdTransaksi == "KK1")
{
nobbk = Numerator.BookNumerator("BBM");
nobgch = Numerator.BookNumerator("BKK");
string recordIDBKK = recordID.TrimEnd() + "B";
string recordIDBKKDetail = recordIDBKK;
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Bank.AddBankDetail(db, rowIDDetail, Guid.Empty, nobbk, nobgch, rowID, "", tglBank, "BBM", tbKeterangan.Text, "IDR", tbDebet.Text, tbKredit.Text, tglBank, tglRK, "", "", "", "", noPerkiraan, bankID, recordID.TrimEnd() + "T");
BKK.AddHeader(db, rowIDDetail, rowIDDetail, recordIDBKK, nobgch, "", "BNK", tglBank, "Mutasi Ke " + namaBank, "", "", SecurityManager.UserName, "", "");
BKK.AddDetail(db, Guid.NewGuid(), rowIDDetail, recordIDBKKDetail, recordIDBKK, "", "", "", "", noPerkiraan, tbKeterangan.Text, tbDebet.Text);
db.CommitTransaction();
}
}
else if (kdTransaksi == "BM1")
{
nobbk = Numerator.BookNumerator("BBK");
nobgch = Numerator.BookNumerator("BBM");
string noBBKBank2, noBGCHBank2;
Guid LinkRowID = Guid.NewGuid() ;
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Bank.AddBankDetail(db, rowIDDetail, LinkRowID, nobbk, nobgch, rowID, "", tglBank, "BBK", tbKeterangan.Text, "IDR", tbDebet.Text, tbKredit.Text, tglBank, tglRK, "", "", "", "", noPerkiraan, bankID, recordID.TrimEnd() + "T");
noBBKBank2 = nobgch;
noBGCHBank2 = nobbk;
Bank.AddBankDetail(db, LinkRowID, rowIDDetail, noBBKBank2, noBGCHBank2, rowIDBank2, "", tglBank, "BBM", "Mutasi Bank, No : " + noBGCHBank2, "IDR", tbKredit.Text, tbDebet.Text, tglBank, tglRK, "", "", "", "", noPerkiraan, bankID2, recordID.TrimEnd() + "M");
db.CommitTransaction();
}
}
else if (kdTransaksi == "BK2")
{
nobbk = Numerator.BookNumerator("BBK");
nobgch = nobbk;
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Bank.AddBankDetail(db, rowIDDetail, Guid.Empty, nobbk, nobgch, rowID, "", tglBank, "BBK", tbKeterangan.Text, "IDR", tbDebet.Text, tbKredit.Text, tglBank, tglRK, "", "", "", "", noPerkiraan, bankID, recordID.TrimEnd() + "T");
db.CommitTransaction();
}
}
else if (kdTransaksi == "BM2" || kdTransaksi == "BBM")
{
nobbk = Numerator.BookNumerator("BBM");
nobgch = nobbk;
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Bank.AddBankDetail(db, rowIDDetail, Guid.Empty, nobbk, nobgch, rowID, "", tglBank, "BBM", tbKeterangan.Text, "IDR", tbDebet.Text, tbKredit.Text, tglBank, tglRK, "", "", "", "", noPerkiraan, bankID, recordID.TrimEnd() + "T");
db.CommitTransaction();
}
}
frmBukuBankBrowse frm = new frmBukuBankBrowse();
frm = (frmBukuBankBrowse)Caller;
//frm.HeaderRefresh(rowID);
frm.HeaderRefresh();
frm.HeaderFindRow("RowIDH", rowID.ToString());
//frm.DetailRefresh(rowIDDetail);
frm.DetailRefresh();
frm.DetailFindRow("RowID", rowIDDetail.ToString());
this.Close();
bool isPrinted = LookupInfoValue.CekPrintBukuBank();
if (isPrinted)
{
frm.cetakLaporan();
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
//SAVE UPDATE DETAIL
try
{
tglRK = (DateTime)tbTglBank.DateValue;
keterangan = tbKeterangan.Text;
debet = tbDebet.Text;
kredit = tbKredit.Text;
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_BankDetail_RELASI_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@jenis", SqlDbType.VarChar, nobgch.Substring(0, 3)));
db.Commands[0].Parameters.Add(new Parameter("@RowID2", SqlDbType.UniqueIdentifier, rowID));
db.Commands[0].Parameters.Add(new Parameter("@RowIDDetail", SqlDbType.UniqueIdentifier, rowIDDetail));
db.Commands[0].Parameters.Add(new Parameter("@NoBKK2", SqlDbType.VarChar, nobbk));
db.Commands[0].Parameters.Add(new Parameter("@NoBGCH2", SqlDbType.VarChar, nobgch));
db.Commands[0].Parameters.Add(new Parameter("@tglRK2", SqlDbType.DateTime, tglRK));
db.Commands[0].Parameters.Add(new Parameter("@keterangan2", SqlDbType.VarChar, keterangan));
db.Commands[0].Parameters.Add(new Parameter("@debet2", SqlDbType.Money, debet));
db.Commands[0].Parameters.Add(new Parameter("@kredit2", SqlDbType.Money, kredit));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy2", SqlDbType.VarChar, SecurityManager.UserID));
db.BeginTransaction();
db.Commands[0].ExecuteNonQuery();
db.CommitTransaction();
}
frmBukuBankBrowse frm = new frmBukuBankBrowse();
frm = (frmBukuBankBrowse)Caller;
frm.HeaderRefresh(rowID);
frm.HeaderFindRow("RowIDH", rowID.ToString());
frm.DetailRefresh(rowIDDetail);
frm.DetailFindRow("RowID", rowIDDetail.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
}
private void cmdLinkBKK_Click(object sender, EventArgs e)
{
if (dgvHeader.Rows.Count > 0)
{
try
{
Guid headerRowID = (Guid)dgvHeader.SelectedCells[0].OwningRow.Cells["HeaderRowID"].Value;
int link = int.Parse(Tools.isNull(dgvHeader.SelectedCells[0].OwningRow.Cells["Link"].Value, string.Empty).ToString());
string pin = Tools.isNull(dgvHeader.SelectedCells[0].OwningRow.Cells["PIN"].Value, string.Empty).ToString();
string Nama = Tools.isNull(dgvHeader.SelectedCells[0].OwningRow.Cells["Nama"].Value, string.Empty).ToString();
if (pin == string.Empty || pin == "")
{
try
{
DateTime fromDate = (DateTime)rdbTanggal.FromDate;
DateTime toDate = (DateTime)rdbTanggal.ToDate;
DataSet ds = new DataSet();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_BiayaOperasional_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.DateTime, fromDate));
db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.DateTime, toDate));
ds = db.Commands[0].ExecuteDataSet();
}
GenerateExcell(ds);
MessageBox.Show("Belum Isi PIN");
return;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
if (link == 1)
{
MessageBox.Show("Biaya Operasional sudah di-link..");
return;
}
string _recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
string src = "OUT";
_recordID = BKK.GetRecordIDBukti(_recordID, src);
DateTime _Tanggal = GlobalVar.DateOfServer.Date;
Guid _rowID = Guid.NewGuid();
string _noBukti = Numerator.BookNumerator("BKK", _Tanggal);
string _recordIDDetail; Guid _rowIDDetail;
string noACC = "";
string _uraianDetail = "";
string _noperkiraan = "";
double _rpbiaya = 0;
double _rpSisaBudget = 0;
//string _attachment = "";
using (Database db = new Database(GlobalVar.DBName))
{
//db.BeginTransaction();
BKK.AddHeader(db, _rowID, _rowID, _recordID, _noBukti, "", src, _Tanggal, Nama, "", "", SecurityManager.UserName, "", "");
foreach (DataGridViewRow row in dgvDetail.Rows)
{
_rpSisaBudget = double.Parse(Tools.isNull(row.Cells["SisaBudget"].Value, "0").ToString());
_rpbiaya = double.Parse(Tools.isNull(row.Cells["RpBiayaAcc"].Value, "0").ToString());
if (_rpSisaBudget < 0)
{
_rpbiaya = double.Parse(Tools.isNull(row.Cells["RpBiayaACC11"].Value, "0").ToString());
}
_noperkiraan = Tools.isNull(row.Cells["NoPerkiraan"].Value, string.Empty).ToString();
_uraianDetail = Tools.isNull(row.Cells["Keterangan"].Value, string.Empty).ToString();
_recordIDDetail = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_rowIDDetail = Guid.NewGuid();
if (_rpbiaya > 0)
{
BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", noACC, _noperkiraan, _uraianDetail, _rpbiaya.ToString());
}
}
//db.CommitTransaction();
}
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_BiayaOperasional_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, headerRowID));
db.Commands[0].Parameters.Add(new Parameter("@Link", SqlDbType.Int, 1));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
MessageBox.Show("Link data Biaya operasional ke BKK berhasil. Silahkan cek BKK no. " + _noBukti + " tanggal " + _Tanggal.ToString("dd-MM-yyyy"));
cmdSearch_Click(sender, e);
dgvHeader.FindRow("HeaderRowID", headerRowID.ToString());
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void AddTransaksi()
{
_rowIDTransferBank = Guid.NewGuid();
_recordIDTransferBank = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
string penyetor = txtKepada.Text;
string kasir = SecurityManager.UserID;
string noBBK = string.Empty;
string MK = string.Empty;
string dibukukan = string.Empty;
string diketahui = string.Empty;
string namaBank = lookupBank1.NamaBank;
string bankID = lookupBank1.BankID;
if (_isFromPiutang == true)
{
if (_cmbJU == "TRK")
{
noBBK = Numerator.BookNumerator("BBK");
MK = "K";
_recordIDTransferBank = _recordIDTransferBank.Trim() + "1";
}
else if (_cmbJU == "TRM")
{
noBBK = Numerator.BookNumerator("BBM");
MK = "M";
_recordIDTransferBank = _recordIDTransferBank.Trim() + "2";
}
}
else
{
noBBK = Numerator.BookNumerator("BBK");
MK = "K";
_recordIDTransferBank = _recordIDTransferBank.Trim() + "4";
}
try
{
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database(GlobalVar.DBName))
{
Class.TransferBank.addHeader(db,
_rowIDTransferBank,
_rowIDTransferBank,
_recordIDTransferBank,
DateTime.Now.Date,
noBBK,
MK,
bankID,
namaBank,
dibukukan,
diketahui,
SecurityManager.UserID,
penyetor);
if (_isFromPiutang == true)
{
_recordIDTransferBank2 = _recordIDTransferBank.Substring(0, 22) + _jp;
Class.TransferBank.AddPinjamanPegawai(
db,
_rowIDTransferBank,
_recordIDTransferBank2,
_nip,
DateTime.Now.Date,
_cmbJU,
noBBK,
penyetor,
string.Empty,
0,
0,
_jp);
}
}
lblNoBkk.Visible = true;
lblNoBkk.Text = noBBK;
txtKepada.Enabled = true;
lookupBank1.Enabled = false;
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
try
{
if (lookupBank1.BankID == "" || lookupBank1.BankID == "[CODE]")
{
MessageBox.Show(Messages.Error.InputRequired);
lookupBank1.Focus();
return;
}
if (formMode == enumFormMode.New)
{
DateTime _Tanggal = tbTanggal.DateValue.Value;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
using (Database db = new Database(GlobalVar.DBName))
{
VoucherJournal.AddHeader(db, RowID, Guid.Empty, RecordID, "TT", (DateTime)tbTanggal.DateValue, Numerator.BookNumerator("VTG"), tbUraian1.Text, tbUraian2.Text, tbUraian3.Text, tbDibuat.Text, tbDibukukan.Text, tbMengetahui.Text, lookupBank1.BankID, lookupBank1.NamaBank, 0, true);
}
}
else
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_VoucherJournal_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, lookupBank1.BankID));
db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, lookupBank1.NamaBank));
db.Commands[0].Parameters.Add(new Parameter("@Uraian1", SqlDbType.VarChar, tbUraian1.Text));
db.Commands[0].Parameters.Add(new Parameter("@Uraian2", SqlDbType.VarChar, tbUraian2.Text));
db.Commands[0].Parameters.Add(new Parameter("@Uraian3", SqlDbType.VarChar, tbUraian3.Text));
db.Commands[0].Parameters.Add(new Parameter("@Dibukukan", SqlDbType.VarChar, tbDibukukan.Text));
db.Commands[0].Parameters.Add(new Parameter("@Mengetahui", SqlDbType.VarChar, tbMengetahui.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands.Add(db.CreateCommand("usp_GIRO_Titip_UPDATE"));
db.Commands[1].Parameters.Add(new Parameter("@TitipID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[1].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, lookupBank1.BankID));
db.Commands[1].Parameters.Add(new Parameter("@NamaBanki", SqlDbType.VarChar, lookupBank1.NamaBank));
db.Commands[1].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.BeginTransaction();
db.Commands[0].ExecuteNonQuery();
db.Commands[1].ExecuteNonQuery();
db.CommitTransaction();
}
}
frmVoucherGiroTitipanBrowse frm = new frmVoucherGiroTitipanBrowse();
frm = (frmVoucherGiroTitipanBrowse)Caller;
frm.HeaderRowRefresh(RowID);
frm.HeaderFindRow("hdrRowID", RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void frmPenerimaanTunaiPIN_Load(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_PenerimaanTunai_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
dt = db.Commands[0].ExecuteDataTable();
}
_RowIDInden = Guid.NewGuid();
_RowIDIndenDetail = Guid.NewGuid();
_RecordIDInden = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
//_RecordIDIndenDetail = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_TglKasir = _TglTerima; // GlobalVar.DateOfServer;
_Kasir = SecurityManager.UserName;
_NoBukti = Numerator.BookNumerator("IND");
_CollectorID = Tools.isNull(dt.Rows[0]["CollectorID"], "").ToString();
_NamaCollector = Tools.isNull(dt.Rows[0]["Nama"], "").ToString();
_Acc = "";
_Nominal = dt.Rows[0]["Nominal"].ToString();
txtPublicKey.Text = Tools.isNull(dt.Rows[0]["PublicKey"], "").ToString();
if (_NamaCollector == "VIA")
{
DataTable dtAppSet;
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_AppSetting_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@key", SqlDbType.VarChar, "PENERIMAAN TUNAI"));
dtAppSet = db.Commands[0].ExecuteDataTable();
}
if (dtAppSet.Rows.Count > 0)
{
if (dtAppSet.Rows[0]["Value"].ToString() == "1")
{
MD5 md5Hash = MD5.Create();
string _PIN = key.GetMd5Hash(md5Hash, txtPublicKey.Text);
txtPin.Text = _PIN;
}
}
}
/*pin dilepas*/
if (GlobalVar.Gudang == "2808")
{
MD5 md5Hash = MD5.Create();
string _PIN = key.GetMd5Hash(md5Hash, txtPublicKey.Text);
txtPin.Text = _PIN;
}
else
{
MD5 md5Hash = MD5.Create();
string _PIN = key.GetMd5Hash(md5Hash, txtPublicKey.Text);
txtPin.Text = _PIN;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
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 cmdSave_Click(object sender, EventArgs e)
{
//if (lookupPerkiraanKoneksi1.NoPerkiraan == "" || lookupPerkiraanKoneksi1.NoPerkiraan == "[CODE]")
//{
// MessageBox.Show("No Perkiraan masih kosong.");
// return;
//}
bool isPrinted = LookupInfoValue.CekPrintBs();
if (formMode == enumformMode.New)
{
if (txtAcc.Text == "")
{
MessageBox.Show("Masih ada Kasbon yang belum diselesaikan, dan belum ada PIN dari HO.");
lookupPegawai1.Focus();
return;
}
if (!validate())
{
return;
}
DateTime _Tanggal = (DateTime)tbTanggal.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing!");
return;
}
_RowID = Guid.NewGuid();
string _RecordID = ISA.Common.Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1);
string _RecordIDBKKDetail = ISA.Common.Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 2);
string _NoBKK = Numerator.BookNumerator("BKK", tbTanggal.DateValue);
string _NoBukti = Numerator.BookNumerator("BON", tbTanggal.DateValue);
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Kasbon_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, _RecordID));
db.Commands[0].Parameters.Add(new Parameter("@NIP", SqlDbType.VarChar, lookupPegawai1.Nip));
db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, lookupPegawai1.Nama));
db.Commands[0].Parameters.Add(new Parameter("@UnitKerja", SqlDbType.VarChar, lookupPegawai1.Unitkerja));
db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, _NoBukti));
db.Commands[0].Parameters.Add(new Parameter("@Tgl", SqlDbType.DateTime, tbTanggal.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@Keperluan", SqlDbType.VarChar, tbKeperluan.Text.Trim()));
db.Commands[0].Parameters.Add(new Parameter("@BKKNo1", SqlDbType.VarChar, _NoBKK));
db.Commands[0].Parameters.Add(new Parameter("@BKKRp1", SqlDbType.Money, tbNominal.Text));
db.Commands[0].Parameters.Add(new Parameter("@Total1", SqlDbType.Money, tbNominal.Text));
db.Commands[0].Parameters.Add(new Parameter("@Kode", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@Sub", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@Hari", SqlDbType.VarChar, tbHari.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, lookupPerkiraanKoneksi1.NoPerkiraan));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.BeginTransaction();
db.Commands[0].ExecuteNonQuery();
BKK.AddHeader(db, _RowID, _RowID, BKK.GetRecordIDBukti(_RecordID, "BSA"), _NoBKK, "", "BSA", (DateTime)tbTanggal.DateValue, lookupPegawai1.Nama, "", "", SecurityManager.UserName, "", "TT");
BKK.AddDetail(db, Guid.NewGuid(), _RowID, _RecordIDBKKDetail, BKK.GetRecordIDBukti(_RecordID, "BSA"), "", "", "", "", lookupPerkiraanKoneksi1.NoPerkiraan, tbKeperluan.Text.Trim() + " (" + _NoBukti + ")", tbNominal.Text);
db.CommitTransaction();
}
string nominal = tbNominal.GetDoubleValue.ToString("#,###");
if (isPrinted)
{
cetakLaporan(_NoBKK, tbKeperluan.Text.Trim() + " (" + _NoBukti + ")", nominal, tbTanggal.DateValue.Value.ToString("dd/MM/yyyy"), "K");
}
frmKasbonBrowse frm = new frmKasbonBrowse();
frm = (frmKasbonBrowse)Caller;
//frm.KasbonRefresh(_RowID);
frm.KasbonRefresh();
frm.KasbonFindRow("RowID", _RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
if (tbSisa.Text != "0")
{
MessageBox.Show("Masih ada sisa BS, tidak boleh di update.");
return;
}
if (tbRpTrm.Text != "0" && bankID == "")
{
MessageBox.Show("Detail transfer belum diisi.");
return;
}
string noVJU = "", noBKK3 = "", noBKM3 = "", noTRM3 = "";
double rpVJU = 0, rpBKK3 = 0, rpBKM3 = 0, rpTRM3 = 0, rpTotle = 0, rpTotku = 0;
if (dtVoucher.Rows.Count > 0)
{
noVJU = Numerator.BookNumerator("VJU", tbTanggal.DateValue);
rpVJU = Convert.ToDouble(tbTotal.Text);
}
if (selisih < 0)
{
rpTotku = selisih * -1;
rpBKK3 = Convert.ToDouble(tbBKK.Text);
noBKK3 = Numerator.BookNumerator("BKK", tbTanggal.DateValue);
}
else
{
rpTotle = Convert.ToDouble(tbBKM.Text) + Convert.ToDouble(tbRpTrm.Text);
if (cbBkm.Checked == true)
{
rpBKM3 = Convert.ToDouble(tbBKM.Text);
noBKM3 = Numerator.BookNumerator("BKM", tbTanggal.DateValue);
}
if (cbTrm.Checked == true)
{
rpTRM3 = Convert.ToDouble(tbRpTrm.Text);
noTRM3 = Numerator.BookNumerator("BBM", tbTanggal.DateValue);
}
}
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
db.Commands.Add(db.CreateCommand("usp_Kasbon_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@JVNo1", SqlDbType.VarChar, noVJU));
db.Commands[0].Parameters.Add(new Parameter("@BKKNo3", SqlDbType.VarChar, noBKK3));
db.Commands[0].Parameters.Add(new Parameter("@BKMNo3", SqlDbType.VarChar, noBKM3));
db.Commands[0].Parameters.Add(new Parameter("@TRNNo3", SqlDbType.VarChar, noTRM3));
db.Commands[0].Parameters.Add(new Parameter("@JVRp1", SqlDbType.Money, rpVJU));
db.Commands[0].Parameters.Add(new Parameter("@Total2", SqlDbType.Money, Convert.ToDouble(tbTotal.Text)));
db.Commands[0].Parameters.Add(new Parameter("@BKKRp3", SqlDbType.Money, rpBKK3));
db.Commands[0].Parameters.Add(new Parameter("@BKMRp3", SqlDbType.Money, rpBKM3));
db.Commands[0].Parameters.Add(new Parameter("@TRNRp3", SqlDbType.Money, rpTRM3));
db.Commands[0].Parameters.Add(new Parameter("@Totle3", SqlDbType.Money, rpTotle));
db.Commands[0].Parameters.Add(new Parameter("@Totku3", SqlDbType.Money, rpTotku));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
if (_biayaOperasionalRowId != Guid.Empty)
{
db.Commands[0].Parameters.Add(new Parameter("@BiayaOperasionalRowID", SqlDbType.UniqueIdentifier, _biayaOperasionalRowId));
}
db.Commands[0].ExecuteNonQuery();
if (dtVoucher.Rows.Count > 0)
{
string vjRecID = _RecordID + "X";
VoucherJournal.AddHeader(db, _RowID, _RowID, vjRecID, "UM", DateTime.Today, noVJU, tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")", "", "", SecurityManager.UserName, "", "", "", "", 0, true);
foreach (DataRow dr in dtVoucher.Rows)
{
VoucherJournal.AddDetail(db, (Guid)dr["RowID"], _RowID, dr["RecordID"].ToString(), vjRecID, "", "", dr["NoAcc"].ToString(), "", dr["NoPerkiraan"].ToString(), dr["Keterangan"].ToString() + " (" + TBNoKasbon.Text + ")", (Double)dr["Debet"], 0, true);
}
if (isPrinted)
{
cetakLaporanVju(noVJU, String.Format("{0:dd/MM/yyyy}", DateTime.Today));
}
}
if (cbBkm.Checked == true)
{
Guid rowID = Guid.NewGuid();
string recIDD = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 2);
string uraian = "KELEBIHAN BS " + tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")";
BKM.AddHeader(db, rowID, _RowID, BKM.GetRecordIDBukti(_RecordID, "BSL"), noBKM3, "", "BSL", DateTime.Today, lookupPegawai1.Nama, "", "", SecurityManager.UserName, "");
BKM.AddDetail(db, Guid.NewGuid(), rowID, recIDD, BKM.GetRecordIDBukti(_RecordID, "BSL"), "", "", "", "", "", uraian, rpBKM3.ToString());
if (isPrinted)
{
cetakLaporan(noBKM3, uraian, rpBKM3.ToString("#,###"), String.Format("{0:dd/MM/yyyy}", DateTime.Today), "M");
}
}
if (cbBkk.Checked == true)
{
Guid rowID = Guid.NewGuid();
string recIDD = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 2);
string uraian = "KEKURANGAN BS " + tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")";
BKK.AddHeader(db, rowID, _RowID, BKK.GetRecordIDBukti(_RecordID, "BSK"), noBKK3, "", "BSK", DateTime.Today, lookupPegawai1.Nama, "", "", SecurityManager.UserName, "", "");
BKK.AddDetail(db, Guid.NewGuid(), rowID, recIDD, BKK.GetRecordIDBukti(_RecordID, "BSK"), "", "", "", "", "", uraian, rpBKK3.ToString());
if (isPrinted)
{
cetakLaporan(noBKK3, uraian, rpBKK3.ToString("#,###"), String.Format("{0:dd/MM/yyyy}", DateTime.Today), "K");
}
}
if (cbTrm.Checked == true)
{
Guid rowID = _RowID;
string uraian = "KELEBIHAN BS " + tbKeperluan.Text.Trim() + " (" + TBNoKasbon.Text + ")";
TransferBank.addHeader(db, rowID, _RowID, _RecordID.TrimEnd() + "8", DateTime.Today, noTRM3, "M", bankID, bankAsal, "", "", SecurityManager.UserName, lookupPegawai1.Nama);
TransferBank.addDetail(db, rowID, rowID, _RecordID.TrimEnd() + "8", _RecordID.TrimEnd() + "8", "", uraian, bankAsal, "", nomor, DateTime.Today, rpTRM3.ToString(), "", "", "", "", bankID, "", "");
Bank.AddBankDetail(db, rowID, Guid.Empty, noTRM3, "", Guid.Empty, "", DateTime.Today, "BBM", "TRANSFER DARI : " + uraian, "IDR", rpTRM3.ToString(), "0", DateTime.Today, DateTime.Today, "", "", "", "", "", bankID, _RecordID.TrimEnd() + "8");
}
db.CommitTransaction();
}
frmKasbonBrowse frm = new frmKasbonBrowse();
frm = (frmKasbonBrowse)Caller;
frm.KasbonRefresh(_RowID);
frm.KasbonFindRow("RowID", _RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
double _Nominal = double.Parse(tbNominal.Text);
string _NomorTransaksi, _PublicKey;
if (CollectorID == "")
{
MessageBox.Show("Collector belum diisi");
tbCollector.Focus();
return;
}
if (_Nominal == 0)
{
MessageBox.Show("Nominal belum diisi");
tbNominal.Focus();
return;
}
int mingguKe;
string Gudang;
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
DateTime date = Convert.ToDateTime(GlobalVar.DateTimeOfServer);
Calendar cal = dfi.Calendar;
mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
Gudang = GlobalVar.Gudang;
string jam = date.ToString("HHmmss");
_NomorTransaksi = Numerator.BookNumerator("PTU");
//_PublicKey = Tools.pin(Convert.ToInt32(jam), mingguKe, date, PinId.Bagian.Keuangan, Convert.ToInt32(PinId.ModulId.PenerimaanTunai), Gudang);
// _PublicKey = Tools.pin(Convert.ToInt32(jam), mingguKe, date, 12, Convert.ToInt32(PinId.ModulId.TempoSpesial), Gudang); //12 merupakan kode bagian dari PIN di menu penerimaan tunai
try
{
switch (formMode)
{
case enumFormMode.New:
using (Database db = new Database(GlobalVar.DBFinance))
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_PenerimaanTunai_INSERT"));
_RowID = Guid.NewGuid();
_PublicKey = Tools.GetKey(_RowID.ToString(), Gudang, 12); //12 merupakan kode bagian dari PIN di menu penerimaan tunai
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@NomorTransaksi", SqlDbType.VarChar, _NomorTransaksi));
db.Commands[0].Parameters.Add(new Parameter("@TanggalTerima", SqlDbType.DateTime, (DateTime)tbTanggalTerima.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID));
db.Commands[0].Parameters.Add(new Parameter("@Nominal", SqlDbType.Money, tbNominal.Text));
db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, tbKeterangan.Text));
db.Commands[0].Parameters.Add(new Parameter("@PublicKey", SqlDbType.VarChar, _PublicKey));
db.Commands[0].Parameters.Add(new Parameter("@CreatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
}
break;
}
this.DialogResult = DialogResult.OK;
FormClose();
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (dtRowDetail.Rows.Count > 0 && txtSelisih.GetDoubleValue == 0)
{
try
{
this.Cursor = Cursors.WaitCursor;
switch (formMode)
{
case enumFormMode.New:
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Class.Journal.AddHeader(db, _rowID, _recID, (DateTime)txtTanggal.DateValue, Numerator.BookNumerator("ADJ"), txtUraian.Text, _src, lookupGudang1.GudangID, false);
foreach (DataRow drDetail in dtRowDetail.Rows)
{
//Guid dJournalID = Guid.NewGuid();
//string journalRecID = ISA.Common.Tools.CreateFingerPrint (GlobalVar.PerusahaanID, SecurityManager.UserInitial);
Class.Journal.AddDetail(db, (Guid)drDetail["RowID"], (Guid)drDetail["HeaderID"], drDetail["RecordID"].ToString(), drDetail["HRecordID"].ToString(), drDetail["NoPerkiraan"].ToString(), drDetail["Uraian"].ToString(), double.Parse(drDetail["Debet"].ToString()), double.Parse(drDetail["Kredit"].ToString()), drDetail["DK"].ToString());
}
db.CommitTransaction();
dtRowDetail.AcceptChanges();
formMode = enumFormMode.Update;
}
break;
case enumFormMode.Update:
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
Class.Journal.UpdateHeader(db, _rowID, _recID, (DateTime)txtTanggal.DateValue, txtNoReff.Text, txtUraian.Text, _src, lookupGudang1.GudangID, false);
DataTable dtInsert, dtUpdate, dtDelete;
dtInsert = dtRowDetail.GetChanges(DataRowState.Added);
dtUpdate = dtRowDetail.GetChanges(DataRowState.Modified);
//dtDelete = dtRowDetail.GetChanges(DataRowState.Deleted);
if (dtDeleteee.Rows.Count > 0)
{
foreach (DataRow drDetail in dtDeleteee.Rows)
{
Class.Journal.DeleteDetail(db, (Guid)drDetail["RowID"]);
}
}
if (dtInsert != null)
{
foreach (DataRow drDetail in dtInsert.Rows)
{
Class.Journal.AddDetail(db, (Guid)drDetail["RowID"], (Guid)drDetail["HeaderID"], drDetail["RecordID"].ToString(), drDetail["HRecordID"].ToString(), drDetail["NoPerkiraan"].ToString(), drDetail["Uraian"].ToString(), double.Parse(drDetail["Debet"].ToString()), double.Parse(drDetail["Kredit"].ToString()), drDetail["DK"].ToString());
}
}
if (dtUpdate != null)
{
foreach (DataRow drDetail in dtUpdate.Rows)
{
Class.Journal.UpdateDetail(db, (Guid)drDetail["RowID"], (Guid)drDetail["HeaderID"], drDetail["RecordID"].ToString(), drDetail["HRecordID"].ToString(), drDetail["NoPerkiraan"].ToString(), drDetail["Uraian"].ToString(), double.Parse(drDetail["Debet"].ToString()), double.Parse(drDetail["Kredit"].ToString()), drDetail["DK"].ToString());
}
}
db.CommitTransaction();
dtRowDetail.AcceptChanges();
}
break;
}
this.DialogResult = DialogResult.OK;
MessageBox.Show(ISA.Common.Messages.Confirm.UpdateSuccess);
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
else
{
MessageBox.Show("Debet-Kredit masih belum balance");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedCells.Count > 0 && dataGridView2.SelectedCells.Count > 0)
{
if (Convert.ToBoolean(dataGridView2.SelectedCells[0].OwningRow.Cells["upd"].Value) == false && dataGridView2.SelectedCells[0].OwningRow.Cells["IdWilBaru"].Value.ToString() != "")
{
string kodeToko = dataGridView1.SelectedCells[0].OwningRow.Cells["KodeToko"].Value.ToString();
string namaToko = dataGridView1.SelectedCells[0].OwningRow.Cells["NamaToko"].Value.ToString();
string idWilBaru = dataGridView2.SelectedCells[0].OwningRow.Cells["IdWilBaru"].Value.ToString();
string idWilLama = dataGridView2.SelectedCells[0].OwningRow.Cells["IdWilLama"].Value.ToString();
Guid rowID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value;
Guid reWilRowID = (Guid)dataGridView2.SelectedCells[0].OwningRow.Cells["Row"].Value;
DataTable dtVwil = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("psp_VWIL_GetData"));
db.Commands[0].Parameters.Add(new Parameter("@kodetoko", SqlDbType.VarChar, kodeToko));
dtVwil = db.Commands[0].ExecuteDataTable();
//RefreshData();
//DataTable dt = new DataTable();
//db.Commands.Add(db.CreateCommand("usp_Toko_UPDATE"));
//db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, rowID));
//db.Commands[0].Parameters.Add(new Parameter("@wilID", SqlDbType.VarChar, wilID));
//db.Commands[0].Parameters.Add(new Parameter("@reWilRowID", SqlDbType.UniqueIdentifier, reWilRowID));
//db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
//db.Commands[0].ExecuteNonQuery();
//RefreshData();
}
DataTemplates.dsJurnal.JournalDataTable dtHeader = new ISA.Finance.DataTemplates.dsJurnal.JournalDataTable();
DataTemplates.dsJurnal.JournalDetailDataTable dtDetail = new ISA.Finance.DataTemplates.dsJurnal.JournalDetailDataTable();
double rpSisa = 0;
if (dtVwil.Rows.Count == 1)
{
Guid jRowID = Guid.NewGuid();
string jRecID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
DateTime jTanggal = DateTime.Now.Date;
string jReff = Numerator.BookNumerator("ADJ");
string jUraian = "PINDAH WILAYAH TOKO " + namaToko + " DARI " + idWilLama + " KE " + idWilBaru;
rpSisa = Convert.ToDouble(dtVwil.Rows[0]["RpSisa"]);
string dNoPerk = "";
string kNoPerk = "";
string NoPerkBaru = Perkiraan.GetPerkiraanKoneksiDetail("COL" + idWilBaru.Substring(0, 1)).Rows[0]["NoPerkiraan"].ToString();
string NoPerkLama = Perkiraan.GetPerkiraanKoneksiDetail("COL" + idWilLama.Substring(0, 1)).Rows[0]["NoPerkiraan"].ToString();
if (rpSisa >= 0)
{
dNoPerk = NoPerkBaru;
kNoPerk = NoPerkLama;
}
else
{
dNoPerk = NoPerkLama;
kNoPerk = NoPerkBaru;
}
if (rpSisa > 0)
{
dtJurnalH.Rows.Clear();
dtJurnalD.Rows.Clear();
InsertJournalHeader(jRowID, rowID, jRecID, jTanggal, jReff, jUraian, "WIL", GlobalVar.Gudang, false, rpSisa, rpSisa);
InsertJournalDetail(Guid.NewGuid(), rowID, jRowID, Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial), jRecID, dNoPerk, jUraian, rpSisa, 0, "D");
InsertJournalDetail(Guid.NewGuid(), rowID, jRowID, Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial), jRecID, kNoPerk, jUraian, 0, rpSisa, "K");
}
}
VWil.frmProsesIDWilExecute ifrmChild = new VWil.frmProsesIDWilExecute(kodeToko, reWilRowID, dtJurnalH, dtJurnalD);
ifrmChild.Caller = this;
ifrmChild.ShowDialog();
//MessageBox.Show("Refresh data transaksi telah selesai");
}
else
{
MessageBox.Show("Record ini sudah diupload");
}
}
else
{
MessageBox.Show(Messages.Error.RowNotSelected);
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
try
{
if (tbTanggal.DateValue.ToString() != "" && lookupStafAdm1.Nama != "")
{
TglKasir = (DateTime)tbTanggal.DateValue;
Acc = lookupStafAdm2.Kode;
NamaCollector = lookupStafAdm1.Nama;
if (formMode == enumFormMode.New)
{
if (PeriodeClosing.IsKasirClosed(TglKasir))
{
MessageBox.Show("Sudah Closing!");
return;
}
noBukti = Numerator.BookNumerator("IND");
RowIDI = Guid.NewGuid();
string RecordIDI = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("usp_Inden_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowIDI));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, RecordIDI));
db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, TglKasir));
db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, noBukti));
db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID));
db.Commands[0].Parameters.Add(new Parameter("@NamaCollector", SqlDbType.VarChar, NamaCollector));
db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, Acc));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRefresh();
frm.IndenFindRow("RowIDI", RowIDI.ToString());
this.Close();
}
else
{
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("usp_Inden_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowIDI));
db.Commands[0].Parameters.Add(new Parameter("@TglKasir", SqlDbType.DateTime, TglKasir));
db.Commands[0].Parameters.Add(new Parameter("@Kasir", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].Parameters.Add(new Parameter("@CollectorID", SqlDbType.VarChar, CollectorID));
db.Commands[0].Parameters.Add(new Parameter("@NamaCollector", SqlDbType.VarChar, NamaCollector));
db.Commands[0].Parameters.Add(new Parameter("@Acc", SqlDbType.VarChar, Acc));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRefresh();
frm.IndenFindRow("RowIDI", RowIDI.ToString());
this.Close();
}
}
else
{
MessageBox.Show(Messages.Error.InputRequired);
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
