Police said the suspect in the shooting is dead from a self-inflicted gunshot wound and five additional people were wounded