public List <Word> GetAllWordsBySpecificLanguage(int languageId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return((from words in context.Words where words.LanguageId == languageId select words).ToList());
}
}
public List <Word> GetAllWords()
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Words.ToList());
}
}
public List <User> GetUsersFromIntervalByRoleId(int startOfInterval, int endOfInterval, int roleId = 0)
{
using (var context = new WorldOfWordsDatabaseContext())
{
if (startOfInterval >= context.Users.Count() || startOfInterval < 0 ||
startOfInterval > endOfInterval || endOfInterval > context.Users.Count())
{
throw new System.ArgumentException("Start of interval is bigger than end");
}
if (roleId != 0)
{
return(context.Users
.Include(item => item.Roles)
.OrderBy(item => item.Name)
.Where(item => item.Roles.Any(local => local.Id == roleId))
.Skip(startOfInterval)
.Take(endOfInterval - startOfInterval)
.ToList());
}
else
{
return(context.Users
.Include(item => item.Roles)
.OrderBy(item => item.Name)
.Skip(startOfInterval)
.Take(endOfInterval - startOfInterval)
.ToList());
}
}
}
public List <Group> GetAll(int userId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Groups.Where(g => g.OwnerId == userId).Include(group => group.Course).ToList());
}
}
/// <summary>
/// Returns a list of all languages in the database.
/// </summary>
/// <returns></returns>
public List <Language> GetAllLanguages()
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Languages.ToList());
}
}
public bool RemoveProgressesForEnrollment(int enrollmentId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
try
{
Enrollment enrollment = context.Enrollments.FirstOrDefault(e => e.Id == enrollmentId);
if (enrollment == null)
{
return(false);
}
List <int> originalWordsuitesIds = enrollment.Group.Course.WordSuites.Where(w => w.PrototypeId == null).Select(w => w.Id).ToList();
var wordsuitesToDeleteFrom = enrollment.Group.Course.WordSuites
.Where(w => w.OwnerId == enrollment.User.Id && w.PrototypeId != null &&
originalWordsuitesIds.Contains((int)w.PrototypeId)).ToList();
context.WordProgresses.RemoveRange(wordsuitesToDeleteFrom.SelectMany(ws => ws.WordProgresses));
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public int GetAmountOfWordTranslationsByLanguage(int langID)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.WordTranslations.Where(item => item.OriginalWord.LanguageId == langID).Count());
}
}
public List <Enrollment> GetByGroupId(int groupId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Enrollments.Where(e => e.GroupId == groupId).Include(e => e.User).OrderBy(e => e.User.Name).ToList());
}
}
public Group GetById(int groupId, int userId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Groups.Where(g => g.OwnerId == userId).Include(g => g.Course).FirstOrDefault(g => g.Id == groupId));
}
}
public WordTranslation GetWordTranslationById(int id)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.WordTranslations.Where(item => item.Id == id).FirstOrDefault());
}
}
public bool CheckIfGroupNameExists(GroupModel groupModel)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var group = context.Groups.FirstOrDefault(g => g.Name == groupModel.Name);
return(group != null);
}
}
public void Delete(int courseId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
context.Courses.Remove(context.Courses.First(x => x.Id == courseId));
context.SaveChanges();
}
}
public bool Exists(IncomingUser user)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Users.Any(users => users.Email.ToLower() == user.Email.ToLower()) ||
context.IncomingUsers.Any(users => users.Email.ToLower() == user.Email.ToLower()));
}
}
public void Add(IncomingUser user)
{
using (var context = new WorldOfWordsDatabaseContext())
{
context.IncomingUsers.AddOrUpdate(user);
context.SaveChanges();
}
}
public int GetAmountOfUsersByRoleId(int roleId = 0)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return((roleId == 0) ? context.Users.Include(item => item.Roles).Count()
: context.Users.Include(item => item.Roles).Where(item => item.Roles.Any(local => local.Id == roleId)).Count());
}
}
public bool CheckUserPassword(string checkPassword, int userId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var user = context.Users.FirstOrDefault(u => u.Id == userId);
return((user != null) && (VerifyPasswords(user.Password, checkPassword)));
}
}
public bool CheckUserName(string checkName, int userId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var user = context.Users.FirstOrDefault(u => u.Id == userId);
return((user != null) && (user.Name == checkName));
}
}
public int Add(Tag tag)
{
using (var context = new WorldOfWordsDatabaseContext())
{
context.Tags.Add(tag);
context.SaveChanges();
return(tag.Id);
}
}
public List <WordSuite> GetWordSuitesByOwnerAndLanguageId(int userId, int languageId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.WordSuites.
Where(ws => ws.OwnerId == userId && ws.PrototypeId == null && ws.LanguageId == languageId).
ToList());
}
}
public int Exists(string name)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var tag = context.Tags.FirstOrDefault(t => t.Name == name);
return(tag != null ? tag.Id : 0);
}
}
public int Add(WordSuite wordSuite)
{
using (var context = new WorldOfWordsDatabaseContext())
{
context.WordSuites.AddOrUpdate(wordSuite);
context.SaveChanges();
return(wordSuite.Id);
}
}
public int Add(WordTranslation wordTranslation)
{
using (var context = new WorldOfWordsDatabaseContext())
{
context.WordTranslations.Add(wordTranslation);
context.SaveChanges();
return(wordTranslation.Id);
}
}
public List <Course> GetAllCourses(int userId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.Courses.
Where(c => c.OwnerId == userId).
Include(course => course.WordSuites).
Include(course => course.Language).ToList());
}
}
public int GetAmountOfWordsBySearchValues(string searchValue, int languageId)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context.WordTranslations
.Where(w => w.OriginalWord.LanguageId == languageId &&
(w.OriginalWord.Value.Contains(searchValue) || w.TranslationWord.Value.Contains(searchValue)))
.Count());
}
}
public List <User> GetAllUsers()
{
List <User> result;
using (var context = new WorldOfWordsDatabaseContext())
{
result = context.Users.Include(u => u.Roles).ToList();
}
return(result);
}
public void ChangePassword(ForgotPasswordUserModel model)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var targetUser =
context.Users.First(user => user.Id.ToString() == model.Id);
targetUser.Password = _passwordHasher.HashPassword(model.Password);
context.SaveChanges();
}
}
public List <User> SearchByNameAndRole(string name, int roleid = 0)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var neededUsers = context.Users
.Include("Roles")
.Where(item => item.Name.StartsWith(name));
return((roleid == 0) ? neededUsers.ToList() : neededUsers.Where(item => item.Roles.Any(local => local.Id == roleid)).ToList());
}
}
public bool IsStudentWord(WordProgress wordProgress)
{
using (var context = new WorldOfWordsDatabaseContext())
{
return(context
.WordProgresses
.Single(wp => wp.WordSuiteId == wordProgress.WordSuiteId &&
wp.WordTranslationId == wordProgress.WordTranslationId).IsStudentWord);
}
}
public bool Add(GroupModel groupModel)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var newGroup = _mapper.MapToGroup(groupModel);
context.Groups.Add(newGroup);
context.SaveChanges();
return(true);
}
}
public void SetTime(int id)
{
using (var context = new WorldOfWordsDatabaseContext())
{
var suite = context
.WordSuites
.First(ws => ws.Id == id);
suite.QuizStartTime = DateTime.Now;
context.SaveChanges();
}
}
