private void obrisiPoljeButton_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 [Polje] WHERE [PoljeId]='" + PoljaForm.poljeId + "'", con);
con.Open();
sc.ExecuteNonQuery();
con.Close();
MessageBox.Show("Obrisali ste polje: " + imePolja);
this.Close();
PoljaForm pf = new PoljaForm();
pf.Show();
PoljaForm.poljeId = 0;
prinos = 0;
cijenaOtkupa = 0;
trosakSjemena = 0;
trosakGnojiva = 0;
trosakSpriceva = 0;
trosakGoriva = 0;
ostaliTroskovi = 0;
dobit = 0;
ukupniTrosak = 0;
profit = 0;
}
private void natragButton_Click(object sender, EventArgs e)
{
this.Close();
PoljaForm pf = new PoljaForm();
pf.Show();
PoljaForm.poljeId = 0;
prinos = 0;
cijenaOtkupa = 0;
trosakSjemena = 0;
trosakGnojiva = 0;
trosakSpriceva = 0;
trosakGoriva = 0;
ostaliTroskovi = 0;
dobit = 0;
ukupniTrosak = 0;
profit = 0;
}
private void godinaListBox_MouseDoubleClick(object sender, MouseEventArgs 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;");
SqlDataAdapter sda = new SqlDataAdapter("SELECT [GodinaId] FROM [Godina] WHERE [Godina]='" + godinaListBox.Text + "'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
DataTableReader dtr = new DataTableReader(dt);
while (dtr.Read())
{
godinaId = dtr.GetInt32(dtr.GetOrdinal("GodinaId"));
}
this.Close();
PoljaForm pf = new PoljaForm();
pf.Show();
}
