things mentioned by my superior of debugging

1. Start where the problem lies and work backwards in code from there. Also note that the issue may lie on the data side, in a stored procedure perhaps. It is best to rule that out quickly.
2. Methods which take in reference types and doctor them should really be altered to advertise the alterations by making the variables out variables. Typically a method should not change the values handing in as parameters.