From be5d86c202129b841ef448f7f02d3661597ecc24 Mon Sep 17 00:00:00 2001
From: unknown
Date: Wed, 19 Feb 2014 12:41:49 +0100
Subject: Es ist nun möglich auf der Datenbank basierend VLs sowie
 Veranstaltungen neu anzulegen

---
 Dozentenmodulserver/src/server/ServerMethod.java | 76 ++++++++++++++++++++++--
 1 file changed, 71 insertions(+), 5 deletions(-)

(limited to 'Dozentenmodulserver/src/server/ServerMethod.java')

diff --git a/Dozentenmodulserver/src/server/ServerMethod.java b/Dozentenmodulserver/src/server/ServerMethod.java
index 1f66fb6b..aa4dcae8 100644
--- a/Dozentenmodulserver/src/server/ServerMethod.java
+++ b/Dozentenmodulserver/src/server/ServerMethod.java
@@ -11,9 +11,13 @@ import java.sql.ResultSetMetaData;
 import java.sql.SQLException;
 import java.util.ArrayList;
 import java.util.Date;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 import java.util.UUID;
-import Models.*;
+
+import Models.User;
+
 import sql.SQL;
 
 @SuppressWarnings("serial")
@@ -133,16 +137,17 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 			String Fak, boolean license, boolean internet, int ram, int cpu)
 			throws RemoteException {
 		String login="tete";
-		System.out.println("1");
+		
 		int pk_institution=sql.setInstitution(con, university);
-		System.out.println("2");
+		
 		int pk_person=sql.setPerson(con, login, lastname, firstname, Mail, new Date(), pk_institution);
-		System.out.println("3");
+		
 		sql.setImageData(con, pk_person, license, internet, cpu, ram, imagename);
-		System.out.println("4");
+		
 		// TODO Auto-generated method stub
 		return true;
 	}
+	
 
 
 
@@ -156,6 +161,7 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 			List<Object[]> listWith = ResSetToObject(resWith);
 			List<Object[]> listWithout=ResSetToObject(resWithout);
 			listWith.addAll(listWith.size(), listWithout);
+			
 			return listWith;
 		} catch (SQLException e1) {
 			// TODO Auto-generated catch block
@@ -200,4 +206,64 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface
 		}
 		return null;
 	}
+
+
+
+	@Override
+	public Map<String,String> getPersonData(String Vorname, String Nachname)
+			throws RemoteException {
+		Map<String,String> map=new HashMap<String, String>();
+		System.out.println(Vorname+Nachname);
+		ResultSet rs=sql.getPersonData(con, Vorname, Nachname);
+		try {
+			while(rs.next())
+			{
+				
+				map.put("mail", rs.getString("mail"));
+				map.put("Nachname", rs.getString("Nachname"));
+				map.put("Vorname", rs.getString("Vorname"));
+				map.put("Hochschule", rs.getString("name"));
+				map.put("tel", "009909");
+				map.put("fak", "E+I");
+				
+			}
+			return map;
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		return null;
+	}
+
+
+	@Override
+	public boolean writeLecturedata(String name, String shortdesc, String desc,
+			Date start, Date end, boolean isActive, String imagename,
+			String firstname, String lastname, String university, String Mail,
+			String Tel, String Fak) throws RemoteException {
+		int pk_image = 0;
+		String login="tete";
+		int imageversion = 0;
+		int pk_institution=sql.setInstitution(con, university);
+		int pk_person=sql.setPerson(con, login, lastname, firstname, Mail, new Date(), pk_institution);
+		System.out.println(imagename);
+		ResultSet image=sql.getImageIDandVersion(con, imagename);
+
+			try {
+				while(image.next())
+				{
+				pk_image=image.getInt("GUID_imageID");
+				imageversion=image.getInt("imageVersion");
+				}
+			} catch (SQLException e) {
+				// TODO Auto-generated catch block
+				e.printStackTrace();
+			}
+			
+			
+			
+			sql.setLectureData(con, pk_person, pk_image, imageversion, name, desc, shortdesc, start, end, isActive);
+		
+		return false;
+	}
 }
\ No newline at end of file
-- 
cgit v1.2.3-55-g7522