public string GetConfigParameterValueFromDataSourceInfo(string moduleId, string dataSourceId, string protocol, string fileFormat, string aggregationSubType = "Incremental", string aggregationType = "REALListing")
{
//RdcCode is data source id.
string paramValue = "";
using (SystemEntities se = new SystemEntities())
{
try
{
var dataSourceResult =
se.spDA_TCSDatasource_sel(moduleId.ToString(CultureInfo.InvariantCulture), false).ToList();
if (dataSourceResult.Count == 0)
{
return(null);
}
int dsid = 0;
foreach (var item in dataSourceResult)
{
if (item.OriginalDataSourceID.ToLower().Trim().Equals(dataSourceId.ToLower().Trim()))
{
dsid = item.datasourceid;
break;
}
}
var dataSourceConfigResult =
se.spDA_GetDataSourceConfigBasic(dsid.ToString(CultureInfo.InvariantCulture), protocol.ToString(CultureInfo.InvariantCulture), fileFormat.ToString(CultureInfo.InvariantCulture)).ToList();
if (dataSourceConfigResult.Count == 0)
{
return(null);
}
foreach (var item in dataSourceConfigResult)
{
if (!(item.AggregationSubType.Equals(aggregationSubType) && item.AggregationType.Equals(aggregationType)))
{
continue;
}
else
{
paramValue = item.FileFormatInfo.Trim();
break;
}
}
}
catch (Exception ex)
{
}
}
return(paramValue);
}
public bool ExistAggregationTypeFromDataSourceInfo(string moduleId, string dataSourceId, string protocol, string fileFormat, string aggregationType)
{
//RdcCode is data source id.
bool existAggregationType = false;
using (SystemEntities se = new SystemEntities())
{
try
{
var dataSourceResult =
se.spDA_TCSDatasource_sel(moduleId.ToString(CultureInfo.InvariantCulture), false).ToList();
if (dataSourceResult.Count == 0)
{
return(existAggregationType);
}
int dsid = 0;
foreach (var item in dataSourceResult)
{
if (item.OriginalDataSourceID.ToLower().Trim().Equals(dataSourceId.ToLower().Trim()))
{
dsid = item.datasourceid;
break;
}
}
var dataSourceConfigResult =
se.spDA_GetDataSourceConfigBasic(dsid.ToString(CultureInfo.InvariantCulture), protocol.ToString(CultureInfo.InvariantCulture), fileFormat.ToString(CultureInfo.InvariantCulture)).ToList();
if (dataSourceConfigResult.Count == 0)
{
return(existAggregationType);
}
foreach (var item in dataSourceConfigResult)
{
if ((item.AggregationType.Equals(aggregationType)))
{
existAggregationType = true;
break;
}
}
}
catch (Exception ex)
{
}
}
return(existAggregationType);
}
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);
}
}
}
