Пример #1
0
        /// <summary>
        /// Returns the todo-items from the data context.
        /// </summary>
        /// <returns></returns>
        public IEnumerable <TodoViewModel> GetTodos()
        {
            // Get todos, tasks and subtasks
            using (var context = new TolldoDbContext())
            {
                // Get items from database
                var todos = context.Todos
                            .Include(a => a.Tasks)
                            .ThenInclude(b => b.Subtasks)
                            .OrderBy(a => a.Order)
                            .ToList();

                // Map items
                var todoViewModels = _mapper.Map <List <TodoViewModel> >(todos);

                // Order tasks by order property
                foreach (var todo in todoViewModels)
                {
                    var tasks = todo.Tasks.OrderBy(a => a.Order).ToList();
                    todo.Tasks = new System.Collections.ObjectModel.ObservableCollection <TaskViewModel>(tasks);
                }

                // Return items
                return(todoViewModels);
            }
        }
Пример #2
0
 /// <summary>
 /// Ensures that the database for the context exists.
 /// </summary>
 public void EnsureDataBase()
 {
     using (var context = new TolldoDbContext())
     {
         _ = context.Database.EnsureCreated();
     }
 }
Пример #3
0
        /// <summary>
        /// Adds a todo-item to the data context.
        /// </summary>
        /// <param name="item">Item to add.</param>
        /// <returns>Primary key for inserted item.</returns>
        public async Task <int> AddTodo(TodoViewModel item)
        {
            using (var context = new TolldoDbContext())
            {
                // Create item to add
                var itemToAdd = _mapper.Map <Todo>(item);

                // Add item to database
                context.Add(itemToAdd);
                await context.SaveChangesAsync();

                return(itemToAdd.Id);
            }
        }
Пример #4
0
        /// <summary>
        /// Deletes a subtask-item from the data context.
        /// </summary>
        /// <param name="item">Item to delete.</param>
        /// <returns>Success value.</returns>
        public async Task <bool> DeleteSubtask(SubtaskViewModel item)
        {
            using (var context = new TolldoDbContext())
            {
                // Get item to remove
                var itemToRemove = await context.Subtasks.Where(i => i.Id == item.Id).FirstOrDefaultAsync();

                if (itemToRemove == null)
                {
                    return(false);
                }

                // Remove item from database
                context.Remove(itemToRemove);
                return(await context.SaveChangesAsync() > 0 ? true : false);
            }
        }
Пример #5
0
        /// <summary>
        /// Adds a subtask-item to the data context.
        /// </summary>
        /// <param name="item">Item to add.</param>
        /// <param name="id">Foreign key to the item.</param>
        /// <returns>Primary key for inserted item.</returns>
        public async Task <int> AddSubtask(SubtaskViewModel item, int id)
        {
            using (var context = new TolldoDbContext())
            {
                // Create item to add
                var itemToAdd = _mapper.Map <Subtask>(item);

                // Add foreign key
                itemToAdd.TodoTaskId = id;

                // Add item to database
                context.Add(itemToAdd);
                await context.SaveChangesAsync();

                return(itemToAdd.Id);
            }
        }
Пример #6
0
        /// <summary>
        /// Updates a subtask-item in the data context.
        /// </summary>
        /// <param name="item">Item to update.</param>
        /// <returns>Success value.</returns>
        public async Task <bool> UpdateSubtask(SubtaskViewModel item)
        {
            using (var context = new TolldoDbContext())
            {
                // Get item to update
                var itemToUpdate = await context.Subtasks.Where(i => i.Id == item.Id).FirstOrDefaultAsync();

                _mapper.Map(item, itemToUpdate);

                if (itemToUpdate == null)
                {
                    return(false);
                }

                // Update item in database
                context.Update(itemToUpdate);

                return(await context.SaveChangesAsync() > 0 ? true : false);
            }
        }
Пример #7
0
        /// <summary>
        /// Updates a todo-item in the data context.
        /// </summary>
        /// <param name="item">Item to update.</param>
        /// <returns>Success value.</returns>
        public async Task <bool> UpdateTodo(TodoViewModel item)
        {
            using (var context = new TolldoDbContext())
            {
                // Get item to update
                var itemToUpdate = await context.Todos.Where(i => i.Id == item.Id).FirstOrDefaultAsync();

                _mapper.Map(item, itemToUpdate);

                if (itemToUpdate == null)
                {
                    return(false);
                }

                // Update item in database
                itemToUpdate.Tasks = null;
                context.Update(itemToUpdate);

                // Ignore tasks
                context.Entry(itemToUpdate).Collection(x => x.Tasks).IsModified = false;

                return(await context.SaveChangesAsync() > 0 ? true : false);
            }
        }