public async Task <T> Get <T>(Guid Id, bool isNullable = true) where T : IEntity
{
return(await Task.Run(() =>
{
using var db = new LiteDB.LiteRepository(_connectionString);
if (isNullable)
{
return db.Query <T>().Where(e => e.Id == Id).FirstOrDefault();
}
return db.Query <T>().Where(e => e.Id == Id).Single();
}));
}
public Cliente GetByName(string name)
{
using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco)))
{
return(db.Query <Cliente>("clientes").Where(x => x.Nome.ToLowerInvariant() == name.ToLowerInvariant()).SingleOrDefault());
}
}
public IEnumerable <Cliente> Get()
{
using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco)))
{
return(db.Query <Cliente>("clientes").ToList());
}
}
public Servico GetByDescription(string descricao)
{
using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco)))
{
return(db.Query <Servico>("servicos").Where(x => x.Descricao.ToLowerInvariant() == descricao.ToLowerInvariant()).SingleOrDefault());
}
}
public IEnumerable <Servico> Get()
{
using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco)))
{
return(db.Query <Servico>("servicos").ToList());
}
}
public async Task <IEnumerable <T> > Get <T>(Expression <Func <T, bool> > predicate)
{
return(await Task.Run(() =>
{
using var db = new LiteDB.LiteRepository(_connectionString);
return db.Query <T>().Where(predicate).ToList();
}));
}
public async Task <IEnumerable <T> > Get <T>()
{
return(await Task.Run(() =>
{
using var db = new LiteDB.LiteRepository(_connectionString);
return db.Query <T>().ToList();
}));
}
public Agenda Get(int id)
{
using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco)))
{
return(db.Query <Agenda>("agendas")
.Include(x => x.Servico)
.Include(x => x.Cliente)
.Where(x => x.AgendaId == id).SingleOrDefault());
}
}
public IEnumerable <Agenda> Get()
{
using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco)))
{
return(db.Query <Agenda>("agendas")
.Include(x => x.Servico)
.Include(x => x.Cliente)
.ToList());
}
}
public async Task <T> Get <T>(Expression <Func <T, bool> > predicate, bool isNullable)
{
if (isNullable)
{
return(await Task.Run(() =>
{
using var db = new LiteDB.LiteRepository(_connectionString);
return db.Query <T>().Where(predicate).FirstOrDefault();
}));
}
return(await Task.Run(() =>
{
using var db = new LiteDB.LiteRepository(_connectionString);
return db.Query <T>().Where(predicate).Single();
}));
}
