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