public List <Indihiang.DomainObject.IPCountry> GetAllIpCountry() { SQLiteConnection con = null; SQLiteDataReader rd = null; List <Indihiang.DomainObject.IPCountry> list = new List <Indihiang.DomainObject.IPCountry>(); try { con = new SQLiteConnection(GetConnectionStrng()); con.Open(); string query = "SELECT ip_start,ip_end,country_name FROM ip_country"; SQLiteCommand cmd = new SQLiteCommand(query, con); rd = cmd.ExecuteReader(); while (rd.Read()) { Indihiang.DomainObject.IPCountry obj = new Indihiang.DomainObject.IPCountry(); if (!rd.IsDBNull(rd.GetOrdinal("ip_start"))) { obj.IpStart = Convert.ToDouble(rd["ip_start"]); } else { obj.IpStart = 0; } if (!rd.IsDBNull(rd.GetOrdinal("ip_end"))) { obj.IpEnd = Convert.ToDouble(rd["ip_end"]); } else { obj.IpEnd = 0; } if (!rd.IsDBNull(rd.GetOrdinal("country_name"))) { obj.CoutryName = (string)rd["country_name"]; } list.Add(obj); } } catch (Exception err) { System.Diagnostics.Debug.WriteLine(err.StackTrace); } finally { if (rd != null) { rd.Close(); } if (con != null) { con.Close(); } } return(list); }
public List <Indihiang.DomainObject.IPCountry> GetAllIpCountry() { List <Indihiang.DomainObject.IPCountry> list = new List <Indihiang.DomainObject.IPCountry>(); if (Indihiang.Properties.Settings.Default.FindCountries == false) { return(list); } SQLiteConnection con = null; SQLiteDataReader rd = null; try { con = new SQLiteConnection(GetConnectionStrng()); con.Open(); string query = "SELECT ip_start,ip_end,country_name FROM ip_country"; SQLiteCommand cmd = new SQLiteCommand(query, con); rd = cmd.ExecuteReader(); while (rd.Read()) { Indihiang.DomainObject.IPCountry obj = new Indihiang.DomainObject.IPCountry(); if (!rd.IsDBNull(rd.GetOrdinal("ip_start"))) { obj.IpStart = Convert.ToDouble(rd["ip_start"]); } else { obj.IpStart = 0; } if (!rd.IsDBNull(rd.GetOrdinal("ip_end"))) { obj.IpEnd = Convert.ToDouble(rd["ip_end"]); } else { obj.IpEnd = 0; } if (!rd.IsDBNull(rd.GetOrdinal("country_name"))) { obj.CoutryName = (string)rd["country_name"]; } list.Add(obj); } } catch (Exception err) { System.Diagnostics.Debug.WriteLine(err.StackTrace); System.Windows.Forms.MessageBox.Show("There was an error reading the country IP ranges.\n\nHave you installed the \'ipcountry.db\' database into (User Profile Application Data)\\Indihiang\\Media?\n\nException: " + err.Message, "Exception", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Warning); } finally { if (rd != null) { rd.Close(); } if (con != null) { con.Close(); } } return(list); }