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