public void Configuration(IAppBuilder app) { ConfigureAuth(app); app.MapSignalR(); GlobalHost.DependencyResolver.Register(typeof(JsonSerializer), () => JsonSerializer.Create(new JsonSerializerSettings { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore })); IpDatabase = new DatabaseReader(HostingEnvironment.MapPath("/App_Data/GeoLite2-City.mmdb")); CrunchDispatcher.Crunchers.Add(new SystemEventsPerHour()); CrunchDispatcher.Crunchers.Add(new ServerEventsPerHour()); }
private async Task<DatabaseReader> GetDatabaseAsync(CancellationToken cancellationToken) { // Try to load the new database from disk if the current one is an hour old. if (_database != null && _databaseLastChecked.HasValue && _databaseLastChecked.Value < DateTime.UtcNow.SubtractHours(1)) { _database.Dispose(); _database = null; } if (_database != null) return _database; if (_databaseLastChecked.HasValue && _databaseLastChecked.Value >= DateTime.UtcNow.SubtractSeconds(30)) return null; _databaseLastChecked = DateTime.UtcNow; if (!await _storage.ExistsAsync(GEO_IP_DATABASE_PATH).AnyContext()) { Logger.Warn().Message("No GeoIP database was found.").Write(); return null; } Logger.Info().Message("Loading GeoIP database.").Write(); try { using (var stream = await _storage.GetFileStreamAsync(GEO_IP_DATABASE_PATH, cancellationToken).AnyContext()) _database = new DatabaseReader(stream); } catch (Exception ex) { Logger.Error().Exception(ex).Message("Unable to open GeoIP database.").Write(); } return _database; }
public static string GetCountry(string ClientIP) { //shortcut for local if (ClientIP == "127.0.0.1") { return "US"; } // future licensed webservice call //int _userId = int.Parse(Sitecore.Configuration.Settings.GetSetting(Constants.GeoIPLookup.GeoIPUserId)); //string _licenseKey = Sitecore.Configuration.Settings.GetSetting(Constants.GeoIPLookup.GeoIPLicenseKey); //var client = new WebServiceClient(_userId, _licenseKey); //var omni = client.Country(ClientIP); //return omni.Country.IsoCode; // temporary free database string _database = Sitecore.Configuration.Settings.GetSetting(Constants.GeoIPLookup.GeoIPDatabaseName); string _dataFolder = Sitecore.Configuration.Settings.DataFolder; try { var reader = new DatabaseReader(_dataFolder + "\\" + _database); var country = reader.Country(ClientIP); return country.Country.IsoCode; } catch (Exception) { return "US"; } }
public RuneSlot(DatabaseReader reader) { Slot = reader.Integer(); Rune = reader.Integer(); reader.SanityCheck(Fields); }
public static void Main() { DatabaseReader dr = new DatabaseReader(); int? i = dr.GetIntFromDatabase(); if (i.HasValue) Console.WriteLine("Value of 'i' is: {0}", i.Value); else Console.WriteLine("Value of 'i' is undefined"); // Get the bool bool? b = dr.GetBoolFromDatabase(); if (b.HasValue) Console.WriteLine("Value of 'b' is: {0}", b.Value); else Console.WriteLine("Value of 'b' is undefined"); // Now use ?? to suplement null with a default // if the value is null // assign local variable to 100. int myData = dr.GetIntFromDatabase() ?? 100; Console.WriteLine("Value of myData: {0}", myData); // Long hand notation not using ?? syntax. int? moreData = dr.GetIntFromDatabase(); if (!moreData.HasValue) moreData = 100; Console.WriteLine("Value of moreData: {0}", moreData); Console.ReadLine(); }
public static KeyValuePair<string, string> GetCodeFromIP(string ipaddress) { var databasePath = Sitecore.Configuration.Settings.GetSetting(Constants.Settings.MaxMindDatabasePath); var foundCountry = new KeyValuePair<string, string>(); try { //First try and get the response that matches the IP from cache var countryResponse = CacheHelper.RedirectCache.GetObject(ipaddress) as CountryResponse; if (countryResponse != null) { foundCountry = new KeyValuePair<string, string>(countryResponse.Continent.Code, countryResponse.Country.IsoCode); } //Else, let's grab it from the database using (var reader = new DatabaseReader(databasePath)) { var dbResponse = reader.Country(ipaddress); //Add to cache CacheHelper.RedirectCache.SetObject(ipaddress, dbResponse); foundCountry = new KeyValuePair<string, string>(dbResponse.Continent.Code, dbResponse.Country.IsoCode); } } catch (Exception error) { Log.Error(string.Format("[SharedSource.RedirectModule.MaxMind.DatabaseHelper] {0}", error.Message), typeof(DatabaseHelper)); } return foundCountry; }
/// <summary> /// Lấy thông tin country của 1 ip address /// </summary> protected virtual CountryResponse GetInformation(string ipAddress) { if (string.IsNullOrEmpty(ipAddress)) return null; try { // sẽ chỉ tạo duy nhất 1 đối tượng _databaseReader cho mỗi thể hiện IGeoLookupService, tức là per request if (_databaseReader == null) { var webHelper = EngineContext.Current.Resolve<IWebHelper>(); string filePath = webHelper.MapPath("~/App_Data/GeoLite2-Country.mmdb"); _databaseReader = new DatabaseReader(filePath); } return _databaseReader.Country(ipAddress); } catch (GeoIP2Exception) { //address is not found //do not throw exceptions return null; } catch (Exception ex) { var logger = EngineContext.Current.Resolve<ILogger>(); logger.Warning("Không thể load MaxMind.GeoIP2", ex); return null; } }
protected virtual OmniResponse GetInformation(string ipAddress) { try { var databasePath = _webHelper.MapPath("~/App_Data/GeoLite2-Country.mmdb"); var reader = new DatabaseReader(databasePath); var omni = reader.Omni(ipAddress); return omni; //more info: http://maxmind.github.io/GeoIP2-dotnet/ //more info: https://github.com/maxmind/GeoIP2-dotnet //more info: http://dev.maxmind.com/geoip/geoip2/geolite2/ //Console.WriteLine(omni.Country.IsoCode); // 'US' //Console.WriteLine(omni.Country.Name); // 'United States' //Console.WriteLine(omni.Country.Names["zh-CN"]); // '美国' //Console.WriteLine(omni.MostSpecificSubdivision.Name); // 'Minnesota' //Console.WriteLine(omni.MostSpecificSubdivision.IsoCode); // 'MN' //Console.WriteLine(omni.City.Name); // 'Minneapolis' //Console.WriteLine(omni.Postal.Code); // '55455' //Console.WriteLine(omni.Location.Latitude); // 44.9733 //Console.WriteLine(omni.Location.Longitude); // -93.2323 } //catch (AddressNotFoundException exc) catch (GeoIP2Exception exc) { //address is not found //do not throw exceptions return null; } catch (Exception exc) { //do not throw exceptions _logger.Warning("Cannot load MaxMind record", exc); return null; } }
/// <summary> /// Initializes a new instance of the <see cref="MaxMindGeolocationService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="configuration"> /// The configuration. /// </param> public MaxMindGeolocationService(ILogger logger, IPrivateConfiguration configuration) { this.logger = logger; this.databasePath = configuration.MaxMindDatabasePath; var file = this.databasePath + "/GeoLite2-City.mmdb"; this.reader = new DatabaseReader(file); }
public void HasIPAddress() { using (var reader = new DatabaseReader(_databaseFile)) { var resp = reader.CityIspOrg("81.2.69.160"); Assert.That(resp.Traits.IPAddress, Is.EqualTo("81.2.69.160")); } }
/// <summary> /// Reads the table schema and data and returns the INSERT statements /// </summary> /// <param name="tableName">Name of the table.</param> /// <param name="connectionString">The connection string.</param> /// <param name="providerName">Name of the provider.</param> /// <returns></returns> public string ReadTable(string tableName, string connectionString, string providerName) { using (var dr = new DatabaseReader(connectionString, providerName)) { var databaseTable = dr.Table(tableName); if (databaseTable == null) return null; return ReadTable(databaseTable, connectionString, providerName); } }
public void Domain() { using (var reader = new DatabaseReader(Path.Combine(_databaseDir, "GeoIP2-Domain-Test.mmdb"))) { var ipAddress = "1.2.0.0"; var response = reader.Domain(ipAddress); Assert.That(response.Domain, Is.EqualTo("maxmind.com")); Assert.That(response.IPAddress, Is.EqualTo(ipAddress)); } }
public void ConnectionType() { using (var reader = new DatabaseReader(Path.Combine(_databaseDir, "GeoIP2-Connection-Type-Test.mmdb"))) { var ipAddress = "1.0.1.0"; var response = reader.ConnectionType(ipAddress); Assert.That(response.ConnectionType, Is.EqualTo("Cable/DSL")); Assert.That(response.IPAddress, Is.EqualTo(ipAddress)); } }
public static void Initialize() { try { using (var fileStream = new FileStream("GeoLite2-Country.mmdb.gz", FileMode.Open, FileAccess.Read)) using (var gzipStream = new GZipInputStream(fileStream)) database = new DatabaseReader(gzipStream); } catch (Exception e) { Log.Write("geoip", "DatabaseReader failed: {0}", e); } }
public SummonerRating(DatabaseReader reader) { Map = reader.Map(); GameMode = reader.GameMode(); Wins = reader.Integer(); Losses = reader.Integer(); Leaves = reader.Integer(); CurrentRating = reader.MaybeInteger(); TopRating = reader.MaybeInteger(); reader.SanityCheck(Fields); }
public void Isp() { using (var reader = new DatabaseReader(Path.Combine(_databaseDir, "GeoIP2-ISP-Test.mmdb"))) { var ipAddress = "1.128.0.0"; var response = reader.Isp(ipAddress); Assert.That(response.AutonomousSystemNumber, Is.EqualTo(1221)); Assert.That(response.AutonomousSystemOrganization, Is.EqualTo("Telstra Pty Ltd")); Assert.That(response.Isp, Is.EqualTo("Telstra Internet")); Assert.That(response.Organization, Is.EqualTo("Telstra Internet")); Assert.That(response.IPAddress, Is.EqualTo(ipAddress)); } }
public static void Initialize(Action<string, string> log, string category) { DatabaseReader reader; if (File.Exists("GeoIP2-Country.mmdb")) { reader = new DatabaseReader("GeoIP2-Country.mmdb"); log(category, "Loaded GeoIP2-Country.mmdb"); } else if (File.Exists("GeoLite2-Country.mmdb")) { reader = new DatabaseReader("GeoLite2-Country.mmdb"); log(category, "Loaded GeoLite2-Country.mmdb"); } else { reader = null; } _instance = new GeoIP(reader); }
public void AnonymousIP() { using (var reader = new DatabaseReader(Path.Combine(_databaseDir, "GeoIP2-Anonymous-IP-Test.mmdb"))) { var ipAddress = "1.2.0.1"; var response = reader.AnonymousIP(ipAddress); Assert.That(response.IsAnonymous, Is.True); Assert.That(response.IsAnonymousVpn, Is.True); Assert.That(response.IsHostingProvider, Is.False); Assert.That(response.IsPublicProxy, Is.False); Assert.That(response.IsTorExitNode, Is.False); Assert.That(response.IPAddress, Is.EqualTo(ipAddress)); } }
public static string GetCountryLocal(string ip) { if (string.IsNullOrEmpty(ip)) return string.Empty; try { using (var reader = new DatabaseReader(@"IPDatabase\GeoLite2-City.mmdb")) { var city = reader.City(ip); return city.Country.Name; } } catch(Exception e) { return string.Empty; } }
protected virtual async Task <string> FindLocation(string ipAddress) { try { var databasePath = _fileProvider.MapContentPath("~/Country.mmdb"); var reader = new DatabaseReader(databasePath); var response = reader.Country(ipAddress); if (response != null && response.Country != null && string.IsNullOrEmpty(response.Country.IsoCode)) { throw new GeoIP2Exception("Country not found"); } return(await Task.FromResult(response.Country?.IsoCode)); } catch (Exception ex) { _logger.Error("An error occurred while finding country.", ex, ipAddress); return(null); } }
public VotesManager() { try { var uri = new Uri("pack://application:,,,/Assets/RuleChanges.txt"); System.Windows.Resources.StreamResourceInfo resourceStream = Application.GetResourceStream(uri); using (var reader = new StreamReader(resourceStream.Stream)) { string traitsText = reader.ReadToEnd(); List <DatabaseEntry> result = DatabaseReader.LoadFromText(traitsText); LoadVotesFromDatabase(result); } } catch (Exception e) { Console.WriteLine(e); //throw; } }
public void MySqlViaDevartTest() { const string providername = "Devart.Data.MySql"; var connectionString = ConnectionStrings.MySqlDevart; ProviderChecker.Check(providername, connectionString); DatabaseSchemaReader.Utilities.DiscoverProviderFactory.Discover(connectionString, providername); var dbReader = new DatabaseReader(connectionString, providername); dbReader.Owner = "sakila"; var schema = dbReader.ReadAll(); var country = schema.FindTableByName("country"); Assert.AreEqual(3, country.Columns.Count); Assert.IsNotNull(country.PrimaryKeyColumn); var table = dbReader.Table("city"); Assert.AreEqual(4, table.Columns.Count); }
public static void Initialize(Action <string, string> log, string category) { DatabaseReader reader; if (File.Exists("GeoIP2-Country.mmdb")) { reader = new DatabaseReader("GeoIP2-Country.mmdb", MaxMind.Db.FileAccessMode.Memory); log(category, "Loaded GeoIP2-Country.mmdb"); } else if (File.Exists("GeoLite2-Country.mmdb")) { reader = new DatabaseReader("GeoLite2-Country.mmdb", MaxMind.Db.FileAccessMode.Memory); log(category, "Loaded GeoLite2-Country.mmdb"); } else { reader = null; } _instance = new GeoIP(reader); }
public IEnumerable <LogEntry> LoadLogEntries(int?pageNumber = null, int numberPerPage = 10) { var target = Procedures.ErrorLog.LogEntries.LoadLogEntries; var db = new SqlDatabase(target.Connection); using (var command = db.GetStoredProcCommand(target.ProcedureName)) { if (pageNumber != null) { db.AddInParameter(command, "@PageNumber", DbType.Int32, (int)pageNumber); db.AddInParameter(command, "@NumberPerPage", DbType.Int32, numberPerPage); } using (var reader = db.ExecuteReader(command)) { var readerWrapper = new DatabaseReader(reader, target.ProcedureName); return(LogEntryMap.LoadLogEntries(readerWrapper)); } } }
public Task InitializeAsync(IDnsServer dnsServer, string config) { if (_mmCityReader == null) { string mmFile = Path.Combine(dnsServer.ApplicationFolder, "GeoIP2-City.mmdb"); if (!File.Exists(mmFile)) { mmFile = Path.Combine(dnsServer.ApplicationFolder, "GeoLite2-City.mmdb"); } if (!File.Exists(mmFile)) { throw new FileNotFoundException("MaxMind City file is missing!"); } _mmCityReader = new DatabaseReader(mmFile); } return(Task.CompletedTask); }
public Armor(int inputID) { DatabaseConnection conn = new DatabaseConnection(); DatabaseReader reader = conn.QueryRowFromTableWithID("Armor", inputID); ID = inputID; if (reader.NextRow()) { Name = reader.GetStringFromCol("Name"); Description = reader.GetStringFromCol("Description"); FlavorText = reader.GetStringFromCol("Flavor_Text"); int statusConditionsResitancesID = reader.GetIntFromCol("Status_Conditions_Resistances_FK"); StatusConditionsResistances = new StatusConditionsResistances(statusConditionsResitancesID); Physical_Defense = reader.GetIntFromCol("Physical_Defense"); Magic_Defense = reader.GetIntFromCol("Magic_Defense"); } reader.CloseReader(); conn.CloseConnection(); }
/// <summary> /// The return schemas. /// </summary> /// <param name="options"> /// The options. /// </param> /// <returns> /// The <see cref="List"/>. /// </returns> public List <string> ReturnSchemas(object options) { this.Schemas.Clear(); AdoSourceOptions adoOptions = options as AdoSourceOptions; var databaseReader = new DatabaseReader(adoOptions.ConnectionString, adoOptions.ProviderName); this.Schemas.Clear(); IList <DatabaseTable> tables = databaseReader.TableList(); foreach (var table in tables) { if (!this.Schemas.Any(s => s == table.SchemaOwner)) { this.Schemas.Add(table.SchemaOwner); } } this.Schemas = this.Schemas.OrderBy(s => s).ToList(); return(this.Schemas); }
protected virtual OmniResponse GetInformation(string ipAddress) { if (String.IsNullOrEmpty(ipAddress)) { return(null); } try { var databasePath = _webHelper.MapPath("~/App_Data/GeoLite2-Country.mmdb"); var reader = new DatabaseReader(databasePath); var omni = reader.Omni(ipAddress); return(omni); //more info: http://maxmind.github.io/GeoIP2-dotnet/ //more info: https://github.com/maxmind/GeoIP2-dotnet //more info: http://dev.maxmind.com/geoip/geoip2/geolite2/ //Console.WriteLine(omni.Country.IsoCode); // 'US' //Console.WriteLine(omni.Country.Name); // 'United States' //Console.WriteLine(omni.Country.Names["zh-CN"]); // '美国' //Console.WriteLine(omni.MostSpecificSubdivision.Name); // 'Minnesota' //Console.WriteLine(omni.MostSpecificSubdivision.IsoCode); // 'MN' //Console.WriteLine(omni.City.Name); // 'Minneapolis' //Console.WriteLine(omni.Postal.Code); // '55455' //Console.WriteLine(omni.Location.Latitude); // 44.9733 //Console.WriteLine(omni.Location.Longitude); // -93.2323 } //catch (AddressNotFoundException exc) catch (GeoIP2Exception) { //address is not found //do not throw exceptions return(null); } catch (Exception exc) { //do not throw exceptions _logger.Warning("Cannot load MaxMind record", exc); return(null); } }
/// <summary> /// Opens the database using the specified password. /// </summary> /// <param name="dispatcher">The dispatcher.</param> /// <param name="password">The password.</param> /// <param name="savePassword">set to <c>true</c> to save user password.</param> /// <returns>Open result.</returns> public OpenDbResults Open(Dispatcher dispatcher, string password, bool savePassword) { using (var store = IsolatedStorageFile .GetUserStoreForApplication()) { using (var fs = store.OpenFile( DatabasePath, FileMode.Open)) { DbPersistentData xml; try { xml = DatabaseReader.GetXml(fs, password, GetKeyFile(store)); } catch { return(OpenDbResults.CorruptedFile); } if (xml == null) { return(OpenDbResults.IncorrectPassword); } if (savePassword) { Save(store, xml); } else { ClearPassword(); } Open(store, xml, dispatcher); return(OpenDbResults.Success); } } }
public IpGeoBlockMiddleware( OwinMiddleware next, IpGeoBlockOptions options, RemoteIdAddressFunc getRemoteIpAddress = null) : base(next) { if (next == null) { throw new ArgumentNullException(nameof(next)); } if (options == null) { throw new ArgumentNullException(nameof(options)); } // Check if MaxMind GeoLite2 database is available if (string.IsNullOrEmpty(options.GeoLite2Path)) { throw new ArgumentNullException(nameof(options.GeoLite2Path)); } if (!File.Exists(options.GeoLite2Path)) { throw new FileNotFoundException($"MaxMind GeoLit2 Country database is not found at {options.GeoLite2Path}. Please download the database from https://dev.maxmind.com/geoip/geoip2/geolite2/."); } // Check that user added only denied countries or only allowed countries if (options.AllowedCountries.Count > 0 && options.BlockedCountries.Count > 0) { throw new InvalidOperationException("You have to choose only allowed contries or only blocked countries."); } _options = options; _ipDbReader = new DatabaseReader(_options.GeoLite2Path); if (getRemoteIpAddress != null) { _getRemoteIpAddress = getRemoteIpAddress; } }
public static VerifyResults VerifyUnattened(Stream file) { if (file.Length == 0) { return(new VerifyResults { Message = Resources.EmptyFile, Result = VerifyResultTypes.Error, }); } if (!DatabaseReader.CheckSignature(file)) { return(new VerifyResults { Message = Resources.NotKdbx, Result = VerifyResultTypes.Error, }); } var oddTransforms = DatabaseReader .LargeTransformRounds(file); if (oddTransforms) { return(new VerifyResults { Message = Properties.Resources .LargeTransforms, Result = VerifyResultTypes.Warning, }); } file.Position = 0; return(new VerifyResults { Result = VerifyResultTypes.Pass, }); }
public HttpResponseMessage Get() { try { MapDTO dto = new MapDTO() { latitude = "37.09024", longitude = "-95.712891" }; string ip_address = this.Request.GetIPAddress(); //ip_address = "104.185.202.20"; // for testing on localhost, should resolve to Atlanta, GA... using (var objGeoIP2DB = new DatabaseReader(string.Concat(AppDomain.CurrentDomain.BaseDirectory, "App_Data\\GeoIP2-City.mmdb"))) { try { var objGeoIP2 = objGeoIP2DB.City(ip_address); if (objGeoIP2 != null) { dto.latitude = objGeoIP2.Location.Latitude.ToString(); dto.longitude = objGeoIP2.Location.Longitude.ToString(); } } catch { // IP address cannot be resolved } } return(Request.CreateResponse(HttpStatusCode.OK, dto)); } catch (Exception ex) { Exceptions.LogException(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex)); } }
private void DecreaseAffectionOT(int speed) { long diff = System.DateTime.Now.Date.Minute - curMin; UpdatecurMin(); if (diff == 0) { return; } else { int exp = DatabaseReader.Instance().exp; if (exp - speed <= 0) { DatabaseReader.Instance().exp = 0; } else { DatabaseReader.Instance().exp -= speed; } } }
public static List <T> GetPageList <T>(string sql, DbParameter[] param, string OrderBy, int pageIndex, int pageSize, ref int count) { try { StringBuilder strSql = new StringBuilder(); if (pageIndex == 0) { pageIndex = 1; } int num = (pageIndex - 1) * pageSize; int num1 = (pageIndex) * pageSize; strSql.Append("Select * From (Select ROW_NUMBER() Over (" + OrderBy + ")"); strSql.Append(" rowNumber, T.* From (" + sql + ") T ) N Where rowNumber > " + num + " And rowNumber <= " + num1 + ""); count = Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, "Select Count(1) From (" + sql + ") t", param)); IDataReader dr = DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), param); return(DatabaseReader.ReaderToList <T>(dr)); } catch (Exception ex) { throw; } }
public void OnGet() { //Получить местоположение // Затем мы напишем некоторый код, который откроет DatabaseReaderэкземпляр, //а затем вызовет City()метод, передав IP-адрес, который вы хотите найти. // В приложении ASP.NET Core вы можете определить IP-адрес, используя HttpContext.Connection.RemoteIpAddress. // Если мы сможем найти местоположение, мы сохраним его InitialLatitudeи InitialLongitudeполя, //а также установите начальный масштаб, который будет увеличен в этом месте. //Если по какой - то причине взгляд не сработает, мы просто потерпим неудачу. //Нам нужно будет добавить X - Forwarded - For заголовок к нашим запросам. // Я использую Firefox и установил расширение Modify Header Value. // Если вы используете Chrome, вы можете установить расширение ModHeader, // которое позволит вам изменять HTTP-заголовки запросов. // Нам понадобится IP - адрес для тестирования. Самый простой способ - напечатать // «что такое мой IP-адрес» в вашей поисковой системе, и он вам скажет.Я использую DuckDuckGo, но Google сделает то же самое для вас: try { using (var reader = new DatabaseReader(_hostingEnvironment.WebRootPath + "\\GeoLite2-City.mmdb")) { // Определение IP-адреса запроса var ipAddress = HttpContext.Connection.RemoteIpAddress; // Получить город по IP-адресу var city = reader.City(ipAddress); if (city?.Location?.Latitude != null && city?.Location?.Longitude != null) { InitialLatitude = city.Location.Latitude.Value; InitialLongitude = city.Location.Longitude.Value; InitialZoom = 9; } } } catch (Exception e) { // Просто подавите ошибки. Если мы не смогли восстановить местоположение по какой-либо причине // нет причин уведомлять пользователя. Мы просто не будем знать их текущий // расположение и не сможет центрировать карту на нем } }
private void ReadSchemaClick(object sender, EventArgs e) { if (!IsConnectionStringValid()) { return; } var connectionString = ConnectionString.Text.Trim(); var providerName = DataProviders.SelectedValue.ToString(); StartWaiting(); var rdr = new DatabaseReader(connectionString, providerName); var owner = SchemaOwner.Text.Trim(); if (!string.IsNullOrEmpty(owner)) { rdr.Owner = owner; } toolStripStatusLabel1.Text = "Reading..."; backgroundWorker1.RunWorkerAsync(rdr); }
public object GetCBCDataByTaxRefNo(int incLocal, string taxRefNo, int year) { string xml = ""; string jsonString = ""; try { var dsResults = DatabaseReader.GetCBCDataByTaxRefNo(incLocal, taxRefNo, year); if (dsResults.HasRows()) { xml = dsResults.Tables[0].Rows[0][0].ToString(); var doc = new XmlDocument(); doc.LoadXml(xml); jsonString = JsonConvert.SerializeXmlNode(doc); } } catch (Exception x) { throw new Exception(x.Message); } return(jsonString); }
public MainWindow() { InitializeComponent(); ToolStripManager.Renderer = new Office2007Renderer.Office2007Renderer(); toolBar.Renderer = new Office2007Renderer.Office2007Renderer(); this.home.TopLevel = false; panel1.Controls.Clear(); panel1.Controls.Add(this.home); this.home.parentForm = this; this.home.Show(); AppUtilities.mainForm = this; project_name = ProjectConfig.projectSettings["Title"].ToString().ToUpper(); label1.Text = project_name.ToUpper(); currency.Text = ProjectConfig.projectSettings.ContainsKey("Currency") ? ProjectConfig.projectSettings["Currency"].ToString() : "N.A."; setTreeNodes(); DocumentProgressor dpg = new DocumentProgressor(); label4.Text = dpg.completedSteps().ToString() + " /"; label5.Text = dpg.totalSteps().ToString() + " tasks completed"; progressBar1.Maximum = dpg.totalSteps(); progressBar1.Value = dpg.completedSteps(); currencyHandler(); if (dashboard == null) { activateEditMenus(0); } meeting_count = DatabaseReader.getMeetingCount(); button1.Text = meeting_count == 1 ? meeting_count + " Meeting Today" : meeting_count + " Meetings Today"; if (meeting_count > 0) { button1.ImageIndex = 1; button1.Enabled = true; } else { button1.ImageIndex = 0; button1.Enabled = false; } }
public void OnGet() { try { using (var reader = new DatabaseReader(_hostingEnvironment.WebRootPath + "\\GeoLite2-City.mmdb")) { var ipAddress = HttpContext.Connection.RemoteIpAddress; var city = reader.City(ipAddress); if (city?.Location?.Latitude != null && city?.Location?.Longitude != null) { InitialLatitude = city.Location.Latitude.Value; InitialLongitude = city.Location.Longitude.Value; InitialZoom = 9; } } } catch (Exception e) { } }
public CircuitManager() { Instance = this; try { var uri = new Uri("pack://application:,,,/Assets/Locations.txt"); System.Windows.Resources.StreamResourceInfo resourceStream = Application.GetResourceStream(uri); using (var reader = new StreamReader(resourceStream.Stream)) { string traitsText = reader.ReadToEnd(); List <DatabaseEntry> result = DatabaseReader.LoadFromText(traitsText); LoadCircuitsFromDatabase(result, ClimateManager.Instance); } } catch (Exception e) { Console.WriteLine(e); //throw; } }
public void CacheTest() { // <system.data> // <DbProviderFactories> //<add name="InterSystems Data Provider" // invariant="InterSystems.Data.CacheClient" // description="InterSystem .Net Data Provider" // type="InterSystems.Data.CacheClient.CacheFactory, // Intersystems.Data.CacheClient, Version=2.0.0.1, Culture=neutral, PublicKeyToken=ad350a26c4a4447c" // /> // </DbProviderFactories> // </system.data> const string providername = "InterSystems.Data.CacheClient"; const string connectionString = "Server=localhost; Port=1972; Namespace=SAMPLES;Password=SYS; User ID=_SYSTEM;"; ProviderChecker.Check(providername, connectionString); var dbReader = new DatabaseReader(connectionString, providername); var schema = dbReader.ReadAll(); Assert.IsTrue(schema.Tables.Count > 0); }
private string GetUserRequestLocation() { UserIp = DayaxeDal.Ultility.Ip.GetIpAddress(); if (Session[UserIp] != null) { return(Session[UserIp].ToString()); } using (var reader = new DatabaseReader(Server.MapPath("/App_Data/GeoLite2-City.mmdb"))) { if (UserIp == "::1") { UserIp = "134.201.250.155"; // Los Angeles IP Address } CityResponse response; if (reader.TryCity(UserIp, out response)) { Session[UserIp] = response.City.Name; return(response.City.Name); } return(string.Empty); } }
public void TestAccess2007() { const string providername = "System.Data.OleDb"; const string dir = @"C:\Data\Nwind.accdb"; if (!File.Exists(dir)) { Assert.Inconclusive("Access test requires database file " + dir); } const string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + dir; ProviderChecker.Check(providername, connectionString); DiscoverProviderFactory.Discover(connectionString, providername); var dbReader = new DatabaseReader(connectionString, providername); var schema = dbReader.ReadAll(); var table = schema.FindTableByName("Products"); Assert.IsTrue(table.Columns.Count > 0); }
public string GetCountryFromIp(string ip) { var cacheKey = $"PersonalisationGroups_Criteria_Country_GeoLocation_{ip}"; var cachedItem = ApplicationContext.Current.ApplicationCache.RuntimeCache .GetCacheItem(cacheKey, () => { try { using (var reader = new DatabaseReader(_pathToDb)) { try { var response = reader.Country(ip); var isoCode = response.Country.IsoCode; if (!string.IsNullOrEmpty(isoCode)) { HttpRuntime.Cache.Insert(cacheKey, isoCode, null, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration); } return(isoCode); } catch (AddressNotFoundException) { return(string.Empty); } } } catch (FileNotFoundException) { throw new FileNotFoundException( $"MaxMind Geolocation database required for locating visitor country from IP address not found, expected at: {_pathToDb}. The path is derived from either the default ({AppConstants.DefaultGeoLocationCountryDatabasePath}) or can be configured using a relative path in an appSetting with key: \"{AppConstants.ConfigKeys.CustomGeoLocationCountryDatabasePath}\"", _pathToDb); } }); return(cachedItem?.ToString() ?? string.Empty); }
public static IEnumerable <LogEntry> LoadLogEntries(DatabaseReader readerWrapper) { var returnValue = new List <LogEntry>(); using (readerWrapper) { while (readerWrapper.Read()) { var logEntry = new LogEntry { Id = readerWrapper.GetInt32("LogId"), Entry = readerWrapper.GetString("LogEntry"), CreatedOn = readerWrapper.GetDateTime("CreatedOn"), CreatedBy = readerWrapper.GetString("CreatedBy") }; returnValue.Add(logEntry); } } return(returnValue); }
public void Enterprise_ValidResponse() { using var reader = new DatabaseReader(_enterpriseDatabaseFile); var ipAddress = "74.209.24.0"; var response = reader.Enterprise(ipAddress); Assert.Equal(11, response.City.Confidence); Assert.Equal(99, response.Country.Confidence); Assert.False(response.Country.IsInEuropeanUnion); Assert.Equal(6252001, response.Country.GeoNameId); Assert.Equal(27, response.Location.AccuracyRadius); Assert.False(response.RegisteredCountry.IsInEuropeanUnion); Assert.False(response.RepresentedCountry.IsInEuropeanUnion); Assert.Equal("Cable/DSL", response.Traits.ConnectionType); Assert.True(response.Traits.IsLegitimateProxy); Assert.Equal(ipAddress, response.Traits.IPAddress); Assert.Equal("74.209.16.0/20", response.Traits.Network?.ToString()); response = reader.Enterprise("149.101.100.0"); Assert.Equal("310", response.Traits.MobileCountryCode); Assert.Equal("004", response.Traits.MobileNetworkCode); }
static void Main() { Console.WriteLine("Hello from Nullable Types"); DatabaseReader dr = new DatabaseReader(); int? i = dr.GetIntFromDatabase(); if (i != null) { Console.WriteLine("value of (i) is : {0}", i.Value); } else { Console.WriteLine("value of (i) is not defined"); } bool?b = dr.GetBoolFromDatabase(); if (b != null) { Console.WriteLine("value of (b) is {0}", b.Value); } else { Console.WriteLine("value of (b) is not defined"); } int?myData = dr.GetIntFromDatabase() ?? 100; Console.WriteLine("value of myData is {0}", myData.Value); Console.ReadLine(); int?moreData = dr.GetIntFromDatabase(); if (!moreData.HasValue) { moreData = 100; } Console.WriteLine("value of moreData is {0}", moreData.Value); }
public MainWindow(DatabaseReader reader, Uploader uploader) { InitializeComponent(); this.DataContext = this; _reader = reader; _uploader = uploader; Events = new ObservableCollection <LogItem>(); UploadQueue = new ConcurrentQueue <UploadEvent>(); ActiveOnly = true; ((CollectionViewSource)this.Resources["FilteredTournaments"]).Filter += (sender, e) => { TrackableTournament t = e.Item as TrackableTournament; e.Accepted = !ActiveOnly || t.Tournament.Active; }; _worker = new UploadWorker(this.UploadQueue, this.AddEvent); _workerThread = new Thread(_worker.DoUpload); _workerThread.IsBackground = true; _workerThread.Start(); Tournaments = new ObservableCollection <TrackableTournament>(from t in _reader.getAllTournaments() select new TrackableTournament(t)); new CheckTournamentsDelegate(CheckTournaments).BeginInvoke(null, null); }
private void DecreaseHungerOT(int speed) { long diff = System.DateTime.Now.Date.Minute - curMin; UpdatecurMin(); if (diff == 0) { return; } else { int hunger = DatabaseReader.Instance().hunger; if (hunger - speed <= 0) { DatabaseReader.Instance().hunger = 0; } else { DatabaseReader.Instance().hunger -= speed; } } }
public void TestLocaleList() { using (var reader = new DatabaseReader(_databaseFile, new List<string> { "xx", "ru", "pt-BR", "es", "en" })) { var resp = reader.Omni("81.2.69.160"); Assert.That(resp.City.Name, Is.EqualTo("Лондон")); } }
public void TestDefaultLocale() { using (var reader = new DatabaseReader(_databaseFile)) { var resp = reader.City("81.2.69.160"); Assert.That(resp.City.Name, Is.EqualTo("London")); } }
public GeoIP() { Target = "geoip"; DatabaseFileName = Path.Combine(AssemblyDirectory, "GeoLite2City.mmdb"); dr = new DatabaseReader(DatabaseFileName); }
public void Metadata() { using (var reader = new DatabaseReader(Path.Combine(_databaseDir, "GeoIP2-Domain-Test.mmdb"))) { Assert.That(reader.Metadata.DatabaseType, Is.EqualTo("GeoIP2-Domain")); } }
public void UnknownAddress() { using (var reader = new DatabaseReader(_databaseFile)) { reader.City("10.10.10.10"); } }
public void TestStreamConstructor() { using (StreamReader streamReader = new StreamReader(_databaseFile)) { using (var reader = new DatabaseReader(streamReader.BaseStream)) { var resp = reader.City("81.2.69.160"); Assert.That(resp.City.Name, Is.EqualTo("London")); } } }
public void TestMemoryMode() { using (var reader = new DatabaseReader(_databaseFile, FileAccessMode.Memory)) { var resp = reader.City("81.2.69.160"); Assert.That(resp.City.Name, Is.EqualTo("London")); } }
public void InvalidMethod() { using (var reader = new DatabaseReader(_databaseFile)) { reader.Country("10.10.10.10"); } }
public void TestWithIPAddress() { using (var reader = new DatabaseReader(_databaseFile)) { var resp = reader.City(IPAddress.Parse("81.2.69.160")); Assert.That(resp.City.Name, Is.EqualTo("London")); } }
public void TestCountryWithIPAddress() { using (var reader = new DatabaseReader(Path.Combine(_databaseDir, "GeoIP2-Country-Test.mmdb"))) { var resp = reader.Country(IPAddress.Parse("81.2.69.160")); Assert.That(resp.Country.IsoCode, Is.EqualTo("GB")); } }