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