protected void Page_Load(object sender, EventArgs e)
{
if (Request.ServerVariables["REQUEST_METHOD"] == "POST")
{
strPost = CCLib.Common.Strings.GetFormString("post");
if (strPost == "1" && Session["RegionAdminInfo"] != null)
{
DataRow drAdminInfo = (DataRow)Session["RegionAdminInfo"];
//CCLib.Common.DataAccess.ExecuteDb("update RRS_Login_View set Agreement=1 where RegionId='" + drAdminInfo["RegionId"].ToString().Replace("'", "''") + "' and Password='******'", "''") + "'");
//
this.strPassword = drAdminInfo["Password"].ToString().Replace("'", "''");
this.strRegionID = drAdminInfo["RegionId"].ToString();
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.objDistrictUserID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectDistrictUserID(this.strPassword, this.strRegionID));
this.strDistrictUserID = this.objDistrictUserID != null ? this.objDistrictUserID.ToString() : null;
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateRRSUsers(this.strDistrictUserID), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateConRRSUsers(this.strDistrictUserID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.trsCC.Commit();
this.ReleaseObjects();
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
}
//
Response.Redirect("https://" + ConfigurationManager.AppSettings["strServerName"] + "/Region/Home.aspx");
}
}
}
private void ReleaseObjects()
{
this.trsCC = null;
if (this.cnnCC.State == ConnectionState.Open)
{
this.cnnCC.Close();
}
this.userCredential = null;
this.wsSLXIntegration = null;
this.objDistrictUserID = null;
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckSchoolAdminSession();
#endregion Check Login
strLoggedInAdminID = AdminInfo["AdminID"].ToString();
strLoggedInUsernameSQL = "SELECT FirstName + ' ' + LastName AS Username FROM PortfolioAdmin WHERE AdminID = " + strLoggedInAdminID;
dtLoggedInUsername = CCLib.Common.DataAccess.GetDataTable(strLoggedInUsernameSQL);
strLoggedInUsername = dtLoggedInUsername.Rows[0]["Username"].ToString();
dtSecurityLevels = CCLib.Cache.GetCachedDataTable("SecurityLevels-" + PortTypeID + SuffixCode(), "select *, SecurityName" + SuffixCode() + " SecurityName, Description" + SuffixCode() + " Description from PortfolioAdminSecurity where PortTypeID = " + PortTypeID + " order by SecurityLevel DESC");
SchoolID = AdminInfo["SchoolID"] != null ? AdminInfo["SchoolID"].ToString() : null;
SchoolUsername = AdminInfo["SchoolUsername"] != null ? (AdminInfo["SchoolUsername"].ToString().Trim().Length > 50 ? AdminInfo["SchoolUsername"].ToString().Trim().Substring(0, 50) : AdminInfo["SchoolUsername"].ToString().Trim()) : null;
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
uc1.argTitle = new string[] { "Transcript Specialist", "" };
uc1.argContent = new string[] { @"Transcript Specialists handle the processing of requests by students to have their transcripts submitted to colleges and other institutions.
<br /><br />
Transcripts are printed from the student information system, mapped to student accounts in Career Cruising, and are then available to be sent electronically to colleges.
<br /><br />
You can also track paper transcripts that are mailed to colleges that do not accept electronic transcripts." };
uc1.intTagNum = 1;
uc1.TagID = new string[] { "1" };
uc1.strBgColor = "#f0ede3";
uc1.strHeader = "contentTableHeaderDarkBG";
uc1.ShowDirection = "right-bottom";
uc2.argTitle = new string[] { "Transcript Specialist", "" };
uc2.argContent = new string[] { @"Transcript Specialists handle the processing of requests by students to have their transcripts submitted to colleges and other institutions.
<br /><br />
Transcripts are printed from the student information system, mapped to student accounts in Career Cruising, and are then available to be sent electronically to colleges.
<br /><br />
You can also track paper transcripts that are mailed to colleges that do not accept electronic transcripts." };
uc2.intTagNum = 1;
uc2.TagID = new string[] { "2" };
uc2.strBgColor = "#f0ede3";
uc2.strHeader = "contentTableHeaderDarkBG";
uc2.ShowDirection = "right-bottom";
if (Request.ServerVariables["REQUEST_METHOD"] == "POST")
{
//For Web Services Model
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
wstest = new WSCCIntegrationWithSLX.IntegrationWithSLX();
System.Net.NetworkCredential userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
wstest.Credentials = userCredential;
wstest.PreAuthenticate = true;
this.connCC = new SqlConnection(strConnectionStringToCC);
strMAForm = CCLib.Common.Strings.GetFormString("MAForm");
string strFirstName = CareerCruisingWeb.CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("FirstName")));
string strLastName = CareerCruisingWeb.CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("LastName")));
string strEmail = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("Email"));
string strPortfolioAdminEmail = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("Email"));
string strPassword = CCLib.Common.Strings.GetFormString("Password").Replace("'", "''");
string strSecurityLevel = CCLib.Common.Strings.GetFormString("SecurityLevel");
string strDisplayName = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("DisplayName"));
string strSecCodeID = "SYST00000001";
object objLicenseType = wstest.GetValueFromSLX(this.GetSLXSQLSelectLicenseType(), this.strConnectionStringToSLX);
string strLicenseType = objLicenseType != null ? objLicenseType.ToString() : null;
string strTranscript = (CCLib.Common.Strings.GetFormString("cbTranscript") == "1") ? "1" : "0";
bool booIsLOK; //For License Type: L--Licensed, O--Ontario, K--Kentucky
ViewState["Email"] = strEmail;
switch (strMAForm)
{
case "1":
// New advisor posting
if (CheckForPwdConflict(strPassword))
{
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8246).Replace("'", "\\'")));
}
else
{
if ((this.wstest.GetRecordCount(this.GetSLXSQLContactExists(strFirstName, strLastName), this.strConnectionStringToSLX, true) == 1) & (!IntegrationWithSLX.CheckExists(this.GetCCSQLAdminIDExists(strFirstName, strLastName), this.strConnectionStringToCC)))
{
if (this.connCC.State == ConnectionState.Closed)
{
this.connCC.Open();
}
this.tranConnCC = this.connCC.BeginTransaction();
this.intReturnValue1 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminPassword(strPassword, strFirstName, strLastName, strPortfolioAdminEmail, strSecurityLevel,strTranscript), this.connCC, this.tranConnCC);
this.objAdminID = SqlHelper.ExecuteScalar(this.tranConnCC, CommandType.Text, this.GetCCSQLSelectAdminID(strPassword));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue6 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminName(strFirstName,strLastName,strDisplayName), this.connCC, this.tranConnCC);
if ((this.intReturnValue1 > 0)&(this.intReturnValue6 > 0))
{
this.objContactID = this.wstest.GetValueFromSLX(this.GetSLXSQLContactExists(strFirstName, strLastName), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
//this.objAdminID = SqlHelper.ExecuteScalar(this.tranConnCC, CommandType.Text, this.GetCCSQLSelectAdminID(strPassword));
//this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
if (this.wstest.CheckExists(this.GetSLXSQLEmailExists(strEmail, this.strContactID), this.strConnectionStringToSLX, true))
{
strEmail = null;
}
this.intReturnValue2 = this.wstest.ExecuteNoQuery(this.GetSLXSQLUpdateContactEmail(this.strContactID, strEmail), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue4 = this.wstest.ExecuteNoQuery(this.GetSLXSQLInsertAdminPassword(this.strContactID, strPassword, strSecurityLevel, this.strAdminID, strLicenseType), this.strConnectionStringToSLX);
}
else
{
this.intReturnValue4 = 0;
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue4 > 0))
{
this.tranConnCC.Commit();
TrackChanges(1);
if (CCLib.Common.Strings.GetFormString("chkEmail").ToString() == "on")
SendEmailToNewAdvisor(strFirstName, ViewState["Email"].ToString());
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8247)));
}
else
{
this.tranConnCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8248)));
}
}
else
{
this.tranConnCC.Rollback();
this.Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8248)));
}
}
else
{
if (this.wstest.CheckExists(this.GetSLXSQLEmailExists(strEmail), this.strConnectionStringToSLX, true))
{
strEmail = null;
}
if (this.connCC.State == ConnectionState.Closed)
{
this.connCC.Open();
}
this.tranConnCC = this.connCC.BeginTransaction();
this.intReturnValue1 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminPassword(strPassword, strFirstName, strLastName, strPortfolioAdminEmail, strSecurityLevel,strTranscript), this.connCC, this.tranConnCC);
this.objAdminID = SqlHelper.ExecuteScalar(this.tranConnCC, CommandType.Text, this.GetCCSQLSelectAdminID(strPassword));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue6 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminName(strFirstName, strLastName, strDisplayName), this.connCC, this.tranConnCC);
if ((this.intReturnValue1 > 0) & (this.intReturnValue6 > 0))
{
this.objContactID = this.wstest.GetNewSLXID("Contact", this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
//this.objAdminID = SqlHelper.ExecuteScalar(this.tranConnCC, CommandType.Text, this.GetCCSQLSelectAdminID(strPassword));
//this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
//if ((strLicenseType == "Licensed") | (strLicenseType == "Ontario") | (strLicenseType == "Kentucky") | (strLicenseType == "Delaware") | (strLicenseType == "Manitoba") | (strLicenseType == "South Dakota"))
//{
booIsLOK = true;
//}
//else
//{
// booIsLOK = false;
//}
this.objAccountID = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectAccountID(), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectAccount(), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? this.objAccount.ToString().Replace("'", "''") : null;
this.objAddressID = this.wstest.GetNewSLXID("Address", this.strConnectionStringToSLX);
this.strAddressID = this.objAddressID != null ? this.objAddressID.ToString() : null;
this.intReturnValue2 = this.wstest.ExecuteNoQuery(this.GetSLXSQLInsertContact(this.strContactID, this.strAccountID, this.strAccount, strFirstName, strLastName, strEmail, strSecCodeID, strAddressID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wstest.ExecuteNoQuery(this.GetSLXSQLSetReceiveNewsLetter(this.strContactID, booIsLOK, strFirstName), this.strConnectionStringToSLX);
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wstest.ExecuteNoQuery(this.GetSLXSQLInsertAdminPassword(this.strContactID, strPassword, strSecurityLevel, this.strAdminID, strLicenseType), this.strConnectionStringToSLX);
if (this.intReturnValue4 > 0)
{
this.intReturnValue5 = this.wstest.ExecuteNoQuery(this.GetSLXSQLInsertAddress(this.strAddressID, this.strContactID), this.strConnectionStringToSLX);
}
}
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0) & (this.intReturnValue4 > 0) & (this.intReturnValue5 > 0))
{
this.tranConnCC.Commit();
TrackChanges(1);
if (CCLib.Common.Strings.GetFormString("chkEmail").ToString() == "on")
SendEmailToNewAdvisor(strFirstName, ViewState["Email"].ToString());
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8247)));
}
else
{
this.tranConnCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8248)));
}
}
else
{
this.tranConnCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8248)));
}
}
}
this.ReleaseDBObjects();
break;
case "2":
// Update Advisor
this.strAdminID = CCLib.Common.Strings.GetFormString("AdminID");
strFN = CCLib.Common.Strings.GetFormString("hidFN");
strLN = CCLib.Common.Strings.GetFormString("hidLN");
strDN = CCLib.Common.Strings.GetFormString("hidDN");
strEA = CCLib.Common.Strings.GetFormString("hidEA");
strPW = CCLib.Common.Strings.GetFormString("hidPW");
strAT = CCLib.Common.Strings.GetFormString("hidAT");
if (CheckForPwdConflict(strPassword, strAdminID))
{
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8246).Replace("'", "\\'")));
}
else
{
this.objContactID = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectContactID(this.strAdminID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
if (this.wstest.CheckExists(this.GetSLXSQLEmailExists(strEmail, this.strContactID), this.strConnectionStringToSLX, true))
{
strEmail = null;
}
if (this.connCC.State == ConnectionState.Closed)
{
this.connCC.Open();
}
this.tranConnCC = this.connCC.BeginTransaction();
this.intReturnValue1 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateAdminPassword(strFirstName, strLastName, strPortfolioAdminEmail, strPassword, strSecurityLevel, this.strAdminID, strTranscript), this.connCC, this.tranConnCC);
this.intReturnValue6 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateAdminName(strFirstName, strLastName, this.strAdminID, strDisplayName), this.connCC, this.tranConnCC);
if ((this.intReturnValue1 > 0) & (this.intReturnValue6 > 0))
{
object objPrefix;
string strDearValue;
objPrefix = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectContactPrefix(this.strContactID), this.strConnectionStringToSLX);
if (objPrefix != null)
{
if (objPrefix.ToString() != "")
{
strDearValue = objPrefix.ToString() + " " + strLastName;
}
else
{
strDearValue = strFirstName;
}
}
else
{
strDearValue = strFirstName;
}
this.intReturnValue2 = this.wstest.ExecuteNoQuery(this.GetSLXSQLUpdateContact(strFirstName, strLastName, strEmail, strDearValue, this.strContactID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wstest.ExecuteNoQuery(this.GetSLXSQLUpdateAdminPassword(strPassword, strSecurityLevel, this.strAdminID, strLicenseType), this.strConnectionStringToSLX);
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0))
{
this.tranConnCC.Commit();
TrackChanges(3);
//Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8249)));
}
else
{
this.tranConnCC.Rollback();
//Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8250)));
}
}
else
{
this.tranConnCC.Rollback();
//Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8250)));
}
this.ReleaseDBObjects();
Response.Redirect("ManageAdvisors.aspx?A=U");
}
this.ReleaseDBObjects();
break;
}
}
strMASection = (CCLib.Common.Strings.GetQueryString("F").Length > 0) ? CCLib.Common.Strings.GetQueryString("F") : "List";
switch (strMASection)
{
case "List":
if (CCLib.Common.Strings.GetQueryString("A") == "U")
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The advisor has been updated."));
strCol = CCLib.Common.Strings.GetQueryString("col");
strOrder = CCLib.Common.Strings.GetQueryString("storder");
strTranscriptOnly = CCLib.Common.Strings.GetQueryString("T");
if (strCol == "")
strCol = "2";
string strListSQL = "Select FirstName, LastName, AdminPassword, SecurityLevel, AdminID, TranscriptSpecialist from PortfolioAdmin where SchoolID=" + AdminInfo["SchoolID"].ToString();
if (strTranscriptOnly == "1")
strListSQL += " and TranscriptSpecialist=1";
strListSQL += " order by " + strCol + " " + strOrder;
dtAdvisorList = CCLib.Common.DataAccess.GetDataTables(strListSQL);
if (strOrder == "")
strNextStOrder = "desc";
else
strNextStOrder = "";
break;
case "New":
// New Advisor Form
break;
case "Stu":
string command = null;
//Assigned Student List
strAdminID = CCLib.Common.Strings.GetQueryString("I");
//string strSort = (CCLib.Common.Strings.GetQueryString("ST").Length > 0) ? CCLib.Common.Strings.GetQueryString("ST") : "2";
strCol = (CCLib.Common.Strings.GetQueryString("Col"));
strOrder = (CCLib.Common.Strings.GetQueryString("storder"));
if (strCol == "")
strCol = "2";
command += "Select StudentFirstName, StudentLastName, GradeNumber, UserName, PassWord, AdvisorFirstName, AdvisorLastName from PortfolioAdvisorAssignmentView where SchoolID=" + AdminInfo["SchoolID"].ToString() + " and AdminID=" + strAdminID + " order by " + strCol + " " + strOrder;
//for reverse sort
if (strOrder == "")
strNextStOrder = "Desc";
else
strNextStOrder = "";
if (strCol == "2")
{
command += ", StudentFirstName;";
}
else
{
command += ", StudentLastName, StudentFirstName;";
}
command += "select FirstName, LastName from PortfolioAdmin where AdminID=" + strAdminID;
dtAdvisorList = CCLib.Common.DataAccess.GetDataTables(command);
break;
case "Del":
//Delete advisor
//For Web Services Model
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
wstest = new WSCCIntegrationWithSLX.IntegrationWithSLX();
System.Net.NetworkCredential userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
wstest.Credentials = userCredential;
wstest.PreAuthenticate = true;
this.connCC = new SqlConnection(strConnectionStringToCC);
strAdminID = CCLib.Common.Strings.GetQueryString("I");
if (this.connCC.State == ConnectionState.Closed)
{
this.connCC.Open();
}
this.tranConnCC = this.connCC.BeginTransaction();
this.intReturnValue1 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLDeleteAdminPassword(strAdminID), this.connCC, this.tranConnCC);
this.intReturnValue2 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLDeleteAdvisorAssignments(strAdminID), this.connCC, this.tranConnCC);
if ((intReturnValue1 > 0) & (intReturnValue2 > 0))
{
object objHistoryID = this.wstest.GetNewSLXID("History", this.strConnectionStringToSLX);
string strHistoryID = objHistoryID != null ? objHistoryID.ToString() : null;
this.objContactID = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectContactID(this.strAdminID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
this.objAccountID = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectAccountID(), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectAccount(), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? this.objAccount.ToString().Replace("'", "''") : null;
object objContactName = this.wstest.GetValueFromSLX(this.GetSLXSQLSelectContactName(strContactID), this.strConnectionStringToSLX);
string strContactName = objContactName != null ? objContactName.ToString() : null;
string strLogType = "262148"; //Type: 262148 -- "Note"
string strDescription = "Admin password deleted";
this.intReturnValue3 = this.wstest.ExecuteNoQuery(this.GetSLXSQLDeleteAdminPassword(strAdminID), this.strConnectionStringToSLX);
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wstest.ExecuteNoQuery(this.GetSLXSQLLogDeletion(strHistoryID, strContactID, strContactName, strLogType, strDescription, strAccountID, strAccount), this.strConnectionStringToSLX);
}
else
{
this.intReturnValue4 = 0;
}
if ((this.intReturnValue3 > 0) & (this.intReturnValue4 > 0))
{
this.tranConnCC.Commit();
TrackChanges(2);
//Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8251)));
}
else
{
this.tranConnCC.Rollback();
//Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8252)));
}
}
else
{
this.tranConnCC.Rollback();
//Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8252)));
}
this.ReleaseDBObjects();
Response.Redirect("ManageAdvisors.aspx");
break;
case "Edit":
//Edit Advisor Info
strAdminID = CCLib.Common.Strings.GetQueryString("I");
strSQL = "select a.LastName, a.FirstName, a.Email, a.AdminPassword, a.SecurityLevel, a.AdminID, n.DisplayName, a.TranscriptSpecialist from PortfolioAdmin a join PortfolioAdminNames n on a.AdminID=n.AdminID where a.AdminID=" + strAdminID;
dtAdvisorList = CCLib.Common.DataAccess.GetDataTables(strSQL);
strFN = dtAdvisorList[0].Rows[0]["FirstName"].ToString();
strLN = dtAdvisorList[0].Rows[0]["LastName"].ToString();
strDN = dtAdvisorList[0].Rows[0]["DisplayName"].ToString();
strEA = dtAdvisorList[0].Rows[0]["Email"].ToString();
strPW = dtAdvisorList[0].Rows[0]["AdminPassword"].ToString();
strAT = dtAdvisorList[0].Rows[0]["SecurityLevel"].ToString();
break;
}
#region Properties For The School Base Class
TitleBar = TextCode(8242);
SubTitleBar = TextCode(8243);
#endregion Properties For The School Base Class
}
protected void ReleaseDBObjects()
{
this.tranConnCC = null;
if (this.connCC.State == ConnectionState.Open)
{
this.connCC.Close();
}
this.connCC = null;
this.wstest = null;
}
private void ReleaseObjects()
{
this.trsCC = null;
if (this.cnnCC.State == ConnectionState.Open)
{
this.cnnCC.Close();
}
this.userCredential = null;
this.wsSLXIntegration = null;
this.objHistoryID = null;
this.objContactID = null;
this.objAccountID = null;
this.objAccount = null;
this.objContactName = null;
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckRegionAdminSession();
#endregion Check Login
#region Initialize Values and Form Execution
//form post and execution
strCol = CCLib.Common.Strings.GetQueryString("col");
strOrder = CCLib.Common.Strings.GetQueryString("storder");
if (strCol == "")
strCol = "3";
strSQL = "select DistrictUserID,FirstName,LastName,Password,SecurityLevel from RRSUsers where RegionID = '" + AdminInfo["RegionID"].ToString() + "' order by " + strCol + " " + strOrder;
dtAdmin = CCLib.Common.DataAccess.GetDataTable(strSQL);
if (strOrder == "")
strNextStOrder = "desc";
else
strNextStOrder = "";
if (Page.IsPostBack)
{
strDistrictUserID = CCLib.Common.Strings.GetQueryString("ID");
if (strDistrictUserID != "")
{
//CCLib.Common.DataAccess.ExecuteNonQuery("Delete from RRSUsers where DistrictUserID=" + strID);
//
this.strRegionID = AdminInfo["RegionID"].ToString();
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLDeleteRRSUsers(this.strDistrictUserID), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
this.objHistoryID = this.wsSLXIntegration.GetNewSLXID("History", this.strConnectionStringToSLX);
this.strHistoryID = objHistoryID != null ? objHistoryID.ToString() : null;
this.objContactID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectContactID(this.strDistrictUserID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
this.objAccountID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccountID(this.strRegionID), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccount(this.strRegionID), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? CCLib.Common.Strings.FormatUserInput(this.objAccount.ToString()) : null;
object objContactName = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectContactName(this.strContactID), this.strConnectionStringToSLX);
string strContactName = objContactName != null ? CCLib.Common.Strings.FormatUserInput(objContactName.ToString()) : null;
string strLogType = "262148"; //Type: 262148 -- "Note"
string strDescription = "RRS Account Deleted";
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLLogDeletion(strHistoryID, strContactID, strContactName, strLogType, strDescription, strAccountID, strAccount), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLDeleteRRSConRRSUsers(strDistrictUserID), this.strConnectionStringToSLX);
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
Response.Redirect("AccessAccounts.aspx");
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The RRS user has failed to delete. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The RRS user has failed to delete. Plesae try again."));
}
//
//Response.Redirect("AccessAccounts.aspx");
}
}
//generate values
#endregion Initialize Values and Form Execution
#region Properties For The Region Base Class
TitleBar = "Access Accounts";
SubTitleBar = PortTypeSettings["DistrictAdminName"].ToString();
#endregion Properties For The Region Base Class
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.ServerVariables["REQUEST_METHOD"] == "POST")
{
strPost = CCLib.Common.Strings.GetFormString("post");
if (strPost == "1" && Session["SchoolAdminInfo"] != null)
{
//For Web Services Model
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
wstest = new WSCCIntegrationWithSLX.IntegrationWithSLX();
System.Net.NetworkCredential userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
wstest.Credentials = userCredential;
wstest.PreAuthenticate = true;
DataRow drAdminInfo = (DataRow)Session["SchoolAdminInfo"];
if (drAdminInfo["IsCcSpark"].ToString() == "True" && drAdminInfo["LicenseType"].ToString() == "ccSpark only")
strDefaultHomepage = "/School/CCSparkHome.aspx";
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
this.connCC = new SqlConnection(strConnectionStringToCC);
this.strSchoolID = drAdminInfo["SchoolId"] != null ? drAdminInfo["SchoolId"].ToString() : null;
this.strPassword = drAdminInfo["AdminPassword"] != null ? drAdminInfo["AdminPassword"].ToString() : null;
this.objAdminID = SqlHelper.ExecuteScalar(this.strConnectionStringToCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strSchoolID, this.strPassword));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString().Replace("'", "''") : null;
if (this.connCC.State == ConnectionState.Closed)
{
this.connCC.Open();
}
this.tranConnCC = this.connCC.BeginTransaction();
this.intReturnValue1 = IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateAgreement(this.strSchoolID, this.strPassword), this.connCC, this.tranConnCC);
//this.intReturnValue1 = CCLib.Common.DataAccess.ExecuteDbWithIntResult(this.GetCCSQLUpdateAgreement(this.strSchoolID, this.strPassword));
if (this.intReturnValue1 > 0)
{
this.intReturnValue2 = this.wstest.ExecuteNoQuery(this.GetSLXSQLUpdateAgreement(strAdminID), this.strConnectionStringToSLX);
//this.intReturnValue2 = CCLib.Common.DataAccess.ExecuteDbWithIntResult(this.GetSLXSQLUpdateAgreement(strAdminID));
//this.intReturnValue2 = CCLib.Common.DataAccess.ExecuteNonQuery(this.GetSLXSQLUpdateAgreement(strAdminID));
if (this.intReturnValue2 > 0)
{
this.tranConnCC.Commit();
this.ReleaseDBObjects();
}
else
{
this.tranConnCC.Rollback();
this.ReleaseDBObjects();
Response.Redirect(strDefaultHomepage);
}
}
else
{
this.tranConnCC.Rollback();
this.ReleaseDBObjects();
Response.Redirect(strDefaultHomepage);
}
if ((bool)drAdminInfo["UseSSL"])
Response.Redirect("https://" + ConfigurationManager.AppSettings["strServerName"] + "/School/Home.aspx");
else
Response.Redirect(strDefaultHomepage);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckRegionAdminSession();
#endregion Check Login
this.strSchoolName = "";
this.strSchoolID = CCLib.Common.Strings.GetQueryString("ID");
if (this.strSchoolID != "")
{
DataTable dtSchoolInfo = CCLib.Common.DataAccess.GetDataTable("select institutionname, username, password from userinfo where schoolid=" + this.strSchoolID);
this.strSchoolName = dtSchoolInfo.Rows[0][0].ToString();
lblSchlUsername.Text = dtSchoolInfo.Rows[0]["Username"].ToString();
lblSchlPwd.Text = dtSchoolInfo.Rows[0]["Password"].ToString();
strCol = CCLib.Common.Strings.GetQueryString("col");
strOrder = CCLib.Common.Strings.GetQueryString("storder");
if (strCol == "")
strCol = "3";
this.strSQL = "select pa.firstname, pa.lastname,pa.AdminPassword,pas.securityname_en,pa.AdminId from portfolioadmin as pa inner join portfolioadminsecurity as pas on pa.securitylevel=pas.securitylevel and pas.PortTypeID=" + PortTypeID + " where pa.schoolid=" + this.strSchoolID + " order by " + strCol + " " + strOrder;
this.dtSchoolAdmin = CCLib.Common.DataAccess.GetDataTable(this.strSQL);
rptDetails.DataSource = this.dtSchoolAdmin;
rptDetails.DataBind();
if (strOrder == "")
strNextStOrder = "desc";
else
strNextStOrder = "";
this.strAdminID = CCLib.Common.Strings.GetQueryString("aID");
}
if ((this.strAdminID != "") & (this.strSchoolID != ""))
{
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLDeleteAdminPassword(this.strAdminID), this.cnnCC, this.trsCC);
this.intReturnValue2 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLDeleteAdvisorAssignments(this.strAdminID), this.cnnCC, this.trsCC);
if ((this.intReturnValue1 > 0) & (this.intReturnValue2 > 0))
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
object objHistoryID = this.wsSLXIntegration.GetNewSLXID("History", this.strConnectionStringToSLX);
string strHistoryID = objHistoryID != null ? objHistoryID.ToString() : null;
this.objContactID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectContactID(this.strAdminID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
this.objAccountID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccountID(this.strSchoolID), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccount(this.strSchoolID), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? this.objAccount.ToString().Replace("'", "''") : null;
object objContactName = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectContactName(this.strContactID), this.strConnectionStringToSLX);
string strContactName = objContactName != null ? objContactName.ToString().Replace("'", "''") : null;
string strLogType = "262148"; //Type: 262148 -- "Note"
string strDescription = "Admin password deleted";
DataRow drRegionAdminInfo = (DataRow)Session["RegionAdminInfo"];
string strloggedInUsername = drRegionAdminInfo["FirstName"].ToString() + " " + drRegionAdminInfo["LastName"].ToString();
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLLogDeletion(strHistoryID, strContactID, strContactName, strLogType, strDescription, strAccountID, strAccount, strloggedInUsername), this.strConnectionStringToSLX);
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLDeleteAdminPassword(strAdminID), this.strConnectionStringToSLX);
}
if ((this.intReturnValue3 > 0) & (this.intReturnValue4 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
TrackChanges();
Response.Redirect("SchoolAdminDetails.aspx?ID=" + this.strSchoolID);
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The advisor has failed to delete. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The advisor has failed to delete. Plesae try again."));
}
}
#region Properties For The Region Base Class
TitleBar = "Manage Accounts";
SubTitleBar = PortTypeSettings["SchoolAdminName"].ToString();
#endregion Properties For The Region Base Class
}
private void ReleaseObjects()
{
this.trsCC = null;
if (this.cnnCC.State == ConnectionState.Open)
{
this.cnnCC.Close();
}
//this.cnnCC = null;
this.userCredential = null;
this.wsSLXIntegration = null;
this.objContactID = null;
this.dtAdmin = null;
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckStateAdminSession();
#endregion Check Login
strRegionID = CCLib.Common.Strings.GetQueryString("rid");
strSchoolID = CCLib.Common.Strings.GetQueryString("sid");
strAdminID = CCLib.Common.Strings.GetQueryString("aid");
strType = CCLib.Common.Strings.GetFormString("Type");
strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (Page.IsPostBack)
{
if (strType == "Edit")
{
strPwd = CCLib.Common.Strings.GetFormString("pwd").Replace("'", "''");
if (this.CheckForPwdConflict(this.strPwd, this.strAdminID, this.strSchoolID))
{
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The advisor could not be updated due to a password conflict, please change the password and try again."));
this.InitializeValues();
this.ReleaseObjects();
}
else
{
this.strFname = CareerCruisingWeb.CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("fname")));
this.strLname = CareerCruisingWeb.CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("lname")));
this.strEmail = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("email"));
this.strDisplayName = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("DisplayName"));
this.strSecurityLevel = CCLib.Common.Strings.GetFormString("drpSecurityLevel");
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
if (this.cnnCC.State == ConnectionState.Closed)
this.cnnCC.Open();
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateAdminPassword(this.strFname, this.strLname, this.strEmail, this.strPwd, this.strSecurityLevel, this.strAdminID), this.cnnCC, this.trsCC);
this.intReturnValue6 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateAdminName(this.strFname, this.strLname, this.strAdminID, this.strDisplayName), this.cnnCC, this.trsCC);
if ((this.intReturnValue1 > 0)&(this.intReturnValue6>0))
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
this.strLicenseType = CCLib.Common.DataAccess.GetValue("select LicenseType from userinfo where schoolID=" + strSchoolID).ToString();
this.strSecurityLevelText = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.GetSecurityLevelText(strSecurityLevel, true, strLicenseType);
this.objContactID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectContactID(strAdminID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
if (this.wsSLXIntegration.CheckExists(this.GetSLXSQLEmailExists(strEmail, this.strContactID), this.strConnectionStringToSLX, true))
{
this.strEmail = null;
}
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateContact(this.strFname, this.strLname, this.strEmail, this.strContactID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateAdminPassword(this.strPwd, this.strSecurityLevel, this.strSecurityLevelText, this.strAdminID), this.strConnectionStringToSLX);
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
TrackChanges();
Response.Redirect("AccountsDistrictSchoolAdvisorList.aspx?rid=" + strRegionID + "&sid=" + strSchoolID);
}
else
{
this.trsCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The advisor has failed to update. Plesae try again."));
this.InitializeValues();
this.ReleaseObjects();
}
}
else
{
this.trsCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The advisor has failed to update. Plesae try again."));
this.InitializeValues();
this.ReleaseObjects();
}
}
}
}
else
{
this.InitializeValues();
this.ReleaseObjects();
}
#region Properties For The Region Base Class
TitleBar = "Manage Accounts";
SubTitleBar = GetPortText(9308, false) + " Accounts";
#endregion Properties For The Region Base Class
}
private void ReleaseObjects()
{
this.trsCC = null;
if (this.cnnCC.State == ConnectionState.Open)
{
this.cnnCC.Close();
}
//this.cnnCC = null;
this.userCredential = null;
this.wsSLXIntegration = null;
this.objContactID = null;
this.objAccountID = null;
this.objAccount = null;
this.objAddressID = null;
this.objLicenseType = null;
}
protected void Page_Load(object sender, EventArgs e)
{
strGUID = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("guid") : CCLib.Common.Strings.GetQueryString("guid");
strReturnUrl = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("returnurl") : CCLib.Common.Strings.GetQueryString("returnurl");
strTargetUrl = (Request.ServerVariables["REQUEST_METHOD"] == "POST") ? CCLib.Common.Strings.GetFormString("targeturl") : CCLib.Common.Strings.GetQueryString("targeturl");
strTargetUrl = (strTargetUrl == "") ? "/Individual/Home.aspx" : strTargetUrl;
DataTable dtbAdminInfo = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("select p.*,u.Username as SchoolUserName,u.Password as SchoolPassword,u.PortTypeID from Port_Admin_FFA p inner join Userinfo u on p.schoolid=u.schoolid where SecureUniqueID='" + strGUID + "'");
if (dtbAdminInfo.Rows.Count == 0)//invalid GUID
Response.Redirect("/Default.aspx");
else if (dtbAdminInfo.Rows.Count != 0 && dtbAdminInfo.Rows[0]["AdminID"].ToString() != "")//redirect associated admin user
{
AutoLoginUser(dtbAdminInfo.Rows[0]["AdminID"].ToString());
}
else//admin user not associated yet, create one
{
strPassword = RandomString().Substring(10, 10);
while (CheckForPwdConflict(strPassword, dtbAdminInfo.Rows[0]["SchoolID"].ToString()))
strPassword = RandomString().Substring(10, 10);
if (dtbAdminInfo.Rows[0]["IsNetworkCDOContact"].ToString() == "True")
intIsNetworkCDOContact = 1;
#region SLX
this.strSchoolID = dtbAdminInfo.Rows[0]["SchoolID"].ToString();
this.strSLXEmail = CCLib.Common.Strings.FormatUserInput(dtbAdminInfo.Rows[0]["EmailAddress"].ToString());
this.strEmail = CCLib.Common.Strings.FormatUserInput(dtbAdminInfo.Rows[0]["EmailAddress"].ToString());
this.strFname = CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(dtbAdminInfo.Rows[0]["FirstName"].ToString()));
this.strLname = CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(dtbAdminInfo.Rows[0]["LastName"].ToString()));
this.strDisplayName = this.strFname+" "+this.strLname;
this.strType = "Add";
this.strSecurityLevel = "400";
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
this.strPwd = strPassword;
this.strLicenseType = CCLib.Common.DataAccess.GetValue("select LicenseType from userinfo where schoolID=" + this.strSchoolID).ToString();
this.strSecurityLevelText = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.GetSecurityLevelText(this.strSecurityLevel, true, this.strLicenseType);
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
if ((this.wsSLXIntegration.GetRecordCount(this.GetSLXSQLContactExists(this.strFname, this.strLname, this.strSchoolID), this.strConnectionStringToSLX, true) == 1) & (!CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.CheckExists(this.GetCCSQLAdminIDExists(this.strFname, this.strLname, this.strSchoolID), this.strConnectionStringToCC)))
{
this.objContactID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLContactExists(this.strFname, this.strLname, this.strSchoolID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
if (this.wsSLXIntegration.CheckExists(this.GetSLXSQLEmailExists(strEmail, strContactID), this.strConnectionStringToSLX, true))
{
this.strSLXEmail = null;
}
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminPassword(this.strPwd, this.strFname, this.strLname, this.strEmail, this.strSecurityLevel, this.strSchoolID,this.intIsNetworkCDOContact), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue6 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminName(this.strFname, this.strLname, this.strSchoolID, this.strDisplayName) + ";update Port_Admin_FFA set AdminID=" + this.strAdminID + " where SecureUniqueID='" + strGUID + "'", this.cnnCC, this.trsCC);
}
if ((this.intReturnValue1 > 0) & (this.intReturnValue6 > 0))
{
this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateContactEmail(this.strContactID, strEmail), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAdminPassword(this.strContactID, this.strPwd, this.strSecurityLevel, this.strAdminID, this.strSecurityLevelText), this.strConnectionStringToSLX);
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
TrackChanges(strAdminID);
if (CCLib.Common.Strings.GetFormString("chkEmail").ToString() == "on")
SendEmailToNewAdvisor(strFname, strEmail, strSchoolID);
AutoLoginUser(this.strAdminID);
//Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has been added."));
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
this.Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
if (this.wsSLXIntegration.CheckExists(this.GetSLXSQLEmailExists(strSLXEmail), this.strConnectionStringToSLX, true))
{
this.strSLXEmail = null;
}
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminPassword(this.strPwd, this.strFname, this.strLname, this.strEmail, this.strSecurityLevel, this.strSchoolID,this.intIsNetworkCDOContact), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue6 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminName(this.strFname, this.strLname, this.strSchoolID, this.strDisplayName) + ";update Port_Admin_FFA set AdminID=" + this.strAdminID + " where SecureUniqueID='" + strGUID + "'", this.cnnCC, this.trsCC);
}
if ((this.intReturnValue1 > 0) & (this.intReturnValue6 > 0))
{
this.objContactID = this.wsSLXIntegration.GetNewSLXID("Contact", this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
this.strSecCodeID = "SYST00000001";
if ((this.strLicenseType == "Licensed") | (this.strLicenseType == "Ontario") | (this.strLicenseType == "Kentucky"))
{
this.booIsLOK = true;
}
else
{
this.booIsLOK = false;
}
this.objAccountID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccountID(this.strSchoolID), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccount(this.strSchoolID), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? CCLib.Common.Strings.FormatUserInput(this.objAccount.ToString()) : null;
this.objAddressID = this.wsSLXIntegration.GetNewSLXID("Address", this.strConnectionStringToSLX);
this.strAddressID = this.objAddressID != null ? this.objAddressID.ToString() : null;
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertContact(this.strContactID, this.strAccountID, this.strAccount, this.strFname, this.strLname, this.strSLXEmail, this.strSecCodeID, this.strAddressID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLSetReceiveNewsLetter(this.strContactID, booIsLOK), this.strConnectionStringToSLX);
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAddress(this.strAddressID, this.strContactID), this.strConnectionStringToSLX);
if (this.intReturnValue4 > 0)
{
this.intReturnValue5 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAdminPassword(this.strContactID, this.strPwd, this.strSecurityLevel, this.strAdminID, this.strSecurityLevelText), this.strConnectionStringToSLX);
}
}
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0) & (this.intReturnValue4 > 0) & (this.intReturnValue5 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
TrackChanges(strAdminID);
if (CCLib.Common.Strings.GetFormString("chkEmail").ToString() == "on")
SendEmailToNewAdvisor(strFname, strEmail, strSchoolID);
AutoLoginUser(this.strAdminID);
//Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has been added."));
//Response.Redirect("schooladmindetails.aspx?ID=" + strSchoolID);
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
#endregion SLX
}//form post
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckRegionAdminSession();
#endregion Check Login
this.strSchoolID = CCLib.Common.Strings.GetFormString("drpSchool");
if(this.strSchoolID=="")
this.strSchoolID = CCLib.Common.Strings.GetQueryString("sID");
GetRegionSchoolList(this.drpSchool);
if (this.strSchoolID != "")
{
if (this.drpSchool.Items.FindByValue(strSchoolID).ToString() != "")
{
ListItem lst1 = this.drpSchool.Items.FindByValue(strSchoolID);
lst1.Selected = true;
}
}
this.strSLXEmail = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("email").ToString());
this.strEmail = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("email").ToString());
this.strFname = CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("fname").ToString()));
this.strLname = CCLib.Common.Strings.ConvertStringToTitleCase(CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("lname").ToString()));
this.strDisplayName = CCLib.Common.Strings.FormatUserInput(CCLib.Common.Strings.GetFormString("DisplayName"));
this.strType = CCLib.Common.Strings.GetFormString("Type");
this.strSecurityLevel = CCLib.Common.Strings.GetFormString("drpSecurityLevel");
GetAdminSecurityList(this.drpSecurityLevel);
if (Page.IsPostBack)
{
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (this.strType == "Add")
{
this.strPwd = CCLib.Common.Strings.GetFormString("pwd").Replace("'", "''");
if (this.CheckForPwdConflict(this.strPwd, this.strSchoolID))
{
Response.Write(CCLib.Common.Forms.JavaScriptNotify("An administrator already exists with that password. Please choose a different password."));
this.ReleaseObjects();
}
else
{
if (this.strSchoolID != "")
{
if (this.drpSchool.Items.FindByValue(strSchoolID).ToString() != "")
{
ListItem lst1 = this.drpSchool.Items.FindByValue(strSchoolID);
lst1.Selected = true;
}
}
this.strLicenseType = CCLib.Common.DataAccess.GetValue("select LicenseType from userinfo where schoolID=" + this.strSchoolID).ToString();
this.strSecurityLevelText = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.GetSecurityLevelText(this.strSecurityLevel, true, this.strLicenseType);
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
if ((this.wsSLXIntegration.GetRecordCount(this.GetSLXSQLContactExists(this.strFname, this.strLname, this.strSchoolID), this.strConnectionStringToSLX, true) == 1) & (!CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.CheckExists(this.GetCCSQLAdminIDExists(this.strFname, this.strLname, this.strSchoolID), this.strConnectionStringToCC)))
{
this.objContactID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLContactExists(this.strFname, this.strLname, this.strSchoolID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
if (this.wsSLXIntegration.CheckExists(this.GetSLXSQLEmailExists(strEmail, strContactID), this.strConnectionStringToSLX, true))
{
this.strSLXEmail = null;
}
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminPassword(this.strPwd, this.strFname, this.strLname, this.strEmail, this.strSecurityLevel, this.strSchoolID), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue6 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminName(this.strFname, this.strLname, this.strSchoolID, this.strDisplayName), this.cnnCC, this.trsCC);
}
if ((this.intReturnValue1 > 0) & (this.intReturnValue6 > 0))
{
this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateContactEmail(this.strContactID, strEmail), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAdminPassword(this.strContactID, this.strPwd, this.strSecurityLevel, this.strAdminID, this.strSecurityLevelText), this.strConnectionStringToSLX);
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
TrackChanges();
if (CCLib.Common.Strings.GetFormString("chkEmail").ToString() == "on")
SendEmailToNewAdvisor(strFname, strEmail, strSchoolID);
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has been added."));
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
this.Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
if (this.wsSLXIntegration.CheckExists(this.GetSLXSQLEmailExists(strSLXEmail), this.strConnectionStringToSLX, true))
{
this.strSLXEmail = null;
}
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminPassword(this.strPwd, this.strFname, this.strLname, this.strEmail, this.strSecurityLevel, this.strSchoolID), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.intReturnValue6 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertAdminName(this.strFname, this.strLname, this.strSchoolID, this.strDisplayName), this.cnnCC, this.trsCC);
}
if ((this.intReturnValue1 > 0) & (this.intReturnValue6 > 0))
{
this.objContactID = this.wsSLXIntegration.GetNewSLXID("Contact", this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
//this.objAdminID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectAdminID(this.strPwd, this.strSchoolID));
//this.strAdminID = this.objAdminID != null ? this.objAdminID.ToString() : null;
this.strSecCodeID = "SYST00000001";
//if ((this.strLicenseType == "Licensed") | (this.strLicenseType == "Ontario") | (this.strLicenseType == "Kentucky"))
//{
this.booIsLOK = true;
//}
//else
//{
// this.booIsLOK = false;
//}
this.objAccountID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccountID(this.strSchoolID), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccount(this.strSchoolID), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? CCLib.Common.Strings.FormatUserInput(this.objAccount.ToString()) : null;
this.objAddressID = this.wsSLXIntegration.GetNewSLXID("Address", this.strConnectionStringToSLX);
this.strAddressID = this.objAddressID != null ? this.objAddressID.ToString() : null;
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertContact(this.strContactID, this.strAccountID, this.strAccount, this.strFname, this.strLname, this.strSLXEmail, this.strSecCodeID, this.strAddressID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLSetReceiveNewsLetter(this.strContactID, booIsLOK), this.strConnectionStringToSLX);
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAddress(this.strAddressID, this.strContactID), this.strConnectionStringToSLX);
if (this.intReturnValue4 > 0)
{
this.intReturnValue5 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAdminPassword(this.strContactID, this.strPwd, this.strSecurityLevel, this.strAdminID, this.strSecurityLevelText), this.strConnectionStringToSLX);
}
}
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0) & (this.intReturnValue4 > 0) & (this.intReturnValue5 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
TrackChanges();
if (CCLib.Common.Strings.GetFormString("chkEmail").ToString() == "on")
SendEmailToNewAdvisor(strFname, strEmail, strSchoolID);
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has been added."));
//Response.Redirect("schooladmindetails.aspx?ID=" + strSchoolID);
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
}
}
}
#region Properties For The Region Base Class
TitleBar = "Manage Accounts";
SubTitleBar = "School Administration System";
#endregion Properties For The Region Base Class
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string strEmail;
string strConnectionStringToSLX;
string strConnectionStringToCC;
object objContactID;
string strContactID;
int intReturnValue1;
int intReturnValue2;
SqlTransaction tranConnCC;
SqlConnection connCC;
WSCCIntegrationWithSLX.IntegrationWithSLX wstest;
strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
wstest = new WSCCIntegrationWithSLX.IntegrationWithSLX();
System.Net.NetworkCredential userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
wstest.Credentials = userCredential;
wstest.PreAuthenticate = true;
connCC = new SqlConnection(strConnectionStringToCC);
objContactID = wstest.GetValueFromSLX(GetSLXSQLSelectContactID(AdminInfo["AdminID"].ToString()), strConnectionStringToSLX);
strContactID = objContactID != null ? objContactID.ToString() : null;
strEmail = txtEmail.Value;
if (wstest.CheckExists(GetSLXSQLEmailExists(strEmail, strContactID), strConnectionStringToSLX, true))
{
strEmail = null;
}
if (connCC.State == ConnectionState.Closed)
{
connCC.Open();
}
tranConnCC = connCC.BeginTransaction();
intReturnValue1 = IntegrationWithSLX.ExecuteNoQuery("UPDATE PortfolioAdmin SET Email='" + txtEmail.Value + "' WHERE AdminID=" + AdminInfo["AdminID"].ToString(), connCC, tranConnCC);
if (intReturnValue1 > 0)
{
intReturnValue2 = wstest.ExecuteNoQuery("UPDATE CONTACT SET EMAIL ='" + strEmail + "' WHERE CONTACTID ='" + strContactID + "'", strConnectionStringToSLX);
if (intReturnValue2 > 0)
{
tranConnCC.Commit();
}
else
{
tranConnCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8250)));
}
}
else
{
tranConnCC.Rollback();
Response.Write(CCLib.Common.Forms.JavaScriptNotify(TextCode(8250)));
}
//CCLib.Common.DataAccess.ExecuteNonQuery("UPDATE PortfolioAdmin SET Email='" + txtEmail.Value + "' WHERE AdminID=" + AdminInfo["AdminID"].ToString());
divEmail.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
#region Check Login
CheckStateAdminSession();
#endregion Check Login
#region Initialize Values and Form Execution
divAdd.Visible = false;
divEdit.Visible = false;
strRegionID = CCLib.Common.Strings.GetQueryString("rid");
strRegionName = CCLib.Common.DataAccess.GetValue("select RegionName from RRSRegions where RegionID = '" + strRegionID + "'").ToString();
if (Page.IsPostBack)
{
strType = CCLib.Common.Strings.GetFormString("Type");
this.strConnectionStringToSLX = WebConfigurationManager.AppSettings["strConSLX"];
this.strConnectionStringToCC = WebConfigurationManager.AppSettings["strConLocal"];
if (strType == "Add")
{
if (this.CheckForPwdConflict(CCLib.Common.Strings.FormatUserInput(this.txtPwd.Value), this.strRegionID))
{
divAdd.Visible = true;
Response.Write(CCLib.Common.Forms.JavaScriptNotify("A RRS user already exists with that password. Please choose a different password."));
}
else
{
this.strFirstName = CCLib.Common.Strings.FormatUserInput(this.txtFirstName.Value);
this.strLastName = CCLib.Common.Strings.FormatUserInput(this.txtLastName.Value);
this.strEmail = CCLib.Common.Strings.FormatUserInput(this.txtEmail.Value);
this.strPassword = CCLib.Common.Strings.FormatUserInput(this.txtPwd.Value);
this.strSecurityLevel = this.selectLevel.Value;
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLInsertRRSUsers(this.strPassword, this.strFirstName,this.strLastName, this.strEmail, this.strSecurityLevel, this.strRegionID),this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.strSecCodeID = "SYST00000001";
this.strSecurityText = this.GetSecurityText(this.strSecurityLevel);
this.strContactName = this.strFirstName + " " + this.strLastName;
this.strLogType = "262148"; //Type: 262148 -- "Note"
this.strDescription = "RRS Account Added";
this.strNote = CreateNoteForAddNew(this.strFirstName, this.strLastName, this.strEmail, this.strSecurityText, this.strPassword);
this.objDistrictUserID = SqlHelper.ExecuteScalar(this.trsCC, CommandType.Text, this.GetCCSQLSelectDistrictUserID(this.strPassword, this.strRegionID));
this.strDistrictUserID = this.objDistrictUserID != null ? this.objDistrictUserID.ToString() : null;
this.objContactID = this.wsSLXIntegration.GetNewSLXID("Contact", this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
this.objAccountID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccountID(this.strRegionID), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objLicenseType = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectLicenseType(this.strAccountID), this.strConnectionStringToSLX);
this.strLicenseType = this.objLicenseType != null ? this.objLicenseType.ToString() : "";
if ((this.strLicenseType == "Licensed") | (this.strLicenseType == "Ontario") | (this.strLicenseType == "Kentucky"))
{
this.booIsLOK = true;
}
else
{
this.booIsLOK = false;
}
this.objAccount = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccount(this.strRegionID), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? CCLib.Common.Strings.FormatUserInput(this.objAccount.ToString()) : null;
this.objAddressID = this.wsSLXIntegration.GetNewSLXID("Address", this.strConnectionStringToSLX);this.strAddressID = this.objAddressID != null ? this.objAddressID.ToString() : null;
this.strAddressID = this.objAddressID != null ? this.objAddressID.ToString() : null;
this.objHistoryID = this.wsSLXIntegration.GetNewSLXID("History", this.strConnectionStringToSLX);
this.strHistoryID = this.objHistoryID != null ? this.objHistoryID.ToString() : null;
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertContact(this.strContactID, this.strAccountID, this.strAccount, this.strFirstName, this.strLastName, this.strSecCodeID, this.strAddressID), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLSetReceiveNewsLetter(this.strContactID, booIsLOK), this.strConnectionStringToSLX);
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertAddress(this.strAddressID, this.strContactID), this.strConnectionStringToSLX);
if (this.intReturnValue4 > 0)
{
this.intReturnValue5 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLLogHistory(this.strHistoryID, this.strContactID, this.strContactName, this.strLogType,this.strDescription, this.strAccountID, this.strAccount, this.strNote),this.strConnectionStringToSLX);
if (this.intReturnValue5 > 0)
{
this.intReturnValue6 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLInsertConRRSUsers(this.strContactID, this.strPassword, this.strSecurityLevel,this.strSecurityText, this.strEmail, this.strDistrictUserID),this.strConnectionStringToSLX);
}
}
}
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0) & (this.intReturnValue4 > 0) & (this.intReturnValue5 > 0) & (this.intReturnValue6 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
Page.ClientScript.RegisterStartupScript(typeof(string), "alertScript", "alert('The new advisor has been added.');window.open('AccountsDistrictAdvisorList.aspx?rid=" + strRegionID + "','_parent')", true);
}
else
{
this.trsCC.Rollback();
divAdd.Visible = true;
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
divAdd.Visible = true;
this.ReleaseObjects();
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The new advisor has failed to add. Plesae try again."));
}
}
}
if (strType == "Edit")
{
this.strPassword = CCLib.Common.Strings.FormatUserInput(this.txtPwdE.Value);
this.strID = CCLib.Common.Strings.GetFormString("ID");
if (this.CheckForPwdConflict(this.strPassword, this.strRegionID, this.strID))
{
divEdit.Visible = true;
Response.Write(CCLib.Common.Forms.JavaScriptNotify("A RRS user already exists with that password. Please choose a different password."));
}
else
{
this.booIfEdit = false;
this.strNote = "";
this.strID = CCLib.Common.Strings.GetFormString("ID");
this.dtOriginalAdmin = CCLib.Common.DataAccess.GetDataTable(this.GetCCSQLSelectRRSUsers(this.strID));
if (this.txtFirstNameE.Value.Trim() != this.dtOriginalAdmin.Rows[0]["FirstName"].ToString())
{
this.booIfEdit = true;
this.strNote = this.strNote + this.dtOriginalAdmin.Rows[0]["FirstName"].ToString() + " changed to " + this.txtFirstNameE.Value.ToString().Trim() + " -- ";
}
if (this.txtLastNameE.Value.Trim() != this.dtOriginalAdmin.Rows[0]["LastName"].ToString())
{
this.booIfEdit = true;
this.strNote = this.strNote + this.dtOriginalAdmin.Rows[0]["LastName"].ToString() + " changed to " + this.txtLastNameE.Value.ToString().Trim() + " -- ";
}
if (this.txtEmailE.Value.Trim() != this.dtOriginalAdmin.Rows[0]["EmailAddress"].ToString())
{
this.booIfEdit = true;
this.strNote = this.strNote + this.dtOriginalAdmin.Rows[0]["EmailAddress"].ToString() + " changed to " + this.txtEmailE.Value.ToString().Trim() + " -- ";
}
if (this.selectLevelE.Value != this.dtOriginalAdmin.Rows[0]["SecurityLevel"].ToString())
{
this.booIfEdit = true;
this.strNote = this.strNote + this.GetSecurityText(this.dtOriginalAdmin.Rows[0]["SecurityLevel"].ToString()) + " changed to " + this.GetSecurityText(this.selectLevelE.Value.ToString()) + " -- ";
}
if (this.txtPwdE.Value.Trim() != this.dtOriginalAdmin.Rows[0]["Password"].ToString())
{
this.booIfEdit = true;
this.strNote = this.strNote + this.dtOriginalAdmin.Rows[0]["Password"].ToString() + " changed to " + this.txtPwdE.Value.ToString() + " -- ";
}
if (this.booIfEdit)
{
this.strFirstName = CCLib.Common.Strings.FormatUserInput(this.txtFirstNameE.Value);
this.strLastName = CCLib.Common.Strings.FormatUserInput(this.txtLastNameE.Value);
this.strEmail = CCLib.Common.Strings.FormatUserInput(this.txtEmailE.Value);
this.strSecurityLevel = this.selectLevelE.Value;
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Ssl3;
System.Net.ServicePointManager.CertificatePolicy = new CareerCruisingWeb.CCLib.SLXIntegration.TrustAllCertificatePolicy();
this.wsSLXIntegration = new WSCCIntegrationWithSLX.IntegrationWithSLX();
this.userCredential = new System.Net.NetworkCredential("WSCCTOSLX", "Next_20");
this.wsSLXIntegration.Credentials = userCredential;
this.wsSLXIntegration.PreAuthenticate = true;
this.cnnCC = new SqlConnection(this.strConnectionStringToCC);
if (this.cnnCC.State == ConnectionState.Closed)
{
this.cnnCC.Open();
}
this.trsCC = this.cnnCC.BeginTransaction();
this.intReturnValue1 = CareerCruisingWeb.CCLib.SLXIntegration.IntegrationWithSLX.ExecuteNoQuery(this.GetCCSQLUpdateRRSUsers(this.strFirstName, this.strLastName, this.strEmail, this.strPassword, this.strSecurityLevel, this.strID), this.cnnCC, this.trsCC);
if (this.intReturnValue1 > 0)
{
this.objHistoryID = this.wsSLXIntegration.GetNewSLXID("History", this.strConnectionStringToSLX);
this.strHistoryID = this.objHistoryID != null ? this.objHistoryID.ToString() : null;
this.objContactID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectContactID(this.strID), this.strConnectionStringToSLX);
this.strContactID = this.objContactID != null ? this.objContactID.ToString() : null;
this.objAccountID = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccountID(this.strRegionID), this.strConnectionStringToSLX);
this.strAccountID = this.objAccountID != null ? this.objAccountID.ToString() : null;
this.objAccount = this.wsSLXIntegration.GetValueFromSLX(this.GetSLXSQLSelectAccount(this.strRegionID), this.strConnectionStringToSLX);
this.strAccount = this.objAccount != null ? CCLib.Common.Strings.FormatUserInput(this.objAccount.ToString()) : null;
this.strContactName = this.strFirstName + " " + this.strLastName;
this.strLogType = "262148"; //Type: 262148 -- "Note"
this.strDescription = "RRS Account Updated";
this.intReturnValue2 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLLogHistory(this.strHistoryID, this.strContactID, this.strContactName, this.strLogType, this.strDescription, this.strAccountID, this.strAccount, this.strNote), this.strConnectionStringToSLX);
if (this.intReturnValue2 > 0)
{
this.intReturnValue3 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateContact(this.strFirstName, this.strLastName, this.strContactID), this.strConnectionStringToSLX);
}
if (this.intReturnValue3 > 0)
{
this.intReturnValue4 = this.wsSLXIntegration.ExecuteNoQuery(this.GetSLXSQLUpdateConRRSUsers(this.strPassword, this.strSecurityLevel, this.GetSecurityText(this.strSecurityLevel), this.strEmail, this.strID), this.strConnectionStringToSLX);
}
if ((this.intReturnValue2 > 0) & (this.intReturnValue3 > 0) & (this.intReturnValue4 > 0))
{
this.trsCC.Commit();
this.ReleaseObjects();
Response.Redirect("AccountsDistrictAdvisorList.aspx?rid=" + strRegionID);
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
divEdit.Visible = true;
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The RRS user has failed to update. Plesae try again."));
}
}
else
{
this.trsCC.Rollback();
this.ReleaseObjects();
divEdit.Visible = true;
Response.Write(CCLib.Common.Forms.JavaScriptNotify("The RRS user has failed to update. Plesae try again."));
}
}
}
}
}
else
{
strType = CCLib.Common.Strings.GetQueryString("Type");
strID = CCLib.Common.Strings.GetQueryString("ID");
if (strType == "Add")
divAdd.Visible = true;
if (strType == "Edit")
{
divEdit.Visible = true;
strSQL = "select U.RegionID,U.FirstName,U.LastName,U.EmailAddress,U.Password,U.SecurityLevel ";
strSQL += " from RRSUsers as U join RRSRegions as R on U.RegionID = R.RegionID where U.DistrictUserID = " + strID;
dtAdmin = CCLib.Common.DataAccess.GetDataTable(strSQL);
txtFirstNameE.Value = dtAdmin.Rows[0]["FirstName"].ToString();
txtLastNameE.Value = dtAdmin.Rows[0]["Lastname"].ToString();
txtEmailE.Value = dtAdmin.Rows[0]["EmailAddress"].ToString();
txtPwdE.Value = dtAdmin.Rows[0]["Password"].ToString();
if (dtAdmin.Rows[0]["SecurityLevel"].ToString() == "100")
selectLevelE.SelectedIndex = 0;
else
selectLevelE.SelectedIndex = 1;
}
}
#endregion Initialize Values and Form Execution
#region Properties For The State Base Class
TitleBar = "Manage Accounts";
SubTitleBar = GetPortText(9309, false) + " Accounts";
#endregion Properties For The State Base Class
}
