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; }
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; }