public async Task UpdateGroupNameAsync(string oldName, string newName) { using (var db = new ListomatorContext()) { var group = await db.ToDoGroups.FirstOrDefaultAsync(t => t.ToDoGroupName == oldName); if (group != null) { group.ToDoGroupName = newName; await db.SaveChangesAsync(); } } }
public async Task AddGroupAsync(string name) { using (var db = new ListomatorContext()) { if (!(await db.ToDoGroups.AnyAsync(t => t.ToDoGroupName == name))) { await db.ToDoGroups.AddAsync(new ToDoGroup { ToDoGroupName = name }); await db.SaveChangesAsync(); } else { throw new ConstraintException($"Group {name} already exists"); } } }
public async Task RemoveGroupAsync(string name) { using (var db = new ListomatorContext()) { try { var group = await db.ToDoGroups.FirstOrDefaultAsync(t => t.ToDoGroupName == name); if (group != null) { db.ToDoGroups.Remove(group); } await db.SaveChangesAsync(); } catch (Exception e) { Console.WriteLine(e); throw; } } }