Exemplo n.º 1
0
        public static CollectionOfConnectStrings EncrpytConnectionString(string key,
                                                                         CollectionOfConnectStrings connectStrings)
        {
            connectStrings.ReadOnlyConnectionString =
                SecurityUtility.EncryptString(key, connectStrings.ReadOnlyConnectionString);

            return(connectStrings);
        }
Exemplo n.º 2
0
        public static CollectionOfConnectStrings LoadConfiguration()
        {
            var builder = new ConfigurationBuilder()
                          .SetBasePath(Directory.GetCurrentDirectory())
                          .AddJsonFile("appsettings.json", true, true);

            builder.AddUserSecrets <ConfigurationHelper>();

            var configuration = builder.Build();

            var connectStringSettings = new CollectionOfConnectStrings();

            configuration.GetSection("CollectionOfConnectStrings").Bind(connectStringSettings);

            EncrpytConnectionString(configuration["ConnectionDbKey"], connectStringSettings);

            return(connectStringSettings);
        }
Exemplo n.º 3
0
        public static List <QueryConfig> GetConfigurationData(CollectionOfConnectStrings connectionSettings)
        {
            var queryConfigs = new List <QueryConfig>();

            var counter          = 0;
            var placeNameOutputs = new List <PropertyOutput>
            {
                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "placeNameId",
                    OutputName   = "Id"
                },
                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "placeName",
                    OutputName   = "placeName"
                },
                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "locality",
                    OutputName   = "locality"
                },
                new PropertyOutput
                {
                    Id           = counter,
                    ColumnType   = PropertyType.Object,
                    PropertyName = "geometry",
                    OutputName   = "geometry"
                }
            };


            var placeNameDbSettings = new DataSourceSettings
            {
                ConnectionString = connectionSettings.ReadOnlyConnectionString,
                Entity           = "place_names_test",
                DatabaseType     = SourceType.Mongodb,
                Database         = "ccc_db",
            };

            queryConfigs.Add(new QueryConfig
            {
                Name         = "QueryPlaceName",
                Description  = "Query PlaceName collection by Name",
                QueryType    = QueryType.Text,
                QueryField   = "placeName",
                Mappings     = placeNameOutputs,
                DbSettings   = placeNameDbSettings,
                GeometryType = GeometryType.MultiPoint
            });

            counter = 0; //reset counter;
            var parkOutputs = new List <PropertyOutput>
            {
                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "parkId",
                    OutputName   = "Id"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "parkName",
                    OutputName   = "parkName"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "parkTypeDescription",
                    OutputName   = "parkType"
                },

                new PropertyOutput
                {
                    Id           = counter,
                    ColumnType   = PropertyType.Object,
                    PropertyName = "geometry",
                    OutputName   = "geometry"
                }
            };

            var parkDbSettings = new DataSourceSettings
            {
                ConnectionString = connectionSettings.ReadOnlyConnectionString,
                Entity           = "parks_test",
                DatabaseType     = SourceType.Mongodb,
                Database         = "ccc_db"
            };

            queryConfigs.Add(new QueryConfig
            {
                Name         = "QueryPark",
                Description  = "Query Park collection by Name",
                QueryType    = QueryType.Text,
                QueryField   = "parkName",
                Mappings     = parkOutputs,
                DbSettings   = parkDbSettings,
                GeometryType = GeometryType.MultiPolygon
            });


            var streetAddressDbSettings = new DataSourceSettings
            {
                ConnectionString = connectionSettings.ReadOnlyConnectionString,
                Entity           = "street_addresses_test",
                DatabaseType     = SourceType.Mongodb,
                Database         = "ccc_db"
            };

            counter = 0; //reset counter;
            var streetAddressOutputs = new List <PropertyOutput>
            {
                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "streetAddressId",
                    OutputName   = "Id"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "streetAddress",
                    OutputName   = "streetAddress"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "localityName",
                    OutputName   = "locality"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "occupationLevelDescription",
                    OutputName   = "occupationLevel"
                },

                new PropertyOutput
                {
                    Id           = counter,
                    ColumnType   = PropertyType.Object,
                    PropertyName = "geometry",
                    OutputName   = "geometry"
                }
            };

            queryConfigs.Add(new QueryConfig
            {
                Name         = "QueryAddress",
                Description  = "Query StreetAddress collection by Name",
                QueryType    = QueryType.Text,
                QueryField   = "streetAddress",
                Mappings     = streetAddressOutputs,
                DbSettings   = streetAddressDbSettings,
                GeometryType = GeometryType.MultiPoint
            });

            var ratingUnitDbSettings = new DataSourceSettings
            {
                ConnectionString = connectionSettings.ReadOnlyConnectionString,
                Entity           = "ratingunits",
                DatabaseType     = SourceType.Mongodb,
                Database         = "ccc_db"
            };

            counter = 0; //reset counter;
            var ratingUnitOutputs = new List <PropertyOutput>
            {
                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "ratingUnitId",
                    OutputName   = "Id"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "streetAddress",
                    OutputName   = "streetAddress"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "localityName",
                    OutputName   = "locality"
                },

                new PropertyOutput
                {
                    Id           = counter++,
                    ColumnType   = PropertyType.Normal,
                    PropertyName = "occupationLevelDescription",
                    OutputName   = "occupationLevel"
                },

                new PropertyOutput
                {
                    Id           = counter,
                    ColumnType   = PropertyType.Object,
                    PropertyName = "geometry",
                    OutputName   = "geometry"
                }
            };

            queryConfigs.Add(new QueryConfig
            {
                Name         = "QueryRatingUnit",
                Description  = "Query RatingUnit collection by Name",
                QueryType    = QueryType.Text,
                QueryField   = "streetAddress",
                Mappings     = ratingUnitOutputs,
                DbSettings   = ratingUnitDbSettings,
                GeometryType = GeometryType.MultiPolygon
            });

            return(queryConfigs);
        }