Efluids Admin

<%@ page language="Java" import="java.io.*,java.sql.*,StrChk.Str,java.net.URLEncoder" session="true"%> <%! java.sql.ResultSet rs,res1; java.sql.Connection con; java.sql.Statement st; boolean flag; int i=0; StringBuffer buffer4; StringBuffer buffer5; private String htm4; private String htm5; public String addSpaceCode(String s) { String s1 = ""; if(s != null) { for(int i = 0; i < s.length(); i++) if(s.substring(i, i + 1).equals(" ")) s1 = s1 + "%20"; else s1 = s1 + s.substring(i, i + 1); } return s1; } public String formatDate(String s, String s1, String s2) { String as[] = { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; String s3 = "-"; String s4 = ""; if(s1.equals("01")) s1 = as[0]; else if(s1.equals("02")) s1 = as[1]; else if(s1.equals("03")) s1 = as[2]; else if(s1.equals("04")) s1 = as[3]; else if(s1.equals("05")) s1 = as[4]; else if(s1.equals("06")) s1 = as[5]; else if(s1.equals("07")) s1 = as[6]; else if(s1.equals("08")) s1 = as[7]; else if(s1.equals("09")) s1 = as[8]; else if(s1.equals("10")) s1 = as[9]; else if(s1.equals("11")) s1 = as[10]; else if(s1.equals("12")) s1 = as[11]; s4 = s + s3 + s1 + s3 + s2; return s4; } %> <% try { con=dbcon.getConnection(); st=con.createStatement(); Str str = new Str(); String s = ""; String s1 = ""; String s2 = ""; String s3 = ""; String s4 = ""; String s5 = ""; buffer4 = new StringBuffer(1024); buffer5 = new StringBuffer(1024); buffer4.append("Efluids Admin"); buffer4.append(""); buffer4.append("

"); buffer4.append("

"); buffer4.append("

ADMIN MESSAGE
"); buffer4.append("
You are not a authorized user Or you have not Logged in Properly. Please Login Properly
"); buffer4.append("
"); buffer4.append("LOGIN"); buffer4.append("

"); buffer4.append("

"); buffer4.append(""); buffer5.append("Efluids Admin Options"); buffer5.append(""); buffer5.append("

"); buffer5.append("

"); buffer5.append("
ADMIN MESSAGE
"); buffer5.append("
Your session has expired. Please Login Again.
"); buffer5.append("
LOGIN

"); buffer5.append("

"); buffer5.append(""); htm4 = buffer4.toString(); htm5 = buffer5.toString(); String s6 = request.getParameter("session"); if(s6 != null) { String s8 = (String)session.getValue("sesUser"); if(s8 != null) { String s10 = (String)session.getValue("sesPss"); s8 = str.retString(s8); s10 = str.retString(s10); long l = session.getLastAccessedTime(); Long long1 = new Long(l); Long long2 = (Long)session.getValue("sessionTime"); long l1 = long2.longValue(); long l2 = l - l1; if(l2 > 0x1b7740L) { String s19 = ""; rs = st.executeQuery("select date_format(now(),'%d-%m-%Y')AS Date"); if(rs.next()) s19 = rs.getString("Date"); rs.close(); String s21 = "update adminlog set OUTTIME='" + s19 + "',STATUS='OFF' where USRNAME='" + s8 + "' and STATUS='ON'"; int j = st.executeUpdate(s21); session.invalidate(); out.println(htm5); } else { session.putValue("sessionTime", long1); if(s8 != null) { res1 = st.executeQuery("Select * from admin where usrname='" + s8 + "' and pssword='" + s10 + "'"); if(res1.next()) { s4 = res1.getString("USRNAME"); s5 = res1.getString("PSSWORD"); } res1.close(); if(s8.equals(s4) && s10.equals(s5)) { s = request.getParameter("editType"); s2 = request.getParameter("SDate"); s3 = request.getParameter("EDate"); } flag = true; } } } else { out.println(htm4); } } String s7 = "-"; String s9 = request.getParameter("subtype"); String s11 = request.getParameter("usrname"); s11 = s11.trim(); s11 = str.retString(s11); int i = Integer.parseInt(request.getParameter("eventid")); String s12 = request.getParameter("evtCalTypeOfEvt"); s12 = s12.trim(); s12 = str.retString(s12); String s13 = request.getParameter("evtCalName"); s13 = s13.trim(); s13 = str.retString(s13); String s14 = request.getParameter("evtCalLocation"); s14 = s14.trim(); s14 = str.retString(s14); String s15 = request.getParameter("evtCalAddr"); if(s15.equals(null) || s15.equals("")) s15 = "null"; s15 = s15.trim(); s15 = str.retString(s15); String s16 = request.getParameter("evtCalAddr1"); if(s16.equals(null) || s16.equals("")) s16 = "null"; s16 = s16.trim(); s16 = str.retString(s16); String s17 = request.getParameter("evtCalAddr2"); if(s17.equals(null) || s17.equals("")) s17 = "null"; s17 = s17.trim(); s17 = str.retString(s17); String s18 = request.getParameter("evtCalSMonth"); s18 = str.retString(s18); String s20 = request.getParameter("evtCalSDay"); s20 = str.retString(s20); String s22 = request.getParameter("evtCalSYear"); s22 = str.retString(s22); String s23 = formatDate(s20, s18, s22); String s24 = request.getParameter("evtCalEMonth"); s24 = str.retString(s24); String s25 = request.getParameter("evtCalEDay"); s25 = str.retString(s25); String s26 = request.getParameter("evtCalEYear"); s26 = str.retString(s26); String s27 = formatDate(s25, s24, s26); String s28 = request.getParameter("evtCalCity"); if(s28.equals(null) || s28.equals("")) s28 = "null"; s28 = s28.trim(); s28 = str.retString(s28); String s29 = request.getParameter("evtCalState"); if(s29.equals(null) || s29.equals("")) s29 = "null"; s29 = s29.trim(); s29 = str.retString(s29); String s30 = request.getParameter("evtCalCountry"); s30 = s30.trim(); s30 = str.retString(s30); String s31 = request.getParameter("evtCalEmail"); if(s31.equals(null) || s31.equals("")) s31 = "null"; s31 = s31.trim(); s31 = str.retString(s31); String s32 = request.getParameter("evtCalWebSiteLink"); if(s32.equals(null) || s32.equals("")) s32 = "null"; s32 = s32.trim(); s32 = str.retString(s32); String s33 = request.getParameter("evtCalCtPerName"); if(s33.equals(null) || s33.equals("")) s33 = "null"; s33 = s33.trim(); s33 = str.retString(s33); String s34 = request.getParameter("evtCalCtEmail"); if(s34.equals(null) || s34.equals("")) s34 = "null"; s34 = s34.trim(); s34 = str.retString(s34); String s35 = request.getParameter("evtCalStreetAddr1"); if(s35.equals(null) || s35.equals("")) s35 = "null"; s35 = s35.trim(); s35 = str.retString(s35); String s36 = request.getParameter("evtCalStreetAddr2"); if(s36.equals(null) || s36.equals("")) s36 = "null"; s36 = s36.trim(); s36 = str.retString(s36); String s37 = request.getParameter("evtCalCtCity"); if(s37.equals(null) || s37.equals("")) s37 = "null"; s37 = s37.trim(); s37 = str.retString(s37); String s38 = request.getParameter("evtCalCtState"); if(s38.equals(null) || s38.equals("")) s38 = "null"; s38 = s38.trim(); s38 = str.retString(s38); String s39 = request.getParameter("evtCalCtCountry"); if(s39.equals(null) || s39.equals("")) s39 = "null"; s39 = s39.trim(); s39 = str.retString(s39); String s40 = request.getParameter("evtCalCtZipCode"); if(s40.equals(null) || s40.equals("")) s40 = "null"; s40 = s40.trim(); s40 = str.retString(s40); String s41 = request.getParameter("evtCalCtPhoneNo"); if(s41.equals(null) || s41.equals("")) s41 = "null"; s41 = s41.trim(); s41 = str.retString(s41); String s42 = request.getParameter("evtCalCtFaxNo"); if(s42.equals(null) || s42.equals("")) s42 = "null"; s42 = s42.trim(); s42 = str.retString(s42); String s43 = request.getParameter("evtCalDesch"); s43 = s43.trim(); s43 = str.retString(s43); if(s43.equals(null)) s43 = "0"; String s44 = request.getParameter("evtCalCallFPaph"); s44 = s44.trim(); s44 = str.retString(s44); if(s44.equals(null) || s44 == null) s44 = "0"; String s45 = request.getParameter("evtCalDeadLineh"); s45 = s45.trim(); s45 = str.retString(s45); if(s45.equals(null) || s45 == null) s45 = "0"; String s46 = request.getParameter("evtCalRegInfoh"); s46 = s46.trim(); s46 = str.retString(s46); if(s46.equals(null) || s46 == null) s46 = "0"; String s47 = request.getParameter("evtCalTravelInfoh"); s47 = s47.trim(); s47 = str.retString(s47); if(s47.equals(null) || s47 == null) s47 = "0"; String s48 = request.getParameter("evtCalAccoRegh"); s48 = s48.trim(); s48 = str.retString(s48); if(s48.equals(null) || s48 == null) s48 = "0"; String s49 = ""; if(s9.equals("1")) { rs = st.executeQuery("select date_format(sysdate,'dd-Mon-yyyy') from dual"); if(rs.next()) s49 = rs.getString("Date"); rs.close(); String s50 = ""; String s52 = ""; boolean flag1 = false; boolean flag2 = false; if(flag) { String s54 = "update eventnmeet set TYPEEVENT='" + s12 + "',NMEVENT='" + s13 + "',STDATE='" + s23 + "',ENDATE='" + s27 + "',VENUE='" + s14 + "',VENUEADD='" + s15 + "',ADDRESS2='" + s16 + "',ADDRESS3='" + s17 + "',CITY='" + s28 + "',STATE='" + s29 + "',COUNTRY='" + s30 + "',EVENTURL='" + s32 + "',EVENTEMAIL='" + s31 + "',STATUS='U',ENTERDATE='" + s49 + "' where USRNAME='" + s11 + "' AND EVENTID=" + i; String s56 = "update evenmtconper set CONPERS='" + s33 + "',STRTADD1='" + s35 + "',STRTADD2='" + s36 + "',CONCITY='" + s37 + "',CONSTATE='" + s38 + "',CONCOUNTRY='" + s39 + "',ZIP='" + s40 + "',PHNO='" + s41 + "',FAX='" + s42 + "',CONEMAIL='" + s34 + "',STATUS='U',ENTERDATE='" + s49 + "' where EVENTID=" + i; int i2 = st.executeUpdate(s54); int k2 = st.executeUpdate(s56); boolean flag4 = i2 != 0 && k2 != 0; out.println("Edit Form for Calendar of Events"); %> <%@ include file="../Inserthead.inc" %> <% out.println("

Your Details have been updated successfully.

"); out.println("

Click LIST to return to the List page.

"); out.println("

Click Main Options to return the Options Page.

"); out.println("

"); } else { String s55 = "update eventnmeet set TYPEEVENT='" + s12 + "',NMEVENT='" + s13 + "',STDATE='" + s23 + "',ENDATE='" + s27 + "',VENUE='" + s14 + "',VENUEADD='" + s15 + "',ADDRESS2='" + s16 + "',ADDRESS3='" + s17 + "',CITY='" + s28 + "',STATE='" + s29 + "',COUNTRY='" + s30 + "',EVENTURL='" + s32 + "',EVENTEMAIL='" + s31 + "',STATUS='D',ENTERDATE='" + s49 + "' where USRNAME='" + s11 + "' AND EVENTID=" + i; String s57 = "update evenmtconper set CONPERS='" + s33 + "',STRTADD1='" + s35 + "',STRTADD2='" + s36 + "',CONCITY='" + s37 + "',CONSTATE='" + s38 + "',CONCOUNTRY='" + s39 + "',ZIP='" + s40 + "',PHNO='" + s41 + "',FAX='" + s42 + "',CONEMAIL='" + s34 + "',STATUS='D',ENTERDATE='" + s49 + "' where EVENTID=" + i; int j2 = st.executeUpdate(s55); int i3 = st.executeUpdate(s57); boolean flag5 = j2 != 0 && i3 != 0; out.println("Edit Form for Calendar of Events"); %> <%@ include file="../Inserthead.inc" %> <% out.println("

Your Details have been updated successfully.

"); out.println("

Click Display to see Event Calendar Listings.

"); out.println("

Click Home to return to the Home Page.

"); out.println("

"); } } else { String s51 = "insert into eventnmeetstore values('" + i + "','" + s12 + "','" + s13 + "','" + s23 + "','" + s27 + "','" + s14 + "','" + s15 + "','" + s28 + "','" + s29 + "','" + s30 + "','" + s32 + "','" + s31 + "','" + s11 + "','" + s16 + "','" + s17 + "','" + s49 + "','D')"; int k = st.executeUpdate(s51); String s53 = "insert into evenmtconperstore values('" + s33 + "','" + s35 + "','" + s36 + "','" + s37 + "','" + s38 + "','" + s39 + "','" + s40 + "','" + s41 + "','" + s42 + "','" + s34 + "','" + i + "','" + s49 + "','D')"; int i1 = st.executeUpdate(s53); int j1 = 0; int k1 = 0; boolean flag3 = false; if(i1 != 0 && k != 0) { String s58 = "delete from evenmtconper where EVENTID = " + i; k1 = st.executeUpdate(s58); String s59 = "delete from eventnmeet where USRNAME='" + s11 + "' AND EVENTID=" + i; j1 = st.executeUpdate(s59); } if(j1 >= 1 && k1 >= 1) { out.println("Edit Form for Calendar of Events"); %> <%@ include file="../Inserthead.inc" %> <% out.println("

Details have been deleted successfully.

"); out.println("

Click LIST to return to the List page.

"); out.println("

Click Main Options to return the Options Page.

"); out.println("

"); } } } catch(Exception exception1) { out.println("Edit Form for Calendar of Events"); %> <%@ include file="../Inserthead.inc" %> <% out.println("

ERROR

"); out.println("The error is: " + exception1); out.println("

"); } finally { try { if(con !=null) { con.close(); } if(rs !=null || res1 != null) { rs.close(); res1.close(); } }catch(Exception e) { out.println("There is an problem in your database communication" +e); } } %>