public void Create(CreateTaskViewModel task) { var entity = createTaskViewModelToTask(task); _context.Tasks.Add(entity); _context.SaveChanges(); }
public RegisterResponse Register(RegisterRequest registerRequest) { RegisterResponse response = new RegisterResponse(); if (string.IsNullOrWhiteSpace(registerRequest.Username)) { response.Error = "Username is empty"; return(response); } if (string.IsNullOrWhiteSpace(registerRequest.Password)) { response.Error = "Password is empty"; return(response); } User user; if (context.Users.Any()) { user = context.Users.FirstOrDefault(p => p.Name.ToLower() == registerRequest.Username.ToLower()); if (user != null) { response.Error = "User already exists"; return(response); } } user = new User(); user.Name = registerRequest.Username; user.Password = registerRequest.Password; user.Token = Guid.NewGuid().ToString(); context.Entry(user).State = EntityState.Added; context.SaveChanges(); response.Token = user.Token; return(response); }
public IHttpActionResult PutAspNetUser(string id, AspNetUser aspNetUser) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != aspNetUser.Id) { return(BadRequest()); } db.Entry(aspNetUser).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AspNetUserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async void ToDoDeleteTest() { DbContextOptions <ToDoDbContext> options = new DbContextOptionsBuilder <ToDoDbContext>() .UseInMemoryDatabase("todoDelete") .Options; using (ToDoDbContext context = new ToDoDbContext(options)) { //CREATE //Arrange ToDo taskOne = new ToDo(); taskOne.Name = "Finish homework"; taskOne.Completed = false; context.ToDos.Add(taskOne); context.SaveChanges(); //READ var myTask = await context.ToDos.FirstOrDefaultAsync(t => t.Name == taskOne.Name); context.ToDos.Remove(myTask); context.SaveChanges(); var deletedTask = await context.ToDos.FirstOrDefaultAsync(t => t.Name == myTask.Name); Assert.True(deletedTask == null); } }
public async void ToDoListUpdateTest() { DbContextOptions <ToDoDbContext> options = new DbContextOptionsBuilder <ToDoDbContext>() .UseInMemoryDatabase("todoListUpdate") .Options; using (ToDoDbContext context = new ToDoDbContext(options)) { //CREATE //Arrange ToDoList myList = new ToDoList(); myList.Name = "new list"; context.ToDoList.Add(myList); context.SaveChanges(); //READ var list = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name); list.Name = "another name"; context.Update(list); context.SaveChanges(); var newList = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name); Assert.Equal("another name", newList.Name); } }
public ToDoItemDTO CreateItemInList(Guid listId, ToDoItemDTO itemDTO) { _logger.LogInformation("ToDoItemService -> Executing CreateItemInList()"); var toDoList = _context.ToDoLists .SingleOrDefault(todo => todo.Id.Equals(listId));; if (toDoList == null) { throw new EntityNotFoundException(); } //create item from dto ToDoItem itemToAdd = itemDTO.CreateEntity(listId); //each new Item receives the lowest position of all items in a list itemToAdd.Position = _context.ToDoItems.Where(x => x.ToDoListId.Equals(listId)).Count(); //add the new item to list and update database toDoList.Items.Add(itemToAdd); _context.SaveChanges(); //update dto data itemDTO.ItemId = itemToAdd.Id; itemDTO.Position = itemToAdd.Position; return(itemDTO); }
public ValidationResponse CreateTodo(CreateTodoRequest request) { ValidationResponse response = new ValidationResponse(); if (request == null || string.IsNullOrWhiteSpace(request.Username) || string.IsNullOrWhiteSpace(request.Token)) { response.Error = "Need to login"; return(response); } User user = context.Users.FirstOrDefault(u => u.Name == request.Username && u.Token == request.Token); if (user == null) { response.Error = "Need to login"; return(response); } var todo = new ToDo(); todo.User = user; todo.Text = request.TodoText; context.Entry(todo).State = EntityState.Added; context.SaveChanges(); return(response); }
public ActionResult <ToDo> PostToDo(ToDo toDo) { _context.ToDos.Add(toDo); _context.SaveChanges(); return(CreatedAtAction("PostToDo", toDo)); }
public IActionResult Create(ToDo t) { t.isFinished = true; _db.Items.Add(t); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ToDo CreateToDo(ToDo toDo) { _context.Add(toDo); _context.SaveChanges(); return(toDo); }
public async void ToDoListDeleteTest() { DbContextOptions <ToDoDbContext> options = new DbContextOptionsBuilder <ToDoDbContext>() .UseInMemoryDatabase("todoListDelete") .Options; using (ToDoDbContext context = new ToDoDbContext(options)) { //CREATE //Arrange ToDoList myList = new ToDoList(); myList.Name = "new list"; context.ToDoList.Add(myList); context.SaveChanges(); //READ var list = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name); context.ToDoList.Remove(list); context.SaveChanges(); var deletedList = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name); Assert.True(deletedList == null); } }
public ToDoListDTO CreateToDoList(ToDoListDTO toDoListDTO, string email) { _logger.LogInformation("ToDoListService -> Executing CreateToDoList()"); //if the user didn't specify the date for the reminder if (toDoListDTO.EndDate == null) { toDoListDTO.IsReminded = false; //the list is not a reminded list } else { toDoListDTO.IsReminded = true; } ToDoList newList = toDoListDTO.CreateEntity(email); //new todo list position is 'highest' in the hierarchy for the specified user newList.Position = _context.ToDoLists .Where(x => x.Owner.Equals(email)) .Count(); _context.ToDoLists.Add(newList); _context.SaveChanges(); toDoListDTO.Id = newList.Id; toDoListDTO.Position = newList.Position; return(toDoListDTO); }
public ICollection <ToDo> AddToDo(ToDo toDo, Guid userId) { toDo.UserId = userId; _context.ToDos.Add(toDo); _context.SaveChanges(); return(GetAll(userId)); }
public void DeleteById(int id) { ToDo toDo = _context.ToDos.FirstOrDefault(x => x.Id == id); if (toDo != null) { _context.ToDos.Remove(toDo); } _context.SaveChanges(); }
public ActionResult <User> WijzigUser(int id, User user) { if (id != user.Id) { return(BadRequest()); } _context.Users.Update(user); _context.SaveChanges(); return(Ok(user)); }
public void DeleteById(int id) { SubTask subtask = _context.SubTasks.FirstOrDefault(x => x.Id == id); if (subtask != null) { _context.SubTasks.Remove(subtask); } _context.SaveChanges(); }
public void DeleteById(int id) { User user = _context.Users.FirstOrDefault(x => x.Id == id); if (user != null) { _context.Users.Remove(user); } _context.SaveChanges(); }
public ActionResult Create([Bind(Include = "Id,Name,Description")] ToDoItem toDoItem) { if (ModelState.IsValid) { db.ToDoItems.Add(toDoItem); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(toDoItem)); }
public ActionResult Create(ToDoItem toDoItem) { if (ModelState.IsValid) { _db.ToDoItems.Add(toDoItem); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(toDoItem)); }
public ActionResult Create([Bind(Include = "Id,Description,Completed")] ToDo toDo) { _toDoRepo.Add(toDo); ViewBag.ToDoes = _toDoRepo.GetAll(); //return RedirectToAction("Index"); if (ModelState.IsValid) { db.ToDoes.Add(toDo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
/// <summary> /// DB method to Soft delete(Mark complete) a task /// </summary> /// <param name="toDoID"></param> /// <returns></returns> public long Update(long toDoID) { ToDo todo = _toDoDbContext.todoS.Find(toDoID); if (todo != null) { todo.isDeleted = true; _toDoDbContext.Entry(todo).State = EntityState.Modified; if (_toDoDbContext.SaveChanges() == 1) { return(todo.Id); } } return(0); }
public IActionResult Edit(Task edittedTask) { if (ModelState.IsValid) { using (var db = new ToDoDbContext()) { var entityToEdit = db.Tasks.FirstOrDefault(t => t.Id == edittedTask.Id); entityToEdit.Title = edittedTask.Title; entityToEdit.Comments = edittedTask.Comments; db.SaveChanges(); } return(RedirectToAction("Index")); } else { ViewData["Error"] = "Leaving empty title or comment is not allowed!"; if (string.IsNullOrWhiteSpace(edittedTask.Title)) { ViewData["TitleError"] = "bg-danger"; } if (string.IsNullOrWhiteSpace(edittedTask.Comments)) { ViewData["CommentsError"] = "bg-danger"; } return(View()); } }
public Item Update(Item item) { using var todoDbContext = new ToDoDbContext(); todoDbContext.Items.Update(item); todoDbContext.SaveChanges(); return(item); }
private void CheckForExpirations(object state) { using (var scope = _serviceScopeFactory.CreateScope()) { _dbContext = scope.ServiceProvider.GetService <ToDoDbContext>(); DateTime today = DateTime.Today; //loop through to do lists and check if their reminder date expired _dbContext.ToDoLists .ToList() .ForEach(list => { if (list.IsReminded && list.EndDate.HasValue && today > list.EndDate.Value) { _logger.LogInformation($"ReminderService -> Found expired list with title '{list.Title}'"); SendEmail($"{_options.LinkToExpiredList}/{list.Id}", list.Owner); list.IsReminded = false; } }); _dbContext.SaveChanges(); } }
private void SetupDb() { var ti = new TenantInfo { Id = "finbuckle", ConnectionString = "Data Source=Data/ToDoList.db" }; using (var db = new ToDoDbContext(ti)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); db.ToDoItems.Add(new ToDoItem { Title = "Call Lawyer ", Completed = false }); db.ToDoItems.Add(new ToDoItem { Title = "File Papers", Completed = false }); db.ToDoItems.Add(new ToDoItem { Title = "Send Invoices", Completed = true }); db.SaveChanges(); } ti = new TenantInfo { Id = "megacorp", ConnectionString = "Data Source=Data/ToDoList.db" }; using (var db = new ToDoDbContext(ti)) { db.Database.EnsureCreated(); db.ToDoItems.Add(new ToDoItem { Title = "Send Invoices", Completed = true }); db.ToDoItems.Add(new ToDoItem { Title = "Construct Additional Pylons", Completed = true }); db.ToDoItems.Add(new ToDoItem { Title = "Call Insurance Company", Completed = false }); db.SaveChanges(); } ti = new TenantInfo { Id = "initech", ConnectionString = "Data Source=Data/Initech_ToDoList.db" }; using (var db = new ToDoDbContext(ti)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); db.ToDoItems.Add(new ToDoItem { Title = "Send Invoices", Completed = false }); db.ToDoItems.Add(new ToDoItem { Title = "Pay Salaries", Completed = true }); db.ToDoItems.Add(new ToDoItem { Title = "Write Memo", Completed = false }); db.SaveChanges(); } }
public IActionResult Post([FromBody] Activity a) { var db = new ToDoDbContext(); db.Activity.Add(a); db.SaveChanges(); return(Ok()); }
public IActionResult Delete(uint id) { var db = new ToDoDbContext(); var a = db.Activity.Find(id); db.Activity.Remove(a); db.SaveChanges(); return(Ok()); }
public IActionResult Put(uint id, [FromBody] Activity a) { var db = new ToDoDbContext(); a.Id = id; db.Update(a); db.SaveChanges(); return(Ok()); }
public async Task <bool> Handle(ToggleDoneCommand request, CancellationToken cancellationToken) { var entity = await _context.ToDoItems.SingleOrDefaultAsync(x => x.ToDoItemId == request.ItemId, cancellationToken); var updatedDone = !entity.Done; entity.Done = updatedDone; _context.SaveChanges(); return(updatedDone); }
public ActionResult Edit([Bind("Id", "Item", "Completed")] ToDoItem toDoItem) { if (ModelState.IsValid) { _db.Entry(toDoItem).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(toDoItem)); }