private string GetGeocachePostion(string code) { string result = ""; if (!string.IsNullOrEmpty(code) && !string.IsNullOrEmpty(Settings.Settings.Default.DatabaseFolderPath) && !string.IsNullOrEmpty(Settings.Settings.Default.SelectedDatabase) ) { try { var fn = System.IO.Path.Combine(Settings.Settings.Default.DatabaseFolderPath, Settings.Settings.Default.SelectedDatabase, "sqlite.db3"); if (System.IO.File.Exists(fn)) { using (var temp = new Database.DBConSqlite(fn)) using (var db = new NPoco.Database(temp.Connection, NPoco.DatabaseType.SQLite)) { var wp = db.FirstOrDefault<DataTypes.GSAKCaches>("select * from Caches where Code=@0", code); var wpc = db.FirstOrDefault<DataTypes.GSAKCorrected>("select * from Corrected where kCode=@0", code); if (wpc != null && !string.IsNullOrEmpty(wpc.kAfterLat) && !string.IsNullOrEmpty(wpc.kAfterLon)) { result = Utils.Conversion.GetCoordinatesPresentation(Utils.Conversion.StringToDouble(wpc.kAfterLat), Utils.Conversion.StringToDouble(wpc.kAfterLon)); } else if (!string.IsNullOrEmpty(wp.Latitude) && !string.IsNullOrEmpty(wp.Longitude)) { result = Utils.Conversion.GetCoordinatesPresentation(Utils.Conversion.StringToDouble(wp.Latitude), Utils.Conversion.StringToDouble(wp.Longitude)); } } } } catch { } } return result; }
public GeocacheCollection GetCollection(string name, bool createIfNotExists = false) { GeocacheCollection result = null; if (!string.IsNullOrEmpty(name)) { lock (this) { if (_dbcon != null) { using (var db = new NPoco.Database(_dbcon.Connection, NPoco.DatabaseType.SQLite)) { result = db.FirstOrDefault <GeocacheCollection>("where Name like @0", name); if (result == null && createIfNotExists) { //just the lazy way var record = db.FirstOrDefault <GeocacheCollection>("order by CollectionID desc limit 1"); result = new GeocacheCollection(); result.Name = name; result.CollectionID = record == null ? 1 : record.CollectionID + 1; db.Insert(result); } } } } } return(result); }
//---------------------------------------------------------------------------------------------------------------- public static Breach CheckIfBreachExistsInDatabase(string Title) { //Check database to see if Title passed in exists in the Breach table Breach breach = db.FirstOrDefault <Breach>("SELECT * FROM Breach WHERE Title= @0 ", Title); return(breach); }
//---------------------------------------------------------------------------------------------------------------- public static Breached_Emails CheckIfEmailExistsInDatabase(Breached_Emails breachedEmailsObj) { Breached_Emails breachedEmails = db.FirstOrDefault <Breached_Emails>("SELECT * FROM Breached_Emails WHERE ID= @0 AND Email= @1" , breachedEmailsObj.ID, breachedEmailsObj.Email); return(breachedEmails); }
private object GetWaypointPostion(string wpt) { string result = ""; if (!string.IsNullOrEmpty(Settings.Settings.Default.ActiveGeocacheCode) && !string.IsNullOrEmpty(Settings.Settings.Default.DatabaseFolderPath) && !string.IsNullOrEmpty(Settings.Settings.Default.SelectedDatabase) ) { try { var fn = System.IO.Path.Combine(Settings.Settings.Default.DatabaseFolderPath, Settings.Settings.Default.SelectedDatabase, "sqlite.db3"); if (System.IO.File.Exists(fn)) { using (var temp = new Database.DBConSqlite(fn)) using (var db = new NPoco.Database(temp.Connection, NPoco.DatabaseType.SQLite)) { var wp = db.FirstOrDefault <DataTypes.GSAKWaypoints>("select * from Waypoints where cCode=@0", wpt); if (!string.IsNullOrEmpty(wp.cLat) && !string.IsNullOrEmpty(wp.cLon)) { result = Utils.Conversion.GetCoordinatesPresentation(Utils.Conversion.StringToDouble(wp.cLat), Utils.Conversion.StringToDouble(wp.cLon)); } } } } catch { } } return(result); }
public DTO.Database.CurrencyExchangeRateDto CurrencyExchangeRate(DateTime date, string currencyCode) { DTO.Database.CurrencyExchangeRateDto result; using (NPoco.IDatabase dbContext = new NPoco.Database(DTO.Global.SQLConnectionString, NPoco.DatabaseType.SqlServer2012)) { result = dbContext.FirstOrDefault <DTO.Database.CurrencyExchangeRateDto>("SELECT * FROM tbl_CurrencyExchangeRate WHERE CurrencyExchangeRateShortDate = " + Helper.DateHelper.ShortDate(date) + " AND CurrencyCode = '" + currencyCode + "'"); } return(result); }
private string GetGeocachePostion(string code) { string result = ""; if (!string.IsNullOrEmpty(code) && !string.IsNullOrEmpty(Settings.Settings.Default.DatabaseFolderPath) && !string.IsNullOrEmpty(Settings.Settings.Default.SelectedDatabase) ) { try { var fn = System.IO.Path.Combine(Settings.Settings.Default.DatabaseFolderPath, Settings.Settings.Default.SelectedDatabase, "sqlite.db3"); if (System.IO.File.Exists(fn)) { using (var temp = new Database.DBConSqlite(fn)) using (var db = new NPoco.Database(temp.Connection, NPoco.DatabaseType.SQLite)) { var wp = db.FirstOrDefault <DataTypes.GSAKCaches>("select * from Caches where Code=@0", code); var wpc = db.FirstOrDefault <DataTypes.GSAKCorrected>("select * from Corrected where kCode=@0", code); if (wpc != null && !string.IsNullOrEmpty(wpc.kAfterLat) && !string.IsNullOrEmpty(wpc.kAfterLon)) { result = Utils.Conversion.GetCoordinatesPresentation(Utils.Conversion.StringToDouble(wpc.kAfterLat), Utils.Conversion.StringToDouble(wpc.kAfterLon)); } else if (!string.IsNullOrEmpty(wp.Latitude) && !string.IsNullOrEmpty(wp.Longitude)) { result = Utils.Conversion.GetCoordinatesPresentation(Utils.Conversion.StringToDouble(wp.Latitude), Utils.Conversion.StringToDouble(wp.Longitude)); } } } } catch { } } return(result); }
public ScriptItem GetScriptItem(string name) { ScriptItem result = null; lock (this) { if (_dbcon != null) { using (var db = new NPoco.Database(_dbcon.Connection, NPoco.DatabaseType.SQLite)) { result = db.FirstOrDefault <ScriptItem>("select * from Scripts where Name=@0", name); } } } return(result); }
public void StoreScriptItem(ScriptItem item) { lock (this) { if (_dbcon != null) { using (var db = new NPoco.Database(_dbcon.Connection, NPoco.DatabaseType.SQLite)) { if (db.FirstOrDefault <ScriptItem>("select * from Scripts where Name=@0", item.Name) == null) { db.Insert("Scripts", null, item); } else { db.Update("Scripts", "Name", item); } } } } }
private object GetWaypointPostion(string wpt) { string result = ""; if (!string.IsNullOrEmpty(Settings.Settings.Default.ActiveGeocacheCode) && !string.IsNullOrEmpty(Settings.Settings.Default.DatabaseFolderPath) && !string.IsNullOrEmpty(Settings.Settings.Default.SelectedDatabase) ) { try { var fn = System.IO.Path.Combine(Settings.Settings.Default.DatabaseFolderPath, Settings.Settings.Default.SelectedDatabase, "sqlite.db3"); if (System.IO.File.Exists(fn)) { using (var temp = new Database.DBConSqlite(fn)) using (var db = new NPoco.Database(temp.Connection, NPoco.DatabaseType.SQLite)) { var wp = db.FirstOrDefault<DataTypes.GSAKWaypoints>("select * from Waypoints where cCode=@0", wpt); if (!string.IsNullOrEmpty(wp.cLat) && !string.IsNullOrEmpty(wp.cLon)) { result = Utils.Conversion.GetCoordinatesPresentation(Utils.Conversion.StringToDouble(wp.cLat), Utils.Conversion.StringToDouble(wp.cLon)); } } } } catch { } } return result; }