1 files changed, 58 insertions, 1 deletions
diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index 27bdc17c..daffbf0b 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -14,6 +14,7 @@ import java.util.Random;
 import org.apache.log4j.Logger;
 
 import server.BinaryListener;
+import server.ServerHandler;
 
 public class SQL {
 
@@ -447,9 +448,41 @@ public class SQL {
 		}
 		return -1;
 	}
+
+
+
+	/**
+	 * 
+	 * @param id
+	 * @param version
+	 * @return
+	 */
 	
+	 public boolean deleteImage(Connection con, String id, String version) {
+		 
+		 System.out.println("delete image");
+		 
+		try {
+
+			Statement stm=con.createStatement();
+			
+			System.out.println("delete image");
+			
+			stm.executeUpdate("DELETE FROM bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"+id+"' " +
+					"AND imageVersion = '"+version+"';");
+			
+			return true;
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return false;
+	 }
+
 	public int updateLectureData(Connection con, int pk_image,
-			int imageversion, String name, String newName ,String desc, String shortdesc,
+			int imageversion, String name, String newName ,String desc, String shortdesc,
 			String start, String end, boolean isactive, String id) {
 
 		DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
@@ -480,11 +513,35 @@ public class SQL {
 					+id+"';" );
 			con.commit();
 
+
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		}
+
 		return 0;
 
 	}
+	
+	public boolean connectedToEvents (Connection con, String id, String version) {
+		
+		try {
+
+			Statement stm=con.createStatement();
+			
+			ResultSet rs = stm.executeQuery("SELECT ...VERANSTALTUNG_VERKNÜPFUNG... FROM " +
+					"bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"+id+"' " + 
+					"AND imageVersion = '"+version+"';");
+			
+			return !rs.wasNull();
+			
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return false;
+		
+	}
 }