public static void Delete(DodatnaUsluga du) { du.Obrisan = true; Update(du); }
public static void Obrisi(DodatnaUsluga du) { du.Obrisan = true; Izmeni(du); }
public static ObservableCollection <ProdajaNamjestaja> GetAll() { try { var prodaja = new ObservableCollection <ProdajaNamjestaja>(); 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 Prodaja WHERE Obrisan = 0;"; da.SelectCommand = cmd; da.Fill(ds, "Prodaja"); foreach (DataRow row in ds.Tables["Prodaja"].Rows) { var p = new ProdajaNamjestaja(); p.Id = int.Parse(row["Id"].ToString()); p.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString()); p.BrojRacuna = row["BrojRacuna"].ToString(); p.Kupac = row["Kupac"].ToString(); p.UkupanIznos = double.Parse(row["UkupanIznos"].ToString()); p.Obrisan = bool.Parse(row["Obrisan"].ToString()); DataSet ds3 = new DataSet(); SqlCommand cmd3 = con.CreateCommand(); cmd3.CommandText = "SELECT UslugaId FROM ProdateUsluge WHERE PId=@Id;"; cmd3.Parameters.AddWithValue("@Id", p.Id); da.SelectCommand = cmd3; da.Fill(ds3, "ProdateUsluge"); ObservableCollection <DodatnaUsluga> usluga = new ObservableCollection <DodatnaUsluga>(); foreach (DataRow dr1 in ds3.Tables["ProdateUsluge"].Rows) { int id = int.Parse(dr1["UslugaId"].ToString()); usluga.Add(DodatnaUsluga.GetById(id)); } p.DodatnaU = usluga; prodaja.Add(p); DataSet ds2 = new DataSet(); SqlCommand cmd2 = con.CreateCommand(); cmd2.CommandText = "SELECT NId FROM Stavka WHERE PId=@Id;"; cmd2.Parameters.AddWithValue("@Id", p.Id); da.SelectCommand = cmd2; da.Fill(ds2, "Stavka"); foreach (DataRow dr in ds2.Tables["Stavka"].Rows) { Stavke s = new Stavke() { Id = int.Parse(dr["StId"].ToString()), Kolicina = int.Parse(dr["Kolicina"].ToString()), NamjestajID = int.Parse(dr["NId"].ToString()), Obrisan = bool.Parse(dr["Obrisan"].ToString()) }; p.NamjestajPro.Add(s); } prodaja.Add(p); } } return(prodaja); } catch (Exception) { MessageBox.Show("Greska prilikom ucitavanja prodaje namjestaja!", "Info", MessageBoxButton.OK, MessageBoxImage.Information); return(null); } }