public ParkImagesModel GetParkImagesById(int id)
{
ParkImagesModel parkImage = new ParkImagesModel();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM park_images WHERE park_images.park_images_id = @id;", conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
parkImage = MapRowToParkImages(reader);
}
else
{
parkImage = null;
}
}
}
catch (SqlException)
{
throw;
}
return(parkImage);
}
public List <ParkImagesModel> GetParkImagesByParkId(int parkId)
{
List <ParkImagesModel> parkImages = new List <ParkImagesModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM park_images WHERE park_images.park_id = @parkId;", conn);
cmd.Parameters.AddWithValue("@parkId", parkId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ParkImagesModel parkImage = MapRowToParkImages(reader);
parkImages.Add(parkImage);
}
}
}
catch (SqlException)
{
throw;
}
return(parkImages);
}
public List <ParkImagesModel> GetAllParkImages()
{
List <ParkImagesModel> parkImages = new List <ParkImagesModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM park_images", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ParkImagesModel parkImage = MapRowToParkImages(reader);
parkImages.Add(parkImage);
}
return(parkImages);
}
}
catch (SqlException)
{
throw;
}
}
public void Initialize()
{
park = new ParkModel()
{
Name = "testPark",
Description = "testDescription",
Latitude = 41,
Longitude = 100,
Zoom = 200
};
parkImage = new ParkImagesModel()
{
Bit = true,
ImageAddress = "address"
};
}
public static int InsertFakeParkImage(ParkImagesModel parkImage, int parkId)
{
int parkImageId = -1;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO park_images " +
"(park_id, park_image_address, local) " +
"VALUES (@parkId, @imageAddress, @bit)", conn);
cmd.Parameters.AddWithValue("@parkId", parkId);
cmd.Parameters.AddWithValue("@imageAddress", parkImage.ImageAddress);
cmd.Parameters.AddWithValue("@bit", parkImage.Bit);
cmd.ExecuteNonQuery();
return(parkImageId);
}
}
