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