CoyoteMoves.Data_Access.RequestFormDB.SDApproved C# (CSharp) Method

SDApproved() public method

public SDApproved ( System.Guid uniqueRequestID ) : bool
uniqueRequestID System.Guid
return bool
        public bool SDApproved(Guid uniqueRequestID)
        {
            SqlConnection connection = new SqlConnection(_connectionString);
            SqlCommand cmd = new SqlCommand("SELECT ServiceDeskApproved FROM RequestData WHERE UniqueRequestID = @guid");
            cmd.Parameters.Add("@guid", SqlDbType.UniqueIdentifier).Value = uniqueRequestID;
            cmd.Connection = connection;
            connection.Open();
            var approval = cmd.ExecuteScalar();

            connection.Close();
            if ((approval == null) || (approval == DBNull.Value))
            {
                return false;
            }
            return (bool)approval;
        }