private void LoadGeneralData() { // ... for geographical location hdfCountryId.DataBind(); if (hdfCountryId.Value != "") { CountryGateway countryGateway = new CountryGateway(); countryGateway.LoadByCountryId(Int64.Parse(hdfCountryId.Value)); tbxCountry.Text = countryGateway.GetName(Int64.Parse(hdfCountryId.Value)); } else { tbxCountry.Text = ""; } hdfProvinceStateId.DataBind(); if (hdfProvinceStateId.Value != "") { ProvinceGateway provinceGateway = new ProvinceGateway(); provinceGateway.LoadByProvinceId(Int64.Parse(hdfProvinceStateId.Value)); tbxProvinceState.Text = provinceGateway.GetName(Int64.Parse(hdfProvinceStateId.Value)); } else { tbxProvinceState.Text = ""; } hdfCountyId.DataBind(); if (hdfCountyId.Value != "") { CountyGateway countyGateway = new CountyGateway(); countyGateway.LoadByCountyId(Int64.Parse(hdfCountyId.Value)); tbxCounty.Text = countyGateway.GetName(Int64.Parse(hdfCountyId.Value)); } else { tbxCounty.Text = ""; } hdfCityId.DataBind(); if (hdfCityId.Value != "") { CityGateway cityGateway = new CityGateway(); cityGateway.LoadByCityId(Int64.Parse(hdfCityId.Value)); tbxCity.Text = cityGateway.GetName(Int64.Parse(hdfCityId.Value)); } else { tbxCity.Text = ""; } // ... for project ProjectGateway projectGateway = new ProjectGateway(projectTDS); int currentCompanyId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString())); hdfClientId.Value = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value)).ToString(); // ... for client int companyId = Int32.Parse(hdfCompanyId.Value); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadAllByCompaniesId(currentCompanyId, companyId); if (projectTDS.LFS_PROJECT.Rows.Count > 0) { tkrdpStartDate.DataBind(); tkrdpEndDate.DataBind(); tkrdpProposalDate.DataBind(); tbxProjectNumber.DataBind(); tbxName.DataBind(); tbxDescription.DataBind(); tbxClientName.Text = companiesGateway.GetName(projectGateway.GetClientID(int.Parse(hdfProjectId.Value))); tbxClientProjectNumber.DataBind(); // ... ... for primary contact ContactsList contactList = new ContactsList(); contactList.LoadAllAndAddItemByCompaniesId(-1, " ", projectGateway.GetClientID(int.Parse(hdfProjectId.Value)), companyId); ddlClientPrimaryContactId.DataSource = contactList.Table; ddlClientPrimaryContactId.DataValueField = "CONTACTS_ID"; ddlClientPrimaryContactId.DataTextField = "Name"; if (projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).HasValue) { ddlClientPrimaryContactId.SelectedValue = projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).ToString(); } else { ddlClientPrimaryContactId.SelectedValue = "-1"; } ddlClientPrimaryContactId.DataBind(); // ... ... for secondary contact ddlClientSecondaryContactId.DataSource = contactList.Table; ddlClientSecondaryContactId.DataValueField = "CONTACTS_ID"; ddlClientSecondaryContactId.DataTextField = "Name"; if (projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).HasValue) { ddlClientSecondaryContactId.SelectedValue = projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).ToString(); } else { ddlClientSecondaryContactId.SelectedValue = "-1"; } ddlClientSecondaryContactId.DataBind(); // ... for resources // ... ... for project lead EmployeeList employeeList = new EmployeeList(); employeeList.LoadAndAddItem(-1, " "); ddlProjectLeadId.DataSource = employeeList.Table; ddlProjectLeadId.DataValueField = "EmployeeID"; ddlProjectLeadId.DataTextField = "FullName"; ddlProjectLeadId.SelectedValue = (projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value)).HasValue) ? ((int)projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value))).ToString() : "-1"; ddlProjectLeadId.DataBind(); // ... ... for salesman SalesmanListGateway salesmanListGateway = new SalesmanListGateway(new DataSet()); salesmanListGateway.Load(); ddlSalesmanId.DataSource = salesmanListGateway.Table; ddlSalesmanId.DataValueField = "SalesmanID"; ddlSalesmanId.DataTextField = "FullName"; ddlSalesmanId.SelectedValue = ((int)projectGateway.GetSalesmanID(int.Parse(hdfProjectId.Value))).ToString(); ddlSalesmanId.DataBind(); // ... ... for Pricing if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Ballpark") { ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(projectTDS); if (projectSaleBillingPricingGateway.Table.Rows.Count > 0) { tbxBillPrice.DataBind(); ddlBillMoney.DataBind(); } else { if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1) { ddlBillMoney.SelectedValue = "CAD"; } else { ddlBillMoney.SelectedValue = "USD"; } } } } cbxFairWageApplies.DataBind(); // Data for unit budget tab ProjectNavigatorProjectUnitsBudgetGateway projectNavigatorProjectUnitsBudgetGateway = new ProjectNavigatorProjectUnitsBudgetGateway(projectNavigatorTDS); if (projectNavigatorProjectUnitsBudgetGateway.Table.Rows.Count > 0) { tbxUnitsBudget.Text = projectNavigatorProjectUnitsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value)).ToString("n2"); } // Data for materials budget tab ProjectNavigatorProjectMaterialsBudgetGateway projectNavigatorProjectMaterialsBudgetGateway = new ProjectNavigatorProjectMaterialsBudgetGateway(projectNavigatorTDS); if (projectNavigatorProjectMaterialsBudgetGateway.Table.Rows.Count > 0) { tbxMaterialsBudget.Text = projectNavigatorProjectMaterialsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value)).ToString("n2"); } // Data for subcontractors budget tab ProjectNavigatorProjectSubcontractorsBudgetGateway projectNavigatorProjectSubcontractorsBudgetGateway = new ProjectNavigatorProjectSubcontractorsBudgetGateway(projectNavigatorTDS); if (projectNavigatorProjectSubcontractorsBudgetGateway.Table.Rows.Count > 0) { tbxSubcontractorsBudget.Text = projectNavigatorProjectSubcontractorsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2"); } // Data for hotels budget tab ProjectNavigatorProjectHotelsBudgetGateway projectNavigatorProjectHotelsBudgetGateway = new ProjectNavigatorProjectHotelsBudgetGateway(projectNavigatorTDS); if (projectNavigatorProjectHotelsBudgetGateway.Table.Rows.Count > 0) { tbxHotelsBudget.Text = projectNavigatorProjectHotelsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2"); } // Data for bondings budget tab ProjectNavigatorProjectBondingsBudgetGateway projectNavigatorProjectBondingsBudgetGateway = new ProjectNavigatorProjectBondingsBudgetGateway(projectNavigatorTDS); if (projectNavigatorProjectBondingsBudgetGateway.Table.Rows.Count > 0) { tbxBondingsBudget.Text = projectNavigatorProjectBondingsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2"); } // Data for insurances budget tab ProjectNavigatorProjectInsurancesBudgetGateway projectNavigatorProjectInsurancesBudgetGateway = new ProjectNavigatorProjectInsurancesBudgetGateway(projectNavigatorTDS); if (projectNavigatorProjectInsurancesBudgetGateway.Table.Rows.Count > 0) { tbxInsurancesBudget.Text = projectNavigatorProjectInsurancesBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2"); } CalculateTotalBudget(); }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_PROJECTS_ADD"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); // Initialize viewstate variables ViewState["StepFrom"] = "Out"; // Store navigator state StoreNavigatorState(); // Prepare initial data // ... for country CountryList countryList = new CountryList(); countryList.LoadAndAddItem(-1, "(Select a country)"); ddlCountry.DataSource = countryList.Table; ddlCountry.DataValueField = "CountryID"; ddlCountry.DataTextField = "Name"; ddlCountry.DataBind(); // ... for office OfficeList officeList = new OfficeList(); officeList.LoadByCountryIdAndAddItem(-1, "(Select an office)", -1); ddlOffice.DataSource = officeList.Table; ddlOffice.DataValueField = "OfficeID"; ddlOffice.DataTextField = "Name"; ddlOffice.DataBind(); // ... for province ProvinceList provinceList = new ProvinceList(); provinceList.LoadByCountryIdAndAddItem(-1, "(Select a province)", -1); ddlProvince.DataSource = provinceList.Table; ddlProvince.DataValueField = "ProvinceID"; ddlProvince.DataTextField = "Name"; ddlProvince.DataBind(); // ... for county CountyList countyList = new CountyList(); countyList.LoadByProvinceIdAndAddItem(-1, "(Select a county)", -1); ddlCounty.DataSource = countyList.Table; ddlCounty.DataValueField = "CountyID"; ddlCounty.DataTextField = "Name"; ddlCounty.DataBind(); // ... for city CityList cityList = new CityList(); cityList.LoadByCountyIdAndAddItem(-1, "(Select a city)", -1); ddlCity.DataSource = cityList.Table; ddlCity.DataValueField = "CityID"; ddlCity.DataTextField = "Name"; ddlCity.DataBind(); // ... for employee EmployeeList employeeList = new EmployeeList(); employeeList.LoadAndAddItem(-1, " "); ddlProjectLead.DataSource = employeeList.Table; ddlProjectLead.DataValueField = "EmployeeID"; ddlProjectLead.DataTextField = "FullName"; ddlProjectLead.DataBind(); // ... for salesman SalesmanList salesmanList = new SalesmanList(); salesmanList.LoadAndAddItem(-1, "(Select a salesman)"); ddlSalesman.DataSource = salesmanList.Table; ddlSalesman.DataValueField = "SalesmanID"; ddlSalesman.DataTextField = "FullName"; ddlSalesman.DataBind(); // StepLocationIn // StepSection1In Wizard.ActiveStepIndex = 0; StepTypeOfProjectIn(); } }