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);
}