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