public static IEnumerable <SelectListItem> ResCodes() { return(CodeValueModel.ConvertToSelect(CodeValueModel.ResidentCodesWithZero(), "Id")); }
public static IEnumerable <SelectListItem> StateCodes() { return(CodeValueModel.ConvertToSelect(CodeValueModel.GetStateList(), "Code")); }
private List GetContacts(int pid) { var ctl = new CodeValueModel(); var cts = ctl.ContactTypeCodes(); var managecontacts = DbUtil.Db.CurrentUser.InRole("ManagePrivateContacts"); var cq = from ce in DbUtil.Db.Contactees where ce.PeopleId == pid where (ce.contact.LimitToRole ?? "") == "" || managecontacts orderby ce.contact.ContactDate descending select new { ce.contact, madeby = ce.contact.contactsMakers.FirstOrDefault().person }; var list = new List(false, 10); list.ListSymbol = new Chunk("\u2022", font); var epip = (from p in DbUtil.Db.People where p.PeopleId == pid select new { ep = p.EntryPoint != null ? p.EntryPoint.Description : "", ip = p.InterestPoint != null ? p.InterestPoint.Description : "" }).Single(); if (epip.ep.HasValue() || epip.ip.HasValue()) { list.Add(new ListItem(1.2f * font.Size, $"Entry, Interest: {epip.ep}, {epip.ip}", font)); } const int maxcontacts = 4; foreach (var pc in cq.Take(maxcontacts)) { var cname = "unknown"; if (pc.madeby != null) { cname = pc.madeby.Name; } var ctyp = cts.SingleOrDefault(ct => ct.Id == pc.contact.ContactTypeId); string ctype = null; if (ctyp != null) { ctype = ctyp.Value; } string comments = null; if (pc.contact.Comments.HasValue()) { comments = pc.contact.Comments.Replace("\r\n\r\n", "\r\n"); } string s = $"{pc.contact.ContactDate:d}: {ctype} by {cname}\n{comments}"; list.Add(new ListItem(1.2f * font.Size, s, font)); } if (cq.Count() > maxcontacts) { list.Add(new ListItem(1.2f * font.Size, $"(showing most recent 10 of {cq.Count()})", font)); } return(list); }
public override IEnumerable <ExtraInfo> CodeSummary() { var NameTypes = Views.GetViewableNameTypes(DbUtil.Db, "People", nocache: true); var standardtypes = new CodeValueModel().ExtraValueTypeCodes(); var adhoctypes = new CodeValueModel().AdhocExtraValueTypeCodes(); var qcodevalues = (from e in DbUtil.Db.PeopleExtras where e.Type == "Bit" || e.Type == "Code" group e by new { e.Field, val = e.StrValue ?? (e.BitValue == true ? "1" : "0"), e.Type, } into g select new { key = g.Key, count = g.Count() }).ToList(); var qcodes = from i in qcodevalues join sv in NameTypes on i.key.Field equals sv.Name into j from sv in j.DefaultIfEmpty() let type = sv == null ? i.key.Type : sv.Type let typobj = sv == null ? adhoctypes.SingleOrDefault(ee => ee.Code == type) : standardtypes.SingleOrDefault(ee => ee.Code == type) let typedisplay = typobj == null ? "unknown" : typobj.Value select new ExtraInfoPeople { Field = i.key.Field, Value = i.key.val, Type = i.key.Type, TypeDisplay = typedisplay, Standard = sv != null, Count = i.count, CanView = sv == null || sv.CanView }; var qdatavalues = (from e in DbUtil.Db.PeopleExtras where !(e.Type == "Bit" || e.Type == "Code") where e.Type != "CodeText" where (e.UseAllValues ?? false) == false group e by new { e.Field, e.Type, } into g select new { key = g.Key, count = g.Count() }).ToList(); var qdatums = from i in qdatavalues join sv in NameTypes on i.key.Field equals sv.Name into j from sv in j.DefaultIfEmpty() let type = sv == null ? i.key.Type : sv.Type let typedisplay = sv == null ? adhoctypes.SingleOrDefault(ee => ee.Code == type) : standardtypes.SingleOrDefault(ee => ee.Code == type) select new ExtraInfoPeople { Field = i.key.Field, Value = "(multiple)", Type = i.key.Type, TypeDisplay = typedisplay == null ? (type ?? "unknown") : typedisplay.Value, Standard = sv != null, Count = i.count, CanView = sv == null || sv.CanView }; return(qcodes.Union(qdatums).OrderBy(ee => ee.Field)); }
public IEnumerable <SelectListItem> PmmLabelData() { return(ToIdValueSelectList(CodeValueModel.PmmLabels())); }
public SelectList AttendCreditList() { return(CodeValueModel.AttendCredits().ToSelect()); }
public IEnumerable <SelectListItem> GenderList() { return(CodeValueModel.ConvertToSelect(cv.GenderCodes(), "Id")); }
public SelectList CampusList() { var cv = new CodeValueModel(); return(new SelectList(cv.AllCampuses0(), "Id", "Value")); }
public IEnumerable <SelectListItem> EntryPointList() { return(CodeValueModel.ConvertToSelect(cv.EntryPoints(), "Id")); }
public IEnumerable <SelectListItem> OrganizationTypes() { return(CodeValueModel.ConvertToSelect(cv.OrganizationTypes0(), "Id")); }
public IEnumerable <SelectListItem> CampusList() { return(CodeValueModel.ConvertToSelect(cv.AllCampuses0(), "Id")); }
public IEnumerable <SelectListItem> MaritalStatuses() { return(CodeValueModel.ConvertToSelect(cv.MaritalStatusCodes99(), "Id")); }
public IEnumerable <SelectListItem> TitleCodes() { return(CodeValueModel.ConvertToSelect(cv.TitleCodes(), "Code")); }
public SelectList GenderList() { var cv = new CodeValueModel(); return(new SelectList(cv.GenderCodes(), "Id", "Value")); }
public IEnumerable <SelectListItem> AttendCreditList() { return(CodeValueModel.ConvertToSelect(CodeValueModel.AttendCredits(), "Id")); }
public SelectList MaritalStatusList() { var cv = new CodeValueModel(); return(new SelectList(cv.MaritalStatusCodes(), "Id", "Value")); }
public IEnumerable <SelectListItem> SecurityTypeList() { return(CodeValueModel.ConvertToSelect(cv.SecurityTypeCodes(), "Id")); }
public IEnumerable <SelectListItem> TagData(int?userpeopleid = null) { var q = new CodeValueModel().UserTags(userpeopleid ?? Util.UserPeopleId).ToList(); return(ToIdValueSelectList(q)); }
public static IEnumerable <SelectListItem> RegistrationTypes() { var cv = new CodeValueModel(); return(CodeValueModel.ConvertToSelect(cv.RegistrationTypes(), "Id")); }
public IEnumerable <SelectListItem> StateCodes() { var cv = new CodeValueModel(); return(CodeValueModel.ConvertToSelect(cv.GetStateListUnknown(), "Code")); }
public static IEnumerable <SelectListItem> LetterStatuses() { return(CodeValueModel.ConvertToSelect(cv.LetterStatusCodes(), "Id")); }