protected void Page_Load(object sender, EventArgs e) { //before save, put into login session if (Session["ptreturnurl"] == null) { //get values from form post if (Request.ServerVariables["REQUEST_METHOD"] == "POST") { Session["ptreturnurl"] = CCLib.Common.Strings.GetFormString("ptreturnurl"); Session["ptsavename"] = CCLib.Common.Strings.GetFormString("ptsavename"); Session["ptsavevalue"] = CCLib.Common.Strings.GetFormString("ptsavevalue"); Session["SchoolCountry"] = (CCLib.Common.Strings.GetFormString("SchoolCountry") == "US") ? "1" : "2"; Session["SchoolType"] = CCLib.Common.Strings.GetFormString("SchoolType"); //three values for MatchMaker Session["MatchMakerRef"] = CCLib.Common.Strings.GetFormString("MatchMakerRef"); Session["MatchMakerRes"] = CCLib.Common.Strings.GetFormString("MatchMakerRes"); Session["MatchMakerEducation"] = CCLib.Common.Strings.GetFormString("MatchMakerEducation"); Session["MatchMakerSkill"] = CCLib.Common.Strings.GetFormString("MatchMakerSkill"); Session["MatchMakerSkillRank"] = CCLib.Common.Strings.GetFormString("MatchMakerSkillRank"); Session["MatchMakerLabel"] = CCLib.Common.Strings.GetFormString("MatchMakerLabel"); //one value for Michigan Pathway Session["Pathway"] = CCLib.Common.Strings.GetFormString("Pathway"); } else//get value from query string { Session["ptreturnurl"] = CCLib.Common.Strings.GetQueryString("ptreturnurl"); Session["ptsavename"] = CCLib.Common.Strings.GetQueryString("ptsavename"); Session["ptsavevalue"] = CCLib.Common.Strings.GetQueryString("ptsavevalue"); Session["SchoolCountry"] = (CCLib.Common.Strings.GetQueryString("SchoolCountry") == "US") ? "1" : "2"; Session["SchoolType"] = CCLib.Common.Strings.GetQueryString("SchoolType"); //three values for MatchMaker Session["MatchMakerRef"] = CCLib.Common.Strings.GetQueryString("MatchMakerRef"); Session["MatchMakerRes"] = CCLib.Common.Strings.GetQueryString("MatchMakerRes"); Session["MatchMakerEducation"] = CCLib.Common.Strings.GetQueryString("MatchMakerEducation"); Session["MatchMakerSkill"] = CCLib.Common.Strings.GetQueryString("MatchMakerSkill"); Session["MatchMakerSkillRank"] = CCLib.Common.Strings.GetQueryString("MatchMakerSkillRank"); Session["MatchMakerLabel"] = CCLib.Common.Strings.GetQueryString("MatchMakerLabel"); //one value for Michigan Pathway Session["Pathway"] = CCLib.Common.Strings.GetQueryString("Pathway"); } }//before save, put into login session #region Properties For The Base Class and Check Login LoginID = Request.QueryString["LoginID"]; LoginInfo = CCLib.Login.GetLoginInfo(LoginID); Redirect(); PageTitle = PortfolioName + " Homepage"; Section = "portfolio_tool"; CSS = "student"; HeadTag = "<STYLE TYPE='TEXT/CSS'><!--.btnDescription { font: 11px Verdana, Arial, Helvetica, sans-serif; margin: 0px 15px}--></STYLE>"; BodyTag = " alink='#990000' style='background-image:url(/media/shared/bg_left_bar_grey.gif);background-repeat:repeat-y;' bgcolor='#ffffff' leftmargin=0 link='#003366' text='#000000' topmargin=0 vlink='#003366' marginwidth='0' marginheight='0'"; LeftBar = "<TABLE WIDTH='100%' BORDER='0' CELLSPACING='0' CELLPADDING='0'><TR VALIGN='TOP' BGCOLOR='#669966'><td background='/media/portfolio_tool/bg_bar_tan_top.gif'><img height=23 src='/media/student_parent/icons/icon_arrow.gif' alt='' width=24><img height=23 src='/media/student_parent/shared/h_h_main.gif' alt='' width=141>"; #endregion Properties For The Base Class and Check Login //check session CheckPortSession(); //Response.Write("Out"); if (Session["ptreturnurl"] != null)//return url not null { //Response.Write("In"); //not for ILP Parent if (LoginInfo["ParentID"].ToString() == "") { //save to db //insert into Port_SavedCareers table if (Session["ptsavename"].ToString() == "Career") { if (CCLib.Common.DataAccess.GetValue("select OccNumber from Port_SavedCareers where PortfolioID=" + LoginInfo["PID"].ToString() + " and OccNumber=" + Session["ptsavevalue"].ToString()).ToString() == "") { strSQL = "insert into Port_SavedCareers (OccNumber,PortfolioID) values(" + Session["ptsavevalue"].ToString() + "," + LoginInfo["PID"].ToString() + ")"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("Career"); //Response.Redirect(Session["ptreturnurl"].ToString() + "&LoginID=" + LoginID); } } //insert into Port_SavedCompanies table else if (Session["ptsavename"].ToString() == "ConnectCompany") { if (CCLib.Common.DataAccess.GetValue("select CompanyID from Port_SavedCompanies where PortfolioID=" + LoginInfo["PID"].ToString() + " and CompanyID=" + Session["ptsavevalue"].ToString()).ToString() == "") { strSQL = "insert into Port_SavedCompanies (CompanyID,PortfolioID) values(" + Session["ptsavevalue"].ToString() + "," + LoginInfo["PID"].ToString() + ")"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("NetSavedComp"); } } //insert into Port_SavedSchools table else if (Session["ptsavename"].ToString() == "School") { if (CCLib.Common.DataAccess.GetValue("select SchoolID from Port_SavedSchools where PortfolioID=" + LoginInfo["PID"].ToString() + " and CountryID=" + Session["SchoolCountry"].ToString() + " and SchoolID='" + Session["ptsavevalue"].ToString().Replace("'", "''") + "'").ToString() == "") { if (Session["SchoolType"].ToString() != "") strSQL = "insert into Port_SavedSchools (CountryID,SchoolID,UX_VX, PortfolioID) values(" + Session["SchoolCountry"].ToString() + ",'" + Session["ptsavevalue"].ToString().Replace("'", "''") + "','" + Session["SchoolType"].ToString().Replace("'", "''") + "'," + LoginInfo["PID"].ToString() + ")"; else strSQL = "insert into Port_SavedSchools (CountryID,SchoolID,PortfolioID) values(" + Session["SchoolCountry"].ToString() + ",'" + Session["ptsavevalue"].ToString().Replace("'", "''") + "'," + LoginInfo["PID"].ToString() + ")"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("School"); } } //insert into Port_SavedMatchMakers table else if (Session["ptsavename"].ToString() == "MatchMaker") { //for now, no duplicates string strBM = ""; //flag of best match int intID = 0; string strMMNumbers = CCLib.Common.DataAccess.GetValue("select count(SavedMatchMakerID) from Port_SavedMatchMaker where PortfolioID=" + LoginInfo["PID"].ToString()).ToString(); strBM = (strMMNumbers != "0") ? "0" : "1"; if (Session["MMID"] == null || Session["MMID"].ToString() == "") { if (strMMNumbers != "0") { strSQL = "insert into Port_SavedMatchMaker (PortfolioID,OccNumbers,Ref,Res,Education,Cluster,Skill,SkillRank,BestMatch,Label,DateCreated) values(" + LoginInfo["PID"].ToString() + ",'" + Session["ptsavevalue"].ToString().Replace("'", "''") + "','" + Session["MatchMakerRef"].ToString().Replace("'", "''") + "','" + Session["MatchMakerRes"].ToString().Replace("'", "''") + "','" + Session["MatchMakerEducation"].ToString().Replace("'", "''") + "','" + Session["Pathway"].ToString().Replace("'", "''") + "','" + Session["MatchMakerSkill"].ToString().Replace("'", "''") + "','" + Session["MatchMakerSkillRank"].ToString().Replace("'", "''") + "',0,'" + CCLib.Common.Strings.FormatUserInput(Session["MatchMakerLabel"].ToString().Replace("'", "''")) + "',GETDATE())"; //strSQL = "update Port_SavedMatchMaker set OccNumbers='" + Session["ptsavevalue"].ToString().Replace("'", "''") + "',Ref='" + Session["MatchMakerRef"].ToString().Replace("'", "''") + "',Res='" + Session["MatchMakerRes"].ToString().Replace("'", "''") + "',Education='" + Session["MatchMakerEducation"].ToString().Replace("'", "''") + "',Cluster='" + Session["Pathway"].ToString().Replace("'", "''") + "',Skill='" + Session["MatchMakerSkill"].ToString().Replace("'", "''") + "',SkillRank='" + Session["MatchMakerSkillRank"].ToString().Replace("'", "''") + "', UpdateDate = getdate() where PortfolioID= " + LoginInfo["PID"].ToString(); strBM = "0"; } else { strSQL = "insert into Port_SavedMatchMaker (PortfolioID,OccNumbers,Ref,Res,Education,Cluster,Skill,SkillRank,BestMatch,Label,DateCreated) values(" + LoginInfo["PID"].ToString() + ",'" + Session["ptsavevalue"].ToString().Replace("'", "''") + "','" + Session["MatchMakerRef"].ToString().Replace("'", "''") + "','" + Session["MatchMakerRes"].ToString().Replace("'", "''") + "','" + Session["MatchMakerEducation"].ToString().Replace("'", "''") + "','" + Session["Pathway"].ToString().Replace("'", "''") + "','" + Session["MatchMakerSkill"].ToString().Replace("'", "''") + "','" + Session["MatchMakerSkillRank"].ToString().Replace("'", "''") + "',1,'" + CCLib.Common.Strings.FormatUserInput(Session["MatchMakerLabel"].ToString().Replace("'", "''")) + "',GETDATE())"; strBM = "1"; } intID = CCLib.Common.DataAccess.ExecuteDbWithIntResult(strSQL + "; select SCOPE_IDENTITY();"); } else { string strBestMatch = CCLib.Common.DataAccess.GetValue("select count(SavedMatchMakerID) from Port_SavedMatchMaker where BestMatch=1 and SavedMatchMakerID = " + Session["MMID"].ToString()).ToString(); strBM = (strBestMatch == "1") ? "1" : "0"; strSQL = "update Port_SavedMatchMaker set OccNumbers = '" + Session["ptsavevalue"].ToString().Replace("'", "''") + "',Ref = '" + Session["MatchMakerRef"].ToString().Replace("'", "''") + "',Res='" + Session["MatchMakerRes"].ToString().Replace("'", "''") + "',Education='" + Session["MatchMakerEducation"].ToString().Replace("'", "''") + "',Cluster='" + Session["Pathway"].ToString().Replace("'", "''") + "',Skill='" + Session["MatchMakerSkill"].ToString().Replace("'", "''") + "',SkillRank='" + Session["MatchMakerSkillRank"].ToString().Replace("'", "''") + "',UpdateDate=GETDATE() where SavedMatchMakerID = " + Session["MMID"].ToString(); CCLib.Common.DataAccess.ExecuteNonQuery(strSQL); intID = Convert.ToInt32(Session["MMID"]); } Session["ptreturnurl"] = Session["ptreturnurl"] + "MMID=" + intID.ToString() + "&BM=" + strBM + "&"; UpdatePCSStatusFromSection("MatchMaker"); //matchmaker session initialization CCLib.MatchingObject.ClientStorage clientStorage = new CCLib.MatchingObject.ClientStorage(); if (clientStorage.LoadFromPortfolio(PortInfo["PortfolioID"].ToString(), intID)) { //it's worked so save it back to the session state clientStorage.Save(LoginID); } } else if (Session["ptsavename"].ToString() == "careermessageboard") { if (PortInfo["AllowMsgBrdPosts"].ToString() != "True") Response.Write(CCLib.Common.Forms.JavaScriptNotify("You do not have permission to post to the message boards.")); else { if (Session["ptreturnurl"].ToString().Contains("/Careers/")) UpdatePCSStatusFromSection("NetCoachBoards"); else if (Session["ptreturnurl"].ToString().Contains("/Connect/")) UpdatePCSStatusFromSection("NetCompBoards"); } // Response.Redirect(Session["ptreturnurl"].ToString() + "&LoginID=" + LoginID); } else if (Session["ptsavename"].ToString() == "Military") { if (CCLib.Common.DataAccess.GetValue("select OccNumber from Port_SavedCareers where PortfolioID=" + LoginInfo["PID"].ToString() + " and OccNumber=" + Session["ptsavevalue"].ToString() + "AND IsMilitary = 'true'").ToString() == "") { strSQL = "insert into Port_SavedCareers (OccNumber,PortfolioID, IsMilitary) values(" + Session["ptsavevalue"].ToString() + "," + LoginInfo["PID"].ToString() + ", 'true')"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("Career"); } } else if (Session["ptsavename"].ToString() == "CompareSchools") { //Response.Redirect(Session["ptreturnurl"].ToString() + "&LoginID=" + LoginID); } //insert into or update Port_Selector table else if (Session["ptsavename"].ToString() == "CareerSelector" || Session["ptsavename"].ToString() == "UGSchoolSelector" || Session["ptsavename"].ToString() == "CTSchoolSelector" || Session["ptsavename"].ToString() == "GRSchoolSelector" || Session["ptsavename"].ToString() == "FASelector") { string strSelectorType = Session["ptsavename"].ToString().Replace("Selector", ""); //for now, no duplicates if (CCLib.Common.DataAccess.GetValue("select SelectorID from Port_Selector where PortfolioID=" + LoginInfo["PID"].ToString() + " and SelectorType='" + strSelectorType + "'").ToString() == "") strSQL = "insert into Port_Selector (SelectorType,SelectorCriteria,PortfolioID) values('" + strSelectorType + "','" + Session["ptsavevalue"].ToString().Replace("'", "''") + "'," + LoginInfo["PID"].ToString() + ")"; else strSQL = "update Port_Selector set SelectorCriteria='" + Session["ptsavevalue"].ToString().Replace("'", "''") + "', CreateTime='" + DateTime.Now + "' where SelectorType= '" + strSelectorType + "' and PortfolioID= " + LoginInfo["PID"].ToString(); CCLib.Common.DataAccess.ExecuteDb(strSQL); if (Session["ptsavename"].ToString() == "CareerSelector") UpdatePCSStatusFromSection("CareerSelector"); else if (Session["ptsavename"].ToString() == "UGSchoolSelector" || Session["ptsavename"].ToString() == "CTSchoolSelector" || Session["ptsavename"].ToString() == "GRSchoolSelector") UpdatePCSStatusFromSection("SchoolSelector"); else if (Session["ptsavename"].ToString() == "FASelector") UpdatePCSStatusFromSection("FinancialAidSelector"); } else if (Session["ptsavename"].ToString() == "Apprenticeship") { if (CCLib.Common.DataAccess.GetValue("select AppNum from Port_SavedApprenticeships where PortfolioID = " + LoginInfo["PID"].ToString() + " and AppNum = '" + Session["ptsavevalue"] + "'").ToString() == "") { strSQL = "insert into Port_SavedApprenticeships(PortfolioID, AppNum) values('" + LoginInfo["PID"].ToString() + "', '" + Session["ptsavevalue"].ToString() + "')"; strSQL += "; UPDATE CP_Student SET ProgramEligibilityUpdate = 1 WHERE PortfolioID = '" + LoginInfo["PID"].ToString() + "'"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("Apprenticeship"); strAjaxCPReturnValue = "1"; //added } else if (CCLib.Common.Strings.GetQueryString("ProgramFilterAjax") != "") { strSQL = "delete FROM Port_SavedApprenticeships where PortfolioID = " + LoginInfo["PID"].ToString() + " and AppNum = '" + Session["ptsavevalue"].ToString() + "'"; strSQL += "; UPDATE CP_Student SET ProgramEligibilityUpdate = 1 WHERE PortfolioID = '" + LoginInfo["PID"].ToString() + "'"; CCLib.Common.DataAccess.ExecuteDb(strSQL); strAjaxCPReturnValue = "0"; //removed } if (CCLib.Common.Strings.GetQueryString("ProgramFilterAjax") != "") { Response.Write(strAjaxCPReturnValue); Session["ptreturnurl"] = null; Response.End(); } } else if (Session["ptsavename"].ToString() == "Program") { if (CCLib.Common.DataAccess.GetValue("select ProgramID from Port_SavedPrograms where PortfolioID = " + LoginInfo["PID"].ToString() + " and ProgramID = '" + Session["ptsavevalue"] + "'").ToString() == "") { strSQL = "insert into Port_SavedPrograms(PortfolioID, ProgramID) values('" + LoginInfo["PID"].ToString() + "', '" + Session["ptsavevalue"].ToString() + "')"; strSQL += "; UPDATE CP_Student SET ProgramEligibilityUpdate = 1 WHERE PortfolioID = '" + LoginInfo["PID"].ToString() + "'"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("Programs"); strAjaxCPReturnValue = "1"; //added } else if (CCLib.Common.Strings.GetQueryString("ProgramFilterAjax") != "") { strSQL = "delete FROM Port_SavedPrograms where PortfolioID = " + LoginInfo["PID"].ToString() + " and ProgramID = '" + Session["ptsavevalue"].ToString() + "'"; strSQL += "; UPDATE CP_Student SET ProgramEligibilityUpdate = 1 WHERE PortfolioID = '" + LoginInfo["PID"].ToString() + "'"; CCLib.Common.DataAccess.ExecuteDb(strSQL); strAjaxCPReturnValue = "0"; //removed } if (CCLib.Common.Strings.GetQueryString("ProgramFilterAjax") != "") { Response.Write(strAjaxCPReturnValue); Session["ptreturnurl"] = null; Response.End(); } } else if (Session["ptsavename"].ToString() == "Scholarship") { if (CCLib.Common.DataAccess.GetValue("select ScholarshipID from Port_SavedScholarships where PortfolioID = " + LoginInfo["PID"].ToString() + " and ScholarshipID = '" + Session["ptsavevalue"] + "'").ToString() == "") { strSQL = "insert into Port_SavedScholarships(PortfolioID, ScholarshipID) values('" + LoginInfo["PID"].ToString() + "', '" + Session["ptsavevalue"].ToString() + "')"; CCLib.Common.DataAccess.ExecuteDb(strSQL); } } else if (Session["ptsavename"].ToString() == "LearningStyle" && Session["LS_Answers"] != null) { if (CCLib.Common.DataAccess.GetValue("select LrnStyleID from Port_SavedLrnStyles where PortfolioID = " + LoginInfo["PID"].ToString()).ToString() == "") strSQL = "insert into Port_SavedLrnStyles(PortfolioID, LrnStyleID, DateSaved, LrnStyleAnswers, VisualPercent, AuditoryPercent, TactilePercent) values ('" + LoginInfo["PID"].ToString() + "', '" + Session["LS_ID"].ToString() + "', '" + DateTime.Now + "', '" + Session["LS_Answers"].ToString() + "', '" + Session["VisualPercent"].ToString() + "', '" + Session["AuditoryPercent"].ToString() + "', '" + Session["TactilePercent"].ToString() + "')"; else strSQL = "update Port_SavedLrnStyles set LrnStyleID = " + Session["LS_ID"].ToString() + ", DateSaved = '" + DateTime.Now + "', LrnStyleAnswers = '" + Session["LS_Answers"].ToString() + "', VisualPercent = '" + Session["VisualPercent"].ToString() + "', AuditoryPercent = '" + Session["AuditoryPercent"].ToString() + "', TactilePercent = '" + Session["TactilePercent"].ToString() + "' where PortfolioID = '" + LoginInfo["PID"].ToString() + "'"; CCLib.Common.DataAccess.ExecuteDb(strSQL); UpdatePCSStatusFromSection("LrnStyle"); } else if (Session["ptsavename"].ToString() == "Major") { if (CCLib.Common.DataAccess.GetValue("select SavedMajorID from Port_SavedMajors where PortfolioID = " + LoginInfo["PID"].ToString() + " and CIP_Code = '" + Session["ptsavevalue"] + "'").ToString() == "") { strSQL = "insert into Port_SavedMajors(PortfolioID, CIP_CODE) values('" + LoginInfo["PID"].ToString() + "', '" + Session["ptsavevalue"].ToString() + "')"; CCLib.Common.DataAccess.ExecuteDb(strSQL); } } //save to db }//not for ILP Parent else Session["ptreturnurl"] = "/ILPParent/Home.aspx?";//ILP Parent goes to home page //clear login session strPTReturnURL = Session["ptreturnurl"].ToString() + "LoginID=" + LoginID; if (LoginInfo["ParentID"].ToString() == "" && ScriptName.ToLower().IndexOf("individual/") > -1) { string strAgreement = CCLib.Common.DataAccess.GetValue("select Agreement from Portfolio where PortfolioID=" + PortInfo["PortfolioID"].ToString()).ToString(); if (strAgreement != "True") { strPTReturnURL = "/Individual/Agreement.aspx?LoginID=" + LoginID;//ILP Parent goes to home page Session["ptAgreement"] = Session["ptreturnurl"]; } } Session["ptreturnurl"] = null; Session["ptsavename"] = null; Session["ptsavevalue"] = null; Session["SchoolCountry"] = null; Session["SchoolType"] = null; //three values for MatchMaker Session["MatchMakerRef"] = null; Session["MatchMakerRes"] = null; Session["MatchMakerEducation"] = null; Session["MatchMakerSkill"] = null; Session["MatchMakerSkillRank"] = null; //one value for Michigan Pathway Session["Pathway"] = null; //redirect to save result page Response.Redirect(strPTReturnURL + "&pt=1"); }//return url not null }
protected void Page_Load(object sender, EventArgs e) { #region Properties For The Base Class and Check Login LoginID = Request.QueryString["LoginID"]; LoginInfo = CCLib.Login.GetLoginInfo(LoginID); Redirect(); PageTitle = GetPortText(5357, false); Section = "portfolio_tool"; CSS = "student"; HeadTag = "<STYLE TYPE='TEXT/CSS'><!--.btnDescription { font: 11px Verdana, Arial, Helvetica, sans-serif; margin: 0px 15px}--></STYLE>"; BodyTag = " alink='#990000' style='background-image:url(/media/shared/bg_left_bar_grey.gif);background-repeat:repeat-y;' bgcolor='#ffffff' leftmargin=0 link='#003366' text='#000000' topmargin=0 vlink='#003366' marginwidth='0' marginheight='0'"; LeftBar = "<TABLE WIDTH='100%' BORDER='0' CELLSPACING='0' CELLPADDING='0'><TR VALIGN='TOP' BGCOLOR='#669966'><td background='/media/portfolio_tool/bg_bar_tan_top.gif'><img height=23 src='/media/student_parent/icons/icon_arrow.gif' alt='' width=24><img height=23 src='/media1/" + this.PortType + "/h_h_main" + this.SuffixCode() + ".gif' alt='' width=141>"; #endregion Properties For The Base Class and Check Login #region Initialize Values and Form Execution CheckPortSession(); strSubSection = (CCLib.Common.Strings.GetQueryString("SubSection") == "") ? "List" : CCLib.Common.Strings.GetQueryString("SubSection"); strAP = Request.QueryString["AP"]; strStOrder = CCLib.Common.Strings.GetQueryString("storder"); strSt = CCLib.Common.Strings.GetQueryString("st"); strAction = CCLib.Common.Strings.GetQueryString("action"); strLbl = CCLib.Common.Strings.GetQueryString("Lbl"); //matchMaker Label strYear = CCLib.Common.Strings.GetQueryString("year"); //Archive Year strMMID = CCLib.Common.Strings.GetQueryString("MMID"); SavedMMResults.PortfolioID = PortInfo["PortfolioID"].ToString(); SavedMMResults.LoginID = LoginID; SavedMMResults.MMEduLevel = LoginInfo["MMEduLevel"].ToString().ToLower(); SavedMMResults.SuffixCode = SuffixCode(); SavedMMResults.NonEngSuffixCode = NonEngSuffixCode(); SavedMMResults.JSGenericHrefLink = JSGenericHrefLink; SavedMMResults.CountryLanguageSuffixCode = SuffixCountryLanguageCode(); SavedMMResults.SortColumn = strSt; SavedMMResults.SortBy = strStOrder; SavedMMResults.CtrlType = "SK"; SavedMMResults.ArchiveYear = strYear; SavedMMResults.ParentID = ""; SavedMMResults.ArchiveYear = strYear; BestMatchResults.PortfolioID = PortInfo["PortfolioID"].ToString(); BestMatchResults.LoginID = LoginID; BestMatchResults.MMEduLevel = LoginInfo["MMEduLevel"].ToString().ToLower(); BestMatchResults.SuffixCode = SuffixCode(); BestMatchResults.NonEngSuffixCode = NonEngSuffixCode(); BestMatchResults.JSGenericHrefLink = JSGenericHrefLink; BestMatchResults.CountryLanguageSuffixCode = SuffixCountryLanguageCode(); BestMatchResults.CtrlType = "SK"; BestMatchResults.ParentID = ""; BestMatchResults.ArchiveYear = strYear; ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName = CareerCruisingWeb.CCLib.Common.Strings.GetDatabaseName(); if (Request.ServerVariables["REQUEST_METHOD"] == "POST") { strSavedMatchMakerID = CCLib.Common.Strings.GetFormString("SavedMatchMakerID"); if (strAction == "archive") { BestMatchResults.MMID = strSavedMatchMakerID; } } if (strAction == "new") { CCLib.MatchingObject.ClientStorage clientStorage = new CCLib.MatchingObject.ClientStorage(); clientStorage.ClearSession(); if (clientStorage.LoadFromPortfolio(LoginInfo["PID"].ToString(), Convert.ToInt32(strSavedMatchMakerID))) clientStorage.Save(LoginID); Response.Redirect("/MatchMaker/k_skills_intro.aspx?LoginID=" + LoginID + "&MMID=" + strMMID); //if (!ClientScript.IsOnSubmitStatementRegistered("Submit")) //{ // ClientScript.RegisterOnSubmitStatement(Page.GetType(), "Submit", "showLyr('appendReviewDiv');document.reviewrevise.TargetPage.value='/MatchMaker/k_skills_intro.aspx?LoginID=" + LoginID + "&MMID=" + strSavedMatchMakerID + "';location.hash = 'page_top'; void 0;"); //"CareerCruisingWeb.CCLib.Common.Strings.GenerateHrefString("/MatchMaker/k_list_matched.aspx?LoginID="+LoginID+"&BM=1", JSGenericHrefLink)%>"); //} } dtMatchMaker = CCLib.Common.DataAccess.GetDataTable("select SavedMatchMakerID,OccNumbers,Ref,Res,Education,Cluster,Skill,SkillRank,Convert(varchar(10),UpdateDate,101) UpdateDate,APMatch,APNotMatch,Label,BestMatch from " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedMatchMaker where PortfolioID=" + PortInfo["PortfolioID"].ToString()); for (int i = 0; i < dtMatchMaker.Rows.Count; i++) { if (dtMatchMaker.Rows[i]["Skill"].ToString() != "") blHasSkills = true; } drBM = dtMatchMaker.Select("BestMatch=1"); if (drBM.Length > 0) { strSavedMatchMakerID = drBM[0]["SavedMatchMakerID"].ToString(); strMMLabel = drBM[0]["Label"].ToString(); if (drBM[0]["OccNumbers"].ToString() != "") { bBMNoSkills = (drBM[0]["SkillRank"].ToString() != "") ? false : true; } } #endregion Initialize Values and Form Execution #region Properties For The Individual Base Class SetCustomJS(); AddArchiveButton = true; PortTitle = GetPortText(5372, false); SetTitleBar(); SetLeftButtons(); //LeftButtons = LeftButtons + ((Convert.ToBoolean(PortTypeElements["Mnu_LeftButtonImage"])) ? "<script>subMenu(2,'img16');</script>" : ""); PortSubTitle = TextCode(8799); SetSubTitleBar(); SetFooter(); #endregion Properties For The Individual Base Class }
protected void Page_Load(object sender, EventArgs e) { #region Properties For The Base Class and Check Login LoginID = Request.QueryString["LoginID"]; LoginInfo = CCLib.Login.GetLoginInfo(LoginID); Redirect(); PageTitle = GetPortText(5357, false); Section = "portfolio_tool"; CSS = "student"; HeadTag = "<STYLE TYPE='TEXT/CSS'><!--.btnDescription { font: 11px Verdana, Arial, Helvetica, sans-serif; margin: 0px 15px}--></STYLE>"; BodyTag = " alink='#990000' style='background-image:url(/media/shared/bg_left_bar_grey.gif);background-repeat:repeat-y;' bgcolor='#ffffff' leftmargin=0 link='#003366' text='#000000' topmargin=0 vlink='#003366' marginwidth='0' marginheight='0'"; LeftBar = "<TABLE WIDTH='100%' BORDER='0' CELLSPACING='0' CELLPADDING='0'><TR VALIGN='TOP' BGCOLOR='#669966'><td background='/media/portfolio_tool/bg_bar_tan_top.gif'><img height=23 src='/media/student_parent/icons/icon_arrow.gif' alt='' width=24><img height=23 src='/media1/" + this.PortType + "/h_h_main" + this.SuffixCode() + ".gif' alt='' width=141>"; #endregion Properties For The Base Class and Check Login #region Initialize Values and Form Execution CheckPortSession(); strSubSection = (CCLib.Common.Strings.GetQueryString("SubSection") == "") ? "List" : CCLib.Common.Strings.GetQueryString("SubSection"); strAP = Request.QueryString["AP"]; strStOrder = CCLib.Common.Strings.GetQueryString("storder"); strSt = CCLib.Common.Strings.GetQueryString("st"); strAction = CCLib.Common.Strings.GetQueryString("action"); strLbl = CCLib.Common.Strings.GetQueryString("Lbl"); //matchMaker Label strYear = CCLib.Common.Strings.GetQueryString("year"); //Archive Year SavedMMResults.PortfolioID = PortInfo["PortfolioID"].ToString(); SavedMMResults.LoginID = LoginID; SavedMMResults.MMEduLevel = LoginInfo["MMEduLevel"].ToString().ToLower(); SavedMMResults.SuffixCode = SuffixCode(); SavedMMResults.NonEngSuffixCode = NonEngSuffixCode(); SavedMMResults.JSGenericHrefLink = JSGenericHrefLink; SavedMMResults.CountryLanguageSuffixCode = SuffixCountryLanguageCode(); SavedMMResults.SortColumn = strSt; SavedMMResults.SortBy = strStOrder; SavedMMResults.CtrlType = "MM"; SavedMMResults.ParentID = ""; SavedMMResults.ArchiveYear = strYear; BestMatchResults.PortfolioID = PortInfo["PortfolioID"].ToString(); BestMatchResults.LoginID = LoginID; BestMatchResults.MMEduLevel = LoginInfo["MMEduLevel"].ToString().ToLower(); BestMatchResults.SuffixCode = SuffixCode(); BestMatchResults.NonEngSuffixCode = NonEngSuffixCode(); BestMatchResults.JSGenericHrefLink = JSGenericHrefLink; BestMatchResults.CountryLanguageSuffixCode = SuffixCountryLanguageCode(); BestMatchResults.CtrlType = "MM"; BestMatchResults.ParentID = ""; BestMatchResults.ArchiveYear = strYear; ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName = CareerCruisingWeb.CCLib.Common.Strings.GetDatabaseName(); if (strAction == "new") { CCLib.MatchingObject.ClientStorage clientStorage = new CCLib.MatchingObject.ClientStorage(); clientStorage.ClearSession(); if (LoginInfo["MMEduLevel"].ToString().ToLower() == "true") Response.Redirect("/MatchMaker/k_educationLevel.aspx?LoginID=" + LoginID); else Response.Redirect("/MatchMaker/k_aspects_intro.aspx?LoginID=" + LoginID); } //form post and execution if (Request.ServerVariables["REQUEST_METHOD"] == "POST") { strSavedMatchMakerID = CCLib.Common.Strings.GetFormString("SavedMatchMakerID"); strUpdateMatchMakerID = CCLib.Common.Strings.GetFormString("UpdateMatchMakerID"); strNotBestMatchLabel = CCLib.Common.Strings.GetFormString("NotBestMatchLabel"); if (strSavedMatchMakerID != "") { if (strAction == "changeBestMatch") { DataTable dt = CCLib.Common.DataAccess.GetDataTable("select SavedMatchMakerID from " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedmatchMaker where BestMatch=1 and PortfolioID=" + PortInfo["PortfolioID"].ToString()); if (dt.Rows.Count > 0) { CCLib.Common.DataAccess.ExecuteNonQuery("update " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedMatchMaker set BestMatch=0 where SavedMatchMakerID=" + dt.Rows[0]["SavedMatchMakerID"].ToString() + ";update " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedMatchMaker set BestMatch=1 where SavedMatchMakerID=" + strSavedMatchMakerID); } } if (strAction == "edit") { string strMMNumbers = LabelinDB(strLbl); if (strMMNumbers != "0") strLbl = LabelName(strLbl); CCLib.Common.DataAccess.ExecuteNonQuery("update " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedMatchMaker set Label='" + CCLib.Common.Strings.FormatUserInput(strLbl.Replace("'", "''")) + "',updatedate=getdate() where SavedMatchMakerID=" + strSavedMatchMakerID); } if (strAction == "delete1") { CCLib.Common.DataAccess.ExecuteNonQuery("delete from " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedMatchMaker where SavedMatchMakerID=" + strSavedMatchMakerID + " and PortfolioID=" + PortInfo["PortfolioID"].ToString()); UpdatePCSStatusFromSection("MatchMaker"); //clear mm session CCLib.MatchingObject.ClientStorage cStorage = new CCLib.MatchingObject.ClientStorage(); cStorage.ClearSession(); } if (strAction == "delete2") { CCLib.Common.DataAccess.ExecuteNonQuery("delete from Port_SavedMatchMaker where SavedMatchMakerID=" + strSavedMatchMakerID + " and PortfolioID=" + PortInfo["PortfolioID"].ToString() + "; Update Port_SavedMatchMaker set BestMatch=1 where SavedMatchmakerID = (select SavedMatchMakerID from Port_SavedMatchMaker where PortfolioID=" + PortInfo["PortfolioID"].ToString() + ")"); UpdatePCSStatusFromSection("MatchMaker"); } if (strAction == "delete3") { CCLib.Common.DataAccess.ExecuteNonQuery("delete from Port_SavedMatchMaker where SavedMatchMakerID=" + strSavedMatchMakerID + " and PortfolioID=" + PortInfo["PortfolioID"].ToString() + "; Update Port_SavedMatchMaker set BestMatch=1 where SavedMatchmakerID =" + strUpdateMatchMakerID); UpdatePCSStatusFromSection("MatchMaker"); } if (strAction == "archive") { BestMatchResults.MMID = strSavedMatchMakerID; } } } //generate values dtMatchMaker = CCLib.Common.DataAccess.GetDataTable("select SavedMatchMakerID,OccNumbers,Ref,Res,Education,Cluster,Skill,SkillRank,Convert(varchar(10),UpdateDate,101) UpdateDate,APMatch,APNotMatch,Label,BestMatch from " + ((CareerCruisingWeb.PageBase.IndividualBase)Page).DatabaseName + "Port_SavedMatchMaker where PortfolioID=" + PortInfo["PortfolioID"].ToString()); #endregion Initialize Values and Form Execution #region Properties For The Individual Base Class SetCustomJS(); AddArchiveButton = true; PortTitle = GetPortText(5372, false); SetTitleBar(); SetLeftButtons(); //LeftButtons = LeftButtons + ((Convert.ToBoolean(PortTypeElements["Mnu_LeftButtonImage"])) ? "<script>subMenu(2,'img16');</script>" : ""); PortSubTitle = TextCode(4023); SetSubTitleBar(); SetFooter(); #endregion Properties For The Individual Base Class }
//used to check user session and log out user public void CheckPortSession() { string strPortTypeFolder = (PortTypeID == "4") ? "SD" : PortType; LoginPage = (PortTypeSettings["HasCustomLogin"].ToString() == "True") ? "/" + strPortTypeFolder + "/Default.aspx" : "/Individual/Default.aspx"; UserLanguage = GetUserLanguage(); //first time access, check if it is valid login (has to be withing one minute of login to avoid url copying/pasting) if (CCLib.Common.Strings.GetQueryString("PID") != "" && CCLib.Common.Strings.GetQueryString("PID") == LoginInfo["PID"].ToString() && DateTime.Compare(DateTime.Now.AddDays(1), ((DateTime)(LoginInfo["ExpiredTime"])).AddMinutes(1)) < 0) { //Re-initialize Portfolio Session due to the scenarios like load balancing redirection //if (Session["PortInfo"] == null) //{ // CCLib.Login.PortLoginInitSession(PortTypeID, PortType, LoginInfo["PID"].ToString(), SchoolID); //} //SD user's should be redirected to the main page upon login to home page if (PortTypeID == "4" && ScriptName.ToLower() == "/individual/home.aspx") { if (Session["PortInfo"] != null) { DataRow drwPortInfo = (DataRow)Session["PortInfo"]; //matchmaker session initialization CCLib.MatchingObject.ClientStorage clientStorage = new CCLib.MatchingObject.ClientStorage(); if (clientStorage.LoadFromPortfolio(drwPortInfo["PortfolioID"].ToString())) { //it's worked so save it back to the session state clientStorage.Save(LoginID); } else { //clear previous session if the current user does NOT have matchmaker clientStorage.ClearSession(); } if (drwPortInfo["Agreement"].ToString() == "True") Response.Redirect("/Main/Index.aspx?LoginID=" + LoginID); else Response.Redirect("/Individual/Agreement.aspx?LoginID=" + LoginID); } } } else if (CCLib.Common.Strings.GetQueryString("PID") == "" && LoginInfo["PID"].ToString() == "")//school port login, reset login session for portfolio login page { CCLib.Login.ExpireUserLoginSession(); } if (Session["PortInfo"] != null) { PortInfo = (DataRow)Session["PortInfo"]; if (Convert.ToInt16(PortInfo["GradeNumber"]) < 5) PortInfo["GradeNumber"] = 5; else if (Convert.ToInt16(PortInfo["GradeNumber"]) > 13) PortInfo["GradeNumber"] = 13; if (PortTypeID != "5") AppSettings = CCLib.Login.GetAppSettings(PortInfo["SchoolID"].ToString()); //PortSettings = (DataRow)Session["PortSettings"]; //PortTypeSettings = (DataRow)Session["PortTypeSettings"]; PortTypeElements = GetPortTypeElements(ToolTypeID); #region set menu grade if (Convert.ToInt16(PortInfo["GradeNumber"]) <= 13 && Convert.ToInt16(PortInfo["GradeNumber"]) > 4) MenuGrade = PortInfo["GradeNumber"].ToString(); else if (Convert.ToInt16(PortInfo["GradeNumber"]) > 13) MenuGrade = "13"; else MenuGrade = "5"; #endregion set menu grade GetPCSCriteria(); if (Session["PCSStatus"] != null) { PCSStatus = (DataRow)Session["PCSStatus"]; } //first time access or session is not initialized, generate PCS session variable if (CCLib.Common.Strings.GetQueryString("PID") == LoginInfo["PID"].ToString() || Session["PCSStatus"] == null) GetPCSStatus(); //check AltComp flag, if so, update PCSStatus["AltComp"] if (Convert.ToInt16(PortTypeElements["PCS_AltComp_View"]) == 1 && IsAltComp(PortInfo["PortfolioID"].ToString()) && PCSStatus != null) PCSStatus["AltComp"] = true; //customized code for ILP below, need to be changed later SetPCSDescription(); //Get Port SectionID based on page name GetPortSectionID(); //course planning flag if (LoginInfo["CoursePlanner"].ToString() != "" && (PortInfo["Active"].ToString() == "True" || PortInfo["CP_Demo"].ToString() == "1" || PortInfo["CP_Demo"].ToString() == "2")) { CPCoursePlanner = LoginInfo["CoursePlanner"].ToString(); isCEP = Convert.ToBoolean(LoginInfo["isCEP"]); } //matchmaker session initialization CCLib.MatchingObject.ClientStorage clientStorage = new CCLib.MatchingObject.ClientStorage(); if (clientStorage.LoadFromPortfolio(PortInfo["PortfolioID"].ToString())) { //it's worked so save it back to the session state clientStorage.Save(LoginID); } else { //clear previous session if the current user does NOT have matchmaker clientStorage.ClearSession(); } } else { Session["LastPortPage"] = ScriptName;//used to remember the last Port page when re-login Session["LastPortPageQueryString"] = CCLib.Common.Strings.TrimQueryString(CCLib.Common.Strings.TrimQueryString(Request.QueryString.ToString(), "LoginID=" + LoginID), "PID=" + LoginInfo["PID"].ToString());//used to remember the last Port page's querystring (excluding LoginID and PID) when re-login string strLanguagePar = (UserLanguage == "") ? "" : "&Language=" + UserLanguage; Response.Redirect(LoginPage + "?LoginID=" + LoginID + strLanguagePar);//user clicked portfolio button outside portfoio, either from top nav bar or from the main home page } }