/// <summary>
/// Gets all the AppSettings items from the cache or the database.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <returns>
/// Collection of all the AppSettings items.
/// </returns>
private static TCollection <AppSettings> GetAppSettingsCollection(IUserContext userContext)
{
const string cacheKey = "AppSettingsBusiness.GetAppSettingsCollection";
var collection = CacheServiceHelper.Current.Get <TCollection <AppSettings> >(cacheKey);
if (collection == null)
{
lock (_locker)
{
if (collection == null)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
var options = new SearchOptions();
collection = db.Search(ref options);
}
CacheServiceHelper.Current.Add(new CacheItem
{
Key = cacheKey,
Data = collection,
Expiration = DateTime.Now.AddMinutes(CACHE_DELAY_IN_MINS)
});
}
}
}
return(collection);
}
/// <summary>
/// Refreshs the entity instance from the database.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="appSettings">
/// Entity to refresh (must be in database).
/// </param>
public void Refresh(IUserContext userContext, ref VahapYigit.Test.Models.AppSettings entity)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
db.Refresh(ref entity);
}
}
/// <summary>
/// Gets an entity given its unique ID.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="id">
/// Unique ID.
/// </param>
///
/// <returns>
/// The entity.
/// </returns>
public VahapYigit.Test.Models.AppSettings GetById(IUserContext userContext, long id)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
return(db.GetById(id));
}
}
/// <summary>
/// Deletes the entity given its unique ID.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="id">
/// Unique ID.
/// </param>
///
/// <returns>
/// The number of affected rows.
/// </returns>
public int Delete(IUserContext userContext, long id)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
return(db.Delete(id));
}
}
/// <summary>
/// Deletes the entity from the database.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="entity">
/// Entity to delete.
/// </param>
///
/// <returns>
/// The number of affected rows.
/// </returns>
public int Delete(IUserContext userContext, VahapYigit.Test.Models.AppSettings entity)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
return(db.Delete(entity));
}
}
/// <summary>
/// Saves (or updates) the entity in the database.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="entity">
/// Entity to save or update.
/// </param>
///
/// <param name="options">
/// Optional options.
/// </param>
///
/// <returns>
/// The number of affected rows.
/// </returns>
public int Save(IUserContext userContext, ref VahapYigit.Test.Models.AppSettings entity, SaveOptions options = null)
{
using (var et = new ExecutionTracerService(tag: entity.State.ToString()))
using (var db = new AppSettingsCrud(userContext))
{
return(db.Save(ref entity, options));
}
}
/// <summary>
/// Indicates whether the search returns at least 1 entity.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="options">
/// Optional search options. If not defined, all records are returned.
/// </param>
///
/// <returns>
/// True if the search returns at least 1 entity; otherwise, false.
/// </returns>
public bool HasResult(IUserContext userContext, SearchOptions options = null)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
return(db.HasResult(options));
}
}
/// <summary>
/// Gets entities with search options.
/// </summary>
///
/// <param name="userContext">
/// User context.
/// </param>
///
/// <param name="options">
/// Optional options, filters, orderby, paging, etc.
/// </param>
///
/// <returns>
/// A collection of entities.
/// </returns>
public TCollection <VahapYigit.Test.Models.AppSettings> Search(IUserContext userContext, ref SearchOptions options)
{
using (var et = new ExecutionTracerService())
using (var db = new AppSettingsCrud(userContext))
{
return(db.Search(ref options));
}
}