Something to this effect might work for you

...

The best thing to due is use a variable in the loop. Then after the loop is done then return the variable. So the logic flows like this. First set the variable to false. Then loop through array setting variable to true if you have a match. If all elements in drawnBalls equall all elements in selectBalls. Then the variable will remain true. if any element doesn't match then set to false and break out of the for setting index to last value. This is...

I am assuming that if you are using sql you are selecting the case from the database. I also assume that the database will have an open and close date for the case. In setting the current date and null for close date when creating the case for the first time. Then use the update command to update the sql database with the information needed. Then when select the case to close it use the current date and just update the close date in the database...