private void cmdPrint_Click(object sender, EventArgs e)
{
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.cetakLaporan();
}
private void btnAttachment_Click(object sender, EventArgs e)
{
OpenFileDialog OFD = new OpenFileDialog();
try
{
OFD.Filter = "File Gambar (*.JPEG, *.jpg, *.bmp, *.gif, *.png)|*.JPEG; *.jpg; *.bmp; *.gif; *.png";
if (OFD.ShowDialog() == DialogResult.OK)
{
string strFilename = OFD.SafeFileName;
string strPathName = OFD.FileName;
System.IO.FileInfo fileSize = new System.IO.FileInfo(strPathName);
if (fileSize.Length > 1048576)
{
MessageBox.Show("Ukuran file terlalu besar. Maksimal 1 MB");
}
else
{
imgBase64 = Base64FromImage(strPathName);
string strUser = SecurityManager.UserID;
if (formMode == enumFormMode.Update)
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Bukti_AttachmentBKK"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@AttachmentBKK", SqlDbType.VarChar, imgBase64));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, strUser));
db.Commands[0].ExecuteNonQuery();
}
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
}
lblFile.Text = "*" + strFilename;
Image img = Base64ToImage(imgBase64);
picPreview.Image = img;
lblImage.Visible = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "ERROR ATTACHMENT FILE", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmdDelete_Click(object sender, EventArgs e)
{
if (dgDetailBKK.SelectedCells.Count > 0 && MessageBox.Show("Data akan dihapus?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
_rowIDDetail = (Guid)dgDetailBKK.SelectedCells[0].OwningRow.Cells["rowID"].Value;
try
{
using (Database db = new Database(GlobalVar.DBName))
{
if (_isFromPiutang == false)
{
BKK.DeleteBuktiDetail(db, _rowIDDetail);
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowDetail("RowIDD", _rowIDDetail.ToString());
frm.DetailDeleteRefresh();
}
else
{
db.BeginTransaction();
BKK.DeleteBuktiDetail(db, _rowIDDetail);
BKK.UpdateUraianPinjaman(db, _rowID);
db.CommitTransaction();
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(_Nip);
frmUtang.FindRowPegawsai("NIP", _Nip);
//frmUtang.RefreshPiutang(_rowID);
frmUtang.FindRowPiutang("RowID", _rowID.ToString());
}
}
#region "Tambahan"
int i = 0;
int n = 0;
i = dgDetailBKK.SelectedCells[0].RowIndex;
n = dgDetailBKK.SelectedCells[0].ColumnIndex;
DataRowView dv = (DataRowView)dgDetailBKK.SelectedCells[0].OwningRow.DataBoundItem;
DataRow dr = dv.Row;
dr.Delete();
dtBKKDetail.AcceptChanges();
dgDetailBKK.Focus();
dgDetailBKK.RefreshEdit();
if (dgDetailBKK.RowCount > 0)
{
if (i == 0)
{
dgDetailBKK.CurrentCell = dgDetailBKK.Rows[0].Cells[n];
dgDetailBKK.RefreshEdit();
}
else
{
dgDetailBKK.CurrentCell = dgDetailBKK.Rows[i - 1].Cells[n];
dgDetailBKK.RefreshEdit();
}
}
#endregion
//Korban editan
// DetailRefresh();
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
refreshTerbilang();
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (tbUraian.NoPerkiraan == "" || tbUraian.NoPerkiraan == "?")
{
MessageBox.Show("No Perkiraan masih kosong.");
return;
}
totalPiutang = tbJumlah.GetDoubleValue + tbTotal.GetDoubleValue;
if ((tbUraian.NoPerkiraan != "") && (tbUraian.NoPerkiraan != "?") && (tbJumlah.Text != ""))
{
try
{
if (detailMode == enumDetailMode.New)
{
_recordIDDetail = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_rowIDDetail = Guid.NewGuid();
using (Database db = new Database(GlobalVar.DBName))
{
if (_isFromPiutang == false)
{
//BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan.Trim().Equals("")? "?":tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan.Trim().Equals("") ? "?" : tbUraian.NoPerkiraan, txtUraian.Text, tbJumlah.Text);
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.DetailRowRefresh(_rowIDDetail);
frm.FindRowDetail("RowIDD", _rowIDDetail.ToString());
}
else
{
db.BeginTransaction();
//BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
BKK.AddDetail(db, _rowIDDetail, _rowID, _recordIDDetail, _recordID, "", "", "", tbAcc.Text, tbUraian.NoPerkiraan, txtUraian.Text, tbJumlah.Text);
//BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, tbUraian.NamaPerkiraan, string.Empty, _jp);
BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, txtUraian.Text, _keteranganlain, _jp);
db.CommitTransaction();
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(_Nip);
frmUtang.FindRowPegawsai("NIP", _Nip);
//frmUtang.RefreshPiutang(_rowID);
frmUtang.RefreshPiutang();
frmUtang.FindRowPiutang("RowID", _rowID.ToString());
}
tbUraian.NamaPerkiraan = "";
tbUraian.NoPerkiraan = "?";
tbJumlah.Text = "0";
tbAcc.Text = "";
DetailRowRefresh(_rowIDDetail);
FindRowDetail("rowID", _rowIDDetail.ToString());
refreshTerbilang();
gbBKKUpdate.Enabled = true;
gbUpdateDetailBKK.Visible = false;
dgDetailBKK.Focus();
}
}
else if (detailMode == enumDetailMode.Update)
{
using (Database db = new Database(GlobalVar.DBName))
{
if (_isFromPiutang == false)
{
BKK.UpdateBuktiDetail(db, _rowIDDetail, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.DetailRowRefresh(_rowIDDetail);
}
else
{
db.BeginTransaction();
BKK.UpdateBuktiDetail(db, _rowIDDetail, tbUraian.NoPerkiraan, tbUraian.NamaPerkiraan, tbJumlah.Text);
BKK.UpdatePinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, tbUraian.NamaPerkiraan, string.Empty, _jp);
db.CommitTransaction();
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(_Nip);
frmUtang.FindRowPegawsai("NIP", _Nip);
frmUtang.RefreshPiutang(_rowID);
frmUtang.FindRowPiutang("RowID", _rowID.ToString());
}
tbUraian.NamaPerkiraan = "";
tbUraian.NoPerkiraan = "?";
tbJumlah.Text = "0";
DetailRowRefresh(_rowIDDetail);
refreshTerbilang();
gbBKKUpdate.Enabled = true;
gbUpdateDetailBKK.Visible = false;
}
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void tbKepada_Leave(object sender, EventArgs e)
{
string src = "";
if ((tbKepada.Text != "") && (tbKepada.Text != _Kepada))
{
_Tanggal = (DateTime)tbTanggal.DateValue;
if (PeriodeClosing.IsKasirClosed(_Tanggal))
{
MessageBox.Show("Sudah Closing! Tidak Bisa Tambah Data.");
return;
}
if (imgBase64 != null)
{
if (MessageBox.Show("Data Akan Disimpan?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (formMode == enumFormMode.New)
{
////tambahan
if (_isFromPiutang)
{
if (_jp == "2" || _jp == "5")
{
try
{
DataTable dtc = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_PinjamanPegawai_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _kpid));
db.Commands[0].Parameters.Add(new Parameter("@Nip", SqlDbType.VarChar, _Nip));
dtc = db.Commands[0].ExecuteDataTable();
}
if (dtc.Rows.Count > 0)
{
MessageBox.Show("Data sudah dinput.");
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
_keteranganlain = "";
}
}
else
{
_keteranganlain = "";
}
if (_isFromPiutang != true)
{
src = "OUT";
}
else
{
src = "PIK";
}
//_recordID = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
string _rcid = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial);
_recordID = BKK.GetRecordIDBukti(_rcid, src);
if (_isFromPiutang)
{
if (_recordID.Length > 0 && !string.IsNullOrEmpty(_Nip))
{
_recIDPiutangKaryawan = _recordID.Replace(_recordID.Substring(22, 1), _jp);
}
}
if (_isFromPiutang)
{
if (_jp == "2" || _jp == "5")
{
_rowID = _kpid;
}
else
{
_rowID = Guid.NewGuid();
}
}
else
{
_rowID = Guid.NewGuid();
}
//_rowID = Guid.NewGuid();
_noBukti = Numerator.BookNumerator("BKK");
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.BeginTransaction();
BKK.AddHeader(db, _rowID, _rowID, _recordID, _noBukti, "", src, _Tanggal, tbKepada.Text, "", "", SecurityManager.UserName, " ", imgBase64);
if (_isFromPiutang == true)
{
BKK.AddPinjamanPegawai(db, _rowID, _recIDPiutangKaryawan, _Nip, _Tanggal, "BKK", _noBukti, "", _keteranganlain, totalPiutang, 0, _jp);
}
//BKK.AddPinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, "", _keteranganlain, totalPiutang, 0, _jp);
//BKK.AddPinjamanPegawai(db, _rowID, _recordID, _Nip, _Tanggal, "BKK", _noBukti, "", string.Empty, totalPiutang, 0, _jp);
db.CommitTransaction();
}
tbNoBKK.Text = _noBukti;
_Kepada = tbKepada.Text;
cmdAdd.Enabled = true;
cmdEdit.Enabled = true;
cmdDelete.Enabled = true;
cmdPrint.Enabled = true;
dgDetailBKK.Enabled = true;
if (_isFromPiutang != true)
{
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
frm.FindRowHeader("RowID", _rowID.ToString());
}
else
{
Kasir.frmPiutangKaryawan frmUtang = new Kasir.frmPiutangKaryawan();
frmUtang = (frmPiutangKaryawan)this.Caller;
frmUtang.RefreshPegawai(_Nip);
frmUtang.FindRowPegawsai("NIP", _Nip);
frmUtang.RefreshPiutang(_rowID);
frmUtang.FindRowPiutang("RowID", _rowID.ToString());
}
dtBKKDetail = new DataTable();
dgDetailBKK.DataSource = dtBKKDetail.DefaultView;
dgDetailBKK.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else if (formMode == enumFormMode.Update)
{
try
{
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_Bukti_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@Kepada", SqlDbType.VarChar, tbKepada.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
frmBKKBrowse frm = new frmBKKBrowse();
frm = (frmBKKBrowse)this.Caller;
frm.HeaderRowRefresh(_rowID);
dgDetailBKK.Focus();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
}
else
{
MessageBox.Show("Attachment belum ditambahkan !!");
return;
}
}
}
