public string GetPersonalProfileInfo(string commandText, PortEnumerators.PrinterFriendlyReportTypes reportType) { // define query used to obtain "personal profile" information commandText += " select p.firstname + ' ' + p.lastname as FullName,p.Address1,p.Address2,p.City,p.StateProv,p.PostalZip,EmailAddress,WebAddress,p.Phone,p.Grade,InstitutionName "; commandText += " from Port_Student_KY as p join portfolio on p.PortfolioID = Portfolio.PortfolioID join Userinfo on p.SchoolID = Userinfo.SchoolID "; commandText += " where p.portfolioid=" + portfolioID; // need to customize query for "ILPDistrict" report if (reportType == PortEnumerators.PrinterFriendlyReportTypes.ILPDistrict) { commandText += " and portfolio.schoolid in (select schoolid from userinfo where RegionIDs like '%" + RegionID + "%')"; } // need to customize query for "ILPSchool" and "Mass Print ILPSchool" report if (ReportType == PortEnumerators.PrinterFriendlyReportTypes.ILPSchool || ReportType == PortEnumerators.PrinterFriendlyReportTypes.MassPrintSchool) { commandText += " and portfolio.schoolid=" + SchoolID; } commandText += ";"; }
/// <summary> /// Initiliazes properties used to generate content for the printer friendly reports. /// </summary> /// <param name="studentListDataTable">Contains the portfolio IDs of users for whom to display data.</param> /// <param name="languageOfUser">The language specified by the user.</param> /// <param name="printerFriendlyreportType">The type of printer friendly report as specified in the "PrinterFriendlyReportTypes" enumerator located in ~/App_Code/Enumerators/Port/PortEnumerators.cs</param> /// <param name="userRecordStart">The first record in the "studentListDataTable" datatable for which to show data.</param> /// <param name="userRecordEnd">The last record in the "studentListDataTable" datatable for which to show data.</param> /// <param name="languageCountrySuffix">The language-country suffix code for the report.</param> /// <param name="userNameOfUser">The username of the user.</param> /// <param name="userRegionID">The region in which the school is located (used in the "ILPDistrict" report).</param> /// <param name="userSchoolID">The ID of the school for which data is to be shown (used in the "ILPSchool" and "MassPrintSchool" reports).</param> public void InitializePrinterFriendlyReportProperties(DataTable studentListDataTable, string languageOfUser, CareerCruisingWeb.PortEnumerators.PortEnumerators.PrinterFriendlyReportTypes printerFriendlyreportType, int userRecordStart, int userRecordEnd, string languageCountrySuffix, string nonEnglishSuffix, string userNameOfUser, string userRegionID, string userSchoolID, Hashtable portTypeElements, string portTypeID, PortEnumerators.PrinterFriendlyTypes printerFriendlyType) { this.StudentList = studentListDataTable; this.Language = languageOfUser; this.ReportType = printerFriendlyreportType; this.RecordStart = userRecordStart; this.RecordEnd = userRecordEnd; this.CountryLanguageSuffixCode = languageCountrySuffix; this.NonEnglishSuffixCode = nonEnglishSuffix; this.JobInfoTableName = "Jobinfo" + languageCountrySuffix; this.UserName = userNameOfUser; this.RegionID = userRegionID; this.SchoolID = userSchoolID; this.PortTypeElements = portTypeElements; this.PortTypeID = portTypeID; this.PrinterFriendlyType = printerFriendlyType; // by default, display all sections of the report Dictionary<string, string> displayPrinterFriendlySections = new Dictionary<string, string>(); displayPrinterFriendlySections.Add("PersonalProfile", ""); displayPrinterFriendlySections.Add("AdvisementLog", ""); displayPrinterFriendlySections.Add("AnnualReview", ""); displayPrinterFriendlySections.Add("EducationHistory", ""); displayPrinterFriendlySections.Add("MyDocuments", ""); displayPrinterFriendlySections.Add("CareerCruising", ""); displayPrinterFriendlySections.Add("MatchMaker", ""); displayPrinterFriendlySections.Add("CareersOfInterest", ""); displayPrinterFriendlySections.Add("SchoolsOfInterest", ""); displayPrinterFriendlySections.Add("AssessmentResults", ""); displayPrinterFriendlySections.Add("StandardTests", ""); displayPrinterFriendlySections.Add("KCCTAndCTBSInfo", ""); displayPrinterFriendlySections.Add("OtherAssessments", ""); displayPrinterFriendlySections.Add("GoalsAndPlans", ""); displayPrinterFriendlySections.Add("Goals", ""); displayPrinterFriendlySections.Add("CareerCluster", ""); displayPrinterFriendlySections.Add("PostSecondaryInfo", ""); displayPrinterFriendlySections.Add("CareerPlanningActivities", ""); displayPrinterFriendlySections.Add("ActivitiesAndExperiences", ""); displayPrinterFriendlySections.Add("OrganizationsAndActivities", ""); displayPrinterFriendlySections.Add("HobbiesAndInterests", ""); displayPrinterFriendlySections.Add("CommunityService", ""); displayPrinterFriendlySections.Add("WorkExperience", ""); displayPrinterFriendlySections.Add("AwardsAndRecognitions", ""); displayPrinterFriendlySections.Add("EducationPlan", ""); displayPrinterFriendlySections.Add("LearningService", ""); this.DisplaySections = displayPrinterFriendlySections; }
public void InitializePrinterFriendlyReportProperties(DataTable studentListDataTable, string languageOfUser, PortEnumerators.PrinterFriendlyReportTypes printerFriendlyreportType, int userRecordStart, int userRecordEnd, string languageCountrySuffix, string nonEnglishSuffix, string userNameOfUser, string userRegionID, string userSchoolID, Hashtable portTypeElements, string portTypeID, PortEnumerators.PrinterFriendlyTypes printerFriendlyType, bool usesPresetReport) { this.StudentList = studentListDataTable; this.Language = languageOfUser; this.ReportType = printerFriendlyreportType; this.PrinterFriendlyType = printerFriendlyType; this.RecordStart = userRecordStart; this.RecordEnd = userRecordEnd; //this.CountryLanguageSuffixCode = languageCountrySuffix; this.countryLanguageSuffixCode = ((CareerCruisingWeb.PageBase.SuperBase)Page).AbbreviatedCountryCode() + CareerCruisingWeb.CCLib.Common.Strings.SuffixCode(); //this.NonEnglishSuffixCode = nonEnglishSuffix; this.NonEnglishSuffixCode = CareerCruisingWeb.CCLib.Common.Strings.NonEngSuffixCode(); //this.JobInfoTableName = "Jobinfo" + languageCountrySuffix; this.JobInfoTableName = "Jobinfo" + this.countryLanguageSuffixCode; this.UserName = userNameOfUser; this.RegionID = userRegionID; this.SchoolID = userSchoolID; this.PortTypeElements = portTypeElements; this.PortTypeID = portTypeID; this.IsPresetReport = usesPresetReport; }
/// <summary> /// Initiliazes properties used to generate content for the printer friendly reports. /// </summary> /// <param name="studentListDataTable">Contains the portfolio IDs of users for whom to display data.</param> /// <param name="languageOfUser">The language specified by the user.</param> /// <param name="printerFriendlyreportType">The type of printer friendly report as specified in the "PrinterFriendlyReportTypes" enumerator located in ~/App_Code/Enumerators/Port/PortEnumerators.cs</param> /// <param name="userRecordStart">The first record in the "studentListDataTable" datatable for which to show data.</param> /// <param name="userRecordEnd">The last record in the "studentListDataTable" datatable for which to show data.</param> /// <param name="languageCountrySuffix">The language-country suffix code for the report.</param> /// <param name="userNameOfUser">The username of the user.</param> /// <param name="userRegionID">The region in which the school is located (used in the "ILPDistrict" report).</param> /// <param name="userSchoolID">The ID of the school for which data is to be shown (used in the "ILPSchool" and "MassPrintSchool" reports).</param> public void InitializePrinterFriendlyReportProperties(DataTable studentListDataTable, string languageOfUser, CareerCruisingWeb.PortEnumerators.PortEnumerators.PrinterFriendlyReportTypes printerFriendlyreportType, int userRecordStart, int userRecordEnd, string languageCountrySuffix, string nonEnglishSuffix, string userNameOfUser, string userRegionID, string userSchoolID, Hashtable portTypeElements, string portTypeID, PortEnumerators.PrinterFriendlyTypes printerFriendlyType) { this.StudentList = studentListDataTable; this.Language = languageOfUser; this.ReportType = printerFriendlyreportType; this.RecordStart = userRecordStart; this.RecordEnd = userRecordEnd; this.CountryLanguageSuffixCode = languageCountrySuffix; this.NonEnglishSuffixCode = nonEnglishSuffix; this.JobInfoTableName = "Jobinfo" + languageCountrySuffix; this.UserName = userNameOfUser; this.RegionID = userRegionID; this.SchoolID = userSchoolID; this.PortTypeElements = portTypeElements; this.PortTypeID = portTypeID; this.PrinterFriendlyType = printerFriendlyType; }
public void InitializePrinterFriendlyReportProperties(DataTable studentListDataTable, string languageOfUser, PortEnumerators.PrinterFriendlyReportTypes printerFriendlyreportType, int userRecordStart, int userRecordEnd, string languageCountrySuffix, string nonEnglishSuffix, string userNameOfUser, string userRegionID, string userSchoolID, Hashtable portTypeElements, string portTypeID, PortEnumerators.PrinterFriendlyTypes printerFriendlyType) { InitializePrinterFriendlyReportProperties(studentListDataTable, languageOfUser, printerFriendlyreportType, userRecordStart, userRecordEnd, languageCountrySuffix, nonEnglishSuffix, userNameOfUser, userRegionID, userSchoolID, portTypeElements, portTypeID, printerFriendlyType, false); }