private string String(Context context, string controlId) { var data = context.Forms.Data(controlId); return(data != string.Empty ? data : null); }
private EnumerableRowCollection <DataRow> Items( Context context, SiteSettings ss, string searchText, Column parentColumn, List <long> parentIds, int offset, bool setAllChoices) { var tableName = $"{ss.ReferenceType}_Items"; var view = GetView( context: context, ss: ss); view.Search = searchText; var column = SetSqlColum( context: context, ss: ss, keyColumnName: Rds.IdColumn(tableName: ss.ReferenceType), textColumnName: "Title"); var where = view.Where( context: context, ss: ss, where : Rds.ItemsWhere().ReferenceId_In( tableName: tableName, sub: new SqlStatement(ss.LinkHashRelatingColumnsSubQuery( context: context, referenceType: ss.ReferenceType, parentColumn: parentColumn, parentIds: parentIds)), _using: (ss.ReferenceType == "Results" || ss.ReferenceType == "Issues") && (parentIds?.Any() ?? false) && parentColumn != null)); var orderBy = view.OrderBy( context: context, ss: ss, orderBy: view.ColumnSorterHash?.Any() != true ? new Rds.ItemsOrderByCollection().Title(tableName: tableName) : null); var join = ss.Join( context: context, join: new IJoin[] { column, where, orderBy }); var dataRows = Rds.ExecuteTable( context: context, statements: Rds.Select( tableName: ss.ReferenceType, dataTableName: "Main", column: column, join: join, where : where, orderBy: orderBy, offset: offset, pageSize: !setAllChoices ? Parameters.General.DropDownSearchPageSize : 0)) .AsEnumerable(); return(dataRows); }
private EnumerableRowCollection <DataRow> Users( Context context, SiteSettings ss, long inheritPermission, string searchText, bool setAllChoices, int offset) { var view = GetView( context: context, ss: ss); var sqlColumn = SetSqlColum( context: context, ss: ss, keyColumnName: "UserId", textColumnName: "Name"); var dataRows = Rds.ExecuteTable( context: context, statements: Rds.SelectUsers( column: sqlColumn, join: Rds.UsersJoin() .Add(new SqlJoin( tableBracket: "\"Depts\"", joinType: SqlJoin.JoinTypes.LeftOuter, joinExpression: "\"Users\".\"DeptId\"=\"Depts\".\"DeptId\"")), where : view.Where( context: context, ss: ss, where : Rds.UsersWhere() .TenantId(context.TenantId) .SiteUserWhere( context: context, siteId: inheritPermission, _using: MembersOnly == true) .SqlWhereLike( tableName: "Depts", name: "SearchText", searchText: searchText, clauseCollection: new List <string>() { Rds.Users_LoginId_WhereLike(factory: context), Rds.Users_Name_WhereLike(factory: context), Rds.Users_UserCode_WhereLike(factory: context), Rds.Users_Body_WhereLike(factory: context), Rds.Depts_DeptCode_WhereLike(factory: context), Rds.Depts_DeptName_WhereLike(factory: context), Rds.Depts_Body_WhereLike(factory: context) })), orderBy: view.OrderBy( context: context, ss: ss, orderBy: view.ColumnSorterHash?.Any() != true ? Rds.UsersOrderBy().Name() : null), offset: offset, pageSize: !setAllChoices ? Parameters.General.DropDownSearchPageSize : 0)) .AsEnumerable(); return(dataRows); }
public void SetChoiceHash( Context context, SiteSettings ss, Column column, string searchText, Column parentColumn, List <long> parentIds, int offset, bool search, bool searchFormat, bool setAllChoices, bool setChoices) { switch (TableName) { case "Depts": column.Type = Column.Types.Dept; if (setChoices) { if (column.UseSearch != true || search || setAllChoices) { var currentSs = SiteSettingsUtilities.DeptsSiteSettings(context: context); Set( context: context, ss: currentSs, column: column, dataRows: Depts( context: context, ss: currentSs, inheritPermission: ss.InheritPermission, searchText: searchText, setAllChoices: setAllChoices, offset: offset), searchFormat: searchFormat); } } break; case "Groups": column.Type = Column.Types.Group; if (setChoices) { if (column.UseSearch != true || search || setAllChoices) { var currentSs = SiteSettingsUtilities.GroupsSiteSettings(context: context); Set( context: context, ss: currentSs, column: column, dataRows: Groups( context: context, ss: currentSs, inheritPermission: ss.InheritPermission, searchText: searchText, setAllChoices: setAllChoices, offset: offset), searchFormat: searchFormat); } } break; case "Users": column.Type = Column.Types.User; if (setChoices) { if (column.UseSearch != true || search || setAllChoices) { var currentSs = SiteSettingsUtilities.UsersSiteSettings(context: context); Set( context: context, ss: currentSs, column: column, dataRows: Users( context: context, ss: currentSs, inheritPermission: ss.InheritPermission, searchText: searchText, setAllChoices: setAllChoices, offset: offset), searchFormat: searchFormat); } } break; default: if (setChoices) { if (SiteId > 0) { if (column.UseSearch != true || search || setAllChoices) { var currentSs = ss.JoinedSsHash.Get(SiteId); if (currentSs != null) { Set( context: context, ss: currentSs, column: column, dataRows: Items( context: context, ss: currentSs, searchText: searchText, parentColumn: parentColumn, parentIds: parentIds, offset: offset, setAllChoices: setAllChoices), searchFormat: searchFormat); } } } } break; } }
public bool OverDeadline(Context context) { return(Deadline?.InRange() == true && Deadline.ToDateTime() < DateTime.Now.ToLocal(context: context)); }
public bool InitialValue(Context context) { return(this.ToJson() == "[]"); }