public static bool removeOrderMenuAll(int a1)
{
try
{
enKosar rendeles = (from x in cnDB.enKosarSet where x.rendelesID == a1 select x).FirstOrDefault();
var toDelete = (from x in cnDB.enMenuSet where x.enRendeles == rendeles select x);
if (toDelete == null)
{
return(false);
}
if (toDelete.ToList().Count <= 0)
{
return(false);
}
foreach (enMenu m in toDelete.ToList())
{
cnDB.enMenuSet.Remove(m);
}
cnDB.SaveChanges();
return(true);
}
catch (Exception) { }
return(false);
}
public static bool addOrderMenu(int a1, string a2, int a3)
{
try
{
var tmp = from x in cnDB.enKosarSet where x.rendelesID == a1 select x;
enKosar kosar = tmp.FirstOrDefault();
var tmp2 = from x in cnDB.enNetelekSet where x.napietelekID == a3 select x;
enNetelek etel = tmp2.FirstOrDefault();
enMenu menu = new enMenu()
{
foetel = a2,
enRendeles = kosar,
enNetelek = etel
};
cnDB.enMenuSet.Add(menu);
cnDB.SaveChanges();
return(true);
}
catch (Exception) { }
return(false);
}
public static bool addOrderFood(int a1, DateTime a2, int a3)
{
try
{
var tmp = from x in cnDB.enKosarSet where x.rendelesID == a1 select x;
enKosar kosar = tmp.FirstOrDefault();
var tmp2 = from x in cnDB.enEtelekSet where x.etelekID == a3 select x;
enEtelek etel = tmp2.FirstOrDefault();
enAlacarte alac = new enAlacarte()
{
datum = a2,
enRendeles = kosar,
enEtelek = etel
};
cnDB.enAlacarteSet.Add(alac);
cnDB.SaveChanges();
return(true);
}
catch (Exception) { }
return(false);
}
public static bool removeOrder(int a1)
{
try
{
enKosar toRemove = (from x in cnDB.enKosarSet where x.rendelesID == a1 select x).FirstOrDefault();
cnDB.enKosarSet.Remove(toRemove);
cnDB.SaveChanges();
return(true);
}
catch (Exception) { }
return(false);
}
private void dgOrders_SelectionChanged(object sender, SelectionChangedEventArgs e) //ha kevesebb mint 24 oraja rendelt, meg valtoztathat
{
if (dgOrders.SelectedIndex != -1)
{
enKosar sel = ((enKosar)dgOrders.SelectedItem);
TimeSpan ts = (TimeSpan)(DateTime.Now - sel.rendelesido);
if (ts.TotalMinutes < 1440)
{
btDeleteOrder.Visibility = Visibility.Visible;
return;
}
}
btDeleteOrder.Visibility = Visibility.Hidden;
}
private void btDeleteOrder_Click(object sender, RoutedEventArgs e) //rendeles torlese
{
if (dgOrders.SelectedIndex == -1)
{
return;
}
if (MessageBox.Show("Biztosan törli a megrendelést?", "", MessageBoxButton.YesNoCancel, MessageBoxImage.Question) != MessageBoxResult.Yes)
{
return;
}
enKosar sel = ((enKosar)dgOrders.SelectedItem);
Lib.removeOrderFoodAll(sel.rendelesID);
Lib.removeOrderMenuAll(sel.rendelesID);
Lib.removeOrder(sel.rendelesID);
MessageBox.Show("Megrendelés törölve!");
Betolt();
}
public static int uploadOrder(int a1, DateTime a2, int a3)
{
try
{
var tmp = from x in cnDB.enFelhasznaloSet where x.felhasznaloID == a3 select x;
enFelhasznalo felhasz = tmp.FirstOrDefault();
enKosar kosar = new enKosar()
{
szamla = a1,
rendelesido = a2,
enFelhasznalo = felhasz
};
cnDB.enKosarSet.Add(kosar);
cnDB.SaveChanges();
int id = (from x in cnDB.enKosarSet select x).OrderByDescending(a => a.rendelesID).FirstOrDefault().rendelesID;
return(id);
}
catch (Exception) { }
return(-1);
}
