public static Namestaj Create(Namestaj cn) { using (SqlConnection connection = new SqlConnection(Podaci.CONNECTION_STRING)) { connection.Open(); SqlCommand cnamestajcommand = connection.CreateCommand(); cnamestajcommand.CommandText = "INSERT INTO NAMESTAJ(Naziv, Sifra, Kolicina, Obrisan) VALUES(@Naziv, @Sifra, @Kolicina, @Obrisan)"; cnamestajcommand.CommandText += "SELECT SCOPE_IDENTITY();"; cnamestajcommand.Parameters.AddWithValue("Naziv", cn.Naziv); cnamestajcommand.Parameters.AddWithValue("Sifra", cn.Sifra); cnamestajcommand.Parameters.AddWithValue("Kolicina", cn.Kolicina); cnamestajcommand.Parameters.AddWithValue("Obrisan", cn.Obrisan); } Projekat.Instance.Namestaj.Add(cn); return(cn); }
public static ObservableCollection <Namestaj> UcitajNamestaj() { var lista = new ObservableCollection <Namestaj>(); using (SqlConnection connection = new SqlConnection(Podaci.CONNECTION_STRING)) { connection.Open(); DataSet ds = new DataSet(); SqlCommand namestajcommand = connection.CreateCommand(); namestajcommand.CommandText = @"SELECT * FROM NAMESTAJ"; SqlDataAdapter daNamestaj = new SqlDataAdapter(); daNamestaj.SelectCommand = namestajcommand; daNamestaj.Fill(ds, "NAMESTAJ"); foreach (DataRow row in ds.Tables["Namestaj"].Rows) { Namestaj nam = new Namestaj(); nam.Id = (int)row["id"]; nam.Naziv = (string)row["naziv"]; nam.Sifra = (string)row["sifra"]; nam.Kolicina = (int)row["kolicina"]; // int Id = (int)row["Id"]; /*foreach (TipNamestaja tn in Podaci.Instance.TipoviNamestaja) * { * if (tn.Id == Id) * nam.tipn = tn; * } * foreach (TipNamestaja tn in Podaci.Instance.TipoviNamestaja) * { * if (tn.Id == Id) * nam.tipn = tn; * } */ nam.Obrisan = (bool)row["obrisan"]; lista.Add(nam); } } return(lista); }