public static StavkaUsluge Create(StavkaUsluge u) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); try { cmd.CommandText = "INSERT INTO StavkeUsluge (UslugaId) VALUES (@UslugaId);"; cmd.CommandText += "SELECT SCOPE_IDENTITY();"; cmd.Parameters.AddWithValue("UslugaId", u.UslugaId); u.Id = int.Parse(cmd.ExecuteScalar().ToString()); } catch (Exception ex) { MessageBox.Show("Neuspesno dodavanje", "Greska"); } } Projekat.Instance.StavkeUsluge.Add(u); return(u); }
public static ObservableCollection <StavkaUsluge> GetAll() { var stavka = new ObservableCollection <StavkaUsluge>(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); cmd.CommandText = "SELECT * FROM StavkeUsluge;"; da.SelectCommand = cmd; da.Fill(ds, "StavkeUsluge"); foreach (DataRow row in ds.Tables["StavkeUsluge"].Rows) { var u = new StavkaUsluge(); u.Id = int.Parse(row["Id"].ToString()); u.UslugaId = int.Parse(row["UslugaId"].ToString()); u.IdProdaje = int.Parse(row["IdProdaje"].ToString()); stavka.Add(u); } } return(stavka); }