public List <string> GetUserBILogin()
{
List <string> lstString = new List <string>();
// add this to utiiy class
Type type = (Type)cache.Get("VA037Svc");
if (type == null)
{
Assembly assem = Assembly.Load("VA037Svc");
type = assem.GetType("VA037Svc.Classes.Common");
cache.Add("VA037Svc", type);
}
if (type != null)
{
var o = Activator.CreateInstance(type);
MethodInfo methodInfo = type.GetMethod("GetLoginSession", new Type[] { typeof(Ctx), typeof(VLogger) });
object[] param = new object[2];
param[0] = ctx;
param[1] = log;
var result = methodInfo.Invoke(o, param);
lstString.Add(result.ToString());
PropertyInfo prop = type.GetProperty("BIUrl");
if (null != prop)
{
var propValue = prop.GetValue(type, null);
lstString.Add(propValue.ToString());
}
}
return(lstString);
}
public static MSession Get(Ctx ctx, String SessionType, bool createNew, String Remote_Addr, String Remote_Host, String WebSession)
{
int AD_Session_ID = ctx.GetContextAsInt("#AD_Session_ID");
MSession session = null;
if (AD_Session_ID > 0)
{
session = s_sessions.Get(ctx, AD_Session_ID);
if (session == null)
{
session = new MSession(ctx, AD_Session_ID, null);
}
if (session.IsProcessed())
{
s_log.Log(Level.WARNING, "Processed=" + session, new ArgumentException("Processed"));
s_sessions.Remove(AD_Session_ID);
return(null);
}
}
if (session == null)
{
if (createNew)
{
session = new MSession(ctx, SessionType, Remote_Addr, Remote_Host, null);
session.Save();
AD_Session_ID = session.GetAD_Session_ID();
ctx.SetContext("#AD_Session_ID", AD_Session_ID);
cache.Add(AD_Session_ID, session);
if (s_sessions.ContainsKey(AD_Session_ID))
{
s_sessions[AD_Session_ID] = session;
}
else
{
s_sessions.Add(AD_Session_ID, session);
}
}
else
{
s_log.Warning("No Session!");
}
}
return(session);
} // get
} /** if (AD_SysConfig_ID == 0){SetAD_SysConfig_ID (0);} */
public static String GetValue(String Name, bool Reload)
{
String str = "";
if (!Reload)
{
str = Util.GetValueOfString(cache.Get(Name));
if (!string.IsNullOrEmpty(str))
{
return(str);
}
}
//
String sql = "SELECT Value FROM AD_SysConfig"
+ " WHERE IsActive='Y' AND Name='" + Name + "'"
+ " ORDER BY AD_Client_ID DESC, AD_Org_ID DESC";
IDataReader dr = null;
try
{
dr = DB.ExecuteReader(sql, null);
while (dr.Read())
{
str = dr.GetString(0);
}
}
catch (Exception e)
{
_log.Log(Level.SEVERE, "getValue", e);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
//
if (str != null)
{
cache[Name] = str;
return(str);
}
else
{
// anyways, put the not found key as null
cache[Name] = null;
return(null);
}
}
/// <summary>
/// Get Year
/// </summary>
/// <param name="ctx">context</param>
/// <param name="C_Year_ID"></param>
/// <returns>year or null</returns>
/// <date>07-march-2011</date>
/// <writer>raghu</writer>
public static MYear Get(Ctx ctx, int C_Year_ID)
{
MYear year = _years.Get(ctx, C_Year_ID);
if (year != null)
{
return(year);
}
//
String sql = "SELECT * FROM C_Year WHERE C_Year_ID=" + C_Year_ID;
IDataReader idr = null;
try
{
idr = DB.ExecuteReader(sql, null);
DataTable dt = new DataTable();
dt.Load(idr);
idr.Close();
if (dt.Rows.Count > 0) // first only
{
year = new MYear(ctx, dt.Rows[0], null);
}
}
catch (Exception e)
{
s_log.Log(Level.SEVERE, sql, e);
}
finally
{
if (idr != null)
{
idr.Close();
idr = null;
}
}
return(year);
}
public JavaScriptResult Application()
{
//var s = Codec.DecryptStringAES();
StringBuilder sb = new StringBuilder();
Ctx ctx = Session["ctx"] as Ctx;
if (ctx.GetSecureKey() == "")
{
ctx.SetSecureKey(SecureEngineBridge.GetRandomKey());
}
// ctx.SetApplicationUrl(@Url.Content("~/"));
ctx.SetIsSSL(Request.Url.Scheme == Uri.UriSchemeHttps);
//lakhwinder
string fullUrl = Request.Url.AbsoluteUri.Remove(Request.Url.AbsoluteUri.LastIndexOf('/'));
//fullUrl = fullUrl.Remove(fullUrl.LastIndexOf('/'));
//fullUrl = fullUrl.Remove(fullUrl.LastIndexOf('/'));
fullUrl = fullUrl.Remove(fullUrl.IndexOf("VIS/Resource"));
ctx.SetApplicationUrl(fullUrl);
SecureEngine.Encrypt("a");
CCache <string, string> msgs = Msg.Get().GetMsgMap(ctx.GetAD_Language());
sb.Append("; var VIS = {");
sb.Append("Application: {contextUrl:'").Append(@Url.Content("~/")).Append("',").Append(" contextFullUrl:'").Append(fullUrl).Append("',")
.Append("isMobile:").Append(Request.Browser.IsMobileDevice ? "1" : "0")
.Append(", isRTL:").Append(ctx.GetIsRightToLeft() ? "1" : "0")
.Append(", isBasicDB:").Append(ctx.GetIsBasicDB() ? "1" : "0")
.Append(", isSSL:").Append((Request.Url.Scheme != Uri.UriSchemeHttps ? "0" :"1")) //TODO
.Append("},");
sb.Append("I18N: { }, context: { }");
sb.Append("};");
sb.Append("VIS.Consts={");
/* Table */
sb.Append("'ACCESSLEVEL_Organization' : '1','ACCESSLEVEL_ClientOnly' : '2','ACCESSLEVEL_ClientPlusOrganization' : '3' ,'ACCESSLEVEL_SystemOnly' : '4'");
sb.Append(", 'ACCESSLEVEL_SystemPlusClient' : '6','ACCESSLEVEL_All' : '7'");
sb.Append(", 'ACCESSTYPERULE_Accessing' : 'A', 'ACCESSTYPERULE_Exporting' : 'E' , 'ACCESSTYPERULE_Reporting' : 'R'");
sb.Append("};");
/* USER */
sb.Append(" VIS.MUser = {");
sb.Append("'isAdministrator':'" + MUser.Get(ctx).IsAdministrator() + "', 'isUserEmployee':'" + MUser.GetIsEmployee(ctx, ctx.GetAD_User_ID()) + "' }; ");
/* ROLE */
sb.Append(" VIS.MRole = {");
sb.Append(" 'vo' : " + Newtonsoft.Json.JsonConvert.SerializeObject(VIS.Helpers.RoleHelper.GetRole(VAdvantage.Model.MRole.GetDefault(ctx, false))) + " , ");
sb.Append(" 'SQL_RW' : true, 'SQL_RO' : false, 'SQL_FULLYQUALIFIED' : true, 'SQL_NOTQUALIFIED' : false,'SUPERUSER_USER_ID' : 100, 'SYSTEM_USER_ID' : 0 ");
sb.Append(", 'PREFERENCETYPE_Client':'C', 'PREFERENCETYPE_None':'N', 'PREFERENCETYPE_Organization':'O', 'PREFERENCETYPE_User':'******'");
sb.Append(", columnSynonym : { 'AD_User_ID': 'SalesRep_ID','C_ElementValue_ID':'Account_ID'}");
sb.Append("};");
/* CTX */
SetLoginContext(ctx);
sb.Append(" VIS.context.ctx = ").Append(Newtonsoft.Json.JsonConvert.SerializeObject(ctx.GetMap())).Append("; ");
/* Message */
sb.Append(" VIS.I18N.labels = { ");
if (msgs != null)
{
int total = msgs.Keys.Count;
foreach (var key in msgs.Keys)
{
--total;
//if (key.Contains('\n') || key.Contains('\'')
// || key.Contains('\"') || key.StartsWith("SC_") || key.Contains('\r'))
//{
// continue;
//}
//if (msgs.Get(key).ToString().Contains('\n') || msgs.Get(key).ToString().Contains('\'')
// || msgs.Get(key).ToString().Contains('\"') || msgs.Get(key).ToString().Contains('\r'))
//{
// continue;
//}
string msg = (string)msgs.Get(key) ?? "";
msg = msg.Replace("\n", " ").Replace("\r", " ").Replace("\"", "'");
if (total == 0)
{
sb.Append("\"").Append(key).Append("\": ").Append("\"").Append(msg).Append("\"");
}
else
{
sb.Append("\"").Append(key).Append("\": ").Append("\"").Append(msg).Append("\", ");
}
}
}
sb.Append("};");
// sb.Append(" console.log(VIS.I18N.labels)");
//return View();
//System.Web.Optimization.JsMinify d = new System.Web.Optimization.JsMinify();
//d.Process(
//Update Login Time
var r = new ResourceManager(fullUrl, ctx.GetAD_Client_ID());
r.RunAsync();
r = null;
return(JavaScript(sb.ToString()));
}
