public LastSeenImagesModel GetLastSeenImagesById(int id)
{
LastSeenImagesModel lastSeenImage = new LastSeenImagesModel();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM last_seen_images WHERE last_seen_images.last_seen_images_id = @id;", conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
lastSeenImage = MapRowToLastSeenImages(reader);
}
else
{
lastSeenImage = null;
}
}
}
catch (SqlException)
{
throw;
}
return(lastSeenImage);
}
public List <LastSeenImagesModel> GetLastSeenImagesByParkId(int parkId)
{
List <LastSeenImagesModel> lastSeenImages = new List <LastSeenImagesModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM last_seen_images
INNER JOIN panoramic_images
ON last_seen_images.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())
{
LastSeenImagesModel lastSeenImage = MapRowToLastSeenImages(reader);
lastSeenImages.Add(lastSeenImage);
}
}
}
catch (SqlException)
{
throw;
}
return(lastSeenImages);
}
public List <LastSeenImagesModel> GetAllLastSeenImages()
{
List <LastSeenImagesModel> lastSeenImages = new List <LastSeenImagesModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM last_seen_images", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LastSeenImagesModel lastSeenImage = MapRowToLastSeenImages(reader);
lastSeenImages.Add(lastSeenImage);
}
return(lastSeenImages);
}
}
catch (SqlException)
{
throw;
};
}
