public static void UcitajStavkeRacuna(Racun racun, int Id_Racun) { using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING)) { conn.Open(); DataSet ds = new DataSet(); SqlCommand command = conn.CreateCommand(); command.CommandText = $"SELECT * FROM StavkaProdajeNamestaja s WHERE s.Id_Racun=@Id_Racun "; command.Parameters.Add(new SqlParameter("@Id_Racun", Id_Racun)); SqlDataAdapter daStavkaNamestaja = new SqlDataAdapter(); daStavkaNamestaja.SelectCommand = command; daStavkaNamestaja.Fill(ds, "StavkaProdajeNamestaja"); Projekat.Instance.StavkaProdajeNamestaja.Clear(); foreach (DataRow row in ds.Tables["StavkaProdajeNamestaja"].Rows) { StavkaProdajeNamestaja s = new StavkaProdajeNamestaja(); s.Id = (int)row["Id"]; s.Id_Namestaj = (int)row["Id_Namestaj"]; s.Id_Racun = (int)row["Id_Racun"]; s.Kolicina = (int)row["Kolicina"]; s.Popust = (int)(row["Popust"]); s.Namestaj = Namestaj.GetById(s.Id_Namestaj); racun.listaStavkiNamestaja.Add(s); } } }
public static void IzmeniNamestaj(Namestaj namestaj) { using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING)) { try { if (namestaj.Id != 0)//ako namestaj postoji u bazi { conn.Open(); SqlCommand command = conn.CreateCommand(); command.CommandText = @"UPDATE Namestaj SET NAZIV=@Naziv, Sifra=@Sifra,Cena=@Cena,Kolicina=@Kolicina, Obrisan=@Obrisan,IdTip=@IdTip WHERE Id=@Id"; command.Parameters.Add(new SqlParameter("@Naziv", namestaj.Naziv)); command.Parameters.Add(new SqlParameter("@Sifra", namestaj.Sifra)); command.Parameters.Add(new SqlParameter("@Cena", namestaj.Cena)); command.Parameters.Add(new SqlParameter("@Kolicina", namestaj.Kolicina)); command.Parameters.Add(new SqlParameter("@Obrisan", namestaj.Obrisan)); command.Parameters.Add(new SqlParameter("@IdTip", namestaj.IdTip)); command.Parameters.Add(new SqlParameter("@Id", namestaj.Id)); command.ExecuteNonQuery(); } } catch (Exception) { Console.WriteLine("Nije uspela sql naredba"); return; } } }
public static void ObrisiNamestaj(Namestaj namestaj) { using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING)) { try { if (namestaj.Id != 0)//ako namestaj postoji u bazi { conn.Open(); SqlCommand command = conn.CreateCommand(); command.CommandText = @"DELETE FROM Namestaj WHERE Id=@Id"; command.Parameters.Add(new SqlParameter("@Id", namestaj.Id)); command.ExecuteNonQuery(); } } catch (Exception) { Console.WriteLine("Nije uspela sql naredba"); return; } } }
public static void DodajNamestaj(Namestaj namestaj) { using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING)) { try { conn.Open(); SqlCommand command = conn.CreateCommand(); command.CommandText = @"INSERT INTO Namestaj (Naziv, Sifra,Cena,Kolicina,Obrisan,IdTip) VALUES (@Naziv, @Sifra,@Cena,@Kolicina,@Obrisan,@IdTip)"; command.Parameters.Add(new SqlParameter("@Naziv", namestaj.Naziv)); command.Parameters.Add(new SqlParameter("@Sifra", namestaj.Sifra)); command.Parameters.Add(new SqlParameter("@Cena", namestaj.Cena)); command.Parameters.Add(new SqlParameter("@Kolicina", namestaj.Kolicina)); command.Parameters.Add(new SqlParameter("@Obrisan", namestaj.Obrisan)); command.Parameters.Add(new SqlParameter("@IdTip", namestaj.IdTip)); command.ExecuteNonQuery(); } catch (Exception) { Console.WriteLine("Nije uspela sql naredba"); return; } } }
public StavkaProdajeNamestaja(int Id, int Id_Racun, Namestaj namestaj, int Kolicina, int Id_Namestaj, int Popust) { this.Id = Id; this.Id_Racun = Id_Racun; this.namestaj = namestaj; this.Kolicina = Kolicina; this.Id_Namestaj = Id_Namestaj; this.Popust = Popust; }
public Object Clone() { Namestaj kopija = new Namestaj(); kopija.Id = Id; kopija.IdTip = IdTip; kopija.Naziv = Naziv; kopija.TipNamestaja = TipNamestaja; kopija.Cena = Cena; kopija.Obrisan = Obrisan; kopija.Sifra = Sifra; kopija.Kolicina = Kolicina; return(kopija); }
public static void UcitajNamestaj() { using (SqlConnection connection = new SqlConnection(Projekat.CONNECTION_STRING)) { try { connection.Open(); DataSet ds = new DataSet(); SqlCommand namestajCommand = connection.CreateCommand(); namestajCommand.CommandText = @"SELECT * FROM Namestaj "; SqlDataAdapter daNamestaj = new SqlDataAdapter(); daNamestaj.SelectCommand = namestajCommand; daNamestaj.Fill(ds, "Namestaj"); foreach (DataRow row in ds.Tables["Namestaj"].Rows) { Namestaj n = new Namestaj(); n.Id = (int)row["Id"]; n.Sifra = (string)row["Sifra"]; n.Naziv = (string)row["Naziv"]; n.Cena = Convert.ToDouble(row["Cena"]); n.Kolicina = (int)row["Kolicina"]; n.IdTip = (int)row["IdTip"]; n.TipNamestaja = TipNamestaja.GetById(n.IdTip); n.Obrisan = (bool)row["Obrisan"]; Projekat.Instance.Namestaj.Add(n); } } catch (Exception) { Console.WriteLine("Nije uspela sql naredba"); return; } } }
public static void UcitajAktuelneAkcije() { using (SqlConnection connection = new SqlConnection(Projekat.CONNECTION_STRING)) { try { connection.Open(); string date = Convert.ToString(DateTime.Today); DataSet ds = new DataSet(); SqlCommand namestajCommand = connection.CreateCommand(); namestajCommand.CommandText = @"SELECT * FROM Akcija Where " + date + " BETWEEN DatumPocetka AND DatumZavrsetka "; SqlDataAdapter daNamestaj = new SqlDataAdapter(); daNamestaj.SelectCommand = namestajCommand; daNamestaj.Fill(ds, "Akcija"); foreach (DataRow row in ds.Tables["Akcija"].Rows) { Akcija n = new Akcija(); n.Id = (int)row["Id"]; n.DatumPocetka = (DateTime)row["DatumPocetka"]; n.DatumZavrsetka = (DateTime)row["DatumZavrsetka"]; n.Popust = (int)row["Popust"]; n.IdNamestaj = (int)row["IdNamestaj"]; n.Namestaj = Namestaj.GetById(n.IdNamestaj); n.Obrisan = (bool)row["Obrisan"]; Projekat.Instance.Akcija.Add(n); } } catch (Exception) { Console.WriteLine("Nije uspela sql naredba"); return; } } }
public override string ToString() { return($"{Namestaj.GetById(IdNamestaj).Naziv},{Popust},{datumPocetka},{DatumZavrsetka}"); }
public Akcija(int Id, int IdNamestaj, DateTime DatumPocetka, DateTime DatumZavrsetka, Namestaj Namestaj, int Popust, bool Obrisan) { this.Id = Id; this.IdNamestaj = IdNamestaj; this.DatumPocetka = DatumPocetka; this.DatumZavrsetka = DatumZavrsetka; this.Namestaj = Namestaj; this.Popust = Popust; this.Obrisan = Obrisan; }