public static ObservableCollection <ProdajaNamestaja> GetAll() { var namestaj = new ObservableCollection <ProdajaNamestaja>(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Racun"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // izvrsava se query nad bazom foreach (DataRow row in ds.Tables["Racun"].Rows) { var tn = new ProdajaNamestaja(); tn.Id = int.Parse(row["Id"].ToString()); tn.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString()); tn.BrojRacuna = row["BrojRacuna"].ToString(); tn.Kupac = row["Kupac"].ToString(); tn.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); tn.Obrisan = bool.Parse(row["Obrisan"].ToString()); namestaj.Add(tn); } } return(namestaj); }
public static ProdajaNamestaja Create(ProdajaNamestaja tn) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); DataSet ds = new DataSet(); cmd.CommandText = "INSERT INTO Racun (Id, DatumProdaje, BrojRacuna, Kupac, UkupnaCena, Obrisan) VALUES (@Id, @DatumProdaje, @BrojRacuna, @Kupac, @UkupnaCena, @Obrisan);"; cmd.CommandText += "SELECT SCOPE_IDENTITY();"; cmd.Parameters.AddWithValue("Id", tn.Id); cmd.Parameters.AddWithValue("DatumProdaje", tn.DatumProdaje); cmd.Parameters.AddWithValue("BrojRacuna", tn.BrojRacuna); cmd.Parameters.AddWithValue("Kupac", tn.Kupac); cmd.Parameters.AddWithValue("UkupnaCena", tn.UkupnaCena); cmd.Parameters.AddWithValue("Obrisan", tn.Obrisan); int newId = int.Parse(cmd.ExecuteScalar().ToString()); // ExecuteScalar izvrsava query tn.Id = newId; } Projekat.Instace.prodajanamestaja.Add(tn); return(tn); }