protected string DoGetWhereClause(string entity, DashBoardType?dashboard = null)
{
var sb = new StringBuilder();
var listOfServices = GetListOfServices();
if (listOfServices != null)
{
sb.Append(ServicesWhereClause.Fmt(entity, listOfServices));
}
if (dashboard != null && dashboard != DashBoardType.EuOpenRequests)
{
//this first condition goes except for the EuOpenRequests
if (listOfServices != null)
{
sb.Append(" and ");
}
sb.Append(HapagQueryConstants.ITCActionRequired(entity));
}
if (entity == "sr")
{
//we need to do an or with the enduser queries for SR, since the menu is merged
sb.Append(MergeWithEndUserQuery(dashboard, sb.Length > 0));
}
return(sb.ToString());
}
public string DashboardIMACWhereClause()
{
var ctx = _contextLookuper.LookupContext();
var isViewAllOperation = ctx.ApplicationLookupContext != null &&
"list".Equals(ctx.ApplicationLookupContext.Schema);
return(HapagQueryConstants.ITCOpenImacs(GetUserPersonGroupsUtils(true), isViewAllOperation));
}
public string DashboardIncidentWhereClause()
{
return(HapagQueryConstants.IncidentITCDashboard());
}
public string ITCDashboardIncidentWhereClause()
{
return("(" + _r0017WhereClauseProvider.IncidentWhereClause() + ")" + " AND " + HapagQueryConstants.IncidentITCDashboard());
}
public string XITCDashboardSRWhereClause()
{
return("(" + _r0017WhereClauseProvider.SRWhereClause() + ")" + " AND " + HapagQueryConstants.SrITCDashboard());
}
public string LocalITCDashboardSRWhereClause()
{
//appends EU logic
return("(" + _r0017WhereClauseProvider.LocalITCSRWhereClause() + ")" + " AND " + HapagQueryConstants.SrITCDashboard());
}
