public static MetaLogin GetMetaLogin(long globalLoginId)
{
string sql = "SELECT * FROM public.global_logins WHERE global_login_id=@0;";
if (Factory.ProviderName.ToLower().Contains("sqlclient"))
{
sql = "SELECT * FROM [dbo].global_logins WHERE global_login_id=@0;";
}
MetaLogin login = Factory.Get <MetaLogin>(Factory.MetaDatabase, sql, globalLoginId).FirstOrDefault();
if (login != null)
{
string catalog = login.Catalog;
LoginView view =
Factory.Get <LoginView>(catalog, "SELECT * FROM office.sign_in_view WHERE login_id=@0;",
login.LoginId).FirstOrDefault();
if (view != null)
{
login.View = view;
return(login);
}
}
return(null);
}
public static void SetCurrentLogin(long globalLoginId)
{
if (globalLoginId > 0)
{
string key = globalLoginId.ToString(CultureInfo.InvariantCulture);
if (MemoryCache.Default[key] == null)
{
MetaLogin metaLogin = GetMetaLogin(globalLoginId);
Dictionary <string, object> dictionary = GetDictionary(metaLogin);
CacheFactory.AddToDefaultCache("Dictionary" + key, dictionary);
CacheFactory.AddToDefaultCache(key, metaLogin);
}
}
}
public static MetaLogin GetCurrent(long globalLoginId)
{
MetaLogin login = new MetaLogin();
if (globalLoginId != 0)
{
login = CacheFactory.GetFromDefaultCacheByKey(globalLoginId.ToString(CultureInfo.InvariantCulture)) as MetaLogin;
}
if (login == null)
{
login = new MetaLogin();
}
if (login.View == null)
{
login.View = new LoginView();
}
return login;
}
private static Dictionary <string, object> GetDictionary(MetaLogin metaLogin)
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
if (metaLogin == null)
{
return(dictionary);
}
dictionary.Add("Catalog", metaLogin.Catalog);
dictionary.Add("AddressLine1", metaLogin.View.AddressLine1);
dictionary.Add("AddressLine2", metaLogin.View.AddressLine2);
dictionary.Add("City", metaLogin.View.City);
dictionary.Add("Country", metaLogin.View.Country);
dictionary.Add("Culture", metaLogin.View.Culture);
dictionary.Add("CurrencyCode", metaLogin.View.CurrencyCode);
dictionary.Add("Email", metaLogin.View.Email);
dictionary.Add("Fax", metaLogin.View.Fax);
dictionary.Add("FullName", metaLogin.View.FullName);
dictionary.Add("NickName", metaLogin.View.NickName);
dictionary.Add("Office", metaLogin.View.Office);
dictionary.Add("OfficeCode", metaLogin.View.OfficeCode);
dictionary.Add("OfficeId", metaLogin.View.OfficeId);
dictionary.Add("OfficeName", metaLogin.View.OfficeName);
dictionary.Add("PanNumber", metaLogin.View.PanNumber);
dictionary.Add("Phone", metaLogin.View.Phone);
dictionary.Add("RegistrationDate", metaLogin.View.RegistrationDate);
dictionary.Add("RegistrationNumber", metaLogin.View.RegistrationNumber);
dictionary.Add("Role", metaLogin.View.Role);
dictionary.Add("RoleCode", metaLogin.View.RoleCode);
dictionary.Add("RoleName", metaLogin.View.RoleName);
dictionary.Add("State", metaLogin.View.State);
dictionary.Add("Street", metaLogin.View.Street);
dictionary.Add("Url", metaLogin.View.Url);
dictionary.Add("UserId", metaLogin.View.UserId);
dictionary.Add("UserName", metaLogin.View.UserName);
dictionary.Add("ZipCode", metaLogin.View.ZipCode);
return(dictionary);
}
public static MetaLogin GetMetaLogin(long globalLoginId)
{
const string sql = "SELECT * FROM public.global_logins WHERE global_login_id=@0;";
MetaLogin login = Factory.Get <MetaLogin>(Factory.MetaDatabase, sql, globalLoginId).FirstOrDefault();
if (login != null)
{
string catalog = login.Catalog;
LoginView view =
Factory.Get <LoginView>(catalog, "SELECT * FROM office.sign_in_view WHERE login_id=@0;",
login.LoginId).FirstOrDefault();
if (view != null)
{
login.View = view;
return(login);
}
}
return(null);
}
public static MetaLogin GetCurrent(long globalLoginId)
{
MetaLogin login = new MetaLogin();
if (globalLoginId != 0)
{
login = CacheFactory.GetFromDefaultCacheByKey(globalLoginId.ToString(CultureInfo.InvariantCulture)) as MetaLogin;
}
if (login == null)
{
login = new MetaLogin();
}
if (login.View == null)
{
login.View = new LoginView();
}
return(login);
}
private static Dictionary<string, object> GetDictionary(MetaLogin metaLogin)
{
Dictionary<string, object> dictionary = new Dictionary<string, object>();
if (metaLogin == null)
{
return dictionary;
}
dictionary.Add("Catalog", metaLogin.Catalog);
dictionary.Add("AddressLine1", metaLogin.View.AddressLine1);
dictionary.Add("AddressLine2", metaLogin.View.AddressLine2);
dictionary.Add("City", metaLogin.View.City);
dictionary.Add("Country", metaLogin.View.Country);
dictionary.Add("Culture", metaLogin.View.Culture);
dictionary.Add("CurrencyCode", metaLogin.View.CurrencyCode);
dictionary.Add("Email", metaLogin.View.Email);
dictionary.Add("Fax", metaLogin.View.Fax);
dictionary.Add("FullName", metaLogin.View.FullName);
dictionary.Add("NickName", metaLogin.View.NickName);
dictionary.Add("Office", metaLogin.View.Office);
dictionary.Add("OfficeCode", metaLogin.View.OfficeCode);
dictionary.Add("OfficeId", metaLogin.View.OfficeId);
dictionary.Add("OfficeName", metaLogin.View.OfficeName);
dictionary.Add("PanNumber", metaLogin.View.PanNumber);
dictionary.Add("Phone", metaLogin.View.Phone);
dictionary.Add("RegistrationDate", metaLogin.View.RegistrationDate);
dictionary.Add("RegistrationNumber", metaLogin.View.RegistrationNumber);
dictionary.Add("Role", metaLogin.View.Role);
dictionary.Add("RoleCode", metaLogin.View.RoleCode);
dictionary.Add("RoleName", metaLogin.View.RoleName);
dictionary.Add("State", metaLogin.View.State);
dictionary.Add("Street", metaLogin.View.Street);
dictionary.Add("Url", metaLogin.View.Url);
dictionary.Add("UserId", metaLogin.View.UserId);
dictionary.Add("UserName", metaLogin.View.UserName);
dictionary.Add("ZipCode", metaLogin.View.ZipCode);
return dictionary;
}
