public List <Organization> GetUserOrgs(string userId, int groupType)
{
List <Organization> orgs = new List <Organization>();
try
{
var dbOrgs = JSSESecurityManager.GetUserOrganizations(userId, groupType);
foreach (var dbOrg in dbOrgs)
{
if (!orgs.Any(o => o.Org_Id == dbOrg.org_cd))
{
Organization org = new Organization();
org.Org_Id = dbOrg.org_cd;
org.Org_Name = dbOrg.org_level_name;
org.MajorGroup_Id = dbOrg.vp_cd;
org.MajorGroup_Name = dbOrg.vp_level_name;
org.Departments = null;
orgs.Add(org);
}
}
}
catch
{
throw;
}
return(orgs.Distinct().ToList());
}
public List <MajorGroup> GetUserMajorGroups(string userId, int groupType)
{
List <MajorGroup> mgs = new List <MajorGroup>();
List <Organization> orgs = null;
List <Department> depts = null;
List <Section> sects = null;
try
{
var dbMGs = JSSESecurityManager.GetUserOrganizations(userId, groupType);
foreach (var dbMG in dbMGs)
{
if (!mgs.Any(o => o.MajorGroup_Id == dbMG.vp_cd))
{
MajorGroup mg = new MajorGroup();
mg.MajorGroup_Id = dbMG.vp_cd;
mg.MajorGroup_Name = dbMG.vp_level_name;
var dbOrgs = dbMGs.Where(m => m.vp_cd == dbMG.vp_cd);
orgs = new List <Organization>();
foreach (var dbOrg in dbOrgs)
{
if (!orgs.Any(o => o.Org_Id == dbOrg.org_cd))
{
Organization org = new Organization();
org.Org_Id = dbOrg.org_cd;
org.Org_Name = dbOrg.org_level_name;
var dbDepts = dbOrgs.Where(m => m.org_cd == dbOrg.org_cd);
depts = new List <Department>();
foreach (var dbDept in dbDepts)
{
if (!depts.Any(o => o.Dept_Id == dbDept.dept_cd))
{
Department dept = new Department();
dept.Dept_Id = dbDept.dept_cd;
dept.Dept_Name = dbDept.dept_level_name;
var dbSects = dbDepts.Where(m => m.dept_cd == dbDept.dept_cd);
sects = new List <Section>();
foreach (var dbSect in dbSects)
{
if (!sects.Any(o => o.Section_Id == dbDept.sect_cd))
{
Section sect = new Section();
sect.Section_Id = dbSect.sect_cd;
sect.Section_Name = dbSect.sect_level_name;
sects.Add(sect);
}
}
dept.Sections = sects.ToArray();
depts.Add(dept);
}
}
org.Departments = depts.ToArray();
orgs.Add(org);
}
}
mg.Organizations = orgs.ToArray();
mgs.Add(mg);
}
}
}
catch
{
throw;
}
return(mgs.Distinct().ToList());
}
