Example #1
0
        public Guid OrgMembersQuery(int progid, int divid, int orgid, string memberTypes)
        {
            var c = db.ScratchPadCondition();

            c.Reset();
            var mtlist = memberTypes.Split(',');
            var mts    = string.Join(";", from mt in db.MemberTypes
                                     where mtlist.Contains(mt.Description)
                                     select $"{mt.Id},{mt.Code}");
            var clause = c.AddNewClause(QueryType.MemberTypeCodes, CompareType.OneOf, mts);

            clause.Program      = progid.ToString();
            clause.Division     = divid.ToString();
            clause.Organization = orgid.ToString();
            c.Save(db);
            return(c.Id);
        }