private ProjectCostingSheetsNavigatorTDS SubmitSearch() { ProjectCostingSheetsNavigatorTDS projectCostingSheetsNavigatorTDS = new ProjectCostingSheetsNavigatorTDS(); // ... Load data ProjectCostingSheetsNavigator projectCostingSheetsNavigator = new ProjectCostingSheetsNavigator(projectCostingSheetsNavigatorTDS); projectCostingSheetsNavigator.LoadByProjectId(Int32.Parse(hdfProjectId.Value.ToString()), Int32.Parse(hdfCompanyId.Value.ToString())); ProjectCombinedCostingSheetsNavigator projectCombinedCostingSheetsNavigator = new ProjectCombinedCostingSheetsNavigator(projectCostingSheetsNavigatorTDS); projectCombinedCostingSheetsNavigator.LoadByClientId(Int32.Parse(hdfClientId.Value.ToString()), Int32.Parse(hdfCompanyId.Value.ToString())); return (ProjectCostingSheetsNavigatorTDS)projectCostingSheetsNavigatorTDS; }
/// <summary> /// InitData /// </summary> protected override void InitData() { _data = new ProjectCostingSheetsNavigatorTDS(); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_ADMIN"])) { if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_COSTINGSHEETS_VIEW"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } // Validate query string if (Request.QueryString["source_page"] == null) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_costing_sheets_navigator.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfProjectId.Value = Request.QueryString["project_id"]; hdfDataChanged.Value = Request.QueryString["data_changed"]; hdfDataChangedMessage.Value = "Changes made to this project will not be saved."; ViewState["state"] = Request.QueryString["state"]; ViewState["active_tab"] = Request.QueryString["active_tab"]; ViewState["origin"] = Request.QueryString["origin"]; ViewState["update"] = Request.QueryString["update"]; projectTDS = (ProjectTDS)Session["lfsProjectTDS"]; // Prepare initial data //lblResults.Visible = false; // ... for project int currentProjectId = Int32.Parse(hdfProjectId.Value.ToString()); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); if (name.Length > 23) name = name.Substring(0, 20) + "..."; lblTitleProjectName.Text = name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")"; // ... for client int companyId = Int32.Parse(hdfCompanyId.Value); int currentCompanyId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString())); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadAllByCompaniesId(currentCompanyId, companyId); lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentCompanyId); hdfClientId.Value = projectGateway.GetClientID(int.Parse(hdfProjectId.Value)).ToString(); // Store navigator state at projects navigator StoreNavigatorState(); // If coming from // ... project_summary.aspx, project_edit.aspx, project_sections_navigator.aspx or project_sections_navigator2.aspx if ((Request.QueryString["source_page"] == "project_summary.aspx") || (Request.QueryString["source_page"] == "project_edit.aspx") || (Request.QueryString["source_page"] == "project_sections_navigator.aspx") || (Request.QueryString["source_page"] == "project_sections_navigator2.aspx")) { projectCostingSheetsNavigatorTDS = new ProjectCostingSheetsNavigatorTDS(); // ... Search data with updates projectCostingSheetsNavigatorTDS = SubmitSearch(); // ... Store datasets Session["projectCostingSheetsNavigatorTDS"] = projectCostingSheetsNavigatorTDS; } // ... project_costing_sheets_edit.aspx, project_costing_sheets_summary.aspx or project_costing_sheets_delete.aspx if ((Request.QueryString["source_page"] == "project_costing_sheets_edit.aspx") || (Request.QueryString["source_page"] == "project_costing_sheets_summary.aspx") || (Request.QueryString["source_page"] == "project_costing_sheets_delete.aspx") || (Request.QueryString["source_page"] == "project_combined_costing_sheets_edit.aspx") || (Request.QueryString["source_page"] == "project_combined_costing_sheets_summary.aspx") || (Request.QueryString["source_page"] == "project_combined_costing_sheets_delete.aspx")) { if (Request.QueryString["update"] == "no") { projectCostingSheetsNavigatorTDS = (ProjectCostingSheetsNavigatorTDS)Session["projectCostingSheetsNavigatorTDS"]; } else { // ... Delete store data Session.Contents.Remove("projectCostingSheetsNavigatorTDS"); projectCostingSheetsNavigatorTDS = SubmitSearch(); // ... store datasets Session["projectCostingSheetsNavigatorTDS"] = projectCostingSheetsNavigatorTDS; } } // For the grid grdCostingSheetsNavigator.DataSource = projectCostingSheetsNavigatorTDS.ProjectCostingSheetsNavigator; grdCostingSheetsNavigator.DataBind(); grdCombinedCostingSheetsNavigator.DataSource = projectCostingSheetsNavigatorTDS.ProjectCombinedCostingSheetsNavigator; grdCombinedCostingSheetsNavigator.DataBind(); //lblResults.Visible = false; // ... For the total rows if (projectCostingSheetsNavigatorTDS.ProjectCostingSheetsNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + projectCostingSheetsNavigatorTDS.ProjectCostingSheetsNavigator.Rows.Count; lblTotalRows.Visible = true; //lblResults.Visible = true; btnOpen.Visible = true; btnEdit.Visible = true; btnDelete.Visible = true; ddlAction.Visible = true; pnlHorizontalRule.Visible = true; lblCostingSheetsTitle.Visible = true; } else { lblTotalRows.Visible = false; btnOpen.Visible = false; btnEdit.Visible = false; btnDelete.Visible = false; ddlAction.Visible = false; pnlHorizontalRule.Visible = false; lblCostingSheetsTitle.Visible = false; } // ... For the total rows if (projectCostingSheetsNavigatorTDS.ProjectCombinedCostingSheetsNavigator.Rows.Count > 0) { //lblResults.Visible = true; lblCombinedCostingSheetsTotalRows.Text = "Total Rows: " + projectCostingSheetsNavigatorTDS.ProjectCombinedCostingSheetsNavigator.Rows.Count; lblCombinedCostingSheetsTotalRows.Visible = true; lblCombinedCostingSheetsTitle.Visible = true; lblCombinedCostingSheetsTotalRows.Visible = true; btnOpenCombinedCostingSheet.Visible = true; btnEditCombinedCostingSheet.Visible = true; btnDeleteCombinedCostingSheet.Visible = true; pnlHorizontalRuleCombinedCostingSheet.Visible = true; ddlActionCombinedCostingSheet.Visible = true; } else { lblCombinedCostingSheetsTotalRows.Visible = false; lblCombinedCostingSheetsTitle.Visible = false; lblCombinedCostingSheetsTotalRows.Visible = false; btnOpenCombinedCostingSheet.Visible = false; btnEditCombinedCostingSheet.Visible = false; btnDeleteCombinedCostingSheet.Visible = false; pnlHorizontalRuleCombinedCostingSheet.Visible = false; ddlActionCombinedCostingSheet.Visible = false; } } else { // Restore TDS projectTDS = (ProjectTDS)Session["lfsProjectTDS"]; projectCostingSheetsNavigatorTDS = (ProjectCostingSheetsNavigatorTDS)Session["projectCostingSheetsNavigatorTDS"]; // ... for project int currentProjectId = Int32.Parse(hdfProjectId.Value.ToString()); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); if (name.Length > 23) name = name.Substring(0, 20) + "..."; lblTitleProjectName.Text = name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")"; // ... for client int companyId = Int32.Parse(hdfCompanyId.Value); int currentClientId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString())); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadAllByCompaniesId(currentClientId, companyId); lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId); // ... For the total rows if (projectCostingSheetsNavigatorTDS.ProjectCostingSheetsNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + projectCostingSheetsNavigatorTDS.ProjectCostingSheetsNavigator.Rows.Count; lblTotalRows.Visible = true; //lblResults.Visible = true; btnOpen.Visible = true; btnEdit.Visible = true; btnDelete.Visible = true; ddlAction.Visible = true; pnlHorizontalRule.Visible = true; lblCostingSheetsTitle.Visible = true; } else { lblTotalRows.Visible = false; btnOpen.Visible = false; btnEdit.Visible = false; btnDelete.Visible = false; ddlAction.Visible = false; pnlHorizontalRule.Visible = false; lblCostingSheetsTitle.Visible = false; } // ... For the total rows if (projectCostingSheetsNavigatorTDS.ProjectCombinedCostingSheetsNavigator.Rows.Count > 0) { //lblResults.Visible = true; lblCombinedCostingSheetsTotalRows.Text = "Total Rows: " + projectCostingSheetsNavigatorTDS.ProjectCombinedCostingSheetsNavigator.Rows.Count; lblCombinedCostingSheetsTotalRows.Visible = true; lblCombinedCostingSheetsTitle.Visible = true; lblCombinedCostingSheetsTotalRows.Visible = true; btnOpenCombinedCostingSheet.Visible = true; btnEditCombinedCostingSheet.Visible = true; btnDeleteCombinedCostingSheet.Visible = true; pnlHorizontalRuleCombinedCostingSheet.Visible = true; ddlActionCombinedCostingSheet.Visible = true; } else { lblCombinedCostingSheetsTotalRows.Visible = false; lblCombinedCostingSheetsTitle.Visible = false; lblCombinedCostingSheetsTotalRows.Visible = false; btnOpenCombinedCostingSheet.Visible = false; btnEditCombinedCostingSheet.Visible = false; btnDeleteCombinedCostingSheet.Visible = false; pnlHorizontalRuleCombinedCostingSheet.Visible = false; ddlActionCombinedCostingSheet.Visible = false; } } }