public void AddSimilarUsers(List <UsersSimilarity> similarUsers, int settingsVersion) { using (var db = new BooksRecomendationsEntities()) { var users = similarUsers.Select(x => MapToUserSimilarDataModel(x, settingsVersion)).ToList(); db.UserSimilars.AddRange(users); db.SaveChanges(); } }
public void AddTestResult(List <BookScore> score, int settingVersion) { using (var db = new BooksRecomendationsEntities()) { var result = score.Where(x => x.PredictedRate > 0) .Select(bookScore => MapScoreToTest(bookScore, settingVersion)); db.Tests.AddRange(result); db.SaveChanges(); } }
public void SaveParametersSet(Parameter parameter) { using (var db = new BooksRecomendationsEntities()) { var temp = db.Parameters.Find(parameter.Id); if (temp == null) { db.Parameters.Add(parameter); } db.SaveChanges(); } }
public void AddTestResults(List <BookScore[]> scores, int settingVersion) { using (var db = new BooksRecomendationsEntities()) { var result = new List <Test>(); foreach (var score in scores) { result.AddRange(score.Select(bookScore => MapScoreToTest(bookScore, settingVersion))); } db.Tests.AddRange(result); db.SaveChanges(); } }
public void AddRecommendedBooksForUser(BookScore[] books, int userId) { using (var db = new BooksRecomendationsEntities()) { //delete any if exist db.Database.ExecuteSqlCommand("Delete from BookRecomendation where UserId=@userId", new SqlParameter("@userId", userId)); if (books != null) { db.BookRecomendations.AddRange(books.Select(x => MapToBookRecommendationModel(x, userId))); } db.SaveChanges(); } }