Resident shot in Sandy Springs during home invasion, police say