Did Officer Murdoch really commit suicide after shooting passengers and accepting a bribe?

Officer William McMaster Murdoch

After the release of James Cameron's 1997 movie Titanic, Officer William Murdoch's surviving relatives, other historians, and people from Murdoch's hometown of Dalbeattie, Scotland were angered over Cameron's decisive portrayal of First Officer Murdoch (left)
.

In the film, he turns his gun on himself after shooting two passengers who are rushing a lifeboat. Based on witness testimony, historians are fairly certain that an officer did commit suicide, but it can't be said with absolute certainty that it was First Officer Murdoch.

Also, there is no evidence to suggest that Murdoch ever took a bribe. James Cameron likely put the bribe in the film to show Cal's (Billy Zane) lack of integrity rather than Murdoch's. Studio executives flew to Murdoch's hometown where they issued an apology and made an $8,500 donation to Murdoch's memorial fund.