public async Task <int> DeleteListWithAllTask(int listId)
{
int rowAffacted = 0;
using (IDbContextTransaction transection = _ternContext.Database.BeginTransaction())
{
try
{
List <Domain.Task> tasks = _ternContext.Tasks.Where(x => x.ListId == listId).ToList();
_ternContext.Tasks.RemoveRange(tasks);
rowAffacted += await _ternContext.SaveChangesAsync();
Domain.List list = new Domain.List {
ListId = listId
};
_ternContext.Lists.Attach(list);
_ternContext.Lists.Remove(list);
rowAffacted += await _ternContext.SaveChangesAsync();
await transection.CommitAsync();
}
catch (Exception e)
{
throw e;
}
}
return(0);
}
public async Task <int> DeleteList(int listId)
{
int rowAffacted = 0;
try
{
Domain.List list = new Domain.List {
ListId = listId
};
_ternContext.Lists.Attach(list);
_ternContext.Lists.Remove(list);
rowAffacted = await _ternContext.SaveChangesAsync();
return(rowAffacted);
}
catch (Exception e)
{
throw e;
}
}
