public void Delete(int id) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Delete <Servico>(x => x.ServicoId == id, "servicos"); } }
public void Delete(int id) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Delete <Cliente>(x => x.ClienteId == id, "clientes"); } }
public IEnumerable <Cliente> Get() { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { return(db.Query <Cliente>("clientes").ToList()); } }
public void Put(int id, [FromBody] Agenda agenda) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Update <Agenda>(agenda, "agendas"); } }
public void Delete(int id) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Delete <Agenda>(x => x.AgendaId == id, "agendas"); } }
public void Post([FromBody] Servico servico) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Insert <Servico>(servico, "servicos"); } }
public void Put(int id, [FromBody] Servico servico) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Update <Servico>(servico, "servicos"); } }
public IEnumerable <Servico> Get() { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { return(db.Query <Servico>("servicos").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 void Put(int id, [FromBody] Cliente cliente) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { db.Update <Cliente>(cliente, "clientes"); } }
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 async Task <IEnumerable <T> > Get <T>() { return(await Task.Run(() => { using var db = new LiteDB.LiteRepository(_connectionString); return db.Query <T>().ToList(); })); }
public async Task Delete <T>(Guid id) where T : IEntity { await Task.Run(() => { using var db = new LiteDB.LiteRepository(_connectionString); db.Delete <T>(e => e.Id == id); }); }
public async Task Put <T>(T entity) { await Task.Run(() => { using var db = new LiteDB.LiteRepository(_connectionString); db.Update(entity); }); }
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 Agenda Post([FromBody] Agenda agenda) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { agenda.AgendaId = db.Insert <Agenda>(agenda, "agendas").AsInt32; return(agenda); } }
public Cliente Post([FromBody] Cliente cliente) { using (var db = new LiteDB.LiteRepository(new LiteDatabase(dirBanco))) { cliente.ClienteId = db.Insert <Cliente>(cliente, "clientes").AsInt32; return(cliente); } }
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>(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 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(); })); }
public OfflineDatabase(Type itemType, string filenameModifier) { var fullName = this.GetFileName(itemType.ToString()); if (fullName.Length > 100) { fullName = fullName.Substring(0, 100); } BsonMapper mapper = BsonMapper.Global; mapper.Entity <OfflineEntry>().Id(o => o.Key); string root = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData); string filename = fullName + filenameModifier + ".db"; var path = Path.Combine(root, filename); this.db = new LiteRepository(new LiteDatabase(path, mapper)); this.cache = db.Database.GetCollection <OfflineEntry>().FindAll() .ToDictionary(o => o.Key, o => o); }