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