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 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 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 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; } } }