private void btnObrisiObrazac_Click(object sender, EventArgs e) { if (this.UltraGrid1.Selected == null) { return; } if (this.UltraGrid1.Selected.Rows.Count == 0) { return; } if (MessageBox.Show("Nastaviti sa brisanjem obrasca?\n\nNAPOMENA: brisanjem obrasca NE brišete obračune već samo JOPPD izvještaj!", "Brisanje JOPPD obrasca", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes) { int joppdID = (int)this.UltraGrid1.Selected.Rows[0].Cells["JoppdaID"].Value; Mipsed7.DataAccessLayer.SqlClient database = new Mipsed7.DataAccessLayer.SqlClient(); database.ExecuteNonQuery(string.Format("DELETE FROM dbo.JOPPDB WHERE JOPPDAID = {0}", joppdID)); database.ExecuteNonQuery(string.Format("DELETE FROM dbo.JOPPDA WHERE ID = {0}", joppdID)); database.ExecuteNonQuery(string.Format("DELETE FROM dbo.JOPPDAObracun WHERE JOPPDA_ID = {0}", joppdID)); GetObracunJOPPD(); } }
private void btnObrisi_Click(object sender, EventArgs e) { string sifra_os = string.Empty; string broj_os = string.Empty; int index = UltraGrid1.ActiveRow.Index; sifra_os = UltraGrid1.Rows[index].Cells[0].Value.ToString(); broj_os = UltraGrid1.Rows[index].Cells[2].Value.ToString(); Mipsed7.DataAccessLayer.SqlClient client = new Mipsed7.DataAccessLayer.SqlClient(); client.ExecuteNonQuery("Delete From OSTEMELJNICA Where IDOSDOKUMENT = '" + sifra_os + "' And OSBROJDOKUMENTA = '" + broj_os + "'"); client.CloseConnection(); UltraGrid1.DeleteSelectedRows(); }