public List <BackgroundSoundClip> GetAllBackgroundSoundClips()
{
List <BackgroundSoundClip> backgroundSoundClips = new List <BackgroundSoundClip>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM trail_sounds", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BackgroundSoundClip soundClip = new BackgroundSoundClip()
{
AudioId = Convert.ToInt32(reader["trail_sound_id"]),
AudioAddress = Convert.ToString(reader["trail_sound_file"])
};
backgroundSoundClips.Add(soundClip);
}
}
}
catch (SqlException e)
{
throw;
}
return(backgroundSoundClips);
}
public List <BackgroundSoundClip> GetBackgroundSoundClipsByPanoramicId(int panoramicId)
{
List <BackgroundSoundClip> backgroundSoundClips = new List <BackgroundSoundClip>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT ts.*
FROM trail_sounds ts
INNER JOIN sound_categories sc ON ts.sound_category_id = sc.sound_category_id
INNER JOIN trail_sounds_associative tsa ON tsa.sound_category_id = sc.sound_category_id
WHERE tsa.panoramic_image_id = @panoramicId", conn);
cmd.Parameters.AddWithValue("@panoramicId", panoramicId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BackgroundSoundClip soundClip = new BackgroundSoundClip()
{
AudioId = Convert.ToInt32(reader["trail_sound_id"]),
AudioAddress = Convert.ToString(reader["trail_sound_file"])
};
backgroundSoundClips.Add(soundClip);
}
}
}
catch (SqlException e)
{
throw;
}
return(backgroundSoundClips);
}