using System.Data.OleDb;
using System;
using System.Text;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using MySQLDriverCS;

namespace dbserver
{
	/// <summary>
	/// Zusammendfassende Beschreibung für Service1.
	/// </summary>


/***** CLASS Servic1 ***************************************************************************************/	

	public class Service1 : System.Web.Services.WebService
	{
		public Service1()
		{
			//CODEGEN: Dieser Aufruf ist für den ASP.NET-Webdienst-Designer erforderlich.
			InitializeComponent();
		}


		#region Component Designer generated code
		
		//Erforderlich für den Webdienst-Designer 
		private IContainer components = null;
				
		/// <summary>
		/// Erforderliche Methode für die Designerunterstützung. 
		/// Der Inhalt der Methode darf nicht mit dem Code-Editor geändert werden.
		/// </summary>
		private void InitializeComponent()
		{
		}

		/// <summary>
		/// Die verwendeten Ressourcen bereinigen.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion


		/***** ;-)) Riverhorse **************************************************************************************/	
		[WebMethod]
		public string HelloRiverHorse()
		{
			return "Hallo hier ist das Flusspferd und Bunni Bunn und Mister Fiat";
		}

		/***** DB_NewTemplate ******************************************************************************************/	        
		
		[WebMethod]
		public int DB_NewTemplate(string Name, string Inhalt)
		{
			return newTemplate(Name, Inhalt);
		}

		private int newTemplate(string Name, string Inhalt)
		{
			//deklaration und initialisierung der variablen
			
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"Name"   , Name},
								   {"Inhalt" , Inhalt}
							  }, "Template"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(Template_ID) FROM template", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}
		/***** DB_GetPublikationsInhalte****************************************************************************************/
		[WebMethod]
		public int[] DB_GetPublikationsInhalte(int PublikationsObjektTyp_ID)
		{
			return GetPublikationsInhalte(PublikationsObjektTyp_ID);
		}
		private int[] GetPublikationsInhalte(int PublikationsObjektTyp_ID)
		{
			int i = 0;
            int x = 0;

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * FROM publikation_inhalt WHERE PublikationsObjektTyp_ID = ' " + PublikationsObjektTyp_ID + " '", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();

			while(dr.Read())
			{
				x++;
			} 

   		    int[] id = new int[x];

			
            dr = cmd.ExecuteReaderEx();	
			
			while(dr.Read())
			{
			 id[i] = dr.GetInt32(2);
             i++;
			} 
			DBConn.Close();
			return id;
			
		}
		/***** DB_NewPublikationObjekt******************************************************************************************/	        
		
		[WebMethod]
		public int DB_NewPublikationsObjekt(int PublikationsObjektTyp_ID, int Eltern_ID, string Name, string Beschreibung, string test)
		{
			return newPublikationsObjekt(PublikationsObjektTyp_ID, Eltern_ID, Name, Beschreibung, test);
		}

		private int newPublikationsObjekt(int PublikationsObjektTyp_ID, int Eltern_ID, string Name, string Beschreibung, string test)
		{
			//deklaration und initialisierung der variablen
			
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"PublikationsObjektTyp_ID"   , PublikationsObjektTyp_ID},
								   {"Eltern_ID" , Eltern_ID},
								   {"Name", Name},
								   {"Beschreibung", Beschreibung},
								   {"Ist_Veroeffentlicht", test}
							  }, "publikationsobjekt"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(PublikationsObjekt_ID) FROM publikationsobjekt", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}

		/***** DB_newInhaltsObjekt******************************************************************************************/
		[WebMethod]
		public int DB_NewInhaltsObjekt(int PublikationsObjekt_ID, int InhaltsObjektTyp_ID)
		{
			return newInhaltsObjekt(PublikationsObjekt_ID, InhaltsObjektTyp_ID);
		}
		private int newInhaltsObjekt(int PublikationsObjekt_ID, int InhaltsObjektTyp_ID)
		{
			//deklaration und initialisierung der variablen
			
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"PublikationsObjekt_ID"   , PublikationsObjekt_ID},
								   {"InhaltsObjektTyp_ID" , InhaltsObjektTyp_ID},
							  }, "inhaltsobjekt"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(InhaltsObjekt_ID) FROM inhaltsobjekt", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}
		/***** DB_getTemplate ******************************************************************************************/
		
		[WebMethod]

		public string DB_getTemplate(int Template_ID)
		{
			return getTemplate(Template_ID);
		}
		
	 
		private string getTemplate(int Template_ID)
		{
			//deklaration und initialisierung der variablen
			string pfad; 
			string s;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from template WHERE Template_ID = '" + Template_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			pfad = dr.GetString(2);
 			
			
			
			FileStream fs = new FileStream(pfad, FileMode.Open);
			StreamReader sr = new StreamReader(fs);
			s = sr.ReadToEnd();
			
			sr.Close();
			DBConn.Close();
			return s;
			
		}	


		/***** DB_updateNameTemplate ***************************************************************************************/

		[WebMethod]
		public string DB_updateNameTemplate(int Template_ID, string newName)
		{
			return updateNameTemplate(Template_ID, newName);
		}

		private string updateNameTemplate(int Template_ID, string newName)
		{
			//deklaration und initialisierung der variablen
			
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE template set Name='" + newName + "' WHERE Template_ID = '" + Template_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}	

		/***** DB_updateInhaltTemplate ******************************************************************************/
		
		[WebMethod]
		public string DB_updateInhaltTemplate(int Template_ID, string newInhalt)
		{
			return updateInhaltTemplate(Template_ID, newInhalt);
		}

		private string updateInhaltTemplate(int Template_ID, string newInhalt)
		{
			//deklaration und initialisierung der variablen
			
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE template set Inhalt='" + newInhalt + "' WHERE Template_ID = '" + Template_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}
		/***** DB_NewVersion ******************************************************************************************/	

		[WebMethod]
		public int DB_NewVersion(int InhaltsObjekt_ID, string Jahr_Start, string Monat_Start, string Tag_Start, string Jahr_Ende, string Monat_Ende, string Tag_Ende, string ist_veroeffentlicht, string Inhalt)
		{
			return newVersion(InhaltsObjekt_ID, Jahr_Start, Monat_Start, Tag_Start, Jahr_Ende, Monat_Ende, Tag_Ende, ist_veroeffentlicht, Inhalt);
		}
		private int newVersion(int InhaltsObjekt_ID, string Jahr_Start, string Monat_Start, string Tag_Start, string Jahr_Ende, string Monat_Ende, string Tag_Ende, string ist_veroeffentlicht, string Inhalt)
		{   
		
		

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			string Datum_Start = Jahr_Start + "." + Monat_Start + "." + Tag_Start;
			string Datum_Ende = Jahr_Ende + "." + Monat_Ende + "." + Tag_Ende;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"InhaltsObjekt_ID" , InhaltsObjekt_ID},
								   {"Datum_Start" , Datum_Start},
								   {"Datum_Ende", Datum_Ende},
								   {"Ist_Veroeffentlicht", ist_veroeffentlicht},
								   {"Inhalt", Inhalt}	
									
			}, "version"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(Version_ID) FROM version", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}
		/***** DB_update_Datum_Start_Version ***************************************************************************************/

		[WebMethod]
		public string DB_update_Datum_Start_Version(int Version_ID, string Jahr_Start, string Monat_Start, string Tag_Start)
		{
			return update_Datum_Start_Version(Version_ID, Jahr_Start, Monat_Start, Tag_Start);
		}

		private string update_Datum_Start_Version(int Version_ID, string Jahr_Start, string Monat_Start, string Tag_Start)
		{
			//deklaration und initialisierung der variablen
			string Datum_Start = Jahr_Start + "." + Monat_Start + "." + Tag_Start;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE version set Datum_Start='" + Datum_Start + "' WHERE Version_ID = '" + Version_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}	
		/***** DB_update_Datum_Ende_Version ***************************************************************************************/

		[WebMethod]
		public string DB_update_Datum_Ende_Version(int Version_ID, string Jahr_Ende, string Monat_Ende, string Tag_Ende)
		{
			return update_Datum_Ende_Version(Version_ID, Jahr_Ende, Monat_Ende, Tag_Ende);
		}

		private string update_Datum_Ende_Version(int Version_ID, string Jahr_Ende, string Monat_Ende, string Tag_Ende)
		{
			//deklaration und initialisierung der variablen
			string Datum_Ende = Jahr_Ende + "." + Monat_Ende + "." + Tag_Ende;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE version set Datum_Ende='" + Datum_Ende + "' WHERE Version_ID = '" + Version_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}	
		/***** DB_newPublikationsObjektTyp****************************************************************************/
		[WebMethod]
		public int DB_NewPublikationsObjektTyp(int Template_ID, string Name, string Beschreibung, string Ist_Ordner)
		{
			return newPublikationsObjektTyp(Template_ID, Name, Beschreibung, Ist_Ordner);
		}
		private int newPublikationsObjektTyp(int Template_ID, string Name, string Beschreibung, string Ist_Ordner)
		{
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"Template_ID" , Template_ID},
								   {"Name" , Name},
								   {"Beschreibung", Beschreibung},
								   {"Ist_Ordner", Ist_Ordner}	
								}, "publikationsobjektt"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(PublikationsObjektTyp_ID) FROM publikationsobjektt", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}
		/***** DB_getInhaltVersion ******************************************************************************************/
		[WebMethod]

		public string DB_getInhaltVersion(int Version_ID)
		{
			return getInhaltVersion(Version_ID);
		}
		
	 
		private string getInhaltVersion(int Version_ID)
		{
			string pfad; 
			string s;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from version WHERE Version_ID = '" + Version_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			pfad = dr.GetString(5);
 			
			
			
			FileStream fs = new FileStream(pfad, FileMode.Open);
			StreamReader sr = new StreamReader(fs);
			s = sr.ReadToEnd();
			
			sr.Close();
			DBConn.Close();
			return s;
		}
		/***** DB_update_ist_veroeffentlicht_Version ******************************************************************************/
		
		[WebMethod]
		public string DB_update_ist_veroeffentlicht_Version (int Version_ID, string Ist_Veroeffentlicht)
		{
			return update_ist_veroeffentlicht_Version (Version_ID,  Ist_Veroeffentlicht);
		}

		private string update_ist_veroeffentlicht_Version (int Version_ID, string Ist_Veroeffentlicht)
		{
			//deklaration und initialisierung der variablen
			if ((Ist_Veroeffentlicht != "0") && (Ist_Veroeffentlicht != "1"))
			{
				return "Fehler";
			}

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE version set Ist_Veroeffentlicht ='" + Ist_Veroeffentlicht + "' WHERE Version_ID = '" + Version_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}
		/***** DB_Get_Eltern_ID_from_PublikationsObjekt****************************************************************************************/
		[WebMethod]
		public int DB_Get_Eltern_ID_from_PublikationsObjekt(int PublikationsObjekt_ID)
		{
			return get_Eltern_ID_from_PublikationsObjekt(PublikationsObjekt_ID);
		}
		private int get_Eltern_ID_from_PublikationsObjekt(int PublikationsObjekt_ID)
		{
			int ID;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from publikationsobjekt WHERE PublikationsObjekt_ID = '" + PublikationsObjekt_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			ID = dr.GetInt32(2);
			DBConn.Close();
			return ID;
		}
		/***** DB_Get_all_PublikationsObjekt_ID_from_PublikationsObjekt****************************************************************************************/
		[WebMethod]
		public int[] DB_Get_all_PublikationsObjekt_ID_from_PublikationsObjekt(int Eltern_ID)
		{
			return get_all_PublikationsObjekt_ID_from_PublikationsObjekt(Eltern_ID);
		}
		private int[] get_all_PublikationsObjekt_ID_from_PublikationsObjekt(int Eltern_ID)
		{
			int i = 0;
			int x = 0;

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * FROM publikationsobjekt WHERE Eltern_ID = ' " + Eltern_ID + " '", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();

			while(dr.Read())
			{
				x++;
			} 

			int[] id = new int[x];

			
			dr = cmd.ExecuteReaderEx();	
			
			while(dr.Read())
			{
				id[i] = dr.GetInt32(0);
				i++;
			} 
			DBConn.Close();
			return id;
		}
		/***** DB_update_ist_veroeffentlicht_PublikationsObjekt ******************************************************************************/
		
		[WebMethod]
		public string DB_update_ist_veroeffentlicht_PublikationsObjekt (int PublikationsObjekt_ID, string Ist_Veroeffentlicht)
		{
			return update_ist_veroeffentlicht_PublikationsObjekt (PublikationsObjekt_ID,  Ist_Veroeffentlicht);
		}

		private string update_ist_veroeffentlicht_PublikationsObjekt (int PublikationsObjekt_ID, string Ist_Veroeffentlicht)
		{
			//deklaration und initialisierung der variablen
			if ((Ist_Veroeffentlicht != "0") && (Ist_Veroeffentlicht != "1"))
			{
				return "Fehler";
			}

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE publikationsobjekt set Ist_Veroeffentlicht ='" + Ist_Veroeffentlicht + "' WHERE PublikationsObjekt_ID = '" + PublikationsObjekt_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}
		/***** DB_NewPublikation_Inhalt************************************************************************************************/
		[WebMethod]
		public int DB_NewPublikation_Inhalt(int PublikationsObjektTyp_ID, int InhaltsObjektTyp_ID)
		{
			return newPublikation_Inhalt(PublikationsObjektTyp_ID, InhaltsObjektTyp_ID);
		}
		private int newPublikation_Inhalt(int PublikationsObjektTyp_ID, int InhaltsObjektTyp_ID)
		{
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"PublikationsObjektTyp_ID" , PublikationsObjektTyp_ID},
								   {"InhaltsObjektTyp_ID" , InhaltsObjektTyp_ID}	
							  }, "publikation_inhalt"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(Publikations_Inhalt_ID) FROM publikation_inhalt", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}
		/***** DB_NewInhaltsObjektTyp ******************************************************************************************/	        
		[WebMethod]
		public int DB_NewInhaltsObjektTyp(string Name)
		{
			return newInhaltsObjektTyp(Name);
		}

		private int newInhaltsObjektTyp(string Name)
		{
			//deklaration und initialisierung der variablen
			
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );
			int id = 0;
			DBConn.Open();
			new MySQLInsertCommand
				(
				DBConn, 
				new object[,] {
								   {"Name"   , Name}
							  }, "inhaltsobjekttyp"
				);
			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT MAX(InhaltsObjektTyp_ID) FROM inhaltsobjekttyp", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			id = dr.GetInt32(0);
			DBConn.Close();
			return (id);    
		}
		/***** DB_update_Name_InhaltsObjektTyp************************************************************************************/
		[WebMethod]
		public string DB_update_Name_InhaltsObjektTyp(int InhaltsObjektTyp_ID, string Name)
		{
			return update_Name_InhaltsObjektTyp(InhaltsObjektTyp_ID, Name);
		}
		private string update_Name_InhaltsObjektTyp(int InhaltsObjektTyp_ID, string Name)
		{
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("UPDATE inhaltsobjekttyp set Name ='" + Name + "' WHERE InhaltssObjektTyp_ID = '" + InhaltssObjektTyp_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			
			DBConn.Close();
			return "OK";    
		}
		/***** DB_update_NameBeschreibung_PublikationsObjektTyp************************************************************************************/
		[WebMethod]
		public string DB_update_Name_PublikationsObjektTyp(int PublikationsObjektTyp_ID, string Name, string Beschreibung)
		{
			return update_Name_PublikationsObjektTyp(PublikationsObjektTyp_ID, Name, Beschreibung);
		}
		private string update_Name_PublikationsObjektTyp(int PublikationsObjektTyp_ID, string Name, string Beschreibung)
		{
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd1 = new MySQLCommand("UPDATE publikationsobjektt set Name ='" + Name + "' WHERE PublikationsObjektTyp_ID = '" + PublikationsObjektTyp_ID + "'", DBConn);
			cmd2 = new MySQLCommand("UPDATE publikationsobjektt set Beschreibung ='" + Beschreibung + "' WHERE PublikationsObjektTyp_ID = '" + PublikationsObjektTyp_ID + "'", DBConn);
			MySQLDataReader dr1 = null;
			MySQLDataReader dr2 = null;
			dr1 = cmd1.ExecuteReaderEx();
			dr2 = cmd2.ExecuteReaderEx();
			DBConn.Close();
			return "OK";    
		}
		/***** DB_Get_Name_InhaltsObjektTyp****************************************************************************************/
		public string DB_Get_Name_InhaltsObjektTyp(int InhaltsObjekt_ID)
		{
			return get_Name_InhaltsObjektTyp(InhaltsObjekt_ID);
		}
		private string get_Name_InhaltsObjektTyp(int InhaltsObjekt_ID)
		{
			string name;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from inhaltsobjekttyp WHERE InhaltsObjekt_ID = '" + InhaltsObjekt_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			name = dr.GetString(1);
			DBConn.Close();
			return name;
		}
		/***** DB_Get_PublikationsObjektTyp_ID_from_PublikationsObjektTyp****************************************************************************************/
		[WebMethod]
		public int DB_Get_PublikationsObjektTyp_ID_from_PublikationsObjektTyp(int Template_ID)
		{
			return get_PublikationsObjektTyp_ID_from_PublikationsObjektTyp(Template_ID);
		}
		private int get_PublikationsObjektTyp_ID_from_PublikationsObjektTyp(int Template_ID)
		{
			int ID;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from publikationsobjektt WHERE Template_ID = '" + Template_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			ID = dr.GetInt32(0);
			DBConn.Close();
			return ID;
		}
		/***** DB_Get_Template_ID_from_PublikationsObjektTyp****************************************************************************************/
		[WebMethod]
		public int DB_Get_Template_ID_from_PublikationsObjektTyp(int PublikationsObjektTyp_ID)
		{
			return get_Template_ID_from_PublikationsObjektTyp(PublikationsObjektTyp_ID);
		}
		private int get_Template_ID_from_PublikationsObjektTyp(int PublikationsObjektTyp_ID)
		{
			int ID;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from publikationsobjektt WHERE PublikationsObjektTyp_ID = '" + PublikationsObjektTyp_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			ID = dr.GetInt32(0);
			DBConn.Close();
			return ID;
		}
		/***** DB_Get_InhaltsObjektTyp_ID_from_InhaltsObjekt****************************************************************************************/
		[WebMethod]
		public int DB_Get_InhaltsObjektTyp_ID_from_InhaltsObjekt(int InhaltsObjekt_ID, int PublikationsObjekt_ID)
		{
			return get_InhaltsObjektTyp_ID_from_InhaltsObjekt(InhaltsObjekt_ID, PublikationsObjekt_ID);
		}
		private int get_InhaltsObjektTyp_ID_from_InhaltsObjekt(int InhaltsObjekt_ID, int PublikationsObjekt_ID)
		{
			int ID;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from inhaltsobjekt WHERE InhaltsObjekt_ID = '" + InhaltsObjekt_ID + "' AND WHERE PublikationsObjekt_ID = '" + PublikationsObjekt_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			ID = dr.GetInt32(2);
			DBConn.Close();
			return ID;
		}
		/***** DB_Get_PublikationsObjekt_ID_from_InhaltsObjekt****************************************************************************************/
		[WebMethod]
		public int DB_Get_PublikationsObjekt_ID_from_InhaltsObjekt(int InhaltsObjekt_ID)
		{
			return get_PublikationsObjekt_ID_from_InhaltsObjekt(InhaltsObjekt_ID)
		}
		private int get_PublikationsObjekt_ID_from_InhaltsObjekt(int InhaltsObjekt_ID)
		{
			int ID;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from inhaltsobjekt WHERE InhaltsObjekt_ID = '" + InhaltsObjekt_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			ID = dr.GetInt32(1);
			DBConn.Close();
			return ID;
		}
		/*------------------------------------------------------------------
		/***** DB_GetVersion_ID****************************************************************************************/
		[WebMethod]
		public int DB_Get_Version_ID_from_Version(int InhaltsObjekt_ID)
		{
			return get_Version_ID_from_Version(InhaltsObjekt_ID);
		}
		private int get_Version_ID_from_Version(int InhaltsObjekt_ID)
		{
			int ID;
			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * from version WHERE InhaltsObjekt_ID = '" + InhaltsObjekt_ID + "'", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();
			dr.Read();
			ID = dr.GetInt32(0);
			DBConn.Close();
			return ID;
		}
		/***** DB_Get_all_InhaltsObjekt_ID_from_InhaltsObjekt****************************************************************************************/
		[WebMethod]
		public int[] DB_Get_all_InhaltsObjekt_ID_from_InhaltsObjekt(int PublikationsObjekt_ID)
		{
			return get_all_InhaltsObjekt_ID_from_InhaltsObjekt(PublikationsObjekt_ID);
		}
		private int[]get_all_InhaltsObjekt_ID_from_InhaltsObjekt(int PublikationsObjekt_ID)
		{
			int i = 0;
			int x = 0;

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT * FROM inhaltsobjekt WHERE PublikationsObjekt_ID = ' " + PublikationsObjekt_ID + " '", DBConn);
			MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();

			while(dr.Read())
			{
				x++;
			} 

			int[] id = new int[x];

			
			dr = cmd.ExecuteReaderEx();	
			
			while(dr.Read())
			{
				id[i] = dr.GetInt32(0);
				i++;
			} 
			DBConn.Close();
			return id;
		}
		/***** DB_GetPublikation_Inhalt_Version****************************************************************************************/
/*		[WebMethod]
		public int DB_GetPublikation_Inhalt_Version(int PublikationsObjekt_ID)
		{
			return GetPublikation_Inhalt_Version(PublikationsObjekt_ID);
		}
		private int GetPublikation_Inhalt_Version(int PublikationsObjekt_ID)
		{
			int i = 0;
			int x = 0;

			MySQLConnection DBConn = null;
			DBConn = new MySQLConnection(new MySQLConnectionString("192.168.187.118","wcms","root","").AsString );

			DBConn.Open();

			MySQLCommand cmd = null;
			cmd = new MySQLCommand("SELECT Versions_ID FROM  inhaltsobjekt, version
				WHERE inhaltsobjekt.PublikationsObjekt_ID = ' " + PublikationsObjekt_ID + " '
									   AND WHERE inhaltsobjekt.InhaltsObjekt_ID = Version.InhaltsObjekt_ID
													 AND Version.ist_veroeffentlicht = 1 ", DBConn);
																							 MySQLDataReader dr = null;
			dr = cmd.ExecuteReaderEx();

			while(dr.Read())
			{
				x++;
			} 

			int[] id = new int[x];

			
			dr = cmd.ExecuteReaderEx();	
			
			while(dr.Read())
			{
				id[i] = dr.GetInt32(2);
				i++;
			} 
			DBConn.Close();
			return id;
			
		}

*/
	}
}