private void Spremi_promjene_Click(object sender, EventArgs e)
{
string query = "UPDATE OSOBLJE SET Ime=@Ime,Prezime=@Prezime,Datum_rod=@Datum_rod,Mobitel=@Mobitel,Email=@Email,Zanimanje=@Zanimanje WHERE OIB=@OIB";
using (connection = new SqlConnection(connectionstring))
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.Parameters.AddWithValue("@OIB", maskedTextBox1.Text);
command.Parameters.AddWithValue("@Ime", textBox1.Text);
command.Parameters.AddWithValue("@Prezime", textBox2.Text);
command.Parameters.AddWithValue("@Datum_rod", DateTime.Parse(maskedTextBox3.Text));
command.Parameters.AddWithValue("@Mobitel", maskedTextBox2.Text);
command.Parameters.AddWithValue("@Email", textBox5.Text);
command.Parameters.AddWithValue("@Zanimanje", textBox6.Text);
command.ExecuteScalar();
}
Popis_osoblja forma3 = new Popis_osoblja();
forma3.Show();
this.Close();
}
private void Dodaj_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(maskedTextBox1.Text) &&
!String.IsNullOrEmpty(textBox1.Text) &&
!String.IsNullOrEmpty(textBox2.Text) &&
!String.IsNullOrEmpty(maskedTextBox3.Text) &&
!String.IsNullOrEmpty(maskedTextBox2.Text) &&
!String.IsNullOrEmpty(textBox5.Text) &&
!String.IsNullOrEmpty(textBox6.Text))
{
string query = "INSERT INTO OSOBLJE VALUES (@OIB,@Ime,@Prezime,@Datum_rod,@Mobitel,@Email,@Zanimanje)";
using (connection = new SqlConnection(connectionstring))
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.Parameters.AddWithValue("@OIB", Int64.Parse(maskedTextBox1.Text));
command.Parameters.AddWithValue("@Ime", textBox1.Text);
command.Parameters.AddWithValue("@Prezime", textBox2.Text);
command.Parameters.AddWithValue("@Datum_rod", DateTime.Parse(maskedTextBox3.Text));
command.Parameters.AddWithValue("@Mobitel", maskedTextBox2.Text);
command.Parameters.AddWithValue("@Email", textBox5.Text);
command.Parameters.AddWithValue("@Zanimanje", textBox6.Text);
MessageBox.Show("Broj row: " + command.ExecuteNonQuery());
connection.Close();
}
Popis_osoblja forma3 = new Popis_osoblja();
forma3.Show();
this.Close();
}
else
{
MessageBox.Show("Nije sve popunjeno!");
}
}
private void popisOsobljaToolStripMenuItem_Click(object sender, EventArgs e)
{
Popis_osoblja osoblje = new Popis_osoblja();
osoblje.Show();
}