/// <summary> /// LoadByCountryIdClientIdStartDateEndDate /// </summary> /// <param name="country">country</param> /// <param name="clientId">clientId</param> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="companyId">companyId</param> public void LoadByCountryIdClientIdStartDateEndDate(int country, int clientId, DateTime startDate, DateTime endDate, int companyId) { ProductionReportGateway productionReportGateway = new ProductionReportGateway(Data); productionReportGateway.LoadByCountryIdClientIdStartDateEndDate(country, clientId, startDate, endDate, companyId); }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()); DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()); int companyId = Int32.Parse(hdfCompanyId.Value); LiquiForce.LFSLive.BL.Projects.Projects.ProductionReport productionReport = new LiquiForce.LFSLive.BL.Projects.Projects.ProductionReport(); if (ddlCountry.SelectedValue == "(All)") { if (ddlClient.SelectedValue == "-1") { productionReport.LoadByStartDateEndDate(startDate, endDate, companyId); } else { int clientId = int.Parse(ddlClient.SelectedValue); if (ddlProject.SelectedValue == "-1") { productionReport.LoadByClientIdStartDateEndDate(clientId, startDate, endDate, companyId); } else { int projectId = int.Parse(ddlProject.SelectedValue); productionReport.LoadByClientIdProjectIdStartDateEndDate(clientId, projectId, startDate, endDate, companyId); } } } else { int country = Int32.Parse(ddlCountry.SelectedValue); if (ddlClient.SelectedValue == "-1") { productionReport.LoadByCountryIdStartDateEndDate(country, startDate, endDate, companyId); } else { int clientId = int.Parse(ddlClient.SelectedValue); if (ddlProject.SelectedValue == "-1") { productionReport.LoadByCountryIdClientIdStartDateEndDate(country, clientId, startDate, endDate, companyId); } else { int projectId = int.Parse(ddlProject.SelectedValue); productionReport.LoadByCountryIdClientIdProjectIdStartDateEndDate(country, clientId, projectId, startDate, endDate, companyId); } } } LiquiForce.LFSLive.DA.Projects.Projects.ProductionReportGateway productionReportGateway = new LiquiForce.LFSLive.DA.Projects.Projects.ProductionReportGateway(productionReport.Data); // ... set properties to master page master.Data = productionReportGateway.Data; master.Table = productionReportGateway.TableName; // Get report if (productionReportGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.ProductionReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.ProductionReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... ... user 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()); // ... ... country if (ddlCountry.SelectedValue == "2") { master.SetParameter("Country", "USA"); } else { if (ddlCountry.SelectedValue == "1") { master.SetParameter("Country", "Canada"); } else { master.SetParameter("Country", "All"); } } // ... ... 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); } // ... ... Date string startDateParameter = tkrdpStartDate.SelectedDate.Value.ToShortDateString(); master.SetParameter("StartDate", startDateParameter); string endDateParameter = tkrdpEndDate.SelectedDate.Value.ToShortDateString(); master.SetParameter("EndDate", endDateParameter); // ... ... 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)); } } else { // ... ... Date string startDateParameter = tkrdpStartDate.SelectedDate.Value.ToShortDateString(); master.SetParameter("StartDate", startDateParameter); string endDateParameter = tkrdpEndDate.SelectedDate.Value.ToShortDateString(); master.SetParameter("EndDate", endDateParameter); } } }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// LoadByStartDateEndDate /// </summary> /// <param name="startDate">startDate</param> /// <param name="endDate">endDate</param> /// <param name="companyId">companyId</param> public void LoadByStartDateEndDate(DateTime startDate, DateTime endDate, int companyId) { ProductionReportGateway productionReportGateway = new ProductionReportGateway(Data); productionReportGateway.LoadByStartDateEndDate(startDate, endDate, companyId); }