private void InsertDataHeader() { frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; if (Modus == enumModus.New) { _HeaderID = Guid.NewGuid(); _RecID = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); } DateTime TglBukti = Convert.ToDateTime(dateDKN.DateValue); string Cabang = txtGudang.Text; string DK = ""; if (optDebet.Checked) { DK = "D"; } else { DK = "K"; } using (Database db = new Database(GlobalVar.DBName)) { //if (Modus == enumModus.Update) RowIDDKN = _HeaderID; DKN.DKNInsert(db, _HeaderID, _RecID, DK, "MAN", "B", "DKN", TglBukti, Cabang, "", _HeaderID); } frmCaller.RefreshDkn(); }
private void cmdSAVE_Click(object sender, EventArgs e) { _BankTujuanRowID = lookupBankTujuan.RowID; _BankIDtujuan = lookupBankTujuan.BankID; string _KodeToko = lookupToko1.KodeToko; string lokasi = lookupBankAsal1.Lokasi; string bankID = lookupBankTujuan.BankID; try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBName)) { DataTable dtBK = new DataTable(); db.Commands.Add(db.CreateCommand("usp_BankKota_LIST")); db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, lookupBankAsal1.NamaBank)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, lookupBankAsal1.Lokasi)); dtBK = db.Commands[0].ExecuteDataTable(); if (dtBK.Rows.Count > 0) { _BankKotaRowID = new Guid(dtBK.Rows[0]["RowID"].ToString()); } } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller; if (Brow == enumBrow.Header) { Guid RowID = Guid.NewGuid(); string RecordID = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); DateTime TglBukti = Convert.ToDateTime(dateDKN.DateValue); string Cabang = cboCabang.SelectedValue.ToString(); string DK = ""; if (optDebet.Checked) { DK = "D"; } else { DK = "K"; } using (Database db = new Database(GlobalVar.DBName)) { if (Modus == enumModus.Update) { RowID = _HeaderID; } DKN.DKNInsert(db, RowID, RecordID, DK, "MAN", "B", "DKN", TglBukti, Cabang, "", RowID); } frmCaller.RefreshDkn(); } else { if (_IsiPin == "") { string NoPerkiraan = txtPerkiraan.NoPerkiraan; string Uraian = txtUraian.Text; string HRecordID = frmCaller.gridUtm.SelectedCells[0].OwningRow.Cells["RecordID"].Value.ToString(); string refRecordID = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1); Guid refRowID = Guid.NewGuid(); Double Jumlah = Convert.ToDouble(numJumlah.Text); string KodeKolektor = txtCollectorID.Text; string Kolektor = txtCollector.Text; Guid rowIDdetail; if (Modus == enumModus.New) { rowIDdetail = Guid.NewGuid(); } else { rowIDdetail = _DetailID; } using (Database db = new Database(GlobalVar.DBName)) { if (Modus == enumModus.Update) { refRowID = _DetailID; } DKN.DKNDetailInsert(db, rowIDdetail, _HeaderID, HRecordID, NoPerkiraan, Uraian, Jumlah, refRowID, refRecordID, KodeKolektor, bankID, _BankTujuanRowID, _BankKotaRowID, _KodeToko); } frmCaller.RefreshDknDetail(); } else { UpdateDKN(); } } this.Close(); }