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