protected string ShowPositions(object employeeID)
{
if (employeeID == null) return string.Empty;
int eid = (int)employeeID;
if (eid == 0) return string.Empty;
if (userRolesTable == null)
{
userRoleTableAdapter adp = new userRoleTableAdapter();
userRolesTable = adp.GetUserRoles();
}
if (positionsTable == null)
{
DListTableAdapter adp = new DListTableAdapter();
positionsTable = adp.GetValidList("Position");
}
DataRow[] rows = userRolesTable.Select("roleType=2 and employeeID=" + eid.ToString());
if (rows.Length > 0)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (DS_Employee.userRoleRow row in rows)
{
DataRow[] rr = positionsTable.Select("listValue='" + row.roleID.ToString() + "'");
if (rr.Length > 0)
{
sb.Append(rr[0]["listTitle"].ToString());
sb.Append(",");
}
}
return sb.ToString();
}
else
return string.Empty;
}
