/// <summary> /// GetAllNotes. /// </summary> /// <param name="materialId">materialId</param> /// <param name="companyId">COMPANY_UD</param> /// <param name="numberOfNotes">numberOfNotes</param> /// <param name="enterString">enterString</param> /// <returns>a string with all comments at history separeted with the enterString</returns> public string GetAllNotes(int materialId, int companyId, int numberOfNotes, string enterString) { string note = ""; foreach (MaterialsInformationTDS.NoteInformationRow row in (MaterialsInformationTDS.NoteInformationDataTable)Table) { if ((row.MaterialID == materialId) && (row.COMPANY_ID == companyId)) { // ... Get user name LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID); string user = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID); // ... Form the comment string note = note + row.DateTime_ + " ( " + user.Trim() + " )" + enterString + row.Note; } // Insert enter when correspond if (numberOfNotes > 1) { note = note + enterString + enterString; numberOfNotes--; } } return (note); }
private void Generate() { mReport1 master = (mReport1)this.Master; SubcontractorHoursNavigatorTDS subcontractorHoursNavigatorTDS = (SubcontractorHoursNavigatorTDS)Session["subcontractorHoursNavigatorTDS"]; LiquiForce.LFSLive.BL.LabourHours.SubcontractorHours.SubcontractorHoursNavigator subcontractorHoursNavigator = new LiquiForce.LFSLive.BL.LabourHours.SubcontractorHours.SubcontractorHoursNavigator(subcontractorHoursNavigatorTDS); // ... Set properties to master page master.Data = subcontractorHoursNavigator.Data; master.Table = subcontractorHoursNavigator.TableName; if (subcontractorHoursNavigator.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.SubcontractorHours.SubcontractorHoursPrintSearchResultsReport(); LoginGateway loginGateway = new LoginGateway(); int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); // Report format master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.SubcontractorHours.SubcontractorHoursPrintSearchResultsReportExport(); } } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data PlLiningPlanTDS prLiningPlanTDS = (PlLiningPlanTDS)Session["prLiningPlanTDS"]; PrLiningPlan prLiningPlan = new PrLiningPlan(); prLiningPlan.ProcessForReport(prLiningPlanTDS); // ... set properties to master page master.Data = prLiningPlan.Data; master.Table = prLiningPlan.TableName; // Get report if (prLiningPlan.Table.Rows.Count > 0) { master.Report = new PrLiningPlanReport(); 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()); master.SetParameter("name", Request.QueryString["name"]); } }
private void Generate() { mReport1 master = (mReport1)this.Master; RevenueNavigatorTDS revenueNavigatorTDS = (RevenueNavigatorTDS)Session["revenueNavigatorTDS"]; LiquiForce.LFSLive.BL.Projects.Revenue.RevenueNavigator revenueNavigator = new LiquiForce.LFSLive.BL.Projects.Revenue.RevenueNavigator(revenueNavigatorTDS); // ... Set properties to master page master.Data = revenueNavigator.Data; master.Table = revenueNavigator.TableName; if (revenueNavigator.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Revenue.RevenuePrintSearchResultsReport(); // ... Parameters int j; for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsPreview"]); i++) { j = i + 1; master.SetParameter("header" + j, Request.QueryString["header" + j]); } master.SetParameter("headerComments", Request.QueryString["comments"]); master.SetParameter("Title", Request.QueryString["title"]); 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()); // Report format master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Revenue.RevenuePrintSearchResultsReportExport(); // ... Parameters int j; for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsExport"]); i++) { j = i + 1; master.SetParameter("header" + j, Request.QueryString["header" + j]); } } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Get user data int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Int32.Parse(Session["companyID"].ToString()); LoginGateway loginGateway = new LoginGateway(new DataSet()); loginGateway.LoadByLoginId(loginId, companyId); string userName = loginGateway.GetUserName(loginId, companyId); string userMail = loginGateway.GetEmail(loginId, companyId); string password = loginGateway.GetPassword(loginId, companyId); // Fomat new pass string newPassword = password; if (password.Length <= 7) { for (int i = password.Length; i <= 7; i++) { newPassword = newPassword + "!"; } } else { newPassword = newPassword + "!"; } // Verify pass, if not a valid user create one if (!(Membership.ValidateUser(userName, newPassword))) { MembershipCreateStatus createStatus; Membership.CreateUser(userName, newPassword, userMail, "Password question", "password answer", true, out createStatus); } FormsAuthentication.RedirectFromLoginPage(userName, false); if (Convert.ToBoolean(Session["sgLFS_ITTST_SUPPORTTICKET_ADMIN"])) { Response.Redirect(".//dashboardManager.aspx?source_page=out"); } else { Response.Redirect(".//dashboard.aspx?source_page=out"); } }
private void GrdCommentsAdd() { if (ValidateCommentsFooter()) { Page.Validate("commentsDataAdd"); if (Page.IsValid) { int workId = Int32.Parse(hdfWorkId.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); DateTime dateTime_ = DateTime.Now; bool inDatabase = false; bool toHistory = false; bool deleted = false; string workType = hdfWorkType.Value; string newSubject = ((TextBox)grdComments.FooterRow.FindControl("tbxSubjectNew")).Text.Trim(); string newType = ((DropDownList)grdComments.FooterRow.FindControl("ddlTypeNew")).SelectedValue.ToString().Trim(); string newComment = ((TextBox)grdComments.FooterRow.FindControl("tbxCommentsNew")).Text.Trim(); int? libraryFilesId = null; if (((Label)grdComments.FooterRow.FindControl("lblLIBRARY_FILES_IDNew")).Text != "") libraryFilesId = Int32.Parse(((Label)grdComments.FooterRow.FindControl("lblLIBRARY_FILES_IDNew")).Text.Trim()); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string userFullName = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); if (newType == "Rehab Assessment") { RehabAssessmentCommentDetails model = new RehabAssessmentCommentDetails(rehabAssessmentTDS); model.Insert(workId, newType, newSubject, loginId, dateTime_, newComment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType); } else { if (workIdFll != 0) { RehabAssessmentCommentDetails model = new RehabAssessmentCommentDetails(rehabAssessmentTDS); model.Insert(workIdFll, newType, newSubject, loginId, dateTime_, newComment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType); } } Session.Remove("rehabAssessmentCommentDetailsDummy"); Session["rehabAssessmentTDS"] = rehabAssessmentTDS; Session["rehabAssessmentCommentDetails"] = rehabAssessmentTDS.CommentDetails; grdComments.DataBind(); grdComments.PageIndex = grdComments.PageCount - 1; } } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlOutstandingInvestigationIssuesReport flOutstandingInvestigationIssuesReport = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlOutstandingInvestigationIssuesReport(); if (ddlClient.SelectedValue == "-1") { flOutstandingInvestigationIssuesReport.Load(int.Parse(hdfCompanyId.Value)); } else { if (ddlProject.SelectedValue == "-1") { flOutstandingInvestigationIssuesReport.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue)); } else { flOutstandingInvestigationIssuesReport.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue)); } } // ... set properties to master page master.Data = flOutstandingInvestigationIssuesReport.Data; master.Table = flOutstandingInvestigationIssuesReport.TableName; // Get report if (flOutstandingInvestigationIssuesReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new FlOutstandingInvestigationIssuesReport(); } else { master.Report = new FlOutstandingInvestigationIssuesReportExport(); } // ... set parameters to report int companyId = Convert.ToInt32(Session["companyID"]); if (master.Format == "pdf") { if (ddlClient.SelectedValue != "-1") { // ... for client int currentClientId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter("Client", companiesGateway.GetName(currentClientId)); } else { master.SetParameter("Client", "All"); } if (ddlProject.SelectedValue != "-1") { // ... for project int currentProjectId = Int32.Parse(ddlProject.SelectedValue); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); master.SetParameter("Project", name); } else { master.SetParameter("Project", "All"); } 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()); } } }
/// <summary> /// UpdateForProcess. Update the author of each comment /// </summary> public void UpdateForProcess() { LoginGateway loginGateway = new LoginGateway(); foreach (FlatSectionJlTDS.FlatSectionJlHistoryDetailsRow row in (FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable)Table) { loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID); row.UserFullName = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID); } }
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(); } } }
private void Generate2() { mReportForM12 master = (mReportForM12)this.Master; string unitType = ddlUnitType.SelectedValue; // Get Data LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM2Report flM2Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM2Report(); if (ddlClient.SelectedValue == "-1") { if (cbxSectionId.Checked) { ArrayList sectionsId = new ArrayList(); foreach (ListItem lst in cbxlSectionId.Items) { if (lst.Selected) { sectionsId.Add(lst.Value); } } flM2Report.LoadBySectionId(int.Parse(hdfCompanyId.Value), sectionsId, unitType); } else { if (cbxDate.Checked) { DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString()); flM2Report.LoadByDate(int.Parse(hdfCompanyId.Value), m1Date.ToShortDateString(), unitType); } else { if (cbxStreet.Checked) { flM2Report.LoadByStreet(int.Parse(hdfCompanyId.Value), tbxStreet.Text.Trim(), unitType); } else { if (cbxSubArea.Checked) { flM2Report.LoadBySubArea(int.Parse(hdfCompanyId.Value), tbxSubArea.Text.Trim(), unitType); } else { flM2Report.Load(int.Parse(hdfCompanyId.Value), unitType); } } } } } else { if (ddlProject.SelectedValue == "-1") { if (cbxSectionId.Checked) { ArrayList sectionsId = new ArrayList(); foreach (ListItem lst in cbxlSectionId.Items) { if (lst.Selected) { sectionsId.Add(lst.Value); } } flM2Report.LoadByCompaniesIdSectionId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, sectionsId); } else { if (cbxDate.Checked) { DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString()); flM2Report.LoadByCompaniesIdDate(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, m1Date.ToShortDateString()); } else { if (cbxStreet.Checked) { flM2Report.LoadByCompaniesIdStreet(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, tbxStreet.Text.Trim()); } else { if (cbxSubArea.Checked) { flM2Report.LoadByCompaniesIdSubArea(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, tbxSubArea.Text.Trim()); } else { flM2Report.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType); } } } } } else { if (cbxSectionId.Checked) { ArrayList sectionsId = new ArrayList(); foreach (ListItem lst in cbxlSectionId.Items) { if (lst.Selected) { sectionsId.Add(lst.Value); } } flM2Report.LoadByCompaniesIdProjectIdSectionId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, sectionsId); } else { if (cbxDate.Checked) { DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString()); flM2Report.LoadByCompaniesIdProjectIdDate(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, m1Date.ToShortDateString()); } else { if (cbxStreet.Checked) { flM2Report.LoadByCompaniesIdProjectIdStreet(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, tbxStreet.Text.Trim()); } else { if (cbxSubArea.Checked) { flM2Report.LoadByCompaniesIdProjectIdSubArea(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, tbxSubArea.Text.Trim()); } else { flM2Report.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType); } } } } } } // ... set properties to master page master.Data2 = flM2Report.Data; master.Table2 = flM2Report.TableName; // Get report if (flM2Report.Table.Rows.Count > 0) { if (master.Format2 == "pdf") { master.Report2 = new FlM2Report(); } else { master.Report2 = new FlM2ReportExport(); } // ... set parameters to report int companyId = Convert.ToInt32(Session["companyID"]); if (master.Format2 == "pdf") { if (ddlClient.SelectedValue != "-1") { // ... for client int currentCompanyId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentCompanyId, companyId); master.SetParameter2("Client", companiesGateway.GetName(currentCompanyId)); } else { master.SetParameter2("Client", "All"); } if (ddlProject.SelectedValue != "-1") { // ... for project int currentProjectId = Int32.Parse(ddlProject.SelectedValue); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); master.SetParameter2("Project", name); } else { master.SetParameter2("Project", "All"); } master.SetParameter2("UnitType", unitType); 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.SetParameter2("User", user.Trim()); } } }
/// <summary> /// GetAllHistory. /// </summary> /// <param name="id">id</param> /// <param name="refId">refId</param> /// <param name="companyId">companyId</param> /// <param name="numberOfComments">numberOfComments</param> /// <param name="enterString">enterString</param> /// <returns>a string with all comments at history separeted with the enterString</returns> public string GetAllHistory(Guid id, int refId, int companyId, int numberOfComments, string enterString) { string history = ""; foreach (SectionTDS.LFS_JUNCTION_LINER2_HISTORYRow row in (SectionTDS.LFS_JUNCTION_LINER2_HISTORYDataTable)Table) { if ((row.ID == id) && (row.RefID == refId) && (row.COMPANY_ID == companyId)) { // ... Get user name LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(row.LoginID, row.COMPANY_ID); string user = loginGateway.GetLastName(row.LoginID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.LoginID, row.COMPANY_ID); // ... Form the comment string history = history + row.DateTime_ + " ( " + user.Trim() + " )" + enterString + row.History; } // Insert enter when correspond if (numberOfComments > 1) { history = history + enterString + enterString; numberOfComments--; } } return (history); }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); LiquiForce.LFSLive.BL.FleetManagement.ToDoList.ToDoListToDoAssignedToMeReport toDoListToDoAssignedToMeReport = new LiquiForce.LFSLive.BL.FleetManagement.ToDoList.ToDoListToDoAssignedToMeReport(); // could see all to do lists toDoListToDoAssignedToMeReport.LoadToDoAssignedToMeByEmployeeId(employeeId, companyId); toDoListToDoAssignedToMeReport.Table.AcceptChanges(); // ... set properties to master page master.Data = toDoListToDoAssignedToMeReport.Data; master.Table = toDoListToDoAssignedToMeReport.TableName; // Get report if (toDoListToDoAssignedToMeReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new ToDoListToDoAssignedToMeReport(); } else { master.Report = new ToDoListToDoAssignedToMeReportExport(); } // ... set parameters to report if (master.Format == "pdf") { LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); } } }
private void Generate() { mReport1 master = (mReport1)this.Master; LiquiForce.LFSLive.BL.CWP.ManholeRehabilitation.MrSummaryReport mrSummaryReport = new LiquiForce.LFSLive.BL.CWP.ManholeRehabilitation.MrSummaryReport(); int companyId = Int32.Parse(hdfCompanyId.Value); Page.Validate(); if (Page.IsValid) { // Get Data // For all clients if (ddlClient.SelectedValue == "-1") { // validate checkboxes if (cbxMhId.Checked) { ArrayList assetId = new ArrayList(); foreach (ListItem lst in cbxlMhId.Items) { if (lst.Selected) { assetId.Add(lst.Value); } } mrSummaryReport.LoadByAssetId(companyId, assetId); } } // For specific client else { // For all projects if (ddlProject.SelectedValue == "-1") { if (cbxMhId.Checked) { ArrayList assetId = new ArrayList(); foreach (ListItem lst in cbxlMhId.Items) { if (lst.Selected) { assetId.Add(lst.Value); } } mrSummaryReport.LoadByCompaniesIdAssetId(companyId, int.Parse(ddlClient.SelectedValue), assetId); } } // For specific project else { if (cbxMhId.Checked) { ArrayList assetId = new ArrayList(); foreach (ListItem lst in cbxlMhId.Items) { if (lst.Selected) { assetId.Add(lst.Value); } } mrSummaryReport.LoadByCompaniesIdProjectIdAssetId(companyId, int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), assetId); } } } } // ... set properties to master page master.Data = mrSummaryReport.Data; master.Table = mrSummaryReport.TableName; // Get report if (mrSummaryReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new MrSummaryReport(); } else { master.Report = new MrSummaryReportExport(); } // ... set parameters to report if (master.Format == "pdf") { if (ddlClient.SelectedValue != "-1") { // ... for client int currentClientId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter("Client", companiesGateway.GetName(currentClientId)); } else { master.SetParameter("Client", "All"); } if (ddlProject.SelectedValue != "-1") { // ... for project int currentProjectId = Int32.Parse(ddlProject.SelectedValue); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); master.SetParameter("Project", name); } else { master.SetParameter("Project", "All"); } 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()); } } }
private void masterParameters(mReport1 master) { DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()); DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()); int companyId = Int32.Parse(hdfCompanyId.Value); // ... set parameters to report if (master.Format == "pdf") { // ... ... client if (ddlClient.SelectedValue != "-1") { int currentClientId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter("Client", companiesGateway.GetName(currentClientId)); } else { master.SetParameter("Client", "All"); } // ... ... project if (ddlProject.SelectedValue != "-1") { int currentProjectId = Int32.Parse(ddlProject.SelectedValue); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); master.SetParameter("Project", name); } else { master.SetParameter("Project", "All"); } // ... ... category if (ddlCategory.SelectedValue != "-1") { string currentCategory = ddlCategory.SelectedValue; master.SetParameter("Category", currentCategory); } else { master.SetParameter("Category", "All"); } // ... ... user LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"]), companyId); string user = loginGateway.GetLastName(Convert.ToInt32(Session["loginID"]), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(Session["loginID"]), companyId); master.SetParameter("User", user.Trim()); // ... for start date string startDateParameter = startDate.Month.ToString() + "/" + startDate.Day.ToString() + "/" + startDate.Year.ToString(); master.SetParameter("StartDate", startDateParameter); // ... for end date string endDateParameter = endDate.Month.ToString() + "/" + endDate.Day.ToString() + "/" + endDate.Year.ToString(); master.SetParameter("EndDate", endDateParameter); } }
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); } } }
private void Generate() { 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()); PrintEmployeeHoursForRestartWeekGateway printEmployeeHoursForRestartWeekGateway = new PrintEmployeeHoursForRestartWeekGateway(); printEmployeeHoursForRestartWeekGateway.LoadByEmployeeTypeStartDateEndDateProjectTimeState(employeeType, startDate, endDate, projectTimeState); // ... set properties to master page master.Data = printEmployeeHoursForRestartWeekGateway.Data; master.Table = printEmployeeHoursForRestartWeekGateway.TableName; // Get report if (printEmployeeHoursForRestartWeekGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeHoursForRestartWeekReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeHoursForRestartWeekReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report // ... ... project time state if (ddlProjectTimeState.SelectedValue == "(All)") { master.SetParameter("projectTimeState", "All"); } else { master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text); } // ... ... 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()); master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } } }
/// <summary> /// UpdateForProcess. Update the author of each comment /// </summary> public void UpdateForProcess() { LoginGateway loginGateway = new LoginGateway(); foreach (RehabAssessmentTDS.CommentDetailsRow row in (RehabAssessmentTDS.CommentDetailsDataTable)Table) { loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID); row.UserFullName = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID); } }
/// <summary> /// UpdateForProcess. Update the author of each Note /// </summary> public void UpdateForProcess() { LoginGateway loginGateway = new LoginGateway(); LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(); foreach (ProjectTDS.LFS_PROJECT_NOTERow row in (ProjectTDS.LFS_PROJECT_NOTEDataTable)Table) { loginGateway.LoadByLoginId(row.LoginID, row.COMPANY_ID); row.UserFullName = loginGateway.GetLastName(row.LoginID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.LoginID, row.COMPANY_ID); row.CreationDateTime = row.DateTime.ToString(); if (!row.IsLIBRARY_FILES_IDNull()) { try { libraryFilesGateway.LoadByLibraryFilesId(row.LIBRARY_FILES_ID); row.ORIGINAL_FILENAME = libraryFilesGateway.GetOriginalFileName(row.LIBRARY_FILES_ID); row.FILENAME = libraryFilesGateway.GetFileName(row.LIBRARY_FILES_ID); } catch { } } } }
/// <summary> /// UpdateForProcess. Update the author, and date of each comment at history /// </summary> public void UpdateForProcess() { LoginGateway loginGateway = new LoginGateway(); foreach (SectionTDS.LFS_JUNCTION_LINER2_HISTORYRow row in (SectionTDS.LFS_JUNCTION_LINER2_HISTORYDataTable)Table) { loginGateway.LoadByLoginId(row.LoginID, row.COMPANY_ID); row.UserFullName = loginGateway.GetLastName(row.LoginID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.LoginID, row.COMPANY_ID); row.CreationDateTime = row.DateTime_.ToString(); } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data string whereClause = "(P.Deleted = 0) AND (P.ProjectType = 'Project') AND (P.ProjectState = 'Active')"; if (ddlCountry.SelectedValue != "(All)") { if (whereClause.Length > 0) whereClause += " AND "; whereClause += "(P.CountryID = " + ddlCountry.SelectedValue + ")"; } LiquiForce.LFSLive.BL.Projects.Projects.DetailedWorkOnHandReport detailedWorkOnHandReport = new LiquiForce.LFSLive.BL.Projects.Projects.DetailedWorkOnHandReport(); detailedWorkOnHandReport.LoadWhere(whereClause, ddlCountry.SelectedValue, decimal.Parse(tbxExchangeRate.Text)); // ... set properties to master page master.Data = detailedWorkOnHandReport.Data; master.Table = detailedWorkOnHandReport.TableName; // Get report if (detailedWorkOnHandReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.DetailedWorkOnHandReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.DetailedWorkOnHandReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim())); master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):"); master.SetParameter("Currency", ddlCurrency.SelectedValue.Trim()); // ... ... user LoginGateway loginGateway = new LoginGateway(); int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); 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"); } } } else { master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim())); master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):"); } } }
private void Generate3() { mReportForM12 master = (mReportForM12)this.Master; string unitType = ddlUnitType.SelectedValue; int companyId = Convert.ToInt32(hdfCompanyId.Value); FlM1ReportTDS flM1ReportTDS = new FlM1ReportTDS(); // Get Data LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM1Report flM1Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM1Report(flM1ReportTDS); LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM12Report flM2Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM12Report(flM1ReportTDS); GetM1Data(flM1Report, unitType, companyId); GetM2Data(flM2Report, unitType); // ... set properties to master page //FlM1ReportTDS dataSet = new FlM1ReportTDS(); //dataSet.M1ReportByClient.Merge(flM1Report, true); //dataSet.M2_SECTION.Merge(flM2Report, true); master.Data3 = flM1ReportTDS; master.Table1 = flM1Report.TableName; master.Table2 = flM2Report.TableName; // Get report if (flM2Report.Table.Rows.Count > 0 || flM1Report.Table.Rows.Count > 0) { if (master.Format3 == "pdf") { master.Report3 = new FlM12Report(); if (ddlClient.SelectedValue != "-1") { // ... for client int currentClientId = Int32.Parse(ddlClient.SelectedValue); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter3("Client", companiesGateway.GetName(currentClientId)); } else { master.SetParameter3("Client", "All"); } if (ddlProject.SelectedValue != "-1") { // ... for project int currentProjectId = Int32.Parse(ddlProject.SelectedValue); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); master.SetParameter3("Project", name); } else { master.SetParameter3("Project", "All"); } master.SetParameter3("UnitType", unitType); 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.SetParameter3("User", user.Trim()); } else { //master.Report2 = new FlM12ReportExport(); } } }
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()); PrintUnnapprovedProjectTimes printUnnapprovedProjectTimes = new PrintUnnapprovedProjectTimes(); if (ddlCountry.SelectedValue == "-1") { printUnnapprovedProjectTimes.LoadByStartDateEndDate(startDate, endDate); } else { printUnnapprovedProjectTimes.LoadByStartDateEndDateCountryId(startDate, endDate, int.Parse(ddlCountry.SelectedValue)); } // ... set properties to master page master.Data = printUnnapprovedProjectTimes.Data; master.Table = printUnnapprovedProjectTimes.TableName; // Get report if (printUnnapprovedProjectTimes.Table.Rows.Count > 0) { // ... set parameters to report if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintUnapprovedProjectTimesReport(); // ... 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"); } } // ... ... 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()); master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintUnapprovedProjectTimesReportExport(); } } }
// //////////////////////////////////////////////////////////////////////// // 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_EDIT"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_notes.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString(); hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); hdfUpdate.Value = "yes"; // Prepare initial data Session.Remove("projectNotesDummy"); // ... Names for UserList int companyId = Int32.Parse(hdfCompanyId.Value); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value),companyId); hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId); hdfCreationDateTime.Value = DateTime.Now.ToString(); // If coming from // ... project_summary.aspx or project_edit.aspx if (Request.QueryString["source_page"] == "project_summary.aspx" || Request.QueryString["source_page"] == "project_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"]; projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"]; int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); // Get Notes ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS); projectNavigatorProjectNotes.LoadAllByProjectId(currentProjectId); // ... Store datasets Session["projectNavigatorTDS"] = projectNavigatorTDS; Session["projectNotes"] = projectNavigatorTDS.ProjectNotes; } } else { // Restore datasets projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"]; projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"]; } }
private void Generate() { mReport1 master = (mReport1)this.Master; int companyId = Convert.ToInt32(Session["companyID"]); string type = Request.QueryString["type"].ToString(); int costingSheetId = 0; int projectId = 0; ProjectCostingSheetInformationBasicInformation projectCostingSheetInformationBasicInformation = new ProjectCostingSheetInformationBasicInformation(); if (ddlCostingSheets.SelectedValue != "-1") { // Get Data costingSheetId = Convert.ToInt32(ddlCostingSheets.SelectedValue); projectCostingSheetInformationBasicInformation.LoadByCostingSheetIdForPreviewReport(costingSheetId, companyId); ProjectCostingSheetInformationBasicInformationGateway projectCostingSheetInformationBasicInformationGateway = new ProjectCostingSheetInformationBasicInformationGateway(projectCostingSheetInformationBasicInformation.Data); projectId = projectCostingSheetInformationBasicInformationGateway.GetProjectID(costingSheetId); // ... set properties to master page master.Data = projectCostingSheetInformationBasicInformation.Data; master.Table = projectCostingSheetInformationBasicInformation.TableName; master.Report = new ProjectCostingSheetsPreview(); // Get report if (projectCostingSheetInformationBasicInformation.Table.Rows.Count > 0) { ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); int clientId = projectGateway.GetClientID(projectId); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(clientId, companyId); master.SetParameter("Client", companiesGateway.GetName(clientId)); string name = projectGateway.GetName(projectId); master.SetParameter("Project", name); 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()); master.SetParameter("CostingSheet", projectCostingSheetInformationBasicInformationGateway.GetName(costingSheetId)); if (type == "resume") { ((Section)master.Report.ReportDefinition.Sections["detailsLabourHours"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsLabourHours2"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsUnits"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsUnits2"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsMaterials"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsMaterials2"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts2"]).SectionFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors"]).SectionFormat.EnableSuppress = true; //((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors2"]).SectionFormat.EnableSuppress = true; } else { ((Section)master.Report.ReportDefinition.Sections["detailsLabourHours"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsLabourHours2"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsUnits"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsUnits2"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsMaterials"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsMaterials2"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts2"]).SectionFormat.EnableSuppress = false; ((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors"]).SectionFormat.EnableSuppress = false; //((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors2"]).SectionFormat.EnableSuppress = false; } if (projectGateway.GetCountryID(projectId) == 1)//Canada { // General ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text32"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text34"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text36"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text38"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["headerTotalSubcontractorsUsd"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalLabourHoursUsd1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalUnitsUsd1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalMaterialsUsd1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalOtherCostsUsd1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["GrandTotalUsd1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalSubcontractorsUsd1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["GrandTotalUsd2"].ObjectFormat.EnableSuppress = true; // Labour Hours ReportDocument rpLabourHoursDetails = master.Report.OpenSubreport("LabourHoursDetails"); ReportDocument rpLabourHoursResume = master.Report.OpenSubreport("LabourHoursResume"); ((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["LHCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; // ((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; // Units ReportDocument rpUnitsDetails = master.Report.OpenSubreport("UnitsDetails"); ReportDocument rpUnitsResume = master.Report.OpenSubreport("UnitsResume"); ((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; // ((Section)rpUnitsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; // Materials ReportDocument rpMaterialsDetails = master.Report.OpenSubreport("MaterialsDetails"); ReportDocument rpMaterialsResune = master.Report.OpenSubreport("MaterialsResume"); ((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; /// ((Section)rpMaterialsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; // Subcontractors ReportDocument rpSubcontractorsDetails = master.Report.OpenSubreport("SubcontractorsDetails"); //ReportDocument rpSubcontractorsResune = master.Report.OpenSubreport("SubcontractorsResume"); ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true; /// //((Section)rpSubcontractorsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true; //((Section)rpSubcontractorsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true; //((Section)rpSubcontractorsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; // Other Costs ReportDocument rpOtherCostsDetails = master.Report.OpenSubreport("OtherCostsDetails"); ReportDocument rpOtherCostsResume = master.Report.OpenSubreport("OtherCostsResume"); ((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; /// ((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true; } else//USA { // General ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text31"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text33"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text35"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text37"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["headerTotalSubcontractorsCad"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalLabourHoursCad1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalUnitsCad1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalMaterialsCad1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalOtherCostsCad1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["GrandTotalCad1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalSubcontractorsCad1"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["GrandTotalCad2"].ObjectFormat.EnableSuppress = true; // Labour Hours ReportDocument rpLabourHoursDetails = master.Report.OpenSubreport("LabourHoursDetails"); ReportDocument rpLabourHoursResume = master.Report.OpenSubreport("LabourHoursResume"); ((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text9"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["LHCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; // ((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; // Units ReportDocument rpUnitsDetails = master.Report.OpenSubreport("UnitsDetails"); ReportDocument rpUnitsResume = master.Report.OpenSubreport("UnitsResume"); ((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; // ((Section)rpUnitsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpUnitsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; // Materials ReportDocument rpMaterialsDetails = master.Report.OpenSubreport("MaterialsDetails"); ReportDocument rpMaterialsResune = master.Report.OpenSubreport("MaterialsResume"); ((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; /// ((Section)rpMaterialsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpMaterialsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; // Subcontractors ReportDocument rpSubcontractorsDetails = master.Report.OpenSubreport("SubcontractorsDetails"); ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true; // Other Costs ReportDocument rpOtherCostsDetails = master.Report.OpenSubreport("OtherCostsDetails"); ReportDocument rpOtherCostsResume = master.Report.OpenSubreport("OtherCostsResume"); ((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; /// ((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true; ((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true; } } } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data JlLiningPlanTDS jlLiningPlanTDS = (JlLiningPlanTDS)Session["jlLiningPlanTDS"]; JlLiningPlan jlLiningPlan = new JlLiningPlan(); jlLiningPlan.ProcessForReport(jlLiningPlanTDS); // ... set properties to master page master.Data = jlLiningPlan.Data; master.Table = jlLiningPlan.TableName; // Get report if (jlLiningPlan.Table.Rows.Count > 0) { master.Report = new JlLiningPlanReport(); // ... for client int companyId = Int32.Parse(Session["companyID"].ToString()); int currentClientId = Int32.Parse(hdfCurrentClientId.Value); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); master.SetParameter("Client", companiesGateway.GetName(currentClientId)); // ... for project int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); master.SetParameter("Project", projectGateway.GetProjectNumber(currentProjectId)); 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()); } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue; DateTime date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString()); Print3ChartReportGateway print3ChartReportGateway = new Print3ChartReportGateway(); print3ChartReportGateway.LoadByDateProjectTimeState(date, projectTimeState); // ... set properties to master page master.Data = print3ChartReportGateway.Data; master.Table = print3ChartReportGateway.TableName; // Get report if (print3ChartReportGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.Print3ChartReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.Print3ChartReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report // ... ... project time state if (ddlProjectTimeState.SelectedValue == "(All)") { master.SetParameter("projectTimeState", "All"); } else { master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text); } // ... ... 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()); // ... ... Date master.SetParameter("date", tkrdpDate.SelectedDate.Value.ToShortDateString()); } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_EDIT"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["work_id"] == null) || ((string)Request.QueryString["asset_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_comments.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString(); hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_ADMIN"]).ToString(); hdfWorkType.Value = "Rehab Assessment"; hdfWorkId.Value = Request.QueryString["work_id"].ToString(); hdfAssetId.Value = Request.QueryString["asset_id"].ToString(); hdfUpdate.Value = "yes"; // Prepare initial data Session.Remove("rehabAssessmentCommentDetailsDummy"); // ... Names for UserList string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value),companyId); hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId); hdfCreationDateTime.Value = DateTime.Now.ToString(); // If coming from // ... ra_summary.aspx or ra_edit.aspx if (Request.QueryString["source_page"] == "ra_summary.aspx" || Request.QueryString["source_page"] == "ra_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // For RA rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; int assetId = Int32.Parse(hdfAssetId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); int workId = Int32.Parse(hdfWorkId.Value.Trim()); if (workId != 0) { // ... update comments RehabAssessmentCommentDetailsGateway rehabAssessmentCommentDetailsGateway = new RehabAssessmentCommentDetailsGateway(rehabAssessmentTDS); rehabAssessmentCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, workType); RehabAssessmentCommentDetails rehabAssessmentCommentDetails = new RehabAssessmentCommentDetails(rehabAssessmentCommentDetailsGateway.Data); rehabAssessmentCommentDetails.UpdateForProcess(); } // For FLL int workIdFll = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId); hdfWorkIdFll.Value = workIdFll.ToString(); if (workIdFll != 0) { // ... update comments FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway(); fullLengthLiningCommentDetailsGateway.LoadAllByWorkIdWorkType(workIdFll, companyId, "Full Length Lining"); FullLengthLiningCommentDetails fullLengthLiningCommentDetails = new FullLengthLiningCommentDetails(fullLengthLiningCommentDetailsGateway.Data); fullLengthLiningCommentDetails.UpdateForProcess(); } // ... Store datasets Session["rehabAssessmentTDS"] = rehabAssessmentTDS; Session["rehabAssessmentCommentDetails"] = rehabAssessmentTDS.CommentDetails; } } else { // Restore datasets rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; rehabAssessmentCommentDetails = rehabAssessmentTDS.CommentDetails; } }
private void Generate() { mReport1 master = (mReport1)this.Master; RaNavigatorTDS raNavigatorTDS = (RaNavigatorTDS)Session["raNavigatorTDS"]; LiquiForce.LFSLive.BL.CWP.RehabAssessment.RaNavigator raNavigator = new LiquiForce.LFSLive.BL.CWP.RehabAssessment.RaNavigator(raNavigatorTDS); // ... set properties to master page master.Data = raNavigator.Data; master.Table = raNavigator.TableName; if (raNavigator.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.CWP.RehabAssessment.RaPrintSearchResultsReport(); master.SetParameter("name", Server.UrlDecode(Request.QueryString["name"].ToString())); master.SetParameter("Title", Server.UrlDecode(Request.QueryString["title"].ToString())); // ... Parameters int j; for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsPreview"]); i++) { j = i + 1; master.SetParameter("header" + j, Request.QueryString["header" + j]); } master.SetParameter("headerComments", Request.QueryString["comments"]); 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()); if (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 12) { ((Section)master.Report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = false; } else { if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 12) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 24)) { ((Section)master.Report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = false; } else { if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 25) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 36)) { ((Section)master.Report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = false; } else { if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 36) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 48)) { ((Section)master.Report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = false; } else { if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 48) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 60)) { ((Section)master.Report.ReportDefinition.Sections["sDetail60columns"]).SectionFormat.EnableSuppress = false; } } } } } // Report format master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { master.Report = new LiquiForce.LFSLive.WebUI.CWP.RehabAssessment.RaPrintSearchResultsReportExport(); // ... Parameters int j; for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsExport"]); i++) { j = i + 1; master.SetParameter("header" + j, Request.QueryString["header" + j]); } } } }
protected string GetCommentCreatedBy(object userId) { if (userId != DBNull.Value) { if (Convert.ToInt32(userId) != -1) { try { // Created By int companyId = Int32.Parse(hdfCompanyId.Value); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(userId),companyId); string userName = loginGateway.GetLastName(Convert.ToInt32(userId), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(userId), companyId); return userName.ToString(); } catch { return ""; } } else { return ""; } } else { return ""; } }
/// <summary> /// UpdateForProcess. Update the author of each comment /// </summary> public void UpdateForProcess() { LoginGateway loginGateway = new LoginGateway(); foreach (FullLengthLiningTDS.WetOutCommentsDetailsRow row in (FullLengthLiningTDS.WetOutCommentsDetailsDataTable)Table) { loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID); row.UserFullName = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID); } }