private void cmdSave_Click(object sender, EventArgs e)
{
if (tbTglJT.Text == "")
{
MessageBox.Show("Tanggal J.Tempo Tidak Boleh Kosong");
tbTglJT.Focus();
return;
}
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_IndenDetail_UPDATE_TglJT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, IndenDetailID));
db.Commands[0].Parameters.Add(new Parameter("@TglJT", SqlDbType.DateTime, (DateTime)tbTglJT.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
MessageBox.Show("Update Tanggal J.Tempo Berhasil");
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenDetailRowRefresh(IndenDetailID);
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
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)
{
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 (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);
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
Guid RowID;
try
{
string kodeToko = lookupToko.KodeToko;
/*kendala, toko pt transfernya ke rekening non pt*/
//if (GlobalVar.Gudang == "2803")
//{
// CekBankPT();
// CekTokoPT(kodeToko);
// if (cTokoPT == "PT" && cBankPT != "PT")
// {
// MessageBox.Show("Toko PT harus menggunakan Rekening Bank PT");
// return;
// }
// else if (cTokoPT != "PT" && cBankPT == "PT")
// {
// MessageBox.Show("Toko Non PT harus menggunakan Rekenig Bank Non PT");
// return;
// }
//}
if (cbNonPiut.Checked == true)
{
if (tbNamaToko.Text == "")
{
MessageBox.Show("Nama Toko Belum Diisi");
tbNamaToko.Focus();
return;
}
if (tbTeidentifikasi.GetDoubleValue > teridentifikasi)
{
MessageBox.Show("Nominal tidak boleh lebih dari " + teridentifikasi.ToString("#,###"));
tbTeidentifikasi.Focus();
return;
}
if (tbTeidentifikasi.GetDoubleValue == 0)
{
MessageBox.Show("Nominal tidak boleh 0");
tbTeidentifikasi.Focus();
return;
}
if (tbTglKasir.Text == "")
{
MessageBox.Show("Tanggal Kasir Belum Diisi");
tbTglKasir.Focus();
return;
}
//ga pengaruh periode closing,, harus >=tglkasir
DateTime tglKasir = (DateTime)tbTglKasir.DateValue;
if (GlobalVar.Gudang != "2808")
{
if (PeriodeClosing.IsPJTClosed(tglKasir))
{
MessageBox.Show("Sudah Closing!");
return;
}
}
if (tglKasir < tglKasirInden)
{
MessageBox.Show("Tanggal Identifikasi Tidak Boleh Lebih Kecil Dari Tanggal Kasir.");
return;
}
string namaToko = tbNamaToko.Text;
DateTime tglBPP = (DateTime)tbTglBPP.DateValue;
string nominal = tbTeidentifikasi.Text;
RowID = Guid.NewGuid();
Guid RowIDSup = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
string RecordIDSup = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
addIndenSubDetail(db, RowID, RowIDID, RowIDI, RecordID, RecordIDID, "", namaToko, "", "", tglBPP, tglKasir, nominal);
addIndenSuperDetail(db, RowIDSup, RowID, RowIDI, RowIDID, RecordIDSup, RecordID, Guid.Empty, "", Guid.Empty, "", "NP", tglBPP, "", chbg, "", tglKasir, (DateTime)SqlDateTime.Null, "", "", "", nominal, "0", "0");
db.CommitTransaction();
}
}
else
{
if (lookupToko.KodeToko == "[CODE]")
{
MessageBox.Show("Nama Toko Belum Diisi");
lookupToko.Focus();
return;
}
if (_KodeTokoDO != "" && kodeToko != _KodeTokoDO)
{
MessageBox.Show("Tidak bisa identifikasi Toko. Penerimaan uang harus diidentifikasi ke toko " + _NamaTokoDO + " sesuai SO inden no. " + _NoDO + " tgl " + _TglDO.ToString("dd/MM/yyyy") + ". Hubungi manager anda");
lookupToko.Focus();
return;
}
if (tbTeidentifikasi.GetDoubleValue > teridentifikasi)
{
MessageBox.Show("Nominal tidak boleh lebih dari " + teridentifikasi.ToString("#,###"));
tbTeidentifikasi.Focus();
return;
}
if (tbTglBPP.Text == "")
{
MessageBox.Show("Tanggal BPP Belum Diisi");
tbTglBPP.Focus();
return;
}
if (tbTglKasir.Text == "")
{
MessageBox.Show("Tanggal Kasir Belum Diisi");
tbTglKasir.Focus();
return;
}
//if (tbNoBPP.Text == "")
//{
// MessageBox.Show("No BPP Belum Diisi");
// tbNoBPP.Focus();
// return;
//}
//tutup sementara ujicoba_______________________________________
//if (GlobalVar.Gudang != "2803")
//{
// if (tbNoRegister.Text == "")
// {
// MessageBox.Show("No Reg Belum Diisi");
// tbNoRegister.Focus();
// return;
// }
//}
//ga pengaruh periode closing,, harus >=tglkasir
DateTime tglKasir = (DateTime)tbTglKasir.DateValue;
if (GlobalVar.Gudang != "2808")
{
if (PeriodeClosing.IsPJTClosed(tglKasir))
{
MessageBox.Show("Sudah Closing!");
return;
}
}
if (tglKasir < tglKasirInden)
{
MessageBox.Show("Tanggal Identifikasi Tidak Boleh Lebih Kecil Dari Tanggal Kasir.");
return;
}
string namaToko = lookupToko.NamaToko;
string codeToko = lookupToko.KodeToko;
string noReg = tbNoRegister.Text;
string noBPP = tbNoBPP.Text;
DateTime tglBPP = (DateTime)tbTglBPP.DateValue;
string nominal = tbTeidentifikasi.Text;
RowID = Guid.NewGuid();
string RecordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
addIndenSubDetail(db, RowID, RowIDID, RowIDI, RecordID, RecordIDID, kodeToko, namaToko, noReg, noBPP, tglBPP, tglKasir, nominal);
db.Commands.Clear();
db.Commands.Add(db.CreateCommand("usp_Giro_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@GiroID", SqlDbType.UniqueIdentifier, RowIDID));
db.Commands[0].Parameters.Add(new Parameter("@KodeToko", SqlDbType.VarChar, codeToko));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
db.CommitTransaction();
}
}
frmPenerimaanBelumTeridentifikasiBrowse frm = new frmPenerimaanBelumTeridentifikasiBrowse();
frm = (frmPenerimaanBelumTeridentifikasiBrowse)Caller;
frm.IndenRowRefresh(RowIDI);
frm.IndenDetailRowRefresh(RowIDID);
frm.IndenSubDetailRowRefresh(RowID);
frm.IndenSubDetailFindRow("RowIDISD", 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);
}
}