public static void Create(ProdajaDodatnaUsluga prodajaDodatnaUsluga) { try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"INSERT INTO ProdajaDodatnaUsluga (ProdajaId, DodatnaUslugaId, Cena, Obrisan) " + "VALUES (@ProdajaId, @DodatnaUslugaId, @Cena, @Obrisan);"; cmd.CommandText += "SELECT SCOPE_IDENTITY();"; cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaDodatnaUsluga.ProdajaId)); cmd.Parameters.Add(new SqlParameter("@DodatnaUslugaId", prodajaDodatnaUsluga.DodatnaUslugaId)); cmd.Parameters.Add(new SqlParameter("@Cena", prodajaDodatnaUsluga.Cena)); cmd.Parameters.Add(new SqlParameter("@Obrisan", prodajaDodatnaUsluga.Obrisan)); prodajaDodatnaUsluga.Id = int.Parse(cmd.ExecuteScalar().ToString()); } Projekat.Instance.ProdajaDodatneUsluge.Add(prodajaDodatnaUsluga); } catch (Exception) { MessageBox.Show("Doslo je do greske prilikom snimanja u bazu, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information); } }
public static void Load() { try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * " + "FROM ProdajaDodatnaUsluga " + "WHERE Obrisan = 0; "; SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = cmd; DataSet dsA = new DataSet(); // izvrsavanje upita sqlDA.Fill(dsA, "ProdajaDodatnaUsluga"); foreach (DataRow row in dsA.Tables["ProdajaDodatnaUsluga"].Rows) { ProdajaDodatnaUsluga prodajaDodatnaUsluga = new ProdajaDodatnaUsluga(); prodajaDodatnaUsluga.Id = int.Parse(row["IdPDU"].ToString()); prodajaDodatnaUsluga.DodatnaUslugaId = int.Parse(row["DodatnaUslugaId"].ToString()); prodajaDodatnaUsluga.ProdajaId = int.Parse(row["ProdajaId"].ToString()); prodajaDodatnaUsluga.Obrisan = Boolean.Parse(row["Obrisan"].ToString()); prodajaDodatnaUsluga.Cena = double.Parse(row["Cena"].ToString()); Projekat.Instance.ProdajaDodatneUsluge.Add(prodajaDodatnaUsluga); } foreach (var prodaja in Projekat.Instance.Prodaja) { if (prodaja.ListaDodatnihUslugaId == null) { prodaja.ListaDodatnihUslugaId = new ObservableCollection <int?>(); } foreach (var dodatnaUsluga in Projekat.Instance.ProdajaDodatneUsluge) { if (prodaja.Id == dodatnaUsluga.ProdajaId) { prodaja.ListaDodatnihUslugaId.Add(dodatnaUsluga.Id); } } } } } catch (Exception) { MessageBox.Show("Doslo je do greske prilikom ucitavanje iz baze, Molimo vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information); } }
public static void Delete(ProdajaDodatnaUsluga prodajaDodatnaUsluga, TipBrisanja tipBrisanja, int prodajaId) { try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); switch (tipBrisanja) { case TipBrisanja.ProdajaId: cmd.CommandText = @"UPDATE ProdajaDodatnaUsluga SET Obrisan = 1 WHERE ProdajaId=@ProdajaId"; cmd.Parameters.Add(new SqlParameter("@Obrisan", prodajaDodatnaUsluga.Obrisan)); cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaId)); var i = cmd.ExecuteNonQuery(); break; case TipBrisanja.ProdajaDodatnaUsluga: cmd.CommandText = @"UPDATE ProdajaDodatnaUsluga SET Obrisan = 1 " + "WHERE IdPDU=@IdPDU"; cmd.Parameters.Add(new SqlParameter("@IdPDU", prodajaDodatnaUsluga.Id));; var ii = cmd.ExecuteNonQuery(); break; } foreach (var pdu in Projekat.Instance.ProdajaDodatneUsluge) { if (pdu.Id == prodajaDodatnaUsluga.Id) { pdu.Obrisan = true; } } } } catch (Exception) { MessageBox.Show("Doslo je do greske prilikom snimanja u bazu, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information); } }
public static ObservableCollection <ProdajaDodatnaUsluga> LoadByProdajaId(int prodajaId) { try { var lista = new ObservableCollection <ProdajaDodatnaUsluga>(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * " + "FROM ProdajaDodatnaUsluga " + "WHERE Obrisan = 0 and ProdajaId=@ProdajaId;"; SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = cmd; cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaId)); DataSet dsA = new DataSet(); // izvrsavanje upita sqlDA.Fill(dsA, "ProdajaDodatnaUsluga"); foreach (DataRow row in dsA.Tables["ProdajaDodatnaUsluga"].Rows) { ProdajaDodatnaUsluga prodajaDodatnaUsluga = new ProdajaDodatnaUsluga(); prodajaDodatnaUsluga.Id = int.Parse(row["IdPDU"].ToString()); prodajaDodatnaUsluga.DodatnaUslugaId = int.Parse(row["DodatnaUslugaId"].ToString()); prodajaDodatnaUsluga.ProdajaId = int.Parse(row["ProdajaId"].ToString()); prodajaDodatnaUsluga.Obrisan = Boolean.Parse(row["Obrisan"].ToString()); prodajaDodatnaUsluga.Cena = double.Parse(row["Cena"].ToString()); lista.Add(prodajaDodatnaUsluga); } } return(lista); } catch (Exception) { MessageBox.Show("Doslo je do greske prilikom citanja iz baze, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information); return(null); } }
public static void Update(ProdajaDodatnaUsluga prodajaDodatnaUsluga) { try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"UPDATE ProdajaDodatnaUsluga SET ProdajaId=@ProdajaId , DodatnaUslugaId=@DodatnaUslugaId, Cena=@Cena, Obrisan=@Obrisan " + "WHERE IdPDU=@IdPDU;"; cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaDodatnaUsluga.ProdajaId)); cmd.Parameters.Add(new SqlParameter("@DodatnaUslugaId", prodajaDodatnaUsluga.DodatnaUslugaId)); cmd.Parameters.Add(new SqlParameter("@Cena", prodajaDodatnaUsluga.Cena)); cmd.Parameters.Add(new SqlParameter("@Obrisan", prodajaDodatnaUsluga.Obrisan)); cmd.Parameters.Add(new SqlParameter("@IdPDU", prodajaDodatnaUsluga.Id)); var uu = cmd.ExecuteNonQuery(); foreach (var pdu in Projekat.Instance.ProdajaDodatneUsluge) { if (prodajaDodatnaUsluga.Id == pdu.Id) { pdu.DodatnaUslugaId = prodajaDodatnaUsluga.DodatnaUslugaId; pdu.Cena = prodajaDodatnaUsluga.Cena; pdu.Obrisan = prodajaDodatnaUsluga.Obrisan; } } } } catch (Exception) { MessageBox.Show("Doslo je do greske prilikom snimanja u bazu, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information); } }