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