internal void DeleteAlergen(Alergen selectedAlergen, Cont user)
{
context.StergeAlergen(selectedAlergen.denumire);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new AlergenViewModel(user);
MessageBox.Show("Alergen Sters!");
}
internal void DeleteCategorie(Cont user, Categorie categorie)
{
context.StergeCategorie(categorie.denumire);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new CategoriiViewModel(user);
MessageBox.Show("Categorie Stearsa!");
}
public void Adauga(Cont user, int id, string denumire, double pret, double cantitate, double cantitate_Totala, Categorie categorie)
{
RestaurantEntities1 context = new RestaurantEntities1();
if (prepContext.ExistingRecord == false)
{
var preparate = context.Preparats.ToList();
List <string> listaPreparate = new List <string>();
foreach (var preparatNou in preparate)
{
listaPreparate.Add(preparatNou.denumire);
}
if (listaPreparate.Contains(denumire) == false)
{
context.AdaugarePreparatCategorie(categorie.denumire, denumire, pret, cantitate, cantitate_Totala);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new PreparateViewModel("Toate categoriile", user);
System.Windows.MessageBox.Show("Preparat Adaugat!");
}
else
{
MessageBox.Show("Preparatul deja exista!");
}
}
else
{
var preparate = context.Preparats.ToList();
Preparat preparat1 = new Preparat();
foreach (var preparat in preparate)
{
if (preparat.id_preparat == id)
{
preparat1 = preparat;
}
}
if (categorie == null)
{
MessageBox.Show("Selectati o categorie!");
}
else
{
context.ModificaPreparat(id, denumire, pret, cantitate, cantitate_Totala, categorie.id_categorie);
context.SaveChanges();
MessageBox.Show("Preparat Modificat!");
MainViewModel.Instance.ActiveScreen = new PreparateViewModel("Toate categoriile", user);
}
}
}
internal void StergePoza(int idPreparat, Fotografie pozaDeSters)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergePoza(pozaDeSters.id_foto, idPreparat);
context.SaveChanges();
}
public void SignUp(string name, string password, bool statut)
{
RestaurantEntities1 context = new RestaurantEntities1();
var conturi = context.Conts.ToList();
bool contExistent = false;
foreach (var cont in conturi)
{
if (cont.email == name)
{
MessageBox.Show("Cont deja creat!");
contExistent = true;
}
}
if (contExistent == false)
{
if (statut == true)
{
context.AdaugareCont(name, password, "Angajat");
}
else
{
context.AdaugareCont(name, password, "Client");
}
context.SaveChanges();
MessageBox.Show("Cont creat cu succes!");
MainViewModel.Instance.ActiveScreen = new LoginViewModel();
}
}
internal void TrimiteComanda(Cont user)
{
bool activeCont = false;
RestaurantEntities1 context = new RestaurantEntities1();
foreach (var cont in context.DetaliiConts.ToList())
{
if (cont.id_cont == user.id_cont)
{
activeCont = true;
}
}
if (activeCont == true)
{
context.TrimiteComanda(user.email);
var comenzi = context.Comandas.ToList();
context.AdaugareComanda(0, user.email, DateTime.Now);
context.SaveChanges();
MessageBox.Show("Comanda trimisa!");
MainViewModel.Instance.ActiveScreen = new PreparateViewModel("Toate categoriile", user);
}
else
{
MessageBox.Show("Sunt necesare mai multe detalii!");
MainViewModel.Instance.ActiveScreen = new AdaugaDetaliiContViewMode(user);
}
}
internal void DeleteAlergen(Alergen alergenAles, Preparat preparatAles)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergeAlergenDupaID(alergenAles.id_alergen, preparatAles.id_preparat);
context.SaveChanges();
}
//public void AddMethod(object obj)
//{
// //parametrul obj este cel dat prin CommandParameter cu MultipleBinding la Button in xaml
// AlergenPreparatViewModel personVM = obj as AlergenPreparatViewModel;
// //DetaliiPreparatViewModel personVMa = obj as DetaliiPreparatViewModel;
// if (personVM != null)
// {
// Preparat preparat = context.Preparats.SqlQuery("[AfisarePreparatDupaID] @id_preparat", new SqlParameter("id_preparat", Properties.Settings.Default.id_preparat)).First();
// context.AdaugareAlergenPreparat(personVM.Denumire,preparat.denumire);
// //context.persoanes.Add(new persoane() { nume = personVM.Name , adresa = personVM.Address});
// context.SaveChanges();
// prepContext.Alergeni = AllAlergens();
// MainViewModel.Instance.ActiveScreen = new DetaliiPreparatViewModel();
// }
// }
internal void AdaugaAlergenPreparat(Preparat preparatAles, Alergen alergenAles, Cont User)
{
context.AdaugareAlergenPreparat(alergenAles.denumire, preparatAles.denumire);
//context.persoanes.Add(new persoane() { nume = personVM.Name , adresa = personVM.Address});
context.SaveChanges();
//prepContext.Alergeni = AllAlergens();
MainViewModel.Instance.ActiveScreen = new DetaliiPreparatViewModel(preparatAles, User);
}
public void StergeMeniu(Meniu meniuAles, Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergeMeniu(meniuAles.denumireMeniu);
context.SaveChanges();
MessageBox.Show("Meniu Sters!");
MainViewModel.Instance.ActiveScreen = new MeniuViewModel(user);
}
internal void DeletePreparatAlergen(Alergen alergenAles, Preparat preparatAles, Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergeAlergenDupaID(alergenAles.id_alergen, preparatAles.id_preparat);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new DetaliiPreparatViewModel(preparatAles, user);
MessageBox.Show("Alergen Sters!");
}
internal void Delete(int id, Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergePreparat2(id);
context.SaveChanges();
MainViewModel.Instance.ActiveScreen = new PreparateViewModel("Toate categoriile", user);
MessageBox.Show("Preparat Sters!");
}
public void LogIn(string name, string password)
{
RestaurantEntities1 context = new RestaurantEntities1();
var conturi = context.Conts.ToList();
bool contExistent = false;
foreach (var cont in conturi)
{
if (cont.email == name)
{
if (cont.parola == password)
{
var comenzi = context.Comandas.ToList();
bool comandaNoua = true;
foreach (var comanda in comenzi)
{
if (comanda.Cont.email == cont.email && comanda.id_status == 505)
{
comandaNoua = false;
break;
}
}
if (comandaNoua == true)
{
context.AdaugareComanda(0, cont.email, DateTime.Now);
context.SaveChanges();
}
MessageBox.Show("Bun venit!");
MainViewModel.Instance.ActiveScreen = new PreparateViewModel("Toate categoriile", cont);
}
else
{
MessageBox.Show("Parola gresita!");
}
contExistent = true;
}
}
if (contExistent == false)
{
MessageBox.Show("Cont inexistent!");
}
}
public void AdaugaInCos(Cont user, Meniu preparatAles, int cantitate)
{
RestaurantEntities1 context = new RestaurantEntities1();
var comenzi = context.Comandas.ToList();
int idComanda = 0;
foreach (var comanda in comenzi)
{
if (comanda.Cont.email == user.email && comanda.id_status == 505)
{
idComanda = comanda.id_comanda;
break;
}
}
context.AdaugareMeniuInComanda(idComanda, preparatAles.denumireMeniu, cantitate);
context.SaveChanges();
MessageBox.Show("Meniu Adaugat!");
}
public void SalveazaMeniu(Cont user, Meniu meniuAles, bool existingRecord, double discount, string numeMeniu, ObservableCollection <Preparat> listaPreparateDinMeniu, double pretFinal)
{
RestaurantEntities1 context = new RestaurantEntities1();
bool exista = false;
foreach (var meniu in context.Menius.ToList())
{
if (meniu.denumireMeniu == numeMeniu && existingRecord == false)
{
MessageBox.Show("Exista deja un meniu cu acest nume!");
exista = true;
}
}
if (listaPreparateDinMeniu.Count() == 0)
{
MessageBox.Show("Lista de preparate goala!");
exista = true;
}
if (numeMeniu == null || numeMeniu == "")
{
MessageBox.Show("Nume necompletat!");
exista = true;
}
if (exista == false)
{
if (existingRecord == false)
{
context.AdaugareMeniu(numeMeniu, 0, discount);
foreach (var preparat in listaPreparateDinMeniu)
{
context.AdaugarePreparatInMeniu(numeMeniu, preparat.denumire, preparat.cantitate);
MainViewModel.Instance.ActiveScreen = new MeniuViewModel(user);
}
context.AplicaReducereMeniu(numeMeniu, discount);
MessageBox.Show("Meniu Adaugat!");
context.SaveChanges();
}
else
{
var preparate = context.AfisarePreparateDinMeniu(numeMeniu).ToList();
List <string> aux = new List <string>();
foreach (var preparat in preparate)
{
aux.Add(preparat.denumire);
}
foreach (var preparateExistente in aux)
{
context.StergePreparatInMeniu(meniuAles.denumireMeniu, preparateExistente);
context.SaveChanges();
}
foreach (var preparat in listaPreparateDinMeniu)
{
context.AdaugarePreparatInMeniu(meniuAles.denumireMeniu, preparat.denumire, preparat.cantitate);
}
context.ModificaNumeMeniu(meniuAles.denumireMeniu, numeMeniu);
context.SaveChanges();
context.AplicaReducereMeniu(numeMeniu, discount);
MessageBox.Show("Meniu Modificat!");
MainViewModel.Instance.ActiveScreen = new MeniuViewModel(user);
}
}
}
