public async Task <IEnumerable <Domain.Core.Model.Persona.Persona> > GetBySearchText(string text)
{
using (IDbConnection dbConnection = connection.Create())
{
QueryObject byAllText = new PersonaSelect().AllBySearchText(text);
var personaToReturn = dbConnection.Query <Domain.Core.Model.Persona.Persona>(byAllText);
return(personaToReturn);
}
}
public async Task <Domain.Core.Model.Persona.Persona> GetById(int id)
{
IEnumerable <Domain.Core.Model.Persona.Persona> personaToReturn = cacheRepository.Get(CacheKeys.Personas + id.ToString());
if (personaToReturn != null)
{
return(personaToReturn.SingleOrDefault());
}
using (IDbConnection dbConnection = connection.Create())
{
QueryObject byId = new PersonaSelect().ByID(id);
personaToReturn = dbConnection.Query <Domain.Core.Model.Persona.Persona>(byId);
cacheRepository.Set("Persona" + id, personaToReturn);
return(personaToReturn.SingleOrDefault());
}
}
public async Task <IEnumerable <Domain.Core.Model.Persona.Persona> > GetAll()
{
IEnumerable <Domain.Core.Model.Persona.Persona> personaToReturn = cacheRepository.Get("Persona");
if (personaToReturn != null)
{
return(personaToReturn);
}
using (IDbConnection dbConnection = connection.Create())
{
QueryObject byAll = new PersonaSelect().All();
personaToReturn = dbConnection.Query <Domain.Core.Model.Persona.Persona>(byAll);
cacheRepository.Set("Persona", personaToReturn);
return(personaToReturn);
}
}
public async Task <IEnumerable <Domain.Core.Model.Persona.Persona> > GetAll()
{
IEnumerable <Domain.Core.Model.Persona.Persona> personaToReturn = cacheRepository.Get(CacheKeys.Personas);
if (personaToReturn != null)
{
return(personaToReturn);
}
using (IDbConnection dbConnection = connection.Create())
{
QueryObject byAll = new PersonaSelect().All();
personaToReturn = dbConnection.Query <Domain.Core.Model.Persona.Persona>(byAll);
cacheRepository.Set(CacheKeys.Personas, personaToReturn);
// Si lo quiero guardar durante 10 segundos
// cacheRepository.Set(CacheKeys.Personas, personaToReturn, TimeSpan.FromSeconds(30));
return(personaToReturn);
}
}