public bool dodadiNaracka(NarackaView objNarackaView)
{
Naracka objNaracka = new Naracka();
objNaracka.KlientId = objNarackaView.KlientId;
objNaracka.VkupnoPotroseno = objNarackaView.Vkupno;
objNaracka.DatumNaracka = DateTime.Now;
objNaracka.BrojNaracka = String.Format("{0:ddmmmyyyyhhmmss}", DateTime.Now);
objNaracka.TipNaNaplataId = objNarackaView.TipNaNarackaId;
objrestorantDBEntities.Narackas.Add(objNaracka);
objrestorantDBEntities.SaveChanges();
int NarackaId = objNaracka.NarackaId;
foreach (var i in objNarackaView.lista)
{
DetaliNaracka objDetali = new DetaliNaracka();
objDetali.NarackaId = NarackaId;
objDetali.ArtiklId = i.ArtiklId;
objDetali.Vkupno = i.Vkupno;
objDetali.Cena = i.Cena;
objDetali.Kolicina = i.Kolicina;
objrestorantDBEntities.DetaliNarackas.Add(objDetali);
objrestorantDBEntities.SaveChanges();
}
return(true);
}
public override void IncrementOrderNumber(OracleConnection conn, Naracka nar)
{
string updateOnsite = @"update IZVRSHUVA
set IZVRSHENI_NARACHKI = IZVRSHENI_NARACHKI + 1
where VRABOTEN_ID = :VrabotenID
AND RESTORAN_ID = :ResID
AND POZICIJA = 'Келнер'";
OracleCommand cmd = new OracleCommand(updateOnsite, conn);
OracleParameter prm = new OracleParameter("VrabotenID", OracleDbType.Int64);
prm.Value = VrabotenID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("ResID", OracleDbType.Int64);
prm.Value = RestoranID;
cmd.Parameters.Add(prm);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
public OnlineNarackaPodatoci(OracleConnection conn, Naracka nar, Restoran res)
{
InitializeComponent();
Naracka = nar;
Restoran = res;
Rejting = Restoran.Rejting;
lista = new List <PictureBox>();
lista.Add(pbZvezda1);
lista.Add(pbZvezda2);
lista.Add(pbZvezda3);
lista.Add(pbZvezda4);
lista.Add(pbZvezda5);
postaviRejting(Rejting);
Conn = conn;
lblPragZaDostava.Text = Restoran.PragZaDostava.ToString();
if (nar.VkupnaCena < Restoran.PragZaDostava)
{
lblNaplataZaDostava.Text = ((int)Restoran.CenaZaDostava).ToString();
lblVkupno.Text = ((int)Restoran.CenaZaDostava + Naracka.VkupnaCena).ToString();;
}
else
{
lblNaplataZaDostava.Text = "0";
lblVkupno.Text = Naracka.VkupnaCena.ToString();
}
lblNaracano.Text = Naracka.VkupnaCena.ToString();
Opacity = 0;
}
private void pictureBox13_Click(object sender, EventArgs e)
{
if (CurrOrderComponent != null)
{
Naracka.Remove(CurrOrderComponent);
CurrOrderComponent = null;
Naracka = Naracka;
}
}
private void btnOtkazi_Click(object sender, EventArgs e)
{
MessageBoxForm mbf = new MessageBoxForm("Дали навистина сакате да ја откажете нарачката?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
}
Naracka = new Naracka(-1, 0, DateTime.Now);
}
private void pictureBox14_Click(object sender, EventArgs e)
{
if (CurrItem == null)
{
return;
}
OrderComponent oc = new OrderComponent(CurrItem, int.Parse(lblKolicina.Text));
Naracka.Add(oc);
Naracka = Naracka;
}
public OnsiteNarackaPodatoci(OracleConnection conn, Naracka nar, Restoran res)
{
InitializeComponent();
Naracka = nar;
Restoran = res;
Rejting = Restoran.Rejting;
lista = new List <PictureBox>();
lista.Add(pbZvezda1);
lista.Add(pbZvezda2);
lista.Add(pbZvezda3);
lista.Add(pbZvezda4);
lista.Add(pbZvezda5);
postaviRejting(Rejting);
Conn = conn;
BrMasa = 1;
Opacity = 0;
}
public ActionResult DodajKosnica(int productId, int categoryId)//pri klik na "DodajKosnica"
{
//string imeUser = User.Identity.Name;
string currentUserId = User.Identity.GetUserId();
Naracka naracka = new Naracka {
ProduktId = productId, ApplicationUserId = currentUserId, Kolicina = 1, Kupeno = 0, PratkaId = null
};
db.Naracki.Add(naracka);
db.SaveChanges();
List <Produkt> produkti = db.Produkti.Where(p => p.TipId == categoryId).ToList();
List <Naracka> naracki = db.Naracki.Where(n => n.ApplicationUserId == currentUserId && n.Kupeno == 0).ToList();
List <Produkt> naracaniProdukti = new List <Produkt>();
foreach (Naracka nar in naracki)
{
int narProduktId = nar.ProduktId;
Produkt narProdukt = db.Produkti.Find(narProduktId);//Where(p => p.ProduktId == narProduktId);
naracaniProdukti.Add(narProdukt);
}
Produkti_NarProduktiVM obj = new Produkti_NarProduktiVM();
obj.produkti = produkti;
obj.narProdukti = naracaniProdukti;
if (categoryId == 1)
{
return(View("BelaTehnika", obj));
}
//else if (categoryId == 2)
//{
// return View("Hrana");
//}
else if (categoryId == 3)
{
return(View("Nakit", obj));
}
else
{
return(View("Obleka", obj));
}
}
private void btnPotvrdi_Click(object sender, EventArgs e)
{
MessageBoxForm mbf = new MessageBoxForm("Дали сакате достава?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
OnlineNarackaPodatoci onp = new OnlineNarackaPodatoci(Conn, Naracka, Restoran);
if (onp.ShowDialog() == DialogResult.Yes)
{
Naracka = new Naracka(-1, 0, DateTime.Now);
}
}
else
{
OnsiteNarackaPodatoci onp = new OnsiteNarackaPodatoci(Conn, Naracka, Restoran);
if (onp.ShowDialog() == DialogResult.Yes)
{
Naracka = new Naracka(-1, 0, DateTime.Now);
}
}
}
public IzvrsuvanjeNaracka(Restoran restoran, OracleConnection conn)
{
InitializeComponent();
LoadingSemaphore = new Semaphore(0, 100);
Restoran = restoran;
Conn = conn;
OrderList = new List <OrderComponent>();
Opacity = 0;
// Вчитување на мени за ресторанот
Thread oThread = new Thread(new ThreadStart(KreirajMeni));
oThread.Start();
// Вчитување на лого за ресторанот
oThread = new Thread(new ThreadStart(LoadLogo));
oThread.Start();
this.AddButtons();
Naracka = new Naracka(-1, 0, DateTime.Now);
this.lblImeRestoran.Text = String.Format("{0} ", Restoran.Ime);
if (this.Restoran.Ulica != null && this.Restoran.Grad != null)
{
this.lblAdresa.Text = String.Format("{0}, {1} ", Restoran.Ulica, Restoran.Grad);
}
if (this.Restoran.RabotnoVreme != null)
{
this.lblRabVreme.Text = this.Restoran.RabotnoVreme + " ";
}
if (Restoran.PicturePath == null)
{
pictureBoxLogo.Image = Resources.FASAP_LOGO;
}
}
public abstract void IncrementOrderNumber(OracleConnection conn, Naracka nar);
public override void IncrementOrderNumber(Oracle.DataAccess.Client.OracleConnection conn, Naracka nar)
{
throw new NotImplementedException();
}
