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);
}