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; } }