private DataSet GetDataSet()
{
DataSet ds;
ExtractByFunctionFilter extractByFunctionFilter = new ExtractByFunctionFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER));
extractByFunctionFilter.Year = int.Parse(cmbYear.SelectedItem.Text);
extractByFunctionFilter.IdRegion = int.Parse(cmbRegion.SelectedValue);
extractByFunctionFilter.IdCountry = int.Parse(cmbCountry.SelectedValue);
extractByFunctionFilter.IdInergyLocation = int.Parse(cmbInergyLocation.SelectedValue);
extractByFunctionFilter.IdFunction = int.Parse(cmbFunction.SelectedValue);
extractByFunctionFilter.IdDepartment = int.Parse(cmbDepartment.SelectedValue);
CurrentUser user = (CurrentUser )SessionManager.GetSessionValueRedirect(this, "CurrentUser");
extractByFunctionFilter.IdCurrencyAssociate = user.IdCurrency;
extractByFunctionFilter.ActiveStatus = cmbActive.SelectedValue;
extractByFunctionFilter.CostTypeCategory = cmbCostType.SelectedValue;
ds = extractByFunctionFilter.GetData(int.Parse(cmbSource.SelectedItem.Value));
if (ds != null)
{
ds.Tables[0].Columns["Exchange Rate"].ColumnName = "Exchange Rate (" + user.CodeCurrency + ")";
ds.AcceptChanges();
}
return(ds);
}
private void LoadCountriesFiltered(int countryId, int regionId)
{
ExtractByFunctionFilter extractByFunctionFilter = new ExtractByFunctionFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER));
DataSet countryDS;
if (regionId != ApplicationConstants.INT_NULL_VALUE)
{
extractByFunctionFilter.IdRegion = regionId;
countryDS = extractByFunctionFilter.SelectProcedure("SelectCountriesForRegion");
}
else
{
extractByFunctionFilter.IdCountry = countryId;
countryDS = extractByFunctionFilter.SelectProcedure("SelectCountry");
}
cmbCountry.DataSource = countryDS;
cmbCountry.DataMember = countryDS.Tables[0].ToString();
cmbCountry.DataValueField = "Id";
cmbCountry.DataTextField = "Name";
if (currentUser.UserRole.Id == ApplicationConstants.ROLE_FINANCIAL_TEAM)
{
cmbCountry.SelectedValue = currentUser.IdCountry.ToString();
cmbCountry.Enabled = false;
}
else
{
cmbCountry.SelectedIndex = -1;
}
cmbCountry.DataBind();
}
private void LoadDepartmentsFiltered(int functionId)
{
ExtractByFunctionFilter extractByFunctionFilter = new ExtractByFunctionFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER));
extractByFunctionFilter.IdFunction = functionId;
DataSet departmentDS = extractByFunctionFilter.SelectProcedure("SelectDepartmentsForFunction");
cmbDepartment.DataSource = departmentDS;
cmbDepartment.DataMember = departmentDS.Tables[0].ToString();
cmbDepartment.DataValueField = "Id";
cmbDepartment.DataTextField = "Name";
cmbDepartment.DataBind();
cmbDepartment.SelectedIndex = 0;
}
private void LoadFunctionsFiltered(int functionId)
{
cmbFunction.Items.Clear();
ExtractByFunctionFilter extractByFunctionFilter = new ExtractByFunctionFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER));
extractByFunctionFilter.IdFunction = functionId;
DataSet functionDS = extractByFunctionFilter.SelectProcedure("SelectFunction");
cmbFunction.DataSource = functionDS;
cmbFunction.DataMember = functionDS.Tables[0].ToString();
cmbFunction.DataValueField = "Id";
cmbFunction.DataTextField = "Name";
cmbFunction.DataBind();
}
private void LoadInergyLocationsFiltered(int countryId)
{
ExtractByFunctionFilter extractByFunctionFilter = new ExtractByFunctionFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER));
extractByFunctionFilter.IdCountry = countryId;
DataSet inergyLocationDS = extractByFunctionFilter.SelectProcedure("SelectInergyLocation");
cmbInergyLocation.DataSource = inergyLocationDS;
cmbInergyLocation.DataMember = inergyLocationDS.Tables[0].ToString();
cmbInergyLocation.DataValueField = "Id";
cmbInergyLocation.DataTextField = "Name";
cmbInergyLocation.SelectedIndex = -1;
cmbInergyLocation.DataBind();
}
private void LoadRegionsFiltered(int regionId)
{
ExtractByFunctionFilter extractByFunctionFilter = new ExtractByFunctionFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER));
extractByFunctionFilter.IdRegion = regionId;
DataSet regionDS = extractByFunctionFilter.SelectProcedure("SelectRegion");
cmbRegion.DataSource = regionDS;
cmbRegion.DataMember = regionDS.Tables[0].ToString();
cmbRegion.DataValueField = "Id";
cmbRegion.DataTextField = "Name";
if (currentUser.UserRole.Id == ApplicationConstants.ROLE_FINANCIAL_TEAM)
{
cmbRegion.SelectedValue = regionId.ToString();
cmbRegion.Enabled = false;
}
else
{
cmbRegion.SelectedIndex = -1;
}
cmbRegion.DataBind();
}
