public static User LoadSingle(long userId, bool notFromCache = false)
{
if (userId == 0)
{
return(null);
}
User toRet;
if (!CacheHelper.Get(Module + "_" + userId.ToUiString(), out toRet) || notFromCache)
{
var predicate = PredicateBuilder.True <User>();
predicate = predicate.And(e => e.Id == userId);
var userRepository = new UserRepository();
toRet = userRepository.LoadSearch(predicate).First();
if (toRet != null)
{
if (toRet.Roles.Where(r => r.Id == Constants.FullAdminRole).Any())
{
toRet.IsFullPermission = true;
}
CacheHelper.Add(Module + "_" + toRet.Id.ToUiString(), toRet, BlCommon.DefaultTimeOut());
}
else
{
//Force cash refresh for module entry
CacheHelper.Clear(Module + "_" + userId.ToUiString());
}
}
return(toRet);
}
public Menu LoadSingle(long userId, long pin)
{
Menu toRet;
if (!CacheHelper.Get(Module + "_" + userId.ToUiString(), out toRet))
{
toRet = _repository.LoadSingle(pin);
CacheHelper.Add(Module + "_" + toRet.Id.ToUiString(), toRet, BlCommon.DefaultTimeOut());
}
return(toRet);
}
public IEnumerable <string> LoadTables(long userId)
{
IEnumerable <string> toRet;
if (!CacheHelper.Get(Module + "_TableNames", out toRet))
{
var codeRepository = new CodeRepository();
toRet = codeRepository.LoadTables();
if (toRet != null)
{
CacheHelper.Add(Module + "_TableNames", toRet, BlCommon.DefaultTimeOut());
}
}
return(toRet);
}
public static Module LoadSingle(long userId, string id)
{
Module toRet;
if (!CacheHelper.Get(Module + "_" + id.ToUpper(), out toRet))
{
var moduleRepository = new ModuleRepository();
toRet = moduleRepository.LoadSingle(id);
if (toRet != null)
{
CacheHelper.Add(Module + "_" + toRet.Id, toRet, BlCommon.DefaultTimeOut());
}
}
return(toRet);
}
public static Role LoadSingle(long userId, long?id, bool notFromCache = false)
{
if (id == null)
{
return(null);
}
Role toRet;
if (!CacheHelper.Get(Module + "_" + Convert.ToInt64(id).ToUiString(), out toRet) || notFromCache)
{
var roleRepository = new RoleRepository();
toRet = roleRepository.LoadSingle(Convert.ToInt64(id));
if (toRet != null)
{
CacheHelper.Add(Module + "_" + toRet.Id.ToUiString(), toRet, BlCommon.DefaultTimeOut());
}
}
return(toRet);
}
public static Dictionary <string, string> LoadTable(long userId, string tableName, string toRetColumn = "Value1", string relCode = "")
{
var user = BlUser.LoadSingle(userId);
toRetColumn = (toRetColumn == "Value1" || CheckEmpty.String(toRetColumn) == "") ? user.LanguageId == 1 ? "Value1" : "Value2" : toRetColumn;
List <Code> results;
if (!CacheHelper.Get(Module + "_Table_" + tableName + "_" + relCode, out results))
{
var codeRepository = new CodeRepository();
var predicate = PredicateBuilder.True <Code>();
predicate = predicate.And(p => p.TableName == tableName);
predicate = predicate.And(p => p.Status);
if (relCode != "")
{
predicate = predicate.And(p => p.RelCode == relCode);
}
results = codeRepository.LoadSearch(predicate);
if (results != null)
{
CacheHelper.Add(Module + "_Table_" + tableName + "_" + relCode, results, BlCommon.DefaultTimeOut());
}
}
Dictionary <string, string> toRet = null;
if (results != null)
{
toRet = results.ToDictionary(k => k.CodeName, v => v.GetType().GetProperty(toRetColumn).GetValue(v, null).ToString());
}
return(toRet);
}
public IEnumerable <Code> LoadPaging(long userId, Expression <Func <Code, bool> > predicate, int pageSize, int pageNum, out long totCount)
{
IEnumerable <Code> toRet;
if (!CacheHelper.Get(Module + "_" + pageSize + "_" + pageNum + "_" + Evaluator.PartialEval(predicate), out toRet))
{
toRet = _repository.LoadPaging(predicate, pageSize, pageNum, out totCount);
CacheHelper.Add(Module + "_" + pageSize + "_" + pageNum + "_" + Evaluator.PartialEval(predicate), toRet, BlCommon.DefaultTimeOut());
CacheHelper.Add(Module + "_totCount_" + Evaluator.PartialEval(predicate), totCount, BlCommon.DefaultTimeOut());
}
else
{
CacheHelper.Get(Module + "_totCount_" + Evaluator.PartialEval(predicate), out totCount);
}
return(toRet);
}
public IEnumerable <Code> LoadSearch(long userId, Expression <Func <Code, bool> > predicate, int count = 0)
{
IEnumerable <Code> toRet;
if (!CacheHelper.Get(Module + "_" + Evaluator.PartialEval(predicate), out toRet))
{
toRet = _repository.LoadSearch(predicate, count);
CacheHelper.Add(Module + "_" + Evaluator.PartialEval(predicate), toRet, BlCommon.DefaultTimeOut());
}
return(toRet);
}
public static Code LoadSingle(long userId, string tableName, string codeName, bool notFromCache = false)
{
var toRet = new Code {
TableName = tableName, CodeName = codeName
};
if (!CacheHelper.Get(Module + "_" + toRet.TableName + "_" + toRet.CodeName, out toRet) || notFromCache)
{
var codeRepository = new CodeRepository();
toRet = codeRepository.LoadSingle(tableName, codeName);
if (toRet != null)
{
if (tableName == "_System" && codeName == "DefaultTimeOut")
{
CacheHelper.Add(Module + "_" + toRet.TableName + "_" + toRet.CodeName, toRet, Convert.ToInt32(toRet.Value1));
}
else
{
CacheHelper.Add(Module + "_" + toRet.TableName + "_" + toRet.CodeName, toRet, BlCommon.DefaultTimeOut());
}
}
}
return(toRet);
}
