public IQueryable AddItem([FromBody] TodoItem item) { if (item.Text != null || item.Category > 0) { _context.Add(new TodoItem(item.Text, item.Category)); _context.SaveChanges(); } return(_context.TodoItems.Where(i => i.Category == item.Category)); }
public ActionResult <item> Create([FromBody] item item) { _context.Add(item); _context.SaveChanges(); // return CreatedAtRoute("GetItem", new { id = item.id.ToString() }, item); return(item); }
protected override Task <UpdateTodoResponse> ProcessCommand(UpdateTodoCommand command) { var response = new UpdateTodoResponse(); var request = command.Data; var user = _context.AcUsers.FirstOrDefault(e => e.UserName == request.UserName); var task = _context.AcTasks.FirstOrDefault(e => e.TaskId == request.TaskId); if (task != null) { var category = _context.AcCategories.FirstOrDefault(e => e.UserId == user.UserId && e.CategoryId == request.CategoryId && e.IsDeleted == false); if (category != null) { task.Name = request.Name; task.Category = category; task.RootTaskId = request.RootTaskId == 0 ? null : request.RootTaskId; task.Status = (short)request.TaskStatus; task.TaskPriorityId = (short)request.TaskPriority; using (var scope = _context.Database.BeginTransaction()) { try { _context.AcTasks.Attach(task); var activity = new AcTaskActivity { Activity = "Task Updated", ActivityDate = DateTime.Now, Task = task }; _context.Add(activity); _context.SaveChanges(); response.Todo = _mapper.Map <Todo>(task); scope.Commit(); } catch (Exception ex) { scope.Rollback(); throw new Exception("An error occured while creating task."); } } } else { throw new Exception("An error occured while creating task."); } } else { throw new Exception("An error occured while creating task."); } return(Task.FromResult(response)); }
public TodoController(TodoDBContext context) { this._context = context; if (_context.TodoItems.Count() == 0) { var todo = new TodoItem { Name = "Take medicine", TodoDescription = "Take the Valoate CR 500 medicine at night.", IsComplete = false }; _context.Add(todo); _context.SaveChanges(); } }