private void button1_Click(object sender, EventArgs e) { try { CrystalReportCashAdv cr = new CrystalReportCashAdv(); cr.SetParameterValue("noca", labelKodeCA.Text); ((FormParent)this.MdiParent).panggilTampilCA(cr); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DataGridViewCA_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewCA.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Edit" && (dataGridViewCA.Rows[e.RowIndex].Cells[e.ColumnIndex] as DataGridViewDisableButtonCell).Enabled) { ((FormParent)this.MdiParent).panggilCA(dataGridViewCA.Rows[e.RowIndex].Cells[0].Value.ToString(), 4); } if (dataGridViewCA.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Cetak" && (dataGridViewCA.Rows[e.RowIndex].Cells[e.ColumnIndex] as DataGridViewDisableButtonCell).Enabled) { CrystalReportCashAdv cr = new CrystalReportCashAdv(); cr.SetParameterValue("noca", dataGridViewCA.Rows[e.RowIndex].Cells[0].Value.ToString()); ((FormParent)this.MdiParent).panggilTampilCA(cr); } if (dataGridViewCA.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Delete" && (dataGridViewCA.Rows[e.RowIndex].Cells[e.ColumnIndex] as DataGridViewDisableButtonCell).Enabled) { if (MessageBox.Show("Apakah anda yakin ingin mendelete CA dengan tujuan : '" + dataGridViewCA.Rows[e.RowIndex].Cells[5].Value.ToString() + "' ?", "Confirm", MessageBoxButtons.OKCancel) == DialogResult.OK) { try { if (ClassConnection.Instance().Connecting()) { string commandText = "DELETE FROM pettyca WHERE kode = @kode"; MySqlCommand cmd = new MySqlCommand(commandText, ClassConnection.Instance().Connection); cmd.Parameters.AddWithValue("@kode", dataGridViewCA.Rows[e.RowIndex].Cells[0].Value.ToString()); int rowsAffected = cmd.ExecuteNonQuery(); MessageBox.Show("Data telah terhapus", "Berhasil"); ClassConnection.Instance().Close(); (this.MdiParent as FormParent).updateDGVCAAEPO(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } } } }