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