public void Edit(List list)
{
using (var db = new TrelloModelDBContainer())
{
db.EditList(list.ListId, list.Lix, list.BoardId, list.Name);
}
}
//TODO aplicar e melhorar expection handling
// db.Database.Log = (msg) => { Console.WriteLine(msg ); };
#region Sync Methods
public IEnumerable <Board> GetAll()
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.ToList());
}
}
public Board FindBy(Expression <Func <Board, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.FirstOrDefault(predicate));
}
}
public async Task <int> CountAsync()
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.CountAsync());
}
}
public async Task <int> CountConditionalAsync(Expression <Func <Board, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.Where(predicate).CountAsync());
}
}
public async Task <IEnumerable <Board> > GetAllAsync()
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.ToListAsync());
}
}
public async Task <Board> FindByAsync(Expression <Func <Board, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.FirstOrDefaultAsync(predicate));
}
}
public async Task <List> GetSingleAsync(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.List.FirstOrDefaultAsync(l => l.ListId == id));
}
}
public async Task <List> FindByAsync(Expression <Func <List, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.List.Where(predicate).FirstOrDefaultAsync());
}
}
public bool ValidId(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(db.List.Any(l => l.ListId == id));
}
}
public async Task <IEnumerable <List> > GetListsOfBoardAsync(int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.List.Where(l => l.BoardId == boardId).ToListAsync());
}
}
public int CountListsOfBoard(int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(db.List.Count(l => l.BoardId == boardId));
}
}
public string GetListBoardName(int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.Where(l => l.BoardId == boardId).Select(b => b.Name).FirstOrDefault());
}
}
public IEnumerable <List> GetListsOfBoard(int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(db.List.Where(l => l.BoardId == boardId).ToList());
}
}
public int CountConditional(Expression <Func <Board, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.Where(predicate).Count());
}
}
public async Task <string> GetListBoardNameAsync(int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.Where(l => l.BoardId == boardId).Select(b => b.Name).FirstOrDefaultAsync());
}
}
public bool ValidId(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.Any(b => b.BoardId == id));
}
}
public async Task <int> CountListsOfBoardAsync(int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.List.CountAsync(l => l.BoardId == boardId));
}
}
public async Task <Board> GetSingleAsync(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.FirstOrDefaultAsync(b => b.BoardId == id));
}
}
public async Task <int> CountConditionalListsOfBoardAsync(Expression <Func <List, bool> > predicate, int boardId)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.List.Where(predicate).CountAsync(l => l.BoardId == boardId));
}
}
public async Task <IEnumerable <Board> > FindAllByAsync(Expression <Func <Board, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.Where(predicate).ToListAsync());
}
}
public List GetSingle(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(db.List.FirstOrDefault(l => l.ListId == id));
}
}
public async Task <bool> HasRepeatedBoardNameAsync(int boardid, string boardname)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.AnyAsync(b => b.Name == boardname && b.BoardId != boardid));
}
}
public List FindBy(Expression <Func <List, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(db.List.Where(predicate).FirstOrDefault());
}
}
public async Task <bool> ValidIdAsync(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(await db.Board.AnyAsync(b => b.BoardId == id));
}
}
public int Count()
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.Count());
}
}
public Board GetSingle(int id)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.FirstOrDefault(b => b.BoardId == id));
}
}
public bool HasRepeatedBoardName(int boardid, string boardname)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.Any(b => b.Name == boardname && b.BoardId != boardid));
}
}
public IEnumerable <Board> FindAllBy(Expression <Func <Board, bool> > predicate)
{
using (var db = new TrelloModelDBContainer())
{
return(db.Board.Where(predicate).ToList());
}
}
public void Delete(List list)
{
using (var db = new TrelloModelDBContainer())
{
db.DeleteList(list.ListId, list.Lix, list.BoardId);
}
}
