using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Configuration;
using System.IO;

namespace glorija
{
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public class GuestbookSend : System.Web.UI.Page
	{
		private void Page_Load(object sender, System.EventArgs e)
		{
			saveGuestbook();
		}
		//
		//
		private void saveGuestbook()
		{
			//Deklaracija varijabli
			//OleDbConnection  OleDbConn = null;
			OleDbCommand dbComm = null;
			OleDbConnection dbConn = null;
			//
			string sqlQuery = null;

			string datum = null;
			string komentar = null;
			string ime = null;
			string email = null;
			string web = null;
			//
			//
		    datum = Request["datum"].ToString();
			ime = Request["imeGosta"].ToString();
			email = Request["email"].ToString();
			web = Request["web"].ToString();
			komentar = Request["komentar"].ToString();
			//
			//datum = "1/26/2008";
			//ime = "Tomislav";
			//email = "tomislav@multi-design.biz";
			//web = "www.multi-desig.biz";
			//komentar = "Ovo je testni unos u knjigu gostiju";
			//
			//sqlQuery = "INSERT INTO MO_Marchs";
			//sqlQuery += "(MarchName, MarchTypeID, MarchDate) ";
			//sqlQuery += "VALUES";
			//sqlQuery += "('"+ marchName +"',"+ marchType +",'"+ marchDate +"')";
			//
		    sqlQuery = "INSERT INTO GL_Guestbook ";
			sqlQuery += "([Datum], [Comment], [Name], [Email], [Web]) ";
			sqlQuery += "VALUES ";
			sqlQuery += "('"+ datum +"','"+ komentar +"','"+ ime +"','"+ email +"','" + web + "');";
			//
		    dbConn = new OleDbConnection(ConfigurationSettings.AppSettings["dbGlorija"]);
			//
			dbComm = new OleDbCommand(sqlQuery,dbConn);
			dbConn.Open();
			dbComm.ExecuteNonQuery();
			dbConn.Close();
			//
			//Response.Write("sqlQuery= "+sqlQuery);
			//
			//Response.Write("&poruka=Uspješno ste se upisali u knjigu gostiju.");
			//
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}