DECLARE @temp as int; -- Insert statements for procedure here SELECT @temp = (SELECT CAST(COUNT(1) AS BIT) AS Expr1 FROM ALARM_MSTR_ALARM_DETAIL WHERE ALARM_TYPE_ID = @ALARM_TYPE_ID) IF @temp <> 1 BEGIN Delete from ALARM_MSTR_ALARM_TYPE where ALARM_TYPE_ID = @ALARM_TYPE_ID END ELSE SET @temp = 0; RETURN @temp
public string DeleteAlarmType(int iAlarmId) { SqlParameter[] ParamAdd = new SqlParameter[1]; ParamAdd[0] = new SqlParameter("@ALARM_TYPE_ID", iAlarmId); return SqlHelper.ExecuteScalar(ConfigurationManager.ConnectionStrings["MetaConnectionString"].ConnectionString, CommandType.StoredProcedure, "Delete_alarm_master_type", ParamAdd).ToString(); }
ExcecuteScalar
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)