public bool CreateBackupInfo(string infoName, object value) { try { using (var db = new LiteDatabase(@"Database\MyDatabase.db")) { //Looking for Objective var col = db.GetCollection <BackupOfflineInfo>("BackupOfflineInfos"); var test = col.Find(x => x.infoName == infoName).FirstOrDefault(); if (test != null) { return(false); //Already exist } //Update Info for Objective var backupOfflineInfo = new BackupOfflineInfo { infoName = infoName, value = value, LastUpdate = DateTime.Now }; col.Insert(backupOfflineInfo); //Write to database var result = col.Update(backupOfflineInfo); return(result); } } catch (Exception ex) { return(false); } }
//Ini for CFP Offline database //Create Default LiteDB of CFP: "Database\MyDatabase.db" if not yet exist public void IniDatabase() { //Check if Database file already exist or not string databaseFilePath = AppDomain.CurrentDomain.BaseDirectory + @"Database\MyDatabase.db"; if (System.IO.File.Exists(databaseFilePath) == true) { return; } // Open database (or create if doesn't exist) using (var db = new LiteDatabase(@"Database\MyDatabase.db")) { //Ini for CFP System Information var collection = db.GetCollection <CFPSystemInfo>("CFPSystemInfos"); var cfpSystemInfo = new CFPSystemInfo { isFirstRun = true, CFPVersion = "0.0.0.0", ProtectionCode = "00000000-00000000", LastUpdate = DateTime.Now }; collection.Insert(cfpSystemInfo); collection.Update(cfpSystemInfo); //Ini for General Offline Backup Info var col = db.GetCollection <BackupOfflineInfo>("BackupOfflineInfos"); var backupOfflineInfo = new BackupOfflineInfo { infoName = "FirstRun", value = "For Ini Database only!" }; // Create unique index in Name field col.EnsureIndex(x => x.infoName, true); col.Insert(backupOfflineInfo); col.Update(backupOfflineInfo); } }