public static string DescStatusApproval(GlobalVar.enumStatusApproval statusApproval)
{
string result = "";
switch (statusApproval)
{
case GlobalVar.enumStatusApproval.Open: result = "Belum Pengajuan"; break;
case GlobalVar.enumStatusApproval.Waiting1: result = "Menunggu Acc #1"; break;
case GlobalVar.enumStatusApproval.Waiting2: result = "Menunggu Acc #2"; break;
case GlobalVar.enumStatusApproval.Rejected: result = "Ditolak"; break;
case GlobalVar.enumStatusApproval.Approved: result = "Disetujui"; break;
case GlobalVar.enumStatusApproval.Closed: result = "Selesai / Realisasi"; break;
default: result = ""; break;
}
return(result);
}
private int DBGetByRowID(Guid t_rowID)
{
int nresult = 0;
if ((t_rowID == null) || (t_rowID == Guid.Empty))
{
nresult = 1;
}
else
{
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_PengeluaranUang_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, t_rowID));
DataTable dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
_dr = dr;
_rowID = t_rowID;
_perusahaanDariRowID = (Guid)dr["PerusahaanDariRowID"];
_perusahaanKeRowID = (Convert.IsDBNull(dr["PerusahaanKeRowID"]) ? Guid.Empty : (Guid)dr["PerusahaanKeRowID"]);
_noBukti = dr["NoBukti"].ToString();
_tanggal = (Convert.IsDBNull(dr["Tanggal"])) ? DateTime.MinValue : (DateTime)dr["Tanggal"];
_dueDateGiro = (Convert.IsDBNull(dr["DueDateGiro"])) ? DateTime.MinValue : (DateTime)dr["DueDateGiro"];
_cabangDariID = dr["CabangDariID"].ToString();
_cabangKeID = (Convert.IsDBNull(dr["CabangkeID"]) ? "" : dr["CabangKeID"].ToString());
_cabangOriID = (Convert.IsDBNull(dr["CabangIDOri"]) ? _cabangKeID : dr["CabangIDOri"].ToString());
_gudangID = AutoJournal.GetGudangIDByPTRowID(_perusahaanDariRowID);
_uraian = (Convert.IsDBNull(dr["Uraian"]) ? "" : dr["Uraian"].ToString());
_jnsPengeluaran = dr["JnsPengeluaran"].ToString();
// _jnsTransaksiRowID = dr["JnsTransaksiRowID"];
_pengeluaranKe = Convert.IsDBNull(dr["PengeluaranKe"]) ? 0 : int.Parse(dr["PengeluaranKe"].ToString());
_noPerkiraan01 = dr["NoPerkiraan01"].ToString();
_nominal = (Convert.IsDBNull(dr["Nominal"])) ? 0 : double.Parse(dr["Nominal"].ToString());
_nominalRp = (Convert.IsDBNull(dr["NominalRp"])) ? _nominal : double.Parse(dr["NominalRp"].ToString());
if (_nominalRp == 0)
{
_nominalRp = _nominal;
}
_statusApproval = (GlobalVar.enumStatusApproval)dr.Field <byte>("StatusApproval");
_kasRowID = (Guid)Tools.isNull(dr["KasRowID"], Guid.Empty);
_rekeningRowID = (Guid)Tools.isNull(dr["RekeningRowID"], Guid.Empty);
_journalRowID = (Guid)Tools.isNull(dr["JournalRowID"], Guid.Empty);
_mataUangRowID = (Guid)Tools.isNull(dr["MataUangRowID"], Guid.Empty);
_jnsTransaksi = (Guid)Tools.isNull(dr["JnsTransaksiRowID"], Guid.Empty);
_unitusaha = dr["UnitUsaha"].ToString();
if ((_perusahaanKeRowID == Guid.Empty) || (_cabangKeID != _cabangOriID))
{
GetPerusahaanKeRowID();
}
SetNoPerkiraan01();
SetNoPerkiraan02();
if ((_perusahaanKeRowID != null) && (_perusahaanKeRowID != Guid.Empty) && (_perusahaanKeRowID != _perusahaanDariRowID))
{
SetNoPerkiraan03();
SetNoPerkiraan04();
if (!GlobalVar.IsNewDNKN && (_jnsTransaksi != GlobalVar.GetTransaksi.PLL || _jnsTransaksi != GlobalVar.GetTransaksi.HLL))
{
_journal2 = true;
}
}
else
{
_journal2 = false;
}
_state = enumState.Update;
}
else
{
nresult = 2;
}
}
}
catch (Exception ex)
{
nresult = 3;
string s = ex.Message;
}
}
if (nresult != 0)
{
Kosongkan();
}
return(nresult);
}
private void cmdYES_Click(object sender, EventArgs e)
{
if (!cekDataSTNK())
{
return;
}
try
{
if (Convert.ToDouble(txt_BBN.Text) > 0)
{
if (rdoKas.Checked == true && (Guid)cboKas.SelectedValue == Guid.Empty)
{
MessageBox.Show("Kas belum dipilih, silahkan dipilih terlebih dahulu");
return;
}
else if (rdoBank.Checked == true && lkpRekening1.RekeningRowID == Guid.Empty)
{
MessageBox.Show("Bank belum dipilih, silahkan dipilih terlebih dahulu");
return;
}
//PIN
if (Convert.ToDouble(txt_BBN.Text) > Convert.ToDouble(txt_SisaBBN.Text))
{
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
DateTime date = GlobalVar.GetServerDate;
Calendar cal = dfi.Calendar;
int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
Tools.pin(PinId.Periode.Hari, mingguKe, date, PinId.Bagian.Accounting, Convert.ToInt32(PinId.ModulId.PelunasanBBN), "Pembayaran BBN melebihi sisa BBN memerlukan PIN persetujuan bagian Keuangan.");
if (GlobalVar.pinResult == false)
{
return;
}
}
else if (Convert.ToDouble(txt_SisaBBN.Text) - Convert.ToDouble(txt_BBN.Text) > 0)
{
DialogResult dialogResult = MessageBox.Show("Pelunasan BBN hanya dapat dilakukan sekali \nTerdapat sisa BBN sebesar " + (Convert.ToDouble(txt_SisaBBN.Text) - Convert.ToDouble(txt_BBN.Text)).ToString() +
", Anda yakin ingin melanjutkan transaksi ?", "Save Pelunasan BBN", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.No)
{
return;
}
}
Guid _bankRowID = Guid.Empty;
Guid _rekeningRowID = Guid.Empty;
switch (_bentukPengeluaran)
{
case "K": _rekeningRowID = (Guid)cboKas.SelectedValue; break;
case "B":
{
_rekeningRowID = (Guid)lkpRekening1.RekeningRowID;
_bankRowID = (Guid)lkpRekening1.BankRowID;
break;
}
default:
_rekeningRowID = (Guid)Guid.Empty;
_statusApproval = GlobalVar.enumStatusApproval.Approved;
break;
}
DataTable dt1 = new DataTable();
Guid RowIDPU = Guid.NewGuid();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_PengeluaranUang_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowIDPU));
db.Commands[0].Parameters.Add(new Parameter("@TanggalRk", SqlDbType.Date, GlobalVar.GetServerDate.Date));
db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.Date, GlobalVar.GetServerDate.Date));
db.Commands[0].Parameters.Add(new Parameter("@NoAcc", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@NoApproval", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@PerusahaanDariRowID", SqlDbType.UniqueIdentifier, new Guid("F0BFEC6B-E92C-44A3-9EEB-F41960503F15")));
db.Commands[0].Parameters.Add(new Parameter("@CabangDariID", SqlDbType.VarChar, GlobalVar.CabangID));
db.Commands[0].Parameters.Add(new Parameter("@PerusahaanKeRowID", SqlDbType.UniqueIdentifier, new Guid("F0BFEC6B-E92C-44A3-9EEB-F41960503F15")));
db.Commands[0].Parameters.Add(new Parameter("@MataUangRowID", SqlDbType.UniqueIdentifier, new Guid("BC17A644-5DBD-4955-A803-378F8C0A915C")));
db.Commands[0].Parameters.Add(new Parameter("@JnsTransaksiRowID", SqlDbType.UniqueIdentifier, new Guid("CE9075B2-1206-4D8E-9F22-0D12C6DE9939")));
db.Commands[0].Parameters.Add(new Parameter("@Nominal", SqlDbType.Money, double.Parse(txt_BBN.Text)));
db.Commands[0].Parameters.Add(new Parameter("@NominalRp", SqlDbType.Money, double.Parse(txt_BBN.Text)));
db.Commands[0].Parameters.Add(new Parameter("@Uraian", SqlDbType.VarChar, "Pembayaran BBN - " + txt_NoBukti.Text));
db.Commands[0].Parameters.Add(new Parameter("@JnsPengeluaran", SqlDbType.VarChar, _bentukPengeluaran));
db.Commands[0].Parameters.Add(new Parameter("@JnsPenerimaan", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@StatusApproval", SqlDbType.TinyInt, (_needApprove) ? 0 : 9));
db.Commands[0].Parameters.Add(new Parameter("@KasRowID", SqlDbType.UniqueIdentifier, (_bentukPengeluaran == "K") ? _rekeningRowID : Guid.Empty));
db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.UniqueIdentifier, _bankRowID));
db.Commands[0].Parameters.Add(new Parameter("@RekeningRowID", SqlDbType.UniqueIdentifier, (_bentukPengeluaran == "K") ? Guid.Empty : _rekeningRowID));
db.Commands[0].Parameters.Add(new Parameter("@KeKasRowID", SqlDbType.UniqueIdentifier, Guid.Empty));
db.Commands[0].Parameters.Add(new Parameter("@KeRekeningRowID", SqlDbType.UniqueIdentifier, Guid.Empty));
//db.Commands[0].Parameters.Add(new Parameter("@DueDateGiro", SqlDbType.Date, default));
db.Commands[0].Parameters.Add(new Parameter("@NoCekGiro", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@PengeluaranKe", SqlDbType.Int, 2));
db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, PenjualanRowID));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].Parameters.Add(new Parameter("@IsPembayaran", SqlDbType.Bit, 0));
dt1 = db.Commands[0].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
try
{
if (dt1.Rows[0]["Result"].ToString() != "0")
{
MessageBox.Show("Error (" + dt1.Rows[0]["Result"].ToString() + ") : \n" +
dt1.Rows[0]["Message"].ToString() + "\n");
return;
}
}
catch { /*string s = "Unknown Error";*/ }
}
}
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_MasterSTNK_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@PembelianRowID", SqlDbType.UniqueIdentifier, PembelianRowID));
db.Commands[0].Parameters.Add(new Parameter("@PenjualanRowID", SqlDbType.UniqueIdentifier, PenjualanRowID));
db.Commands[0].Parameters.Add(new Parameter("@CustomerRowID", SqlDbType.UniqueIdentifier, CustomerRowID));
db.Commands[0].Parameters.Add(new Parameter("@TglLunasBBN", SqlDbType.DateTime, GlobalVar.GetServerDate.Date));
db.Commands[0].Parameters.Add(new Parameter("@NoSTNK", SqlDbType.VarChar, txt_NoSTNK.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoRegistrasi", SqlDbType.VarChar, txt_NoReg.Text));
db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txt_NamaSTNK.Text));
db.Commands[0].Parameters.Add(new Parameter("@Alamat", SqlDbType.VarChar, txt_AlamatSTNK.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoRangka", SqlDbType.VarChar, txt_NoRangka.Text));
db.Commands[0].Parameters.Add(new Parameter("@NoMesin", SqlDbType.VarChar, txt_NoMesin.Text));
db.Commands[0].Parameters.Add(new Parameter("@Warna", SqlDbType.VarChar, txt_Warna.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
MessageBox.Show(Messages.Confirm.SaveSuccess);
if (this.Caller is frmIdenBBNBrowse)
{
frmIdenBBNBrowse frmCaller = (frmIdenBBNBrowse)this.Caller;
frmCaller.RefreshHeader(PenjualanRowID);
frmCaller.RefreshDetail(RowIDPU);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
