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