protected void Page_Load(object sender, EventArgs e)
{
strAuthToken = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("authToken") : CCLib.Common.Strings.GetQueryString("authToken");
strLaunchParams = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("launchParams") : CCLib.Common.Strings.GetQueryString("launchParams");
strTargetUrl = (strTargetUrl == "") ? "/Individual/Home.aspx" : strTargetUrl;
//there must be a return url
if (strLaunchParams == "JOURNAL")
strTargetUrl = "/Individual/MyJournal/Default.aspx";
else if (strLaunchParams == "PORTFOLIO")
strTargetUrl = "/Individual/Home.aspx";
else if (strLaunchParams == "MATCHMAKER")
strTargetUrl = "/Individual/matchmaker.aspx";
else if (strLaunchParams == "SKILLS")
strTargetUrl = "/Individual/MySkill.aspx";
else if (strLaunchParams == "LSI")
strTargetUrl = "/Individual/LearningStyle.aspx";
else if (strLaunchParams == "EXPLORE")
strTargetUrl = "/Careers/Index4.aspx";
ConnectED_SSO.AcuityFacadeService Service = new ConnectED_SSO.AcuityFacadeService();
ConnectED_SSO.Faculty faculty = Service.getFacultyByAuthToken(strAuthToken);
int intUserID = faculty.UserID;
int intOrganizationID = faculty.OrganizationID;
string strFirstName = faculty.FirstName;
string strLastName = faculty.LastName;
string strGradeLevel = "70";//set as default
int intGenderID = 0;//set as default
string strDateModified = faculty.DateModified;
//check school first
string strSchoolID = CareerCruisingWeb.CCLib.Common.DataAccess.GetValue("select SchoolID from MHWC_Sites where SiteID='" + intOrganizationID + "'" + "and SiteType='MHConnectED'").ToString();
//Invalid OrganizationID
if (strSchoolID == "")
Response.Write("Your school has not yet been set up for Career Cruising. Please send an email to [email protected] with the following information:<br><br>�Institution Name: <br>Street Address: <br>City: <br>State: <br>Zip: <br>Main Phone Number: <br>Institution Contact Person Name: <br>Institution Contact Person Email address: <br>Institution Contact Person Phone Number:<br><br>NOTE: please allow 2-3 Business days for access");
else
{
DataTable dtbUserInfo = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("select UserName,Password from UserInfo where SchoolID=" + strSchoolID);
//Invalid SchoolID
if (dtbUserInfo.Rows.Count == 0)
Response.Write("Your school is not set up correctly for CareerCruising access yet, invalid SchoolID");
else
{
DataTable dtbStudentInfo = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("select PortfolioID from MHConnectED_Users where UserID=" + intUserID + " and OrganizationID=" + intOrganizationID);
if (dtbStudentInfo.Rows.Count == 0)//no records
{
strUsername = "******" + strFirstName.Trim().Substring(0,1)+ strLastName.Trim().Substring(0,1) + RandomString().Substring(0, 10);
strPassword = RandomString().Substring(10, 10);
//insert to Portfolio
strSQL = "insert into Portfolio (UserName,PassWord,SchoolUserName,SchoolPassword,FirstName,LastName,SchoolID,GradeNumber,UserType,GenderID,EmailPrompt) values ('" + strUsername.Replace("'", "''") + "','" + strPassword.Replace("'", "''") + "','" + dtbUserInfo.Rows[0]["UserName"].ToString() + "','" + dtbUserInfo.Rows[0]["Password"].ToString() + "','" + strFirstName.Replace("'", "''") + "','" + strLastName.Replace("'", "''") + "'," + strSchoolID + "," + strGradeLevel + ",0," + intGenderID + ",0)";
strPortfolioID = CCLib.Common.DataAccess.ExecuteDbWithIntResult(strSQL + ";SELECT SCOPE_IDENTITY();").ToString();
//insert to table MHConnectED_Users
CareerCruisingWeb.CCLib.Common.DataAccess.ExecuteNonQuery("insert into MHConnectED_Users (UserID,OrganizationID,RoleID,PortfolioID,SchoolID,FirstName,LastName,GenderID,GradeLevel,DateModified) values (" + intUserID + "," + intOrganizationID + ",5," + strPortfolioID + ","+strSchoolID+",'" + strFirstName.Replace("'", "''") + "','" + strLastName.Replace("'", "''") + "'," + intGenderID + "," + strGradeLevel + ",'" + DateTime.Parse(strDateModified).ToString() + "')");
}
else
strPortfolioID = dtbStudentInfo.Rows[0]["PortfolioID"].ToString();
//auto login user
AutoLoginUser();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
strAuthToken = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("authToken") : CCLib.Common.Strings.GetQueryString("authToken");
strLaunchParams = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("launchParams") : CCLib.Common.Strings.GetQueryString("launchParams");
strTargetUrl = (strTargetUrl == "") ? "/Individual/Home.aspx" : strTargetUrl;
//there must be a return url
if (strLaunchParams == "JOURNAL")
strTargetUrl = "/Individual/MyJournal/Default.aspx";
else if (strLaunchParams == "PORTFOLIO")
strTargetUrl = "/Individual/Home.aspx";
else if (strLaunchParams == "MATCHMAKER")
strTargetUrl = "/Individual/matchmaker.aspx";
else if (strLaunchParams == "SKILLS")
strTargetUrl = "/Individual/MySkill.aspx";
else if (strLaunchParams == "LSI")
strTargetUrl = "/Individual/LearningStyle.aspx";
else if (strLaunchParams == "EXPLORE")
strTargetUrl = "/Careers/Index4.aspx";
int intUserID;
int intOrganizationID;
string strFirstName;
string strLastName;
string strGradeLevel;
int intGenderID;
string strDateModified;
ConnectED_SSO.AcuityFacadeService Service = new ConnectED_SSO.AcuityFacadeService();
ConnectED_SSO.Student student;
try
{
student = Service.getStudentByAuthToken(strAuthToken);
intUserID = student.UserID;
intOrganizationID = student.OrganizationID;
strFirstName = student.FirstName;
strLastName = student.LastName;
strGradeLevel = student.GradeLevel;
intGenderID = student.GenderID - 1;
strDateModified = student.DateModified;
if (strGradeLevel == "pk")
strGradeLevel = "98";
else if (strGradeLevel == "k")
strGradeLevel = "99";
//check school first
string strSchoolID = CareerCruisingWeb.CCLib.Common.DataAccess.GetValue("select SchoolID from MHWC_Sites where SiteID='" + intOrganizationID + "'" + "and SiteType='MHConnectED'").ToString();
//Invalid OrganizationID
if (strSchoolID == "")
Response.Write("Your school is not set up for CareerCruising access yet");
else
{
DataTable dtbUserInfo = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("select UserName,Password from UserInfo where SchoolID=" + strSchoolID);
//Invalid SchoolID
if (dtbUserInfo.Rows.Count == 0)
Response.Write("Your school is not set up correctly for CareerCruising access yet, invalid SchoolID");
else
{
DataTable dtbStudentInfo = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("select PortfolioID from MHConnectED_Users where UserID=" + intUserID + " and OrganizationID=" + intOrganizationID);
if (dtbStudentInfo.Rows.Count == 0)//no records
{
strUsername = "******" + strFirstName.Trim().Substring(0, 1) + strLastName.Trim().Substring(0, 1) + RandomString().Substring(0, 10);
strPassword = RandomString().Substring(10, 10);
//insert to Portfolio
strSQL = "insert into Portfolio (UserName,PassWord,SchoolUserName,SchoolPassword,FirstName,LastName,SchoolID,GradeNumber,UserType,GenderID) values ('" + strUsername.Replace("'", "''") + "','" + strPassword.Replace("'", "''") + "','" + dtbUserInfo.Rows[0]["UserName"].ToString() + "','" + dtbUserInfo.Rows[0]["Password"].ToString() + "','" + strFirstName.Replace("'", "''") + "','" + strLastName.Replace("'", "''") + "'," + strSchoolID + "," + strGradeLevel + ",0," + intGenderID + ")";
strPortfolioID = CCLib.Common.DataAccess.ExecuteDbWithIntResult(strSQL + ";SELECT SCOPE_IDENTITY();").ToString();
//insert to table MHConnectED_Users
CareerCruisingWeb.CCLib.Common.DataAccess.ExecuteNonQuery("insert into MHConnectED_Users (UserID,OrganizationID,RoleID,PortfolioID,SchoolID,FirstName,LastName,GenderID,GradeLevel,DateModified) values (" + intUserID + "," + intOrganizationID + ",7," + strPortfolioID + "," + strSchoolID + ",'" + strFirstName.Replace("'", "''") + "','" + strLastName.Replace("'", "''") + "'," + intGenderID + "," + strGradeLevel + ",'" + DateTime.Parse(strDateModified).ToString() + "')");
}
else
strPortfolioID = dtbStudentInfo.Rows[0]["PortfolioID"].ToString();
//auto login user
AutoLoginUser();
}
}
}
catch (System.Web.Services.Protocols.SoapHeaderException error)
{
//Response.Write(error.ToString());
if (error.ToString().Contains("is not enrolled in a class"))
Response.Write("Your teacher must first add you to a class before you can access Career Cruising");
else
Response.Write("There is error in your account, and it is not set up for CareerCruising access yet");
}
}
