/// <summary> /// LoadByCompaniesIdProjectId /// </summary> /// <param name="companiesId">companiesId</param> /// <param name="projectId">projectId</param> /// <param name="companyId">companyId</param> public void LoadByCompaniesIdProjectId(int companiesId, int projectId, int companyId) { ProjectCostingSheetInformationReportInformationGateway projectCostingSheetInformationReportInformationGateway = new ProjectCostingSheetInformationReportInformationGateway(Data); projectCostingSheetInformationReportInformationGateway.LoadByCompaniesIdProjectId(companiesId, projectId, companyId); UpdateForReport(); }
private void Generate() { mReport1 master = (mReport1)this.Master; int companyId = Convert.ToInt32(Session["companyID"]); ProjectCostingSheetInformationReportInformation projectCostingSheetInformationReportInformation = new ProjectCostingSheetInformationReportInformation(); if (ddlClient.SelectedValue == "-1") { projectCostingSheetInformationReportInformation.Load(companyId); } else { if (ddlProject.SelectedValue == "-1") { projectCostingSheetInformationReportInformation.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId); } else { projectCostingSheetInformationReportInformation.LoadByCompaniesIdProjectId(Int32.Parse(ddlClient.SelectedValue), Int32.Parse(ddlProject.SelectedValue), companyId); } } // ... set properties to master page master.Data = projectCostingSheetInformationReportInformation.Data; master.Table = projectCostingSheetInformationReportInformation.TableName; // Get report if (projectCostingSheetInformationReportInformation.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new ConsolidatedCostingSheetReport(); int loginId = Convert.ToInt32(Session["loginID"]); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); // For process code ProjectCostingSheetInformationReportInformationGateway projectCostingSheetInformationReportInformationGateway = new ProjectCostingSheetInformationReportInformationGateway(projectCostingSheetInformationReportInformation.Data); // ... ... client if (ddlClient.SelectedValue == "-1") { master.SetParameter("client", "All"); } else { CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), Int32.Parse(hdfCompanyId.Value)); string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue)); master.SetParameter("client", clientName); } // ... ... project if (ddlProject.SelectedValue == "-1") { master.SetParameter("project", "All"); } else { int projectId2 = Int32.Parse(ddlProject.SelectedValue); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId2); string project = projectGateway.GetName(projectId2); master.SetParameter("project", project); } } else { master.Report = new ConsolidatedCostingSheetPreviewReport(); } } }