private void InsertDataDetail()
{
frmDebetKreditNotaBrowse frmCaller = (frmDebetKreditNotaBrowse)this.Caller;
if (_IsiPin == "")
{
string NoPerkiraan = txtPerkiraan.NoPerkiraan;
string Uraian = txtUraian.Text;
Double Jumlah = Convert.ToDouble(numJumlah.Text);
string KodeKolektor = txtCollectorID.Text;
string Kolektor = txtCollector.Text;
if (Modus == enumModus.New)
{
_DetailID = Guid.NewGuid();
_RecIDDetail = Tools.CreateShortFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial, 1);
}
using (Database db = new Database(GlobalVar.DBName))
{
DKN.DKNDetailInsert(db, _DetailID, _HeaderID, _RecID, NoPerkiraan, Uraian, Jumlah, _DetailID, _RecIDDetail, KodeKolektor, _BankIDtujuan, _BankTujuanRowID, _BankKotaRowID, _KodeToko);
}
frmCaller.RefreshDknDetail();
}
}
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();
}
