private IEnumerable <IAssociationOption> GetRoom(string location, string building, string floor) { var dto = new SearchRequestDto(); dto.AppendSearchEntry("LOCATION", building + "/FL:" + floor + "/RO:%"); return(BuildingFloorRoomManager.DoGetLocation(location, dto, dict => { var rawValue = (String)dict["location"]; //TODO: fix label return new AssociationOption(rawValue, rawValue.Split(new[] { "RO:" }, StringSplitOptions.None)[1]); })); }
private IEnumerable <IAssociationOption> GetFloor(string location, string building) { var dto = new SearchRequestDto(); dto.AppendSearchEntry("LOCATION", building + "/FL:%"); dto.AppendProjectionField(new ProjectionField("location", String.Format("DISTINCT SUBSTR(REPLACE(location.Location,'{0}',''),1,LOCATE('/',REPLACE(location.Location,'{0}',''))-1)", building + "/FL:"))); dto.SearchSort = "location"; dto.ExpressionSort = true; dto.SearchAscending = true; return(BuildingFloorRoomManager.DoGetLocation(location, dto, dict => { var rawValue = (String)dict["location"]; return new AssociationOption(rawValue, rawValue); })); }
private IEnumerable <IAssociationOption> GetBuilding(string location) { var dto = new SearchRequestDto(); dto.AppendSearchEntry("CLASSSTRUCTUREID", "BUILDING"); dto.AppendProjectionField(ProjectionField.Default("description")); dto.AppendProjectionField(ProjectionField.Default("location")); return(BuildingFloorRoomManager.DoGetLocation(location, dto, dict => { var rawLabel = (String)dict["description"]; var rawValue = (String)dict["location"]; //TODO: fix label return new AssociationOption(rawValue.Split('/')[0], rawLabel); })); }