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