static DbCommand BuildCmdDelInActiveUserSessionsList(DataAccessMgr daMgr)
{
DbTableDmlMgr dmlDeleteMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE
, Constants.UserSessions);
string joinTable = dmlDeleteMgr.AddJoin(DataAccess.Constants.SCHEMA_CORE
, Constants.SignonControl, DbTableJoinType.Cross, null);
string dateAdd = daMgr.FormatDateMathSql(EnumDateDiffInterval.Second
, dmlDeleteMgr.AliasedColumn(joinTable, Constants.StatusSeconds),
dmlDeleteMgr.Column(Constants.SessionDateTime));
dmlDeleteMgr.SetWhereCondition(j => j.Function(dateAdd)
< j.Function(daMgr.GetDbTimeAs(EnumDateTimeLocale.UTC, null)));
return(daMgr.BuildDeleteDbCommand(dmlDeleteMgr));
}
static DbCommand BuildCmdGetAccessControlRulesList(DataAccessMgr daMgr)
{
DbTableDmlMgr dmlSelectMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE
, Constants.AccessControlGroups);
string joinTable = dmlSelectMgr.AddJoin(DataAccess.Constants.SCHEMA_CORE
, Constants.AccessControlGroupRules
, DbTableJoinType.Inner
, j => j.Column(Constants.AccessControlGroupCode)
== dmlSelectMgr.Column(Constants.AccessControlGroupCode)
, Constants.UIControlCode
, Constants.AccessDenied);
dmlSelectMgr.SetWhereCondition(j => j.Column(Constants.AccessControlGroupCode) ==
j.Parameter(Constants.AccessControlGroups, Constants.AccessControlGroupCode
, daMgr.BuildParamName(Constants.AccessControlGroupCode)));
return(daMgr.BuildSelectDbCommand(dmlSelectMgr, null));
}