/// <summary>
/// Returns all Users currently in the System
/// </summary>
/// <returns></returns>
public Users ALLUsers()
{
try
{
Users X = new Users();
string sSQL = "Select * FROM tblUser WHERE Name != 'System Administrator' AND " +
" Name != 'Nobody'" +
" ORDER BY Name";
DataTable DT = GetDataTable(sSQL);
foreach(DataRow R in DT.Rows)
{
User U = null;
FillUser(ref U,R);
X.Add(U);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
internal Users ReturnUsersInHierarchy(int SectionID,Users gUsers)
{
string sSQL = "Select UserId FROM tblUserSectionRel WHERE SectionId = " + SectionID;
DataTable DT = GetDataTable(sSQL);
Users US = new Users();
int[] UO = GetUnassignedObjects();
foreach(DataRow R in DT.Rows)
{
int UserId = Convert.ToInt32(R[0]);
User NewUser = GetUser(UserId);
US.Add(NewUser);
Sections NSections = GetUsersOwnedSections(NewUser.ID,SectionID);
if(NSections != null)
{
foreach(Section S in NSections)
{
Users NUsers = ReturnUsersInHierarchy(S.mvarID,gUsers);
foreach(User CheckMe in NUsers)
{
foreach(User AgainstMe in gUsers)
{
if(CheckMe.mvarID == AgainstMe.mvarID)
{
goto SkipMe;
}
}
if(UO[0] != CheckMe.ID)
gUsers.Add(CheckMe);
SkipMe:{}
}
}
}
}
if(US.Count > 0)
{
foreach(User CheckMe in US)
{
foreach(User AgainstMe in gUsers)
{
if(CheckMe.mvarID == AgainstMe.mvarID)
{
goto SkipMeToo;
}
}
gUsers.Add(CheckMe);
SkipMeToo:{}
}
}
DT.Dispose();
return gUsers;
}
/// <summary>
/// Returns all Users currently in the Group
/// </summary>
/// <param name="GroupId"></param>
/// <returns></returns>
internal Users All_Users(int GroupId)
{
try
{
Users X = new Users();
string sSQL = "SELECT tblGroupUserRel.UserId,tblUser.Name FROM tblGroupUserRel left outer join tblUser ON " +
"tblUser.Id = tblGroupUserRel.UserId WHERE GroupId = " + GroupId +
" ORDER BY tblUser.Name";
DataTable DT = GetDataTable(sSQL);
foreach(DataRow r in DT.Rows)
{
int UserID = Convert.ToInt32(r[0]);
User U = GetUser(UserID);
X.Add(U);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
/// <summary>
/// Returns all the Users in a particular Users Hierarchy
/// </summary>
/// <param name="UserId"></param>
/// <param name="ALLUsers"></param>
/// <param name="ALLSections"></param>
/// <returns></returns>
internal Users ReturnAllHierarchyMembers(int UserId)
{
Users ALLMYUSERS = new Users();
Sections PrimarySections = GetUsersOwnedSections(UserId);
int[] UO = GetUnassignedObjects();
foreach(Section S in PrimarySections)
{
Users NUsers = ReturnUsersInHierarchy(S.mvarID,ALLMYUSERS);
foreach(User CheckMe in NUsers)
{
foreach(User AgainstMe in ALLMYUSERS)
{
if(CheckMe.mvarID == AgainstMe.mvarID)
{
goto SkipMe;
}
}
if(UO[0] != CheckMe.ID) // Make certain Nobody never ever shows up.
{
ALLMYUSERS.Add(CheckMe);
}
//ALLMYUSERS.Add(CheckMe);
SkipMe:{}
}
}
//ALLMYUSERS.Sort();
return ALLMYUSERS;
}
/// <summary>
/// Returns all Users currently in this Section
/// </summary>
/// <returns></returns>
internal Users ALLUsers(int SectionID)
{
try
{
Users X = new Users();
string sSQL = "SELECT usr.UserId,u.Name FROM tblUserSectionRel usr " +
" left outer join tblUser u ON u.Id = usr.UserId " +
"WHERE usr.SectionId = " + SectionID +
"ORDER BY u.Name";
DataTable DT = GetDataTable(sSQL);
foreach(DataRow r in DT.Rows)
{
int UserID = Convert.ToInt32(r[0]);
User U = GetUser(UserID);
U.mvarCurrentSectionID = SectionID;
X.Add(U);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}