static public List <LeaderRelationship> GetReportsTo(int UserId) { StaffBrokerDataContext d = new StaffBrokerDataContext(); var s = from c in d.AP_StaffBroker_LeaderMetas where c.UserId == UserId select c; List <LeaderRelationship> rtn = new List <LeaderRelationship>(); foreach (StaffBroker.AP_StaffBroker_LeaderMeta row in s) { LeaderRelationship x = new LeaderRelationship(); x.UserId = row.UserId; x.UserName = row.User.DisplayName; x.LeaderId = row.LeaderId; x.LeaderName = row.Leaders.DisplayName; x.DelegateId = -1; x.Delegatename = ""; if (row.DelegateId != null) { x.DelegateId = (int)row.DelegateId; x.Delegatename = row.Delegate.DisplayName; } rtn.Add(x); } return(rtn); }
public static List<LeaderRelationship> GetReportsTo(int UserId) { StaffBrokerDataContext d = new StaffBrokerDataContext(); var s = from c in d.AP_StaffBroker_LeaderMetas where c.UserId == UserId select c; List<LeaderRelationship> rtn = new List<LeaderRelationship>(); foreach (StaffBroker.AP_StaffBroker_LeaderMeta row in s) { LeaderRelationship x = new LeaderRelationship(); x.UserId = row.UserId; x.UserName = row.User.DisplayName; x.LeaderId = row.LeaderId; try { x.LeaderName = row.Leaders.DisplayName; } catch (Exception) { x.LeaderName = "Unknown"; } x.DelegateId = -1; x.Delegatename = ""; if (row.DelegateId != null) { x.DelegateId = (int)row.DelegateId; x.Delegatename = row.Delegate.DisplayName; } rtn.Add(x); } return rtn; }