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);
}
}
