public OrganizationCodeCollection GetUnassignedOrganizationCodes(int searchUserIDFilter)
{
OrganizationCodeCollection childDataCollection = null;
if (base.ValidateKeyField(this._userID))
{
try
{
DataTable dt = null;
if (searchUserIDFilter == -1)
{
dt = ExecuteDataTable("spr_GetUnassignedOrganizationCodesByUserID", this._userID, DBNull.Value);
}
else
{
dt = ExecuteDataTable("spr_GetUnassignedOrganizationCodesByUserID", this._userID, searchUserIDFilter);
}
// fill collection list
childDataCollection = OrganizationCode.GetCollection(dt);
}
catch (Exception ex)
{
HandleException(ex);
}
}
return(childDataCollection);
}
private void bindMultipleChildOrgCodes(int primaryOrgCode)
{
OrganizationCode chartOrgCode = new OrganizationCode();
chartOrgCode.OrganizationCodeID = primaryOrgCode;
OrganizationCodeCollection listOrgCodes = chartOrgCode.GetChildrenOrganizations();
ControlUtility.BindRadComboBoxControl(this.dropDownChildOrgCodes, listOrgCodes, null, "NewOrgCodeLine", "OrganizationCodeID", "<<-- Select Child Organization Code Filter -->>");
}
private void buildOrganizationCodeDropdown(int regionID)
{
bool isNilRegionID = regionID == -1;
OrganizationCodeCollection orgCodes = LookupWrapper.GetOrganizationCodesByUser(false, CurrentUserID).GetByRegion(regionID);
if (isNilRegionID)
{
printTopOptionOnly(this.dropdownOrganizationCode, "[-- Select Region First --]");
}
else
{
ControlUtility.BindRadComboBoxControl(this.dropdownOrganizationCode, orgCodes, null, "DetailLineLegacy", "OrganizationCodeID", "[-- Select Organization Code --]");
}
}
private void LoadOrganizationCode()
{
OrganizationCodeCollection orgCodeColl = new OrganizationCodeCollection();
orgCodeColl = CurrentUser.GetAssignedOrganizationCodes();
//remove Org Code 0 from the list
OrganizationCode spdOrgCode = new OrganizationCode();
spdOrgCode.OrganizationCodeID = 1;
orgCodeColl.Remove(spdOrgCode);
rcbOrganizationCode.Items.Clear();
int RegionID = -1;
RegionID = Convert.ToInt32(rcbRegion.SelectedValue);
enumOrgFormat format = enumOrgFormat.New;
if (rdOrgCode.SelectedIndex > -1)
{
string strformat = rdOrgCode.SelectedValue;
Enum.TryParse <enumOrgFormat>(strformat, true, out format);
}
if (RegionID > 0)
{
OrganizationCodeCollection filteredbyregion = orgCodeColl.GetByRegion(RegionID);
if (format == enumOrgFormat.New)
{
ControlUtility.BindRadComboBoxControl(rcbOrganizationCode, filteredbyregion, null, "NewOrgCodeLine", "OrganizationCodeID", "<<--Select Organization -->>");
}
else
{
ControlUtility.BindRadComboBoxControl(rcbOrganizationCode, filteredbyregion, null, "OldOrgCodeLine", "OrganizationCodeID", "<<--Select Organization -->>");
}
}
else
{
if (format == enumOrgFormat.New)
{
ControlUtility.BindRadComboBoxControl(rcbOrganizationCode, orgCodeColl, null, "NewOrgCodeLine", "OrganizationCodeID", "<<--Select Organization -->>");
}
else
{
ControlUtility.BindRadComboBoxControl(rcbOrganizationCode, orgCodeColl, null, "OldOrgCodeLine", "OrganizationCodeID", "<<--Select Organization -->>");
}
}
}
private void toggleOrganizationCodeView(enumOrgChartType selectedChartType, OrgCodeFormatTypes listFormat)
{
// Get data based on chart type
OrganizationCodeCollection listOrgCodes = base.CurrentUser.GetAvailableOrganizationCodesByChartType(selectedChartType, listFormat);
if (listOrgCodes.Count == 0)
{
// display message if there is no organization codes
printOrgCodeListMessage(GetLocalResourceObject("NoOrgCodesAvailableMessage").ToString());
}
else
{
printOrgCodeListMessage(string.Empty);
string displayTextField = (listFormat == OrgCodeFormatTypes.NewOrgCode) ? "NewOrgCodeLine" : "OldOrgCodeLine";
// show org codes if there is data
ControlUtility.BindRadComboBoxControl(dropDownOrganizationCodes, listOrgCodes, null, displayTextField, "OrganizationCodeID", "<<--Select Organization -->>");
}
}
internal static OrganizationCodeCollection GetCollection(DataTable dataItems)
{
OrganizationCodeCollection listCollection = new OrganizationCodeCollection();
OrganizationCode current = null;
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
current = new OrganizationCode(dataItems.Rows[i]);
listCollection.Add(current);
}
}
else
{
throw new Exception("You cannot create a OrganizationCode collection from a null data table.");
}
return(listCollection);
}
private void LoadOrganizationCode()
{
rcbOrganizationCode.Items.Clear();
OrganizationCodeCollection orgCodeColl = CurrentUser.GetAssignedActiveOrganizationCodes();
enumOrgFormat format = enumOrgFormat.New;
if (rdOrgCode.SelectedIndex > -1)
{
string strformat = rdOrgCode.SelectedValue;
Enum.TryParse <enumOrgFormat>(strformat, true, out format);
}
if (format == enumOrgFormat.New)
{
ControlUtility.BindRadComboBoxControl(rcbOrganizationCode, orgCodeColl, null, "NewOrgCodeLine", "OrganizationCodeID", "<<--Select Organization -->>");
}
else
{
ControlUtility.BindRadComboBoxControl(rcbOrganizationCode, orgCodeColl, null, "OldOrgCodeLine", "OrganizationCodeID", "<<--Select Organization -->>");
}
}
public OrganizationCodeCollection GetAvailableOrganizationCodesByChartType(enumOrgChartType selectedChartType, OrgCodeFormatTypes selectedSortType)
{
OrganizationCodeCollection childDataCollection = null;
if (base.ValidateKeyField(this._userID))
{
try
{
DbCommand commandWrapper = GetDbCommand("spr_GetAvailableOrganizationCodesByChartType");
commandWrapper.Parameters.Add(new SqlParameter("@UserID", this._userID));
if (selectedChartType == enumOrgChartType.Undefined)
{
commandWrapper.Parameters.Add(new SqlParameter("@OrganizationChartTypeID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@OrganizationChartTypeID", (int)selectedChartType));
}
if (selectedSortType == OrgCodeFormatTypes.None)
{
commandWrapper.Parameters.Add(new SqlParameter("@OrgCodeFormatTypeID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@OrgCodeFormatTypeID", (int)selectedSortType));
}
// fill collection list
childDataCollection = OrganizationCode.GetCollection(ExecuteDataTable(commandWrapper));
}
catch (Exception ex)
{
HandleException(ex);
}
}
return(childDataCollection);
}
public OrganizationCodeCollection GetChildrenOrganizationsSortedByLevel()
{
OrganizationCodeCollection childDataCollection = null;
if (base.ValidateKeyField(this._organizationCodeID))
{
try
{
DataTable dt = ExecuteDataTable("spr_GetOrganizationCodeChildrenSortedByLevel", this._organizationCodeID);
// fill collection list
childDataCollection = GetCollection(dt);
}
catch (Exception ex)
{
HandleException(ex);
}
}
return(childDataCollection);
}
public OrganizationCodeCollection GetAssignedActiveOrganizationCodes()
{
OrganizationCodeCollection childDataCollection = null;
if (base.ValidateKeyField(this._userID))
{
try
{
DataTable dt = ExecuteDataTable("spr_GetActiveOrganizationCodeByUserID", this._userID);
// fill collection list
childDataCollection = OrganizationCode.GetCollection(dt);
}
catch (Exception ex)
{
HandleException(ex);
}
}
return(childDataCollection);
}
private void buildOrganizationCodeDropdown(int regionID)
{
bool isNilRegionID = regionID == -1;
//JA issue 897 not able to see recently assigned orgcode in JAX create new package
//fixed by always reloading instead of getting from cache.
OrganizationCodeCollection orgCodes = LookupWrapper.GetOrganizationCodesByUser(true, CurrentUserID).GetByRegion(regionID);
//JA id :957:JAX: Remove Standard Org code 0 from HR's list in JAX
//removing standard organization code from the dropdown list since we no longer support standard packages.
OrganizationCode standardOrgCode = new OrganizationCode();
standardOrgCode.OrganizationCodeID = 1;
orgCodes.Remove(standardOrgCode);
if (isNilRegionID)
{
printTopOptionOnly(this.dropdownOrganizationCode, "[-- Select Region First --]");
}
else
{
ControlUtility.BindRadComboBoxControl(this.dropdownOrganizationCode, orgCodes, null, "DetailLineLegacy", "OrganizationCodeID", "[-- Select Organization Code --]");
}
}
