public async Task <bool> SaveRecord() { bool bOK = true; try { using (var db = new DbContextScores()) { db.Scores.Add(this); await db.SaveChangesAsync(); } } catch (Exception ex) { Logger.Instance.Error($"SaveRecord exception, {ex.Message}"); bOK = false; } return(bOK); }
// load all score records public static bool LoadAllRecords(out List <Score> results) { bool bOK = true; results = new List <Score>(); try { using (var db = new DbContextScores()) { db.Database.EnsureCreated(); results = db.Scores.OrderByDescending(item => item.Points).ToList(); } } catch (Exception ex) { Logger.Instance.Error($"LoadAllRecords exception, {ex.Message}"); bOK = false; } return(bOK); }
// get new score rank public static bool GetScoreRank(int score, out int ranking) { bool bOK = true; ranking = 1; try { using (var db = new DbContextScores()) { db.Database.EnsureCreated(); var count = db.Scores.Where(item => item.Points > score).Count(); ranking = count + 1; } } catch (Exception ex) { Logger.Instance.Error($"GetScoreRank exception, {ex.Message}"); bOK = false; } return(bOK); }
// delete all scores internal static async Task <bool> DeleteAllRecords() { bool bOK = true; try { using (var db = new DbContextScores()) { foreach (var score in db.Scores) { db.Scores.Remove(score); } await db.SaveChangesAsync(); } } catch (Exception ex) { Logger.Instance.Error($"DeleteAllRecords exception, {ex.Message}"); bOK = false; } return(bOK); }