public int brisiNarudzbu(NarudzbaHrane a) { try { String query = "DELETE FROM NarudzbaHrane WHERE id = @id;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter id = new SqlParameter(); id.Value = Convert.ToString(a.idNarudzbe); id.ParameterName = "id"; cmd.Parameters.Add(id); con.Open(); int r = 0; if (con.State == System.Data.ConnectionState.Open) { r = cmd.ExecuteNonQuery(); } con.Close(); return(r); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }
public int unesiNarudzbu(NarudzbaHrane a) { try { String query = "insert into NarudzbaHrane " + "values (@id,@idKupca)"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter id = new SqlParameter(); id.Value = Convert.ToString(a.idNarudzbe); id.ParameterName = "id"; SqlParameter idKupca = new SqlParameter(); idKupca.Value = a.idKupca; idKupca.ParameterName = "idKupca"; cmd.Parameters.Add(id); cmd.Parameters.Add(idKupca); int k = cmd.ExecuteNonQuery(); cmd.Dispose(); return(k); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }
public void ucitajNarudzbe() { try { Narudzbe = new List <NarudzbaHrane>(); String query = "SELECT * FROM NarudzbaHrane;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { con.Open(); if (con.State == System.Data.ConnectionState.Open) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { NarudzbaHrane a = new NarudzbaHrane(Convert.ToInt32(reader.GetString(0)), reader.GetInt32(1)); Narudzbe.Add(a); } } con.Close(); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); } }
public void prikazdetaljaNarudzbe(NarudzbaHrane narudzba) { }