private void natragButton_Click(object sender, EventArgs e) { this.Close(); GodineForm gf = new GodineForm(); gf.Show(); }
private void ulazButton_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Trgy\Documents\Visual Studio 2012\Projects\EvidencijaPolja\EvidencijaPolja\BazaPodataka.mdf;Integrated Security=True;"); con.Open(); SqlCommand sc = new SqlCommand("SELECT [UserId] FROM [User] WHERE [User] = @User AND [Password] = @Password", con); SqlParameter userParam = sc.Parameters.Add("@User", SqlDbType.NVarChar, 50 /* max length of field */); userParam.Value = usernameTextBox.Text; SqlParameter passwordParam = sc.Parameters.Add("@Password", SqlDbType.NVarChar, 50 /* max length of field */); passwordParam.Value = passwordTextBox.Text; SqlDataReader reader = sc.ExecuteReader(); while (reader.Read()) { userId = reader.GetInt32(reader.GetOrdinal("UserId")); } con.Close(); if (userId != 0) { this.Hide(); GodineForm gf = new GodineForm(); gf.Show(); } else { MessageBox.Show("Pogrešan username ili password"); } con.Close(); }
private void obrisiGodinuButton_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Trgy\Documents\Visual Studio 2012\Projects\EvidencijaPolja\EvidencijaPolja\BazaPodataka.mdf;Integrated Security=True;"); SqlCommand sc = new SqlCommand("DELETE FROM [Godina] WHERE [GodinaId]='" + GodineForm.godinaId + "'", con); SqlCommand sc1 = new SqlCommand("DELETE FROM [Polje] WHERE [GodinaId]='" + GodineForm.godinaId + "'", con); con.Open(); sc1.ExecuteNonQuery(); sc.ExecuteNonQuery(); con.Close(); MessageBox.Show("Obrisali ste godinu: " + godina + " i sva polja u njoj"); this.Close(); GodineForm gf = new GodineForm(); gf.Show(); }