public bool addResultPerCategory(List <ResultPerCategory> resPerCategory) { try { foreach (ResultPerCategory res in resPerCategory) { ResultsPerCategory resultPerCategoryRow = new ResultsPerCategory() { UserId = res.userId, Category = res.category, Lvl = res.lvl, Counter = 0 }; db.Add(resultPerCategoryRow); } db.SaveChanges(); return(true); } catch (Exception e) { Debug.WriteLine(e.StackTrace); Debug.WriteLine(e.Message); return(false); } }
public bool updateResultsPerCategory(List <ResultPerCategory> resPerCat) { try { foreach (ResultPerCategory updateResult in resPerCat) { ResultsPerCategory result = db.ResultsPerCategory.Find(updateResult.userId, updateResult.category); result.Lvl = updateResult.lvl; result.Counter = updateResult.counter; } db.SaveChanges(); return(true); } catch (Exception e) { Debug.WriteLine(e.StackTrace); Debug.WriteLine(e.Message); return(false); } }