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;
}