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