/// <summary>
/// Execute Query[T].Where(query).FirstOrDefault();
/// </summary>
public T FirstOrDefault <T>(Expression <Func <T, bool> > predicate, string collectionName = null)
{
using (var db = new LiteRepository(_configService.ConnectionString))
{
return(db.FirstOrDefault <T>(predicate, collectionName));
}
}
/// <summary>
/// Execute Query[T].Where(query).FirstOrDefault();
/// </summary>
public T FirstOrDefault <T>(Query query = null, string collectionName = null)
{
using (var db = new LiteRepository(_configService.ConnectionString))
{
return(db.FirstOrDefault <T>(query, collectionName));
}
}
public TModel GetById(int id)
{
using (var db = new LiteRepository(_connectionString))
{
return(db.FirstOrDefault <TModel>(x => x.Id == id && !x.Removed));
}
}
public Optional <Settings> GetSettingsForUser(string userName)
{
using (var repository = new LiteRepository(_connectionStringProvider.ConnectionString))
{
var entity = repository.FirstOrDefault <Settings>(p => p.UserName == userName);
return(entity == null ? Optional <Settings> .Empty() : Optional <Settings> .For(entity));
}
}
public Optional <InferenceProfile> GetProfileByName(string profileName)
{
using (var repository = new LiteRepository(_connectionStringProvider.ConnectionString))
{
var entity = repository.FirstOrDefault <InferenceProfile>(p => p.ProfileName == profileName);
return(entity == null ? Optional <InferenceProfile> .Empty() : Optional <InferenceProfile> .For(entity));
}
}
public Result <T> FirstOrDefault(Query query = null, string collectionName = null)
{
var result = new Result <T>();
try
{
result.ResultObject = _liteRepository.FirstOrDefault <T>(query, collectionName);
}
catch (Exception ex)
{
result.ResultCode = (int)ResultStatusCode.InternalServerError;
result.ResultMessage = "Hata Oluştu => " + ex;
result.ResultInnerMessage = "Hata Oluştu => " + ex.InnerException;
result.ResultStatus = false;
}
return(result);
}
public Security GetSecurity()
{
var security = _repository.FirstOrDefault <Security>();
if (security != null)
{
return(security);
}
security = new Security();
_repository.Insert(security, "security");
return(security);
}
public bool Remove(int id)
{
using (var db = new LiteRepository(_connectionString))
{
var entity = db.FirstOrDefault <TModel>(x => x.Id == id && !x.Removed);
if (entity == null)
{
return(false);
}
entity.Removed = true;
return(db.Update(entity));
}
}
private void AddTagIfNotExists(IEnumerable <TagDto> tags)
{
using (var db = new LiteRepository(_connectionString))
{
foreach (var tag in tags)
{
var exists = db.FirstOrDefault <TagDto>(x => x.NormalizedName == tag.NormalizedName);
if (exists == null)
{
db.Insert <TagDto>(tag);
}
}
}
}
public UserModel Get(Guid id)
{
if (id == Guid.Empty)
{
throw new ArgumentNullException(nameof(id));
}
var result = _instance.FirstOrDefault <UserModel>(x => x.Id == id);
if (result == null)
{
throw new Exception("No user found");
}
return(result);
}
static Database()
{
Repo = new LiteRepository("config.db");
DB = Repo.Database;
InternalOptions = Repo.FirstOrDefault <InternalOptions>();
if (InternalOptions == null)
{
InternalOptions = new InternalOptions();
return;
}
// check if InternalOptions are valid
InternalOptions.MaxModifications = Math.Max(InternalOptions.MaxModifications, 0);
InternalOptions.Duration = Math.Max(InternalOptions.Duration, MIN_DURATION);
Repo.Upsert(InternalOptions);
}
public T GetRawDtoById <T>(Id <T> id)
where T : IHasId <T>
{
return(repo.FirstOrDefault <T>(x => x.Id == id));
}
public T FirstOrDefault(Expression <Func <T, bool> > predicate)
{
return(_liteRepository.FirstOrDefault(predicate));
}
public PluginEntity GetPluginByGuid(Guid pluginGuid)
{
return(_repository.FirstOrDefault <PluginEntity>(p => p.Id == pluginGuid));
}
private static PdfFile GetPdf(this LiteRepository repo, string contentMd5)
{
var md5 = contentMd5.ToLowerInvariant();
return(repo.FirstOrDefault <PdfFile>(p => p.Md5 == md5));
}
public ModuleSettingsEntity GetByPluginGuid(Guid guid)
{
return(_repository.FirstOrDefault <ModuleSettingsEntity>(s => s.PluginGuid == guid));
}
public ProfileEntity Get(Guid id)
{
return(_repository.FirstOrDefault <ProfileEntity>(p => p.Id == id));
}
public DeviceEntity Get(string id)
{
return(_repository.FirstOrDefault <DeviceEntity>(s => s.Id == id));
}
public PluginSettingEntity GetByNameAndPluginGuid(string name, Guid pluginGuid)
{
return(_repository.FirstOrDefault <PluginSettingEntity>(p => p.Name == name && p.PluginGuid == pluginGuid));
}
public ModuleSettingsEntity GetByModuleId(string moduleId)
{
return(_repository.FirstOrDefault <ModuleSettingsEntity>(s => s.ModuleId == moduleId));
}
public async Task <TAggregate> Get(TKey key)
{
return(Db.FirstOrDefault <TAggregate>(a => a.Id == key));
}
public SurfaceEntity GetByName(string name)
{
return(_repository.FirstOrDefault <SurfaceEntity>(s => s.Name == name));
}
public Person Read(string id) => repository.FirstOrDefault <Person>(x => x.Id == id);
public Letter Read(string id) => repository.FirstOrDefault <Letter>(x => x.Id == id);
public Task <Session> GetSession(Guid sessionId)
{
return(Task.FromResult(repo.FirstOrDefault <Session>(x => x.SessionId == sessionId)));
}