private void cmdSave_Click(object sender, EventArgs e) { string nominal = tbNominal.Text; Guid RowID = Guid.NewGuid(); string RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial); using (Database db = new Database(GlobalVar.DBFinance)) { db.BeginTransaction(); addIndenSuperDetail(db, RowID, RowIDISD, RowIDI, RowIDID, RecordID, RecordIDISD, Guid.Empty, "", Guid.Empty, "", "NP", tbTglInden.DateValue.Value, "", chbg, "", tbTglInden.DateValue.Value, (DateTime)SqlDateTime.Null, "", "", "?", nominal, "0", "0"); db.CommitTransaction(); } frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse(); frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller; frm.IndenRowRefresh(RowIDI); frm.IndenDetailRowRefresh(RowIDID); frm.IndenSubDetailRowRefresh(RowIDISD); frm.IndenSuperDetailRowRefresh(RowID); frm.IndenSuperDetailFindRow("RowIDISSD", RowID.ToString()); this.Close(); }
private void cmdSave_Click(object sender, EventArgs e) { if (lookupNotaPiutang1.KPID == Guid.Empty) { MessageBox.Show("No Nota Belum Diisi"); lookupNotaPiutang1.Focus(); return; } if (tbRpTagih.GetDoubleValue < tbRpInden.GetDoubleValue) { MessageBox.Show("Jumlah Rp Inden Tidak Boleh Melebihi Tagihan(" + tbRpTagih.Text + ")"); tbRpInden.Focus(); return; } if (tbRpInden.GetDoubleValue > Convert.ToDouble(RpInden)) { MessageBox.Show("Jumlah Rp Inden Tidak Boleh Melebihi Nilai Identifikasi (" + Convert.ToDouble(RpInden).ToString("#,###") + ")"); tbRpInden.Focus(); return; } if (tbRpInden.GetDoubleValue == 0) { MessageBox.Show("Jumlah Rp Inden Tidak Boleh 0"); tbRpInden.Focus(); return; } DateTime _Tanggal = (DateTime)tbTglInden.DateValue; if (PeriodeClosing.IsPJTClosed(_Tanggal)) { MessageBox.Show("Sudah Closing!"); return; } using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_GetTokoIDWil")); db.Commands[0].Parameters.Add(new Parameter("@kodetoko", SqlDbType.VarChar, kodeToko)); dtIDWil = db.Commands[0].ExecuteDataTable(); } //string kodeTrn = "COL" + dtIDWil.Rows[0]["WilID"].ToString().Substring(0, 1); string kodeTrn = "PJT"; string dNoPerkiraan = Perkiraan.GetPerkiraanKoneksiDetail(kodeTrn).Rows[0]["NoPerkiraan"].ToString(); RowIDISSD = Guid.NewGuid(); RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial); try { using (Database db = new Database(GlobalVar.DBFinance)) { db.BeginTransaction(); //insert indensuperdetail addIndenSuperDetail(db, RowIDISSD, RowIDISD, RowIDI, RowIDID, RecordID , HRecordID, lookupNotaPiutang1.TagihDetailID , lookupNotaPiutang1.TagihDetailRecID, lookupNotaPiutang1.KPID , lookupNotaPiutang1.KPrecID, lookupNotaPiutang1.Jenis, tglBPP, noReg , chbg, noBukti, (DateTime)tbTglInden.DateValue , (DateTime)tbTglJTempo.DateValue, "", "", dNoPerkiraan , tbRpInden.Text, tbRpNota.Text, tbRpTagih.Text); if (lookupNotaPiutang1.Jenis == "KP") { insertKPiutangDetail(db); } else { insertGtolakDetail(db); } //if (GlobalVar.Gudang != "2803") //{ // updateTagihanDetail(db); // insertTagihanSubDetail(db); //} db.CommitTransaction(); } //tutup sementara frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse(); frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller; frm.IndenRowRefresh(RowIDI); frm.IndenDetailRowRefresh(RowIDID); frm.IndenSubDetailRowRefresh(RowIDISD); frm.IndenSuperDetailRowRefresh(RowIDISSD); frm.IndenSuperDetailFindRow("RowIDISSD", RowIDISSD.ToString()); this.Close(); } catch (Exception ex) { Error.LogError(ex); } }