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"));
}
