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