public List<User> GetBestUsers(int count) { List<User> lst; using (var db = new DataContext()) { lst = db.Users.OrderByDescending(user => user.Rate).Take(count).ToList(); } return lst; }
public CourseDatabase() { Context = new DataContext(); Tasks = new TaskRepository(Context); Users = new UserRepository(Context); Tags = new TagsRepository(Context); Answers = new AnswerRepository(Context); Search = new SearchRepository(); }
public List<Tag> GetPopularTags(int count) { List<Tag> lst; using (var db = new DataContext()) { lst = db.Tags.OrderBy(tag => tag.Tasks.Count()).Take(count).ToList(); } return lst; }
/// <summary> /// Delete Task specified in TaskModel. /// </summary> /// <param name="deleteTaskModel">TaskModel of Task to delete.</param> public void DeleteTask(TaskModel deleteTaskModel) { using (var db = new DataContext()) { var userProvider = new UserProvider(); User currentUser = userProvider.GetCurrentUser(db); var deletingTask = currentUser.Tasks.FirstOrDefault(deleteTask => deleteTask.Title == deleteTaskModel.Title); currentUser.Tasks.Remove(deletingTask); db.SaveChanges(); } }
public void AddTask(TaskModel model) { using (var db = new DataContext()) { var tag = new Tag {TagId = Guid.NewGuid(), TagName = "dasd"}; var newTask = new Task { TaskId = Guid.NewGuid(), Title = model.Title, CreationDate = DateTime.UtcNow, }; db.Tags.Add(tag); newTask.Tags.Add(tag); var userProvider = new UserProvider(); userProvider.GetCurrentUser(db).Tasks.Add(newTask); newTask.UserOwner = userProvider.GetCurrentUser(db); db.Tasks.Add(newTask); db.SaveChanges(); } }
private IEnumerable<Tag> InitializeTags(DataContext db,IEnumerable<String> tagNames) { var tags = new List<Tag>(); foreach (var tagString in tagNames) { var tag = db.Tags.Create(); tag.TagId = Guid.NewGuid(); tag.TagName = tagString; tags.Add(tag); } return tags; }
public void LikeTask(Guid id) { using (var db = new DataContext()) { var userProvider = new UserProvider(); Task task = GetTaskById(id); if (!userProvider.IsUserLikedTask(db,task)) { userProvider.AddTaskLiked(db,task); IncrementLikes(id); // DbContext.Entry(user).State = EntityState.Modified; db.SaveChanges(); } } }
public Task GetTaskById(Guid id) { using (var db = new DataContext()) { return db.Tasks.FirstOrDefault(task => task.TaskId == id); } }
public List<Task> GetLastTasks() { List<Task> lst; using (var db = new DataContext()) { lst = db.Tasks.OrderByDescending(task => task.CreationDate).Take(10).ToList(); } return lst; }
public static MembershipCreateStatus Register(string username, string password, string email, bool IsApproved) { MembershipCreateStatus createStatus; System.Web.Security.Membership.CreateUser(username, password, email, null, null, IsApproved, Guid.NewGuid(), out createStatus); if (createStatus == MembershipCreateStatus.Success) { using (var context = new DataContext()) { context.SaveChanges(); } } return createStatus; }
public void AddTaskLiked(DataContext db, Task task) { this.GetCurrentUser(db).TasksLiked.Add(task); }
public bool IsUserLikedTask(DataContext db, Task task) { return this.GetCurrentUser(db).TasksLiked.Find(taskFind => taskFind.TaskId == task.TaskId) != null; }
public IEnumerable<Task> GetAllTasksByUserName(string username) { using (var db = new DataContext()) { var userProvider = new UserProvider(); return userProvider.GetUserByUsername(db, username).Tasks; } }
public List<Tag> GetPopularTags(DataContext db,int count) { return db.Tags.OrderBy(tag => tag.Tasks.Count()).Take(count).ToList(); }
public void AddCathegory(DataContext db,CathegoryModel model) { Cathegory newCathegory = db.Cathegories.Create(); InitializeCathegory(model,newCathegory); db.SaveChanges(); }
public User GetUserByUsername(DataContext db, String username) { return db.Users.FirstOrDefault(user => user.Username == username); }
public User GetUserById(DataContext db, Guid id) { return db.Users.FirstOrDefault(user => user.UserId == id); }
public User GetCurrentUser(DataContext db) { return this.GetUserByUsername(db,WebSecurity.User.Identity.Name); }
public Tag GetTagById(DataContext db, Guid id) { return db.Tags.First(tag => tag.TagId == id); }
public IEnumerable<Task> GetTagTasks(DataContext db, Guid id, int count) { Tag selectedTag = GetTagById(db, id); return selectedTag.Tasks.Take(count); }
/// <summary> /// Return all currnet User Tasks /// </summary> /// <returns>UserTasks</returns> public IEnumerable<Task> GetCurrentUserTasks() { using (var db = new DataContext()) { var userProvider = new UserProvider(); return userProvider.GetCurrentUser(db).Tasks; } }
public IEnumerable<User> GetUsers(DataContext db, int index, int count) { return db.Users.Skip(index).Take(count); }