public ExperienceInfo InsertExperienceInfo(string keycode, string sql)
{
// Open database (or create if not exits)
ExperienceInfo ExperienceInfo = null;
if (FindCountExperienceInfoEntry(keycode) <= 0)
{
using (var db = new LiteDatabase(DatabaseLocation))
{
// Get customer collection
var ExperienceInfos = db.GetCollection <ExperienceInfo>(schemaName);
// Create your new customer instance
ExperienceInfo = new ExperienceInfo
{
KeyCode = keycode,
Stamp = DateTime.Now,
Info = sql,
IsActive = true
};
ExperienceInfos.EnsureIndex(x => x.KeyCode);
ExperienceInfos.EnsureIndex(x => x.Stamp);
ExperienceInfos.Insert(ExperienceInfo);
return(ExperienceInfo);
}
}
return(ExperienceInfo);
}
public bool UpdateExperienceInfo(ExperienceInfo data)
{
// Open database (or create if not exits)
using (var db = new LiteDatabase(DatabaseLocation))
{
var ExperienceInfos = db.GetCollection <ExperienceInfo>(schemaName);
return(ExperienceInfos.Update(data));
}
}
