/// <summary> /// GetAllCategoryManagers /// </summary> /// <param name="category">category</param> /// <param name="employeeId">employeeId</param> /// <returns>All Category Managers</returns> public string GetAllCategoryManagers(string category, int employeeId) { string allCategoryManagers = ""; EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(); employeeInformationBasicInformationGateway.LoadByEmployeeId(employeeId); string employeeType = ""; if (employeeInformationBasicInformationGateway.GetType(employeeId).Contains("CA")) { employeeType = "%CA"; } else { employeeType = "%US"; } EmployeeGateway employeeGateway = new EmployeeGateway(Data); employeeGateway.LoadApproveManagersByCategoryType(category, employeeType); foreach (EmployeeTDS.LFS_RESOURCES_EMPLOYEERow row in (EmployeeTDS.LFS_RESOURCES_EMPLOYEEDataTable)Table) { if (allCategoryManagers.Length > 0) { allCategoryManagers = allCategoryManagers + ", " + row.LastName + " " + row.FirstName; } else { allCategoryManagers = allCategoryManagers + row.LastName + " " + row.FirstName; } } //if (allCategoryManagers[allCategoryManagers.Length-1] == ',') //{ // allCategoryManagers = allCategoryManagers.Substring(0, allCategoryManagers.Length - 2); //} return allCategoryManagers; }