private GSearchResultCube FormatResultKey(GSearchResultCube result)
{
bool isErrored = false;
result.DataSource = new SqlClientManager(ConnectionString, IdpeKeyTypes.ConnectionStringSqlCe)
.ExecuteQuery("select name from idpedatasource ds inner join idpekeydatasource kds on kds.datasourceid = ds.id where keyid = " + result.ReferenceId
, ref isErrored);
int keyType = 0;
if (int.TryParse(result.Param1, out keyType))
{
IdpeKeyTypes idpeKeyType = (IdpeKeyTypes)keyType;
result.Param1 = idpeKeyType.ToString();
if (result.Param1.Contains("OutputWriter"))
{
result.Where = "Output Writer";
}
else if (result.Param1 == "Custom")
{
result.Where = "Custom - " + result.ReferenceName;
}
else
{
result.Where = result.Param1;
}
}
return(result);
}
private GSearchResultCube FormatResultRule(GSearchResultCube result)
{
bool isErrored = false;
string info = new SqlClientManager(ConnectionString, IdpeKeyTypes.ConnectionStringSqlCe)
.ExecuteQuery("select name, rulesettype from idpedatasource ds inner join idperuledatasource rds on rds.datasourceid = ds.id where ruleid = " + result.ReferenceId
, ref isErrored);
if ((info == "NULL") || (string.IsNullOrEmpty(info)))
{
result.DataSource = "0-General";
result.Where = "Master";
}
else
{
info = info.Replace("NULL", string.Empty);
result.DataSource = info.Split("|".ToCharArray())[0];
string strRuleType = info.Split("|".ToCharArray())[1];
int ruleType = 0;
if (int.TryParse(strRuleType, out ruleType))
{
RuleSetTypes ruleSetTypes = (RuleSetTypes)ruleType;
result.Param1 = ruleSetTypes.ToString();
result.Where = "Rule - " + ruleSetTypes.ToString();
}
else
{
result.Where = "Unknown";
}
}
result.Value = string.Empty;
return(result);
}
private List <GSearchResultCube> FormatResults(List <GSearchResultCube> results, int dataSourceId)
{
List <GSearchResultCube> formattedResults = new List <GSearchResultCube>();
foreach (GSearchResultCube result in results)
{
GSearchResultCube formattedResult = result;
switch (result.TableName)
{
case "IdpeAttribute":
result.DataSource = "0-General";
result.Type = "Attribute";
result.Where = "Master";
formattedResult = FormatResult(result);
//formattedResult = FormatResultAttribute(formattedResults, result);
break;
case "IdpeKey":
result.Type = "Key";
formattedResult = FormatResultKey(result);
break;
case "IdpeRule":
result.Type = "Rule";
formattedResult = FormatResultRule(result);
break;
default:
result.Type = "General";
formattedResult = FormatResult(result);
break;
}
formattedResults.Add(formattedResult);
}
formattedResults = formattedResults.OrderBy(r => r.DataSource).ToList();
if (dataSourceId > 0)
{
string dataSourceName = new Manager().GetApplicationName(dataSourceId);
formattedResults = formattedResults.Where(r => r.DataSource == dataSourceName).ToList();
}
return(formattedResults);
}
private GSearchResultCube FormatResultAttribute(List <GSearchResultCube> formattedResults, GSearchResultCube result)
{
result.Type = "";
bool isErrored = false;
DataTable table = new SqlClientManager(ConnectionString, IdpeKeyTypes.ConnectionStringSqlCe)
.ExecuteQueryAndGetDataTable("select name, issystem from idpedatasource ds inner join idpeattributedatasource ads on ads.datasourceid = ds.id where attributeId = " + result.ReferenceId
, ref isErrored);
foreach (DataRow row in table.Rows)
{
GSearchResultCube cube = result;
cube.DataSource = row[0].ToString();
cube.Where = row[1].ToString() == "True" ? "System Data Source" : "Data Source";
cube.Value = string.Empty;
formattedResults.Add(cube);
}
return(result);
}
private GSearchResultCube FormatResult(GSearchResultCube result)
{
return(result);
}
