public static EHierarchyElement GetObject(DatabaseConnection dbConn, int objectID)
{
EHierarchyElement o = new EHierarchyElement();
o.HElementID = objectID;
if (EHierarchyElement.db.select(dbConn, o))
{
return(o);
}
return(null);
}
public bool IsChangeSite(DatabaseConnection dbConn)
{
ERosterCode rosterCode = new ERosterCode();
rosterCode.RosterCodeID = m_RosterCodeID;
if (ERosterCode.db.select(dbConn, rosterCode))
{
ERosterClientSite site = new ERosterClientSite();
site.RosterClientSiteID = rosterCode.RosterClientSiteID;
if (ERosterClientSite.db.select(dbConn, site))
{
ERosterClient client = new ERosterClient();
client.RosterClientID = site.RosterClientID;
if (ERosterClient.db.select(dbConn, client))
{
EHierarchyLevel hLevel = new EHierarchyLevel();
hLevel.HLevelID = client.RosterClientMappingSiteCodeToHLevelID;
if (EHierarchyLevel.db.select(dbConn, hLevel))
{
EEmpPositionInfo empPos = AppUtils.GetLastPositionInfo(dbConn, m_AttendanceRecordDate, m_EmpID);
if (empPos != null)
{
DBFilter empHierarchyFilter = new DBFilter();
empHierarchyFilter.add(new Match("EmpPosID", empPos.EmpPosID));
empHierarchyFilter.add(new Match("HLevelID", hLevel.HLevelID));
System.Collections.ArrayList empHierarchyList = EEmpHierarchy.db.select(dbConn, empHierarchyFilter);
foreach (EEmpHierarchy empHierarchy in empHierarchyList)
{
EHierarchyElement hElement = new EHierarchyElement();
hElement.HElementID = empHierarchy.HElementID;
if (EHierarchyElement.db.select(dbConn, hElement))
{
if (!hElement.HElementCode.Trim().Equals(site.RosterClientSiteCode.Trim(), StringComparison.CurrentCultureIgnoreCase))
{
return(true);
}
}
}
}
}
}
}
}
return(false);
}
public string GetBusinessHierarchyString(DatabaseConnection dbConn, string Delimiter)
{
DBFilter hLevelFilter = new DBFilter();
hLevelFilter.add("HLevelSeqNo", true);
string BusinessHierarchy = string.Empty;
ArrayList HierarchyLevelList = EHierarchyLevel.db.select(dbConn, hLevelFilter);
foreach (EHierarchyLevel hLevel in HierarchyLevelList)
{
DBFilter empHierarchyFilter = new DBFilter();
empHierarchyFilter.add(new Match("EmpPosID", EmpPosID));
empHierarchyFilter.add(new Match("HLevelID", hLevel.HLevelID));
ArrayList empHierarchyList = EEmpHierarchy.db.select(dbConn, empHierarchyFilter);
string currentElement = string.Empty;
if (empHierarchyList.Count > 0)
{
EEmpHierarchy empHierarchy = (EEmpHierarchy)empHierarchyList[0];
EHierarchyElement hElement = new EHierarchyElement();
hElement.HElementID = empHierarchy.HElementID;
if (EHierarchyElement.db.select(dbConn, hElement))
{
currentElement = hElement.HElementCode;
}
}
if (string.IsNullOrEmpty(BusinessHierarchy))
{
BusinessHierarchy = currentElement;
}
else
{
BusinessHierarchy += Delimiter + currentElement;
}
}
return(BusinessHierarchy);
}
