using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace knjigautisaka
{
    public partial class Pocetna : System.Web.UI.Page
    {
        protected void dodaj_Click(object sender, EventArgs e)
        {
            string connStr = @"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\User\Desktop\teodorapejciciv\knjigautisaka\knjigautisaka\App_Data\knjigaUtisaka.mdf; Integrated Security = True;";

            using (SqlConnection conn = new SqlConnection(connStr))
            {
                string query = "INSERT INTO Utisak (Ime, Email, Komentar, Datum) VALUES (@Ime, @Email, @Komentar, @Datum)";
                SqlCommand cmd = new SqlCommand(query, conn);

                cmd.Parameters.AddWithValue("@Ime", ime.Text);
                cmd.Parameters.AddWithValue("@Email", email.Text);
                cmd.Parameters.AddWithValue("@Komentar", komentar.Text);
                cmd.Parameters.AddWithValue("@Datum", DateTime.Now);

                conn.Open();
                cmd.ExecuteNonQuery();
            }

            poruka.Text = "Komentar je uspešno dodat!";
        }
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}