private void btnDeleteIPP_Click(object sender, System.EventArgs e)
{
IPPs = new IPP();
DataTable dt;
ACMS.XtraUtils.GridViewUtils.UpdateData(IPPGridView);
DataRow row = IPPGridView.GetDataRow(IPPGridView.FocusedRowHandle);
if (row != null)
{
string strSQL="select * from tblReceiptPayment where nIPPId = " + Convert.ToInt32(row["nIPPId"]);
DataSet _ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
if (dt.Rows.Count > 0)
{
MessageBox.Show(this, "Cannot be deleted. Please unlink all the receipt from the IPP.");
return;
}
DialogResult result = MessageBox.Show(this, "Do you really want to delete record with IPP ID = " + row["NIPPID"].ToString() + "?",
"Delete?", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
if (IPPs.Delete(ACMS.Convert.ToInt32(row["NIPPID"])))
{
MessageBox.Show(this, "Record deleted");
}
}
}
LoadIPP();
}
