protected void btnOk_Click(object sender, EventArgs e) { try { using (Neophotonics_webDbHelper GWdbHelper = new Neophotonics_webDbHelper()) { GWdbHelper.AddParameter("@GroupID", System.Data.SqlDbType.Int, Convert.ToInt32(hfHidden.Value));//Group ID GWdbHelper.Command.CommandType = System.Data.CommandType.StoredProcedure; GWdbHelper.Command.CommandText = "SP_Group_Delete"; int status = GWdbHelper.ExecuteScalarInt(); int errorNo = (int)GWdbHelper.Command.Parameters["@OPARAMERRNO"].Value; if (errorNo == 0) { Response.Redirect("BuildingView.aspx?RespMsg=Group Deleted Successfully", false); } else { Response.Redirect("BuildingView.aspx?RespMsg=Group Cannot be Deleted", false); } } hfHidden.Value = string.Empty; } catch (Exception ex) { } }
protected void btnDelet_Click(object sender, CommandEventArgs e) { string StrGroupId = Convert.ToString(e.CommandArgument); using (Neophotonics_webDbHelper GWdbHelper = new Neophotonics_webDbHelper()) { GWdbHelper.AddParameter("@GroupID", System.Data.SqlDbType.Int, Convert.ToInt32(StrGroupId)); //Group ID GWdbHelper.Command.CommandType = System.Data.CommandType.StoredProcedure; GWdbHelper.Command.CommandText = "SP_Group_Delete"; int status = GWdbHelper.ExecuteScalarInt(); int errorNo = (int)GWdbHelper.Command.Parameters["@OPARAMERRNO"].Value; if (errorNo == 0) { Response.Redirect("BuildingView.aspx?RespMsg=Group Deleted Successfully", false); } else { Response.Redirect("BuildingView.aspx?RespMsg=Group Cannot be Deleted", false); } } }