public static ProdajaNamestaja Create(ProdajaNamestaja tn) { try { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "INSERT INTO Prodaja (DatumProdaje, BrojRacuna, Kupac, UkupanIznos) VALUES (@DatumProdaje, @BrojRacuna, @Kupac, @UkupanIznos);"; cmd.CommandText += "SELECT SCOPE_IDENTITY();"; cmd.Parameters.AddWithValue("DatumProdaje", tn.DatumProdaje); cmd.Parameters.AddWithValue("BrojRacuna", tn.BrojRacuna); cmd.Parameters.AddWithValue("Kupac", tn.Kupac); cmd.Parameters.AddWithValue("UkupanIznos", tn.UkupanIznos); tn.Id = int.Parse(cmd.ExecuteScalar().ToString()); } Projekat.Instance.ProdajeNamestaja.Add(tn); return(tn); } catch (Exception) { MessageBoxResult obavestenje = MessageBox.Show("Doslo je do greske.", "Obavestenje", MessageBoxButton.OK); return(null); } }
public static ObservableCollection <ProdajaNamestaja> Search(string srchtext, string sorttext) { var prodaje = new ObservableCollection <ProdajaNamestaja>(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); string selectCommand = "SELECT * FROM Prodaja WHERE Kupac LIKE @srchtext OR DatumProdaje LIKE @srchtext OR UkupanIznos LIKE @srchtext ORDER BY "; selectCommand += sorttext; cmd.CommandText = selectCommand; cmd.Parameters.AddWithValue("@srchtext", "%" + srchtext + "%"); da.SelectCommand = cmd; da.Fill(ds, "Prodaja"); foreach (DataRow row in ds.Tables["Prodaja"].Rows) { var tn = new ProdajaNamestaja(); tn.Id = Convert.ToInt32(row["Id"]); tn.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString()); tn.BrojRacuna = Convert.ToInt32(row["BrojRacuna"]); tn.Kupac = row["Kupac"].ToString(); tn.UkupanIznos = double.Parse(row["UkupanIznos"].ToString()); prodaje.Add(tn); } return(prodaje); } }
public static ObservableCollection <ProdajaNamestaja> GetAll() { var prodaje = new ObservableCollection <ProdajaNamestaja>(); 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;"; da.SelectCommand = cmd; da.Fill(ds, "Prodaja"); foreach (DataRow row in ds.Tables["Prodaja"].Rows) { var tn = new ProdajaNamestaja(); tn.Id = Convert.ToInt32(row["Id"]); tn.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString()); tn.BrojRacuna = Convert.ToInt32(row["BrojRacuna"]); tn.Kupac = row["Kupac"].ToString(); tn.UkupanIznos = double.Parse(row["UkupanIznos"].ToString()); prodaje.Add(tn); } } return(prodaje); }
private Projekat() { Namestaji = Namestaj.GetAll(); TipoviNamestaja = TipNamestaja.GetAll(); Korisnici = Korisnik.GetAll(); DodatneUsluge = DodatnaUsluga.GetAll(); ProdajeNamestaja = ProdajaNamestaja.GetAll(); StavkeProdaje = StavkaProdaje.GetAll(); UslugeProdaje = UslugaProdaje.GetAll(); Akcije = Akcija.GetAll(); NaAkcijama = NaAkciji.GetAll(); Saloni = Salon.GetAll(); }
public static void Delete(ProdajaNamestaja p) { using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "DELETE FROM Prodaja WHERE Id=@Id;"; cmd.CommandText += "SELECT SCOPE_IDENTITY();"; cmd.Parameters.AddWithValue("Id", p.Id); cmd.ExecuteNonQuery(); } }
public static void Update(ProdajaNamestaja tn) { try { //azuriranje baze using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "UPDATE Prodaja SET DatumProdaje = @DatumProdaje, BrojRacuna = @BrojRacuna, " + "Kupac = @Kupac, UkupanIznos = @UkupanIznos WHERE Id=@Id;"; 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("UkupanIznos", tn.UkupanIznos); cmd.ExecuteNonQuery(); } //azuriranje modela foreach (var tip in Projekat.Instance.ProdajeNamestaja) { if (tn.Id == tip.Id) { tip.DatumProdaje = tn.DatumProdaje; tip.BrojRacuna = tn.BrojRacuna; tip.Kupac = tn.Kupac; tip.UkupanIznos = tn.UkupanIznos; } } } catch (Exception) { } }