コード例 #1
0
ファイル: RacunDAO.cs プロジェクト: Zannaa/OOAD
        public List<Racun> getAll()
        {
            DataSet data = manager.ExecuteSqlCommandToDataSet("SELECT * FROM Racun r, Uposlenik u WHERE r.Fakturisao =   u.ID  AND r.Odobrio = u.ID ");

            //čitamo rezultate
            List<Racun> racuni = new List<Racun>();

            foreach (DataRow dataRow in data.Tables[0].Rows)
            {

                Racun racun = new Racun(
                      Convert.ToInt32(dataRow["RacunId"]),
                       Convert.ToInt32(dataRow["Sifra"]),
                       Convert.ToDateTime(dataRow["Vrijeme"]),
                    new Menadzer(

                    Convert.ToString(dataRow["Telefon"]),
                     Convert.ToString(dataRow["Ime"]),
                       Convert.ToString(dataRow["Prezime"]),
                         Convert.ToString(dataRow["Jmbg"]),
                           Convert.ToInt32(dataRow["UposlenikId"]),
                             Convert.ToDouble(dataRow["Koeficijent"])
                                                                 ),
                    new ProdavacHrane(Convert.ToString(dataRow["Pult"]),
                     Convert.ToString(dataRow["Ime"]),
                       Convert.ToString(dataRow["Prezime"]),
                         Convert.ToString(dataRow["Jmbg"]),
                           Convert.ToInt32(dataRow["UposlenikId"]),
                             Convert.ToDouble(dataRow["Koeficijent"])),
                    new List<PrehrambeniProdukt>()
                    );
            }

            return racuni;
        }
コード例 #2
0
ファイル: Racun.cs プロジェクト: Zannaa/OOAD
 /// <summary>
 /// Konstruktor koji prima instancu klase Racun
 /// </summary>
 /// <param name="r"></param>
 public Racun(Racun r)
 {
     this.Id = r.Id;
     this.Sifra =r.Sifra;
     this.Vrijeme = r.Vrijeme;
     this.Menadzer = r.Menadzer;
     this.Prodavac = r.Prodavac;
     this.Produkti = r.Produkti;
 }
コード例 #3
0
ファイル: ProdajaHrane.xaml.cs プロジェクト: Zannaa/OOAD
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            // public Racun(int sifra, DateTime vrijeme, Menadzer menadzer, ProdavacHrane prodavac, List<PrehrambeniProdukt> produkti)
            sifra++;
            MenadzerDAO m = new MenadzerDAO();
            ProdavacHraneDAO pk = new ProdavacHraneDAO();
            Menadzer menadzer = m.getById(id);
            ProdavacHrane prodavac = pk.getById(id);

            double cijena = 0;
            foreach (PrehrambeniProdukt p in kprodukti)
            {

                cijena += p.Cijena;

            }

            if (true == rb1.IsChecked)
            {
                cijena = cijena - cijena * 5 / 100;

            }

            Racun r = new Racun(sifra, DateTime.Now, menadzer, prodavac, kprodukti);
            RacunDAO rdao = new RacunDAO();
            kprodukti.Clear();

            string Datum = Convert.ToDateTime(Datump.SelectedDate).ToString("dd.MM.yyyy");
            string s = "     RACUN      " + Environment.NewLine + "Datum: " + Datum + Environment.NewLine + "Cijena: " + cijena;

            MessageBox.Show(s);
        }
コード例 #4
0
ファイル: RacunDAO.cs プロジェクト: Zannaa/OOAD
        public Racun getById(int id)
        {
            DataSet data = manager.ExecuteSqlCommandToDataSet("SELECT * FROM Racun r, ProdavacHrane ph WHERE r.RacunId = " + id + " and r.ProdavacID = ph.PrehrambeniProduktID ");

            DataSet data2 = manager.ExecuteSqlCommandToDataSet("SELECT * FROM PrehrambeniProdukt ph, RacunProdukt rp, Racun r WHERE rp.RacunId = " + id + " AND rp.ProduktID = ph.Id ");

            List<PrehrambeniProdukt> lista = new List<PrehrambeniProdukt>();
            foreach (DataRow dataRow in data2.Tables[0].Rows)
            {
                PrehrambeniProdukt ph = new PrehrambeniProdukt(
                    Convert.ToInt32(dataRow["PrehrambeniProduktID"]),
                    Convert.ToString(dataRow["Tip"]),
                    Convert.ToDouble(dataRow["Cijena"])
                );

                lista.Add(ph);
            }

            foreach (DataRow dataRow in data.Tables[0].Rows)
            {

                Racun racun = new Racun(
                    Convert.ToInt32(dataRow["RacunId"]),
                     Convert.ToInt32(dataRow["Sifra"]),
                     Convert.ToDateTime(dataRow["Vrijeme"]),
                  new Menadzer(

                  Convert.ToString(dataRow["Telefon"]),
                   Convert.ToString(dataRow["Ime"]),
                     Convert.ToString(dataRow["Prezime"]),
                       Convert.ToString(dataRow["Jmbg"]),
                         Convert.ToInt32(dataRow["UposlenikId"]),
                           Convert.ToDouble(dataRow["Koeficijent"])
                                                               ),
                  new ProdavacHrane(Convert.ToString(dataRow["Pult"]),
                   Convert.ToString(dataRow["Ime"]),
                     Convert.ToString(dataRow["Prezime"]),
                       Convert.ToString(dataRow["Jmbg"]),
                         Convert.ToInt32(dataRow["UposlenikId"]),
                           Convert.ToDouble(dataRow["Koeficijent"])), lista

                );

                return racun;
            }

            return null;
        }
コード例 #5
0
ファイル: RacunDAO.cs プロジェクト: Zannaa/OOAD
        public long create(Racun racun)
        {
            string exec = "INSERT INTO racun VALUES(" + racun.Prodavac + ", " + racun.Menadzer + "," + racun.Sifra + " ," + racun.Vrijeme + ")";

            return manager.ExecuteSqlCommandToIntForCreate(exec);
        }