/// <summary> /// Find a rating based on its id in database /// </summary> /// <param name="ratingId">int</param> /// <returns>Rating</returns> public Rating FindById(int ratingId) { Rating rating = null; using (_connection = new SqlConnection(_connectionString)) { _connection.Open(); using (SqlCommand cmd = _connection.CreateCommand()) { cmd.CommandText = "SELECT * FROM Rating WHERE RatingId = @RatingId"; cmd.Parameters.AddWithValue("RatingId", ratingId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int userId = reader.GetInt32(reader.GetOrdinal("UserId")); rating = new Rating { RatingId = ratingId, User = _dbUser.FindById(userId), Rate = reader.GetDouble(reader.GetOrdinal("Rate")), Comment = reader.GetString(reader.GetOrdinal("Comment")) }; } } _connection.Close(); } return(rating); }
/// <summary> /// Find a location based on id in the database /// </summary> /// <param name="locationId">int</param> /// <returns>Location</returns> public Location FindById(int locationId) { Location location = null; using (_connection = new SqlConnection(_connectionString)) { _connection.Open(); using (SqlCommand cmd = _connection.CreateCommand()) { cmd.CommandText = "SELECT * FROM Locations WHERE LocationId = @LocationId"; cmd.Parameters.AddWithValue("LocationId", locationId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { location = new Location { LocationId = locationId, Hits = reader.GetInt32(reader.GetOrdinal("Hits")), IsTopLocation = reader.GetBoolean(reader.GetOrdinal("IsTopLocation")), LocationName = reader.GetString(reader.GetOrdinal("LocationName")), LocationDescription = reader.GetString(reader.GetOrdinal("LocationDescription")), Latitude = reader.GetDouble(reader.GetOrdinal("Latitude")), Longitude = reader.GetDouble(reader.GetOrdinal("Longitude")), Pictures = _dbPicture.FindByLocationId(locationId), Ratings = _dbRating.FindByLocationId(locationId), User = _dbUser.FindById(reader.GetInt32(reader.GetOrdinal("UserId"))), RowVersion = (byte[])reader.GetValue(reader.GetOrdinal("rowVersion")) }; } } _connection.Close(); } return(location); }