public bool Snimi(Utisak utisak)
{
try
{
using (SqlCommand cmd = SQLKonekcija.GetCommand)
{
using (cmd.Connection)
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO Utisak (Ime, Email, Komentar, Datum) " +
"VALUES (@ime, @email, @komentar, @datum) ";
cmd.Parameters.AddWithValue("@ime", utisak.Ime);
cmd.Parameters.AddWithValue("@email", utisak.Email);
cmd.Parameters.AddWithValue("@komentar", utisak.Komentar);
cmd.Parameters.AddWithValue("@datum", utisak.Datum);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
return(true);
}
catch (Exception ex)
{
_ErrorMessage = ex.Message;
return(false);
}
}
protected void btnSnimi_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtIme.Text))
{
lblerror_message.Text = "Ime mora biti navedeno!";
lblerror_message.Visible = true;
return;
}
if (string.IsNullOrEmpty(txtEmail.Text))
{
lblerror_message.Text = "Email mora biti naveden!";
lblerror_message.Visible = true;
return;
}
if (!IsValidEmail(txtEmail.Text))
{
lblerror_message.Text = "Email nije zadat u korektnom obliku!";
lblerror_message.Visible = true;
return;
}
if (string.IsNullOrEmpty(txtKomentar.Text))
{
lblerror_message.Text = "Komentar mora biti naveden!";
lblerror_message.Visible = true;
return;
}
Utisak NoviUtisak = new Utisak();
NoviUtisak.Ime = txtIme.Text;
NoviUtisak.Email = txtEmail.Text;
NoviUtisak.Komentar = txtKomentar.Text;
if (dp.Snimi(NoviUtisak))
{
txtIme.Text = "";
txtEmail.Text = "";
txtKomentar.Text = "";
}
else
{
lblerror_message.Text = dp.ErrorMessage;
lblerror_message.Visible = true;
}
}
