<%@ include file="../../lib/html/defaultHeader.jsp" %> <% // Ggf. Werte in der Datenbank speichern String action = (request.getParameter("action")!=null && !request.getParameter("action").equals("")?request.getParameter("action"):"Nothing"); // Benutzerdaten neu abspeichern String anrede = (request.getParameter("anrede")!=null && !request.getParameter("anrede").equals("")?request.getParameter("anrede"):""); String kundennr = (request.getParameter("kundennr")!=null && !request.getParameter("kundennr").equals("")?request.getParameter("kundennr"):""); String firma = (request.getParameter("firma")!=null && !request.getParameter("firma").equals("")?request.getParameter("firma"):""); String abteilung = (request.getParameter("abteilung")!=null && !request.getParameter("abteilung").equals("")?request.getParameter("abteilung"):""); String vorname = (request.getParameter("vorname")!=null && !request.getParameter("vorname").equals("")?request.getParameter("vorname"):""); String nachname = (request.getParameter("nachname")!=null && !request.getParameter("nachname").equals("")?request.getParameter("nachname"):""); String strasse = (request.getParameter("strasse")!=null && !request.getParameter("strasse").equals("")?request.getParameter("strasse"):""); String branche = (request.getParameter("branche")!=null && !request.getParameter("branche").equals("")?request.getParameter("branche"):""); String plz = (request.getParameter("plz")!=null && !request.getParameter("plz").equals("")?request.getParameter("plz"):""); String ort = (request.getParameter("ort")!=null && !request.getParameter("ort").equals("")?request.getParameter("ort"):""); String telefon = (request.getParameter("telefon")!=null && !request.getParameter("telefon").equals("")?request.getParameter("telefon"):""); String telefax = (request.getParameter("telefax")!=null && !request.getParameter("telefax").equals("")?request.getParameter("telefax"):""); String land = (request.getParameter("land")!=null && !request.getParameter("land").equals("")?request.getParameter("land"):""); String ustid = (request.getParameter("ustid")!=null && !request.getParameter("ustid").equals("")?request.getParameter("ustid"):""); String email = (request.getParameter("email")!=null && !request.getParameter("email").equals("")?request.getParameter("email"):""); String passwd = (request.getParameter("passwd")!=null && !request.getParameter("passwd").equals("")?request.getParameter("passwd"):""); String frage = (request.getParameter("frage")!=null && !request.getParameter("frage").equals("")?request.getParameter("frage"):""); String antwort = (request.getParameter("antwort")!=null && !request.getParameter("antwort").equals("")?request.getParameter("antwort"):""); String login = (request.getParameter("login")!=null && !request.getParameter("login").equals("")?request.getParameter("login"):""); String message = ""; boolean loggedIn=false; if(session!=null && session.getAttribute("isValid")!=null && session.getAttribute("wacSeq")!=null && ((Boolean)session.getAttribute("isValid")).booleanValue() && !session.getAttribute("wacSeq").equals("")) { loggedIn=true; } if (action.equals("save")) { int anzahl = 0; String sql = "select count(*) as anzahl from wwwaccounts where wac_email = ? and language = '"+language+"' and organisation = '"+organisation+"'"; PreparedStatement pstmt = dbconnection.prepareStatement(sql); pstmt.setString(1, email); rsA = pstmt.executeQuery(); if (rsA.next()) { anzahl = rsA.getInt("anzahl"); } rsA.close(); if (anzahl < 1) { rsA = dbconnection.getSequence("seq_wwwaccounts"); String numActual = new String((rsA.next()?rsA.getString(1):"0")); rsA.close(); sql = "insert into wwwaccounts (wac_seq, wac_anrede, wac_kundennr, wac_firma, wac_abteilung, wac_vorname, wac_nachname"; sql += ", wac_strasse, wac_branche, wac_plz, wac_ort, wac_telefon, wac_fax, wac_land, wac_email, wac_passwd, wac_login, wac_ustid,language, organisation)"; sql += " values ('"+numActual+"', ?, ?, ?, ?, ?, ?"; sql += " , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,'"+language+"', '"+organisation+"')"; pstmt = dbconnection.prepareStatement(sql); pstmt.setString(1, anrede); pstmt.setString(2, kundennr); pstmt.setString(3, firma); pstmt.setString(4, abteilung); pstmt.setString(5, vorname); pstmt.setString(6, nachname); pstmt.setString(7, strasse); pstmt.setString(8, branche); pstmt.setString(9, plz); pstmt.setString(10, ort); pstmt.setString(11, telefon); pstmt.setString(12, telefax); pstmt.setString(13, land); pstmt.setString(14, email); pstmt.setString(15, passwd); pstmt.setString(16, ""); pstmt.setString(17, ustid); pstmt.executeUpdate(); pstmt.close(); pstmt=null; dbconnection.commit(); String wacSeq = ""; int a = 0; session.setAttribute("isValid",new Boolean("true")); session.setAttribute("wacSeq",numActual); // Nach Änderung zurück zum Login if(sV.equals("shop")) { %> <% } else { %> <% } } else { message = textSnippets.getProperty("RegisterAccountExists");//"+textSnippets.getProperty("RegisterAccountExists")+""; } } // Falls action = modify -> in db speichern if (action.equals("modify")) { String sql = "update wwwaccounts set wac_anrede = ?,wac_kundennr = ?,wac_firma = ?,wac_abteilung = ?,wac_vorname = ?,wac_nachname = ?"; sql += ",wac_strasse = ?,wac_branche = ?,wac_plz = ?,wac_ort = ?,wac_telefon = ?,wac_fax = ?,wac_land = ?,wac_passwd = ?,wac_ustid = ?,wac_email = ?"; sql += " where wac_seq = "+session.getAttribute("wacSeq")+" and language='"+language+"' and organisation='"+organisation+"'"; PreparedStatement pstmt = dbconnection.prepareStatement(sql); pstmt.setString(1, anrede); pstmt.setString(2, kundennr); pstmt.setString(3, firma); pstmt.setString(4, abteilung); pstmt.setString(5, vorname); pstmt.setString(6, nachname); pstmt.setString(7, strasse); pstmt.setString(8, branche); pstmt.setString(9, plz); pstmt.setString(10, ort); pstmt.setString(11, telefon); pstmt.setString(12, telefax); pstmt.setString(13, land); pstmt.setString(14, passwd); pstmt.setString(15, ustid); pstmt.setString(16, email); pstmt.executeUpdate(); pstmt.close(); pstmt=null; dbconnection.commit(); // Nach Änderung zurück zum Login %> <% } // Falls gültige Session vorhanden -> modify if(session != null && session.getAttribute("isValid")!=null) { String sql = "select * from wwwaccounts where wac_seq = "+session.getAttribute("wacSeq")+" and language='"+language+"' and organisation='"+organisation+"'"; rsA = dbconnection.sqlQuery(sql); if(rsA.next()) { anrede = rsA.getString("wac_anrede"); kundennr = rsA.getString("wac_kundennr"); firma = rsA.getString("wac_firma"); abteilung = rsA.getString("wac_abteilung"); vorname = rsA.getString("wac_vorname"); nachname = rsA.getString("wac_nachname"); strasse = rsA.getString("wac_strasse"); branche = rsA.getString("wac_branche"); plz = rsA.getString("wac_plz"); ort = rsA.getString("wac_ort"); telefon = rsA.getString("wac_telefon"); telefax = rsA.getString("wac_fax"); land = rsA.getString("wac_land"); email = rsA.getString("wac_email"); passwd = rsA.getString("wac_passwd"); ustid = rsA.getString("wac_ustid"); ustid = (ustid!=null && !ustid.equals("null")?ustid:""); action = "modify"; } } if (action.equals("Nothing")) action = "save"; %> <%= textSnippets.getProperty("windowTitel") %> <%@ include file="./metaInclude.jsp" %>
<%@ include file="../../ar01/templates/xxxxxAr01HeadChooseLanguage.jsp" %> <%@ include file="../../ar01/templates/xxxxxAr01HeadNavigation.jsp"%> <%@ include file="../../ar01/templates/xxxxxAr01HeadDirectOrder.jsp"%>
<%@ include file="../../ar03/templates/xxxxxAr03ServiceNavigation.jsp" %>
<%//@ include file="../../ar02/templates/xxxxxAr02LeftNavigation.jsp" %>

<%= (loggedIn?textSnippets.getProperty("RegisterHeadlineEdit"):textSnippets.getProperty("RegisterHeadlineNew")) %>

<%= (loggedIn?StringConvert.nl2br(textSnippets.getProperty("RegisterTextBoldEdit")):StringConvert.nl2br(textSnippets.getProperty("RegisterTextBoldNew"))) %>

<%if (message != ""){%>
<%= message %>
<%}%>
<%= textSnippets.getProperty("RegisterTitel") %>
<%= textSnippets.getProperty("RegisterTitelCompany") %> tabindex="1"> <%= textSnippets.getProperty("RegisterTitelWoman") %> tabindex="2"> <%= textSnippets.getProperty("RegisterTitelMan") %> tabindex="3">
<%= textSnippets.getProperty("RegisterClientNumber") %> <%= textSnippets.getProperty("RegisterName") %> 
<%= textSnippets.getProperty("RegisterCompany") %> <%= textSnippets.getProperty("RegisterFirstName") %>
<%= textSnippets.getProperty("registerUstid") %> <%= textSnippets.getProperty("RegisterStreet") %>
<%= textSnippets.getProperty("RegisterDivision") %> <%= textSnippets.getProperty("RegisterPostalCode") %>
<%= textSnippets.getProperty("RegisterBusiness") %> <%= textSnippets.getProperty("RegisterPostalTown") %>
<%= textSnippets.getProperty("RegisterPhone") %> <%= textSnippets.getProperty("RegisterCountry") %>
<%= textSnippets.getProperty("RegisterFax") %> <%= textSnippets.getProperty("RegisterEmail") %>
<%= textSnippets.getProperty("RegisterPasswordText") %>
<%= textSnippets.getProperty("RegisterYourPassword") %>  
<%= textSnippets.getProperty("ZoomButtonBack") %>   <%= (loggedIn?textSnippets.getProperty("RegisterButtonSave"):textSnippets.getProperty("RegisterButton"))%>
<%@ include file="../../ar04/templates/xxxxxAr04RightServiceColumn.jsp" %>
<%@ include file="../../lib/html/defaultFooter.jsp" %>