public static ObservableCollection <StavkaProdajeNamestaj> GetAll() { var spn = new ObservableCollection <StavkaProdajeNamestaj>(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM StavkaNamestaja "; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "StavkaNamestaja"); // Query se izvrsava foreach (DataRow row in ds.Tables["StavkaNamestaja"].Rows) { var s = new StavkaProdajeNamestaj(); s.Id = int.Parse(row["Id"].ToString()); s.RacunId = int.Parse(row["RacunId"].ToString()); s.NamestajId = int.Parse(row["NamestajId"].ToString()); s.Kolicina = int.Parse(row["Kolicina"].ToString()); spn.Add(s); } return(spn); } }
public static void Update(StavkaProdajeNamestaj s) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "Update StavkaNamestaja set RacunId=@RacunId,NamestajId=@NamestajId,Kolicina=@Kolicina where Id=@Id"; cmd.Parameters.AddWithValue("Id", s.Id); cmd.Parameters.AddWithValue("NamestajId", s.NamestajId); cmd.Parameters.AddWithValue("RacunId", s.RacunId); cmd.Parameters.AddWithValue("Kolicina", s.Kolicina); cmd.ExecuteNonQuery(); foreach (var spn in Projekat.Instance.spn) { if (spn.Id == s.Id) { spn.RacunId = s.RacunId; spn.NamestajId = s.NamestajId; spn.Kolicina = s.Kolicina; break; } } } }
public static StavkaProdajeNamestaj Create(StavkaProdajeNamestaj s) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = $"Insert into StavkaNamestaja (RacunId,NamestajId,Kolicina) Values(@RacunId,@NamestajId,@Kolicina);";//razmisli o ne unosenju obrisan pri dodavanju vec to u bazi cmd.CommandText += "Select scope_identity();"; cmd.Parameters.AddWithValue("RacunId", s.RacunId); cmd.Parameters.AddWithValue("NamestajId", s.NamestajId); cmd.Parameters.AddWithValue("Kolicina", s.Kolicina); int newId = int.Parse(cmd.ExecuteScalar().ToString()); //es izvrsava query s.Id = newId; } Projekat.Instance.spn.Add(s);//obrati paznju {azurira i stanje modela} return(s); }
public static void Delete(StavkaProdajeNamestaj n) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "Delete StavkaNamestaja where Id=@Id"; cmd.Parameters.AddWithValue("Id", n.Id); cmd.ExecuteNonQuery(); foreach (var spn in Projekat.Instance.spn) { if (spn.Id == n.Id) { Projekat.Instance.spn.Remove(spn); break; } } } }
private Projekat() { TN = TipNamestaja.GetAll(); //Console.WriteLine("1"); namestaj = Namestaj.GetAll(); // Console.WriteLine("2"); korisnik = Korisnik.GetAll(); // Console.WriteLine("3"); DU = DodatnaUsluga.GetAll(); // Console.WriteLine("4"); pn = Racun.GetAll(); // Console.WriteLine("5"); akcija = AkcijskaProdaja.GetAll(); // Console.WriteLine("6"); spn = StavkaProdajeNamestaj.GetAll(); // Console.WriteLine("7"); spdu = StavkaProdajeDU.GetAll(); // Console.WriteLine("8"); }