private void GetTraceLogin(ref PendingStatusCompareResult compareResult)
{
using (var se = new SystemEntities())
{
try
{
var loginTraceInfo =
se.spDA_RETSConnectionInfo_sel(compareResult.RdcCode, false).FirstOrDefault();
var dataSourceResult =
se.spDA_TCSDatasource_sel(compareResult.ModuleId.ToString(CultureInfo.InvariantCulture),
false).ToList();
if (dataSourceResult.Count == 0)
{
compareResult.IsDataSourceRemoved = true;
_loginTrace = null;
return;
}
foreach (var item in dataSourceResult)
{
if (!item.OriginalDataSourceID.Equals(compareResult.RdcCode))
{
continue;
}
compareResult.TraceName = item.datasourcename.Trim();
break;
}
if (string.IsNullOrEmpty(compareResult.TraceName) || compareResult.TraceName.EndsWith("Test", StringComparison.OrdinalIgnoreCase))
{
compareResult.IsDataSourceRemoved = true;
_loginTrace = null;
}
if (loginTraceInfo != null)
{
_loginTrace = new LoginInfo
{
UserName = loginTraceInfo.RETSUserName,
Password = loginTraceInfo.RETSPassword,
UserAgent = loginTraceInfo.RETSUserAgent,
UaPassword = loginTraceInfo.RETSUserAgentPassword,
ByPassAuthentication = "1"
};
}
}
catch (Exception ex)
{
compareResult.IsDataSourceRemoved = true;
Log.Error(typeof(PsaManager), "Cannot retrieve log in info from Trace for Module:" + compareResult.ModuleId + ex.Message + ex.StackTrace);
}
}
}
public LoginInfo GetDataAggTraceInfoExtra(string dataSourceId, int moduleId, ref string retsLoginURL, string protocol, string aggregationType = "REALListing")
{
//RdcCode is data source id.
LoginInfo loginInfo = null;
using (SystemEntities se = new SystemEntities())
{
try
{
var loginTraceInfo = se.spDA_RETSConnectionInfo_sel(dataSourceId.ToString(CultureInfo.InvariantCulture),
false).FirstOrDefault();
if (loginTraceInfo != null)
{
var aggregationSubType = "Full";
var paramValue = this.GetConfigParameterValueFromDataSourceInfo(moduleId.ToString(CultureInfo.InvariantCulture), dataSourceId.ToString(CultureInfo.InvariantCulture), protocol, "TCSUserID", aggregationSubType, aggregationType);
if (string.IsNullOrWhiteSpace(paramValue))
{
aggregationSubType = "Incremental";
paramValue = this.GetConfigParameterValueFromDataSourceInfo(moduleId.ToString(CultureInfo.InvariantCulture), dataSourceId.ToString(CultureInfo.InvariantCulture), protocol, "TCSUserID", aggregationSubType, aggregationType);
}
var userName = paramValue == null ? "" : paramValue.ToString();
paramValue = this.GetConfigParameterValueFromDataSourceInfo(moduleId.ToString(CultureInfo.InvariantCulture), dataSourceId.ToString(CultureInfo.InvariantCulture), protocol, "TCSPassword", aggregationSubType, aggregationType);
var password = paramValue == null ? "" : paramValue.ToString();
paramValue = this.GetConfigParameterValueFromDataSourceInfo(moduleId.ToString(CultureInfo.InvariantCulture), dataSourceId.ToString(CultureInfo.InvariantCulture), protocol, "TCSUserAgent", aggregationSubType, aggregationType);
var userAgent = paramValue == null ? "" : paramValue.ToString();
paramValue = this.GetConfigParameterValueFromDataSourceInfo(moduleId.ToString(CultureInfo.InvariantCulture), dataSourceId.ToString(CultureInfo.InvariantCulture), protocol, "TCSUserAgentPwd", aggregationSubType, aggregationType);
var uaPassword = paramValue == null ? "" : paramValue.ToString();
loginInfo = new LoginInfo
{
UserName = userName,
Password = password,
UserAgent = userAgent,
UaPassword = uaPassword,
ByPassAuthentication = "1"
};
retsLoginURL = loginTraceInfo.RETSLoginURL;
}
}
catch (Exception ex)
{
}
}
return(loginInfo);
}
public void GetLoginfromDB(ModuleLoginContainer compareResult, StreamWriter streamWriterReport)
{
var LoginInfo = new ModuleLoginContainer();
try
{
bool loginInfoExistsInTCS = false;
using (var tcsDb = new TCSEntities())
{
short moduleId = Convert.ToInt16(compareResult.ModuleId);
if (tcsDb.tcs_rets_connection_info.Any(x => x.module_id == moduleId))
{
loginInfoExistsInTCS = true;
var qe = tcsDb.tcs_rets_connection_info.Where(x => x.module_id == moduleId).FirstOrDefault();
compareResult.LoginURL = qe.login_url;
compareResult.LoginUserName = qe.user_name;
compareResult.LoginPassword = qe.password;
compareResult.UserAgent = qe.user_agent;
compareResult.UserAgentPW = qe.ua_password;
}
}
if (!loginInfoExistsInTCS)
{
using (SystemEntities se = new SystemEntities())
{
se.Connection.Open();
ObjectResult <spDA_RETSConnectionInfo_sel_Result> loginTrace =
se.spDA_RETSConnectionInfo_sel(compareResult.RdcCode, false);
foreach (var connInfo in loginTrace)
{
compareResult.LoginURL = connInfo.RETSLoginURL;
compareResult.LoginUserName = connInfo.RETSUserName;
compareResult.LoginPassword = connInfo.RETSPassword;
compareResult.UserAgent = connInfo.RETSUserAgent;
compareResult.UserAgentPW = connInfo.RETSUserAgentPassword;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Failed to access DataAgg db\r\n" + ex.Message + ex.Source + ex.StackTrace);
}
}
public LoginInfo GetDataAggTraceInfo(string dataSourceId, ref string retsLoginURL)
{
//RdcCode is data source id.
LoginInfo loginInfo = null;
using (SystemEntities se = new SystemEntities())
{
try
{
var loginTraceInfo = se.spDA_RETSConnectionInfo_sel(dataSourceId.ToString(CultureInfo.InvariantCulture),
false).FirstOrDefault();
//var dataSourceResult =
// se.spDA_TCSDatasource_sel(moduleId.ToString(CultureInfo.InvariantCulture), false).ToList();
//if (dataSourceResult.Count == 0)
//{
// return null;
//}
//string traceName = string.Empty;
//foreach (var item in dataSourceResult)
//{
// if (!item.OriginalDataSourceID.Equals(dataSourceId)) continue;
// traceName = item.datasourcename.Trim();
// break;
//}
//if (string.IsNullOrEmpty(traceName) || traceName.EndsWith("Test", StringComparison.OrdinalIgnoreCase))
//{
// return null;
//}
if (loginTraceInfo != null)
{
loginInfo = new LoginInfo
{
UserName = loginTraceInfo.RETSUserName,
Password = loginTraceInfo.RETSPassword,
UserAgent = loginTraceInfo.RETSUserAgent,
UaPassword = loginTraceInfo.RETSUserAgentPassword,
ByPassAuthentication = "1"
};
retsLoginURL = loginTraceInfo.RETSLoginURL;
}
//se.Connection.Open();
//ObjectResult<spDA_RETSConnectionInfo_sel_Result> loginTrace =
// se.spDA_TCSDatasource_sel(dataSourceId, false);
//foreach (var connInfo in loginTrace)
//{
// ModuleLoginContainer connection = new ModuleLoginContainer();
// connection.LoginURL = connInfo.RETSLoginURL;
// connection.LoginUserName = connInfo.RETSUserName;
// connection.LoginPassword = connInfo.RETSPassword;
// connection.UserAgent = connInfo.RETSUserAgent;
// connection.UserAgentPW = connInfo.RETSUserAgentPassword;
// connections.Add(connection);
//}
}
catch (Exception ex)
{
}
}
return(loginInfo);
}
