private bool completeRegistration(string id) { try { mEncryption tEncrypt = new mEncryption(); byte[] arID = Convert.FromBase64String(id); string memberID = tEncrypt.tdesDecrypt(arID); if (activatetNewUserID(Convert.ToInt32(memberID))) { return(true); } else { return(false); } } catch (Exception ex) { lbInfo.Text = ex.Message; return(false); } }
public bool insertConsultationInfo() { bool success = false; // initialize ADO objects SqlConnection dataConn = null; SqlDataReader dbReader = null; SqlCommand dataCmd = null; SqlTransaction trans = null; try { mEncryption tEncrypt = new mEncryption(); // set connection attributes and open data connection dataConn = new SqlConnection(mMain.sDataPath); dataConn.Open(); trans = dataConn.BeginTransaction(); // set command object attributes dataCmd = new SqlCommand("usp_InsertchaConsultationInfo", dataConn, trans); dataCmd.CommandType = CommandType.StoredProcedure; // declare and instantiate parameters collection dataCmd.Parameters.AddWithValue("@FullName", txtUserName.Text.Trim()); dataCmd.Parameters.AddWithValue("@Email", txtEmail.Text.Trim()); dataCmd.Parameters.AddWithValue("@PhoneNumber", txtPhoneNumber.Text.Trim()); dataCmd.Parameters.AddWithValue("@City", txtCity.Text.Trim()); dataCmd.Parameters.AddWithValue("@State", cboState.SelectedItem.Text.Trim()); dataCmd.Parameters.AddWithValue("@HelpMessage", txtArea.Text.Trim()); dataCmd.Parameters.AddWithValue("@SubscribeNewsletter", chbxSubscribe.Checked ? 1 : 0); dataCmd.Parameters.Add("@confirmation", SqlDbType.Int).Direction = ParameterDirection.Output; // execute command var result = dataCmd.ExecuteNonQuery(); // test return value and transfer control as necessary if (result == 1) { success = true; trans.Commit(); } else { trans.Rollback(); throw new Exception("Error Submitting Credit Card Information"); } // end if } //end try catch (SqlException sqle) { trans.Rollback(); throw new Exception("SqlException: " + sqle.Message); } //end catch catch (Exception z) { trans.Rollback(); throw new Exception("Generic Exception: " + z.Message); } //end catch finally { // clean up if (dbReader != null) { dbReader.Close(); } // end if dataConn.Close(); dataConn.Dispose(); dataCmd.Dispose(); } // end finally return(success); }