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); } }