private void lookupToko1_Validating(object sender, CancelEventArgs e)
{
if (lookupToko1.NamaToko.ToString() != string.Empty)
{
string _alamat = lookupToko1.Alamat;
txtAlamat.Text = _alamat;
txtKota.Text = lookupToko1.Kota;
txtDaerah.Text = lookupToko1.Daerah;
txtPropinsi.Text = lookupToko1.Propinsi;
if (lookupToko1.NamaToko == "")
{
txtAlamat.Text = "";
txtKota.Text = "";
txtDaerah.Text = "";
txtKecamatan.Text = "";
txtPropinsi.Text = "";
}
bool isCekArea = LookupInfoValue.CekFixAreaEnable(GlobalVar.Gudang);
txtAlamat.Enabled = isCekArea;
txtKota.Enabled = isCekArea;
txtDaerah.Enabled = isCekArea;
txtKecamatan.Enabled = isCekArea;
txtPropinsi.Enabled = isCekArea;
}
}
private void frmAccDOBrowser_Load(object sender, EventArgs e)
{
rdbTglDO.FromDate = GlobalVar.DateOfServer;
rdbTglDO.ToDate = GlobalVar.DateOfServer;
bool isAccDo = LookupInfoValue.CekAccDo(SecurityManager.UserID);
cmdYes.Visible = isAccDo;
if (GlobalVar.Gudang == "2807")
{
label1.Visible = false;
label2.Visible = false;
label3.Visible = false;
textBox1.Visible = false;
textBox2.Visible = false;
textBox3.Visible = false;
}
else
{
label1.Visible = true;
label2.Visible = true;
label3.Visible = true;
textBox1.Visible = true;
textBox2.Visible = true;
textBox3.Visible = true;
}
cmdSearch_Click(sender, e);
}
private void DownloadBMK()
{
int counter = 0;
bool isBmk11 = LookupInfoValue.CekBmk11();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_HistoryBMK_DOWNLOAD"));
foreach (DataRow dr in tblBMK.Rows)
{
//add parameters
db.Commands[0].Parameters.Clear();
db.Commands[0].Parameters.Add(new Parameter("@id_hist", SqlDbType.VarChar, Tools.isNull(dr["id_hist"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@id_stok", SqlDbType.VarChar, Tools.isNull(dr["id_stok"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@tmt", SqlDbType.DateTime, dr["tmt"]));
db.Commands[0].Parameters.Add(new Parameter("@tmt_pasif", SqlDbType.DateTime, dr["tmt_pasif"]));
db.Commands[0].Parameters.Add(new Parameter("@hjual_std", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_std"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@h_net", SqlDbType.Money, double.Parse(Tools.isNull(dr["h_net"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@qmin_b", SqlDbType.Int, int.Parse(Tools.isNull(dr["qmin_b"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@hjual_b", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_b"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@qmin_m", SqlDbType.Int, int.Parse(Tools.isNull(dr["qmin_m"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@hjual_m", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_m"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@qmin_k", SqlDbType.Int, int.Parse(Tools.isNull(dr["qmin_k"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@hjual_k", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_k"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@cash", SqlDbType.Int, int.Parse(Tools.isNull(dr["cash"], "0").ToString()))); //.Substring(0, Tools.isNull(dr["cash"], "0").ToString().Length - 3))));
db.Commands[0].Parameters.Add(new Parameter("@top10", SqlDbType.Int, int.Parse(Tools.isNull(dr["top10"], "0").ToString()))); //.Substring(0, Tools.isNull(dr["top10"], "0").ToString().Length - 3))));
db.Commands[0].Parameters.Add(new Parameter("@enduser", SqlDbType.Int, int.Parse(Tools.isNull(dr["enduser"], "0").ToString()))); //.Substring(0, Tools.isNull(dr["enduser"], "0").ToString().Length - 3))));
db.Commands[0].Parameters.Add(new Parameter("@hjual_c", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_c"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@hjual_t", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_t"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@hjual_e", SqlDbType.Money, double.Parse(Tools.isNull(dr["hjual_e"], "0").ToString())));
db.Commands[0].Parameters.Add(new Parameter("@ket", SqlDbType.VarChar, Tools.isNull(dr["ket"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@dl", SqlDbType.VarChar, Tools.isNull(dr["dl"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@nama_stok", SqlDbType.VarChar, Tools.isNull(dr["nama_stok"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@idrecstok", SqlDbType.VarChar, Tools.isNull(dr["idrecstok"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@satuan", SqlDbType.VarChar, Tools.isNull(dr["satuan"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@id_match", SqlDbType.VarChar, Tools.isNull(dr["id_match"], "0").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@sts_laba", SqlDbType.VarChar, Tools.isNull(dr["sts_laba"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
if (isBmk11)
{
db.Commands[0].Parameters.Add(new Parameter("@BmkDari11", SqlDbType.Int, 1));
}
db.Commands[0].ExecuteNonQuery();
//grid and form status
dr["cUploaded"] = true;
counter++;
progressBar1.Increment(1);
lblDownloadStatus1.Text = counter.ToString("#,##0") + "/" + tblBMK.Rows.Count.ToString("#,##0");
this.Refresh();
this.Invalidate();
Application.DoEvents();
}
}
}
private void frmAccDOMandiriBrowser_Load(object sender, EventArgs e)
{
rdbTglDO.FromDate = GlobalVar.DateOfServer;
rdbTglDO.ToDate = GlobalVar.DateOfServer;
bool isAccDo = LookupInfoValue.CekAccDo(SecurityManager.UserID);
cmdYes.Visible = isAccDo;
cmdSearch_Click(sender, e);
}
private void frmACCReturBrowse_Load(object sender, EventArgs e)
{
rdbTglMPR.FromDate = GlobalVar.DateOfServer;
rdbTglMPR.ToDate = GlobalVar.DateOfServer;
bool isAccRetur = LookupInfoValue.CekAccRetur(SecurityManager.UserID);
cmdYes.Visible = isAccRetur;
cmdSearch_Click(sender, e);
}
private void dataGridDO_KeyDown(object sender, KeyEventArgs e)
{
bool isAccRetur = LookupInfoValue.CekAccRetur(SecurityManager.UserID);
if (isAccRetur == true)
{
switch (e.KeyCode)
{
case Keys.Space:
cmdYes_Click(sender, e);
break;
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
bool isPrintSj = LookupInfoValue.CekPrintSj();
cmdPrintSj.Visible = isPrintSj;
if (cmdPrintSj.Visible)
{
cmdPrintPengantarSj.Text = "REKAP";
}
nDay = DateTime.Today.Day - 1;
_fromDate = DateTime.Today.AddDays(-nDay);
_toDate = DateTime.Now;
rdb_xpdc.FromDate = _fromDate;
rdb_xpdc.ToDate = _toDate;
rdb_xpdc.Focus();
RefreshDataXpdc();
//sekarang = _toDate.AddDays(Convert.ToInt16(DateTime.Today));
}
private void cmdSave_Click(object sender, EventArgs e)
{
bool isCashAllowed = LookupInfoValue.CekIndenTunai();
if (cbSOinden.Checked == true)
{
if (RowIDOrderPenjualan == Guid.Empty)
{
MessageBox.Show("SO/DO belum dipilih");
lookupSO1.Focus();
return;
}
}
else
{
RowIDOrderPenjualan = Guid.Empty;
}
if (!isCashAllowed)
{
if (!_isFromPiutang)
{
if (cbCara.Text == "CASH")
{
MessageBox.Show("Input Cash dari Menu Penerimaan Tunai", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
}
if (mode != "Edit")
{
if (!ValidateInput())
{
return;
}
cara = cbCara.Text;
if (cara == "CASH")
{
cara = "";
RpCash = tbNominal.Text;
ket = tbKet.Text;
}
else if (cara == "TRN")
{
/*cegatan Transfer hanya untuk biaya operasional*/
if (GlobalVar.Gudang != "2803")
{
string cBankTujuan = lookupBankTujuan.BankID;
try
{
this.Cursor = Cursors.WaitCursor;
DataTable dtb = new DataTable(GlobalVar.DBName);
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_BankTujuan_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@bankID", SqlDbType.VarChar, cBankTujuan));
db.Commands[0].Parameters.Add(new Parameter("@NamaAccount", SqlDbType.VarChar, "BANK OPERASIONAL"));
dtb = db.Commands[0].ExecuteDataTable();
}
if (dtb.Rows.Count == 0)
{
MessageBox.Show("Transfer Bank hanya digunakan untuk biaya Operasional");
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/*end cegatan-----------------------------------------*/
cara = "T";
RpTrn = tbNominal.Text;
ket = tbKet.Text;
bankID = lookupBankTujuan.BankID;
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
noAcc = lookupAccountToko1.NoAccount;
tglRK = (DateTime)tbTglRK.DateValue;
rowIDBankTujuan = lookupBankTujuan.RowID;
}
else if (cara == "GIRO")
{
RpGiro = tbNominal.Text;
ket = tbKet.Text;
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
noAcc = lookupAccountToko1.NoAccount;
tglGiro = (DateTime)tbTglGiro.DateValue;
tglJTempo = (DateTime)tbTglJTempo.DateValue;
noBGC = tbNoBGC.Text;
cara = tbJenisGiro.Text;
}
else if (cara == "CRD")
{
RpCrd = tbNominal.Text;
ket = tbKet.Text;
cara = "R";
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
tglGiro = (DateTime)tbTglGiro.DateValue;
tglJTempo = (DateTime)tbTglJTempo.DateValue;
noBGC = tbNoBGC.Text;
bankID = lookupBankTujuan.BankID;
namaBanki = lookupBankTujuan.NamaBank;
}
else if (cara == "DBT")
{
RpDbt = tbNominal.Text;
ket = tbKet.Text;
cara = "D";
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
tglGiro = (DateTime)tbTglGiro.DateValue;
tglJTempo = (DateTime)tbTglJTempo.DateValue;
noBGC = tbNoBGC.Text;
bankID = lookupBankTujuan.BankID;
namaBanki = lookupBankTujuan.NamaBank;
}
RowID = Guid.NewGuid();
RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
addIndenDetail(db);
db.CommitTransaction();
}
if (_isFromPiutang == true)
{
this.Close();
}
else
{
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRowRefresh(HeaderID);
frm.IndenDetailRowRefresh(RowID);
frm.IndenDetailFindRow("RowIDID", RowID.ToString());
}
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
try
{
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_IndenDetail_SOInden_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowIDdetail));
db.Commands[0].Parameters.Add(new Parameter("@RowIDOrderPenjualan", SqlDbType.UniqueIdentifier, RowIDOrderPenjualan));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRowRefresh(HeaderID);
frm.IndenDetailRowRefresh(rowIDdetail);
frm.IndenDetailFindRow("RowIDID", rowIDdetail.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
}
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 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)
{
//if (GlobalVar.Gudang != "2803")
//{
bool isCashAllowed = LookupInfoValue.CekIndenTunai();
//if (!isCashAllowed)
//{
// if (cbCara.Text == "CASH")
// {
// MessageBox.Show("Input Cash dari Menu Penerimaan Tunai", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
// }
//}
//}
if (!ValidateInput())
{
return;
}
cara = cbCara.Text;
if (cara == "CASH")
{
cara = "";
RpCash = tbNominal.Text;
ket = tbKet.Text;
}
else if (cara == "TRN")
{
cara = "T";
RpTrn = tbNominal.Text;
ket = tbKet.Text;
bankID = lookupBankTujuan.BankID;
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
noAcc = lookupAccountToko1.NoAccount;
tglRK = (DateTime)tbTglRK.DateValue;
rowIDBankTujuan = lookupBankTujuan.RowID;
}
else if (cara == "GIRO")
{
RpGiro = tbNominal.Text;
ket = tbKet.Text;
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
noAcc = lookupAccountToko1.NoAccount;
tglGiro = (DateTime)tbTglGiro.DateValue;
tglJTempo = (DateTime)tbTglJTempo.DateValue;
noBGC = tbNoBGC.Text;
cara = tbJenisGiro.Text;
}
else if (cara == "CRD")
{
RpCrd = tbNominal.Text;
ket = tbKet.Text;
cara = "R";
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
tglGiro = (DateTime)tbTglGiro.DateValue;
tglJTempo = (DateTime)tbTglJTempo.DateValue;
noBGC = tbNoBGC.Text;
bankID = lookupBankTujuan.BankID;
namaBanki = lookupBankTujuan.NamaBank;
}
else if (cara == "DBT")
{
RpDbt = tbNominal.Text;
ket = tbKet.Text;
cara = "D";
NamaBank = lookupBankAsal1.NamaBank;
Lokasi = lookupBankAsal1.Lokasi;
tglGiro = (DateTime)tbTglGiro.DateValue;
tglJTempo = (DateTime)tbTglJTempo.DateValue;
noBGC = tbNoBGC.Text;
bankID = lookupBankTujuan.BankID;
namaBanki = lookupBankTujuan.NamaBank;
}
RowID = Guid.NewGuid();
RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
try
{
using (Database db = new Database(GlobalVar.DBFinance))
{
db.BeginTransaction();
addIndenDetail(db);
db.CommitTransaction();
}
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRowRefresh(HeaderID);
frm.IndenDetailRowRefresh(RowID);
frm.IndenDetailFindRow("RowIDID", RowID.ToString());
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
