private void cmdSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtdate.Text)) { KotakPesan.Warning("Anda belum mengisi Tanggal", "Cek Tanggal"); txtdate.Focus(); return; } if (txtdate.DateValue < GlobalVar.DateOfServer) { KotakPesan.Warning("Tanggal tidak boleh kurang dari datetime server", "Cek Tanggal"); txtdate.Focus(); return; } if (txtHargaJual.GetDoubleValue <= 0) { KotakPesan.Warning("Harga Jual Harus Lebih besar dari 0", "Cek Harga Jual"); txtHargaJual.Focus(); return; } try { // using (Database db = new Database(GlobalVar.DBFinance)) using (Database db = new Database()) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_JasaHarga_Insert")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@JasaRowID", SqlDbType.UniqueIdentifier, JasaRowID)); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, txtdate.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@HargaJual", SqlDbType.Money, txtHargaJual.GetDoubleValue)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtKeterangan.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dt.Rows.Count > 0) { KotakPesan.Warning(string.Format("Jasa Harga Tanggal {0:dd-MM-yyyy} sudah ada. Mohon gunakan Tombol Edit jika ingin merubah.", txtdate.DateValue), "Cek Tanggal"); txtdate.Focus(); return; } } this.DialogResult = DialogResult.OK; frmJasaBrowse frmcaller = (frmJasaBrowse)this.Caller; frmcaller.RefreshData(); this.Close(); frmcaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }
private void cmdDelete_Click(object sender, EventArgs e) { if (_selectedGrid == enumSelectedGrid.Detail) { try { Guid RowID_ = (Guid)dataGridDetail.SelectedCells[0].OwningRow.Cells["RowIDDetail"].Value; String Kdtp = dataGridDetail.SelectedCells[0].OwningRow.Cells["KodeTransaksi"].Value.ToString(); DateTime TglTansact = Convert.ToDateTime(dataGridDetail.SelectedCells[0].OwningRow.Cells["TglTransaksiDetail"].Value); if (TglTansact != GlobalVar.DateOfServer) { KotakPesan.Warning("Date time server >< Tgl. Transaksi"); return; } if (Kdtp == "ADJ" || Kdtp == "RET") { if (!SecurityManager.AskPasswordManager()) { return; } } else { KotakPesan.Warning("Kode Transaksi Piutang selain ADJ & RET Tidak Bisa Di Hapus"); return; } this.Cursor = Cursors.WaitCursor; DataTable dtSales = new DataTable(); using (Database db = new Database(GlobalVar.DBFinance)) { db.Commands.Add(db.CreateCommand("[usp_KartuPiutangDetail_DELETE]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID_)); db.Commands[0].ExecuteNonQuery(); } RefreshKPiutangDetail(dataGridHeader.SelectedCells[0].OwningRow.Cells["KPID"].Value.ToString(), (Guid)dataGridHeader.SelectedCells[0].OwningRow.Cells["RowID"].Value); MessageBox.Show("Record Berhasil Terhapus", "Notifikacation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } }
private void cmdEdit_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count > 0) { if (Grid == GridSelected.Header) { Guid rowid = new Guid(dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value.ToString()); Master.frmJasaUpdate ifrmChild = new Master.frmJasaUpdate(this, rowid); ifrmChild.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild); ifrmChild.Show(); } else { if (DataGridView2.SelectedCells.Count > 0) { if ((DateTime)DataGridView2.SelectedCells[0].OwningRow.Cells["DTanggal"].Value != GlobalVar.DateOfServer) { KotakPesan.Warning("Tanggal Jasa Harga Tidak sama dengan Tanggal Server. Tidak bisa edit data lampau. Silahkan buat Jasa Harga yang baru saja.", "Cek Harga"); return; } Guid rowid = new Guid(DataGridView2.SelectedCells[0].OwningRow.Cells["DRowID"].Value.ToString()); Guid Headerrowid = new Guid(dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value.ToString()); Master.frmJasaHargaUpdate ifrmChild = new Master.frmJasaHargaUpdate(this, Headerrowid, rowid); ifrmChild.MdiParent = Program.MainForm; Program.MainForm.RegisterChild(ifrmChild); ifrmChild.Show(); } else { MessageBox.Show(Messages.Error.RowNotSelected); } } } else { MessageBox.Show(Messages.Error.RowNotSelected); } }
private void cmdDelete_Click(object sender, EventArgs e) { if (selectedGrid == enumSelectedGrid.HeaderSelected) { if (gridUtm.SelectedCells.Count > 0) { DateTime _Tanggal = (DateTime)gridUtm.SelectedCells[0].OwningRow.Cells["TglBBM"].Value; if (_Tanggal.Date != GlobalVar.DateOfServer.Date) { KotakPesan.Warning("Tanggal server tidak sama dengan tanggal transaksi. \n Tidak bisa hapus transaksi"); return; } if (gridDetail.Rows.Count > 0) { KotakPesan.Warning("Sudah ada record di detail, tidak bisa hapus record. \n Silahkan hapus record detail terlebih dahulu."); return; } else if (!SecurityManager.AskPasswordManager()) { return; } if (PeriodeClosing.IsKasirClosed(_Tanggal)) { MessageBox.Show("Sudah Closing!"); return; } Guid headerID = (Guid)gridUtm.SelectedCells[0].OwningRow.Cells["RowID"].Value; if (MessageBox.Show(Messages.Question.AskDelete, "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (Database db = new Database(GlobalVar.DBFinance)) { db.Commands.Clear(); db.Commands.Add(db.CreateCommand("usp_TransferBank_DELETE")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, headerID)); db.BeginTransaction(); db.Commands[0].ExecuteNonQuery(); db.CommitTransaction(); } //gridDetail.Rows.Remove(gridDetail.SelectedCells[0].OwningRow); //RefreshRowBuktiTransfer(headerID); // ini buat apa ? #region "Tambahan" int i = 0; int n = 0; i = gridUtm.SelectedCells[0].RowIndex; n = gridUtm.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)gridUtm.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtHeader.AcceptChanges(); gridUtm.Focus(); gridUtm.RefreshEdit(); if (gridUtm.RowCount > 0) { if (i == 0) { gridUtm.CurrentCell = gridUtm.Rows[0].Cells[n]; gridUtm.RefreshEdit(); } else { gridUtm.CurrentCell = gridUtm.Rows[i - 1].Cells[n]; gridUtm.RefreshEdit(); } } #endregion } } } else { if (gridDetail.SelectedCells.Count > 0) { DateTime _Tanggal = (DateTime)gridUtm.SelectedCells[0].OwningRow.Cells["TglBBM"].Value; if (_Tanggal.Date != GlobalVar.DateOfServer.Date) { KotakPesan.Warning("Tanggal server tidak sama dengan tanggal transaksi. Tidak bisa hapus transaksi"); return; } else if (!SecurityManager.AskPasswordManager()) { return; } if (PeriodeClosing.IsKasirClosed(_Tanggal)) { MessageBox.Show("Sudah Closing!"); return; } Guid headerID = (Guid)gridUtm.SelectedCells[0].OwningRow.Cells["RowID"].Value; Guid rowID = (Guid)gridDetail.SelectedCells[0].OwningRow.Cells["RowIDDetail"].Value; Guid rowIDBank = (Guid)gridDetail.SelectedCells[0].OwningRow.Cells["RowIDBank"].Value; if (MessageBox.Show(Messages.Question.AskDelete, "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (Database db = new Database(GlobalVar.DBFinance)) { db.BeginTransaction(); Class.TransferBank.DeleteDetail(db, rowID); db.Commands.Clear(); db.Commands.Add(db.CreateCommand("usp_BankDetail_DELETE")); db.Commands[0].Parameters.Add(new Parameter("@rowIDDetail", SqlDbType.UniqueIdentifier, rowID)); db.Commands[0].Parameters.Add(new Parameter("@headerIDBank1", SqlDbType.UniqueIdentifier, rowIDBank)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy2", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); db.CommitTransaction(); } //gridDetail.Rows.Remove(gridDetail.SelectedCells[0].OwningRow); RefreshRowBuktiTransfer(headerID); #region "Tambahan" int i = 0; int n = 0; i = gridDetail.SelectedCells[0].RowIndex; n = gridDetail.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)gridDetail.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtDetail.AcceptChanges(); gridDetail.Focus(); gridDetail.RefreshEdit(); if (gridDetail.RowCount > 0) { if (i == 0) { gridDetail.CurrentCell = gridDetail.Rows[0].Cells[n]; gridDetail.RefreshEdit(); } else { gridDetail.CurrentCell = gridDetail.Rows[i - 1].Cells[n]; gridDetail.RefreshEdit(); } } #endregion } } else { MessageBox.Show("Belum Ada Data", string.Empty, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void cmdDelete_Click(object sender, EventArgs e) { if (dgHeaderBKK.SelectedCells[0].OwningRow.Cells["Src"].Value.ToString() != "OUT") { return; } DateTime _Tanggal = (DateTime)dgHeaderBKK.SelectedCells[0].OwningRow.Cells["tglBukti"].Value; if (_Tanggal.Date != GlobalVar.DateOfServer.Date) { KotakPesan.Warning("Tanggal Bukti transaksi Tidak sama dengan Tanggal server. Tidak bisa hapus record."); return; } if (PeriodeClosing.IsKasirClosed(_Tanggal)) { MessageBox.Show("Sudah Closing!"); return; } if (dgDetailBKK.SelectedCells.Count > 0) { MessageBox.Show("Anda tidak diperkenankan menghapus data ini"); return; } string ques = "No Bukti : " + dgHeaderBKK.SelectedCells[0].OwningRow.Cells["noBukti"].Value.ToString() + " Akan Dihapus?"; if ((dgHeaderBKK.SelectedCells.Count > 0) && (MessageBox.Show(ques, "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)) { Guid _rowID = (Guid)dgHeaderBKK.SelectedCells[0].OwningRow.Cells["RowID"].Value; try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database(GlobalVar.DBFinance)) { db.Commands.Add(db.CreateCommand("usp_Bukti_DELETE")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].ExecuteNonQuery(); } #region "Tambahan" int i = 0; int n = 0; i = dgHeaderBKK.SelectedCells[0].RowIndex; n = dgHeaderBKK.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)dgHeaderBKK.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtBKK.AcceptChanges(); dgHeaderBKK.Focus(); dgHeaderBKK.RefreshEdit(); if (dgHeaderBKK.RowCount > 0) { if (i == 0) { dgHeaderBKK.CurrentCell = dgHeaderBKK.Rows[0].Cells[n]; dgHeaderBKK.RefreshEdit(); } else { dgHeaderBKK.CurrentCell = dgHeaderBKK.Rows[i - 1].Cells[n]; dgHeaderBKK.RefreshEdit(); } } #endregion //di remark //HeaderRefresh(); //DetailRefresh(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } }
private void cmdDelete_Click(object sender, EventArgs e) { if (selectMode == enumSelectMode.Header) { if (gridHeader.SelectedCells.Count > 0) { DateTime _Tanggal = (DateTime)gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value; if (_Tanggal.Date != GlobalVar.DateOfServer.Date) { KotakPesan.Warning("Tanggal server tidak sama dengan tanggal transaksi. \n Tidak bisa hapus transaksi"); return; } if (PeriodeClosing.IsKasirClosed(_Tanggal)) { MessageBox.Show("Sudah Closing!"); return; } Guid rowID = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value; if ((int)dtDetail.Compute("count(Nomor)", "") > 0) { KotakPesan.Warning("Sudah ada record di detail, tidak bisa hapus record. \n Silahkan hapus record detail terlebih dahulu."); return; } if (MessageBox.Show("Data Ini Akan Dihapus?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (!SecurityManager.AskPasswordManager()) { return; } else { try { using (Database db = new Database(GlobalVar.DBFinance)) { VoucherJournal.DeleteVoucherJournal(db, rowID); } #region "Tambahan" int i = 0; int n = 0; i = gridHeader.SelectedCells[0].RowIndex; n = gridHeader.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)gridHeader.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtHeader.AcceptChanges(); gridHeader.Focus(); gridHeader.RefreshEdit(); if (gridHeader.RowCount > 0) { if (i == 0) { gridHeader.CurrentCell = gridHeader.Rows[0].Cells[n]; gridHeader.RefreshEdit(); } else { gridHeader.CurrentCell = gridHeader.Rows[i - 1].Cells[n]; gridHeader.RefreshEdit(); } } #endregion } catch (Exception ex) { Error.LogError(ex); } } } } } else { if (gridDetail.SelectedCells.Count > 0) { DateTime _Tanggal = (DateTime)gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value; if (PeriodeClosing.IsKasirClosed(_Tanggal)) { MessageBox.Show("Sudah Closing!"); return; } if (MessageBox.Show("Apakah giro ini tidak jadi dititipkan?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { Guid _GiroID = (Guid)gridDetail.SelectedCells[0].OwningRow.Cells["GiroID"].Value; Guid _RowID = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value; try { using (Database db = new Database(GlobalVar.DBFinance)) { db.Commands.Add(db.CreateCommand("usp_Giro_BatalTitip")); db.Commands[0].Parameters.Add(new Parameter("@GiroID", SqlDbType.UniqueIdentifier, _GiroID)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } HeaderRowRefresh(_RowID); #region "Tambahan" int i = 0; int n = 0; i = gridDetail.SelectedCells[0].RowIndex; n = gridDetail.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)gridDetail.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtDetail.AcceptChanges(); gridDetail.Focus(); gridDetail.RefreshEdit(); if (gridDetail.RowCount > 0) { if (i == 0) { gridDetail.CurrentCell = gridDetail.Rows[0].Cells[n]; gridDetail.RefreshEdit(); } else { gridDetail.CurrentCell = gridDetail.Rows[i - 1].Cells[n]; gridDetail.RefreshEdit(); } } #endregion } catch (Exception ex) { Error.LogError(ex); } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (dataSudahAda()) { KotakPesan.Warning("Data Sudah Ada di database"); txtNama.Focus(); return; } if (string.IsNullOrEmpty(txtNama.Text)) { KotakPesan.Warning("Anda belum mengisi data Nama"); txtNama.Focus(); return; } if (string.IsNullOrEmpty(txtLokasi.Text)) { KotakPesan.Warning("Anda belum mengisi data Lokasi"); txtLokasi.Focus(); return; } try { switch (formMode) { case enumFormMode.NEW: using (Database db = new Database(GlobalVar.DBFinance)) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("[usp_BankKota_INSERT]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, txtLokasi.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.Bit, cbaktif.Checked)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); KotakPesan.Information("Insert Berhasil"); } break; case enumFormMode.UPDATE: using (Database db = new Database(GlobalVar.DBFinance)) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("[usp_BankKota_UPDATE]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, txtLokasi.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.Bit, cbaktif.Checked)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); KotakPesan.Information("Update Berhasil"); } break; } this.DialogResult = DialogResult.OK; frmBankKotaBrowse frmcaller = (frmBankKotaBrowse)this.Caller; frmcaller.RefreshData(); this.Close(); frmcaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }