public LastSeenVideosModel GetLastSeenVideosById(int id)
{
LastSeenVideosModel lastSeenVideo = new LastSeenVideosModel();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM last_seen_videos WHERE last_seen_videos.last_seen_videos_id = @id;", conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
lastSeenVideo = MapRowToLastSeenVideos(reader);
}
else
{
lastSeenVideo = null;
}
}
}
catch (SqlException)
{
throw;
}
return(lastSeenVideo);
}
public List <LastSeenVideosModel> GetLastSeenVideosByParkId(int parkId)
{
List <LastSeenVideosModel> lastSeenVideos = new List <LastSeenVideosModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM last_seen_videos
INNER JOIN panoramic_images
ON last_seen_videos.panoramic_image_id = panoramic_images.panoramic_image_id
INNER JOIN trails
ON panoramic_images.trail_id = trails.trail_id
INNER JOIN parks
ON trails.park_id = parks.park_id
WHERE parks.park_id = @parkId;", conn);
cmd.Parameters.AddWithValue("@parkId", parkId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LastSeenVideosModel lastSeenVideo = MapRowToLastSeenVideos(reader);
lastSeenVideos.Add(lastSeenVideo);
}
}
}
catch (SqlException)
{
throw;
}
return(lastSeenVideos);
}
public List <LastSeenVideosModel> GetAllLastSeenVideos()
{
List <LastSeenVideosModel> lastSeenVideos = new List <LastSeenVideosModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM last_seen_videos", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LastSeenVideosModel lastSeenVideo = MapRowToLastSeenVideos(reader);
lastSeenVideos.Add(lastSeenVideo);
}
return(lastSeenVideos);
}
}
catch (SqlException)
{
throw;
};
}
