Example #1
0
        private void buttonFASAP2_Click(object sender, EventArgs e)
        {
            if (!ValidateChildren())
            {
                return;
            }
            if (isVoted)
            {
                string updateOnsite = @"UPDATE RESTORAN
                                        SET REJTING = ((REJTING * PRIMEROK) + :Rejting) / (PRIMEROK + 1), PRIMEROK = PRIMEROK + 1
                                        WHERE RESTORAN_ID = :ResID";

                OracleCommand cmd = new OracleCommand(updateOnsite, Conn);

                OracleParameter prm = new OracleParameter("Rejting", OracleDbType.Double);
                prm.Value = Rejting;
                cmd.Parameters.Add(prm);

                prm       = new OracleParameter("ResID", OracleDbType.Int64);
                prm.Value = Restoran.RestoranID;
                cmd.Parameters.Add(prm);

                int br;
                try
                {
                    br = cmd.ExecuteNonQuery();
                }
                catch (Exception)
                {
                }
            }
            Online online = new Online(Naracka.NarackaID, Naracka.VkupnaCena, DateTime.Now, String.Format("{0} \"{1}\"", tbNaselenoMesto.Text, tbAdresa.Text), tbKontakt.Text, tbIme.Text, tbPrezime.Text, 0);

            online.Stavki = Naracka.Stavki;
            if (online.VkupnaCena < Restoran.PragZaDostava)
            {
                online.VkupnaCena   += (int)Restoran.CenaZaDostava;
                online.CenaZaDostava = (int)Restoran.CenaZaDostava;
            }
            else
            {
                online.CenaZaDostava = 0;
            }
            online.SqlInsert(Conn, Restoran.RestoranID);
            UspesnostNaNaracka up = new UspesnostNaNaracka();

            up.ShowDialog();
            DialogResult = DialogResult.Yes;
        }
Example #2
0
        private void buttonFASAP2_Click(object sender, EventArgs e)
        {
            if (isVoted)
            {
                string updateOnsite = @"UPDATE RESTORAN
                                        SET REJTING = ((REJTING * PRIMEROK) + :Rejting) / (PRIMEROK + 1), PRIMEROK = PRIMEROK + 1
                                        WHERE RESTORAN_ID = :ResID";

                OracleCommand cmd = new OracleCommand(updateOnsite, Conn);

                OracleParameter prm = new OracleParameter("Rejting", OracleDbType.Double);
                prm.Value = Rejting;
                cmd.Parameters.Add(prm);

                prm       = new OracleParameter("ResID", OracleDbType.Int64);
                prm.Value = Restoran.RestoranID;
                cmd.Parameters.Add(prm);

                int br;
                try
                {
                    br = cmd.ExecuteNonQuery();
                }
                catch (Exception)
                {
                }
            }
            Onsite online = new Onsite(Naracka.NarackaID, Naracka.VkupnaCena, DateTime.Now, BrMasa);

            online.Stavki = Naracka.Stavki;
            online.SqlInsert(Conn, Restoran.RestoranID);
            UspesnostNaNaracka up = new UspesnostNaNaracka();

            up.ShowDialog();
            DialogResult = DialogResult.Yes;
        }