private void Generate() { Page.Validate(); if (Page.IsValid) { mReport1 master = (mReport1)this.Master; // Get Data string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%"; string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue; DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()); DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()); int clientId = 0; if (ddlClient.SelectedValue != "-1") clientId = Int32.Parse(ddlClient.SelectedValue); int projectId = 0; if (ddlProject.SelectedValue != "-1") projectId = Int32.Parse(ddlProject.SelectedValue); bool includeAllHours = cbxIncludeAllHours.Checked; string personnelAgencySelected = "null"; if (pnlPersonnelAgency.Visible) { if (ddlPersonalAgency.SelectedIndex > 0) { personnelAgencySelected = ddlPersonalAgency.SelectedValue + "%"; } } PrintHoursForPayrollPeriodGateway printHoursForPayrollPeriodGateway = new PrintHoursForPayrollPeriodGateway(); printHoursForPayrollPeriodGateway.ClearBeforeFill = false; foreach (ListItem lst in cbxlEmployee.Items) { if (lst.Selected) { if (ddlCountry.SelectedValue == "-1") { if (ddlEmployeeType.SelectedValue != "Salaried") { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, true, personnelAgencySelected); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, true, personnelAgencySelected); } else { if (!includeAllHours) { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true, personnelAgencySelected); } else { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true); } } } } else { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeState(startDate, endDate, int.Parse(lst.Value), projectTimeState, true); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, true); } else { if (!includeAllHours) { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true); } else { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, true); } } } } } else { if (ddlEmployeeType.SelectedValue != "Salaried") { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, true, personnelAgencySelected); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, true, personnelAgencySelected); } else { if (!includeAllHours) { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true, personnelAgencySelected); } else { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true); } } } } else { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeState(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, true); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, true); } else { if (!includeAllHours) { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true); } else { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectIdIncludeAllHours(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, true); } } } } } } } printHoursForPayrollPeriodGateway.ClearBeforeFill = true; // ... set properties to master page master.Data = printHoursForPayrollPeriodGateway.Data; master.Table = printHoursForPayrollPeriodGateway.TableName; // Get report if (printHoursForPayrollPeriodGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { if (ddlCountry.SelectedValue == "1") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalUSAReport(); } } else { if (ddlCountry.SelectedValue == "1") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalReportExport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodWithApprovalUSAReportExport(); } } // ... set parameters to report if (master.Format == "pdf") { // ... For report // ... ... country if (ddlCountry.SelectedValue == "2") { master.SetParameter("Country", "USA"); } else { if (ddlCountry.SelectedValue == "1") { master.SetParameter("Country", "Canada"); } else { master.SetParameter("Country", "All"); } } // ... ... project time state if (ddlProjectTimeState.SelectedValue == "(All)") { master.SetParameter("ProjectTimeState", "All"); } else { master.SetParameter("ProjectTimeState", ddlProjectTimeState.SelectedItem.Text); } // ... ... team member if (IsAllEmployeesSelected()) { master.SetParameter("teamMember", "All"); } else { string fullName = GetEmployeesSelected(); master.SetParameter("teamMember", fullName); } // ... ... team member type if (ddlEmployeeType.SelectedValue == "(All)") { master.SetParameter("teamMemberType", "All"); } else { if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada"); if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA"); if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS"); if (ddlEmployeeType.SelectedValue == "PAGCA") { master.SetParameter("teamMemberType", "PAG Canada"); } if (ddlEmployeeType.SelectedValue == "PAGUS") { master.SetParameter("teamMemberType", "PAG USA"); } if (ddlEmployeeType.SelectedValue == "PAG") { master.SetParameter("teamMemberType", "All PAG"); } if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA"); if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried"); if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor"); } string employeeTypeSelected = ddlEmployeeType.SelectedValue; string employeeTypeSelectedFull = ddlEmployeeType.SelectedItem.Text; string country = ""; if (ddlCountry.SelectedValue == "1") { country = "CANADA"; } else { country = "USA"; } if (employeeTypeSelected == "PAGCA" || employeeTypeSelected == "PAGUS" || employeeTypeSelected == "PAG") { master.SetParameter("name", "TEAM MEMBER HOURS FOR PAYROLL PERIOD - " + country + " - " + employeeTypeSelectedFull.ToUpper() + " - (New Version With Approval)"); } else { master.SetParameter("name", "TEAM MEMBER HOURS FOR PAYROLL PERIOD - " + country + " - (New Version With Approval)"); } // ... ... user int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); // ... ... client if (ddlClient.SelectedValue == "-1") { master.SetParameter("Client", "All"); } else { int currentClientId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter("Client", companiesGateway.GetName(currentClientId)); } // ... ... 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); } master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); if (ddlPersonalAgency.SelectedIndex > 0) { master.SetParameter("personnelAgency", ddlPersonalAgency.SelectedItem.Text); } else { master.SetParameter("personnelAgency", "All"); } // Report format master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; master.Report.PrintOptions.PaperSize = PaperSize.PaperLetter; } } } else { PrintHoursForPayrollPeriodGateway printHoursForPayrollPeriodGateway = new PrintHoursForPayrollPeriodGateway(); mReport1 master = (mReport1)this.Master; master.Data = printHoursForPayrollPeriodGateway.Data; master.Table = printHoursForPayrollPeriodGateway.TableName; } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%"; string projectTimeState = "%"; DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()); DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()); int clientId = 0; if (ddlClient.SelectedValue != "-1") clientId = Int32.Parse(ddlClient.SelectedValue); int projectId = 0; if (ddlProject.SelectedValue != "-1") projectId = Int32.Parse(ddlProject.SelectedValue); string personnelAgencySelected = "%"; if (pnlPersonnelAgency.Visible) { if (ddlPersonalAgency.SelectedIndex > 0) { personnelAgencySelected = ddlPersonalAgency.SelectedValue + "%"; } } PrintHoursForPayrollPeriodGateway printHoursForPayrollPeriodGateway = new PrintHoursForPayrollPeriodGateway(); printHoursForPayrollPeriodGateway.ClearBeforeFill = false; foreach (ListItem lst in cbxlEmployee.Items) { if (lst.Selected) { if (ddlCountry.SelectedValue == "-1") { if (ddlEmployeeType.SelectedValue != "Salaried") { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, false, personnelAgencySelected); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, false, personnelAgencySelected); } else { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, false, personnelAgencySelected); } } } else { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeState(startDate, endDate, int.Parse(lst.Value), projectTimeState, false); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, false); } else { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(lst.Value), projectTimeState, clientId, projectId, false); } } } } else { if (ddlEmployeeType.SelectedValue != "Salaried") { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, false, personnelAgencySelected); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, false, personnelAgencySelected); } else { printHoursForPayrollPeriodGateway.LoadByEmployeeTypeStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(employeeType, startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, false, personnelAgencySelected); } } } else { if (ddlClient.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeState(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, false); } else { if (ddlProject.SelectedValue == "-1") { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, false); } else { printHoursForPayrollPeriodGateway.LoadBySalariedStartDateEndDateCountryIdEmployeeIdProjectTimeStateClientIdProjectId(startDate, endDate, int.Parse(ddlCountry.SelectedValue), int.Parse(lst.Value), projectTimeState, clientId, projectId, false); } } } } } } printHoursForPayrollPeriodGateway.ClearBeforeFill = true; // ... set properties to master page master.Data = printHoursForPayrollPeriodGateway.Data; master.Table = printHoursForPayrollPeriodGateway.TableName; // Get report if (printHoursForPayrollPeriodGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodReportOld(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintHoursForPayrollPeriodReportExportOld(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report // ... ... country if (ddlCountry.SelectedValue == "2") { master.SetParameter("Country", "USA"); } else { if (ddlCountry.SelectedValue == "1") { master.SetParameter("Country", "Canada"); } else { master.SetParameter("Country", "All"); } } // ... ... team member if (IsAllEmployeesSelected()) { master.SetParameter("teamMember", "All"); } else { string fullName = GetEmployeesSelected(); master.SetParameter("teamMember", fullName); } // ... ... team member type if (ddlEmployeeType.SelectedValue == "(All)") { master.SetParameter("teamMemberType", "All"); } else { if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada"); if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA"); if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS"); if (ddlEmployeeType.SelectedValue == "PAGCA") master.SetParameter("teamMemberType", "PAG Canada"); if (ddlEmployeeType.SelectedValue == "PAGUS") master.SetParameter("teamMemberType", "PAG USA"); if (ddlEmployeeType.SelectedValue == "PAG") master.SetParameter("teamMemberType", "All PAG"); if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA"); if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried"); if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor"); } // ... ... user int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId,companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); // ... ... client if (ddlClient.SelectedValue == "-1") { master.SetParameter("Client", "All"); } else { int currentClientId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter("Client", companiesGateway.GetName(currentClientId)); } // ... ... 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); } master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } else { master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } } }