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;
}
}
}