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 StergeDinCos(InformatiiCos deSters, Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
int tip = 0;
foreach (var preparat in context.Preparats.ToList())
{
if (deSters.Denumire == preparat.denumire)
{
tip = 1;
}
}
foreach (var meniu in context.Menius.ToList())
{
if (deSters.Denumire == meniu.denumireMeniu)
{
tip = 2;
}
}
if (tip == 1)
{
context.stergePreparatDinCos(deSters.Denumire, IdComanda(user));
MainViewModel.Instance.ActiveScreen = new CartViewModel(user);
}
else if (tip == 2)
{
context.StergeMeniuDinCos(deSters.Denumire, IdComanda(user));
MainViewModel.Instance.ActiveScreen = new CartViewModel(user);
}
}
internal void StergePoza(int idPreparat, Fotografie pozaDeSters)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergePoza(pozaDeSters.id_foto, idPreparat);
context.SaveChanges();
}
internal ObservableCollection <InformatiiComanda> Comenzi(Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
ObservableCollection <InformatiiComanda> aux = new ObservableCollection <InformatiiComanda>();
if (user.statut == "Angajat")
{
foreach (var comanda in context.Comandas.ToList())
{
aux.Add(new InformatiiComanda(NumeClient(int.Parse(comanda.id_cont.ToString())),
AdresaClient(int.Parse(comanda.id_cont.ToString())),
NumarClient(int.Parse(comanda.id_cont.ToString())), Status(int.Parse(comanda.id_status.ToString())), double.Parse(comanda.pret.ToString()), comanda.id_comanda));
}
}
else
{
foreach (var comanda in context.Comandas.ToList())
{
if (comanda.id_cont == user.id_cont)
{
aux.Add(new InformatiiComanda(NumeClient(int.Parse(comanda.id_cont.ToString())),
AdresaClient(int.Parse(comanda.id_cont.ToString())),
NumarClient(int.Parse(comanda.id_cont.ToString())), Status(int.Parse(comanda.id_status.ToString())), double.Parse(comanda.pret.ToString()), comanda.id_comanda));
}
}
}
return(aux);
}
public void AdaugaPoza(int id)
{
RestaurantEntities1 context = new RestaurantEntities1();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.ShowDialog();
FileStream fs = new FileStream(dlg.FileName, FileMode.Open, FileAccess.Read);
byte[] data = new byte[fs.Length];
fs.Read(data, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
string iName = dlg.FileName;
string folder = @"\Image\";
var path = Path.Combine(Directory.GetParent(System.IO.Directory.GetCurrentDirectory()).Parent.FullName, Path.GetFileName(iName));
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
context.AdaugarePoza(path, id);
string currentFolder = Directory.GetParent(System.IO.Directory.GetCurrentDirectory()).Parent.FullName;
File.Copy(iName, path);
}
internal void DeleteAlergen(Alergen alergenAles, Preparat preparatAles)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.StergeAlergenDupaID(alergenAles.id_alergen, preparatAles.id_preparat);
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 UpdateStare(StatusComanda statusNou, InformatiiComanda deModificat, Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
context.ModificaStare(deModificat.Numarcomanda, statusNou.id_status);
MessageBox.Show("Stare comanda modificata!");
MainViewModel.Instance.ActiveScreen = new ComenziViewModel(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 double PretMeniu(ObservableCollection <Preparat> preparate)
{
RestaurantEntities1 context = new RestaurantEntities1();
double aux = 0;
foreach (var preparat in preparate)
{
aux += double.Parse(preparat.pret.ToString());
}
return(aux);
}
public ObservableCollection <Preparat> AllProducts()
{
RestaurantEntities1 context = new RestaurantEntities1();
ObservableCollection <Preparat> aux = new ObservableCollection <Preparat>();
foreach (var product in context.Preparats.ToList())
{
aux.Add(product);
}
return(aux);
}
internal ObservableCollection <StatusComanda> AllStatus()
{
RestaurantEntities1 context = new RestaurantEntities1();
ObservableCollection <StatusComanda> aux = new ObservableCollection <StatusComanda>();
foreach (var status in context.StatusComandas.ToList())
{
aux.Add(status);
}
return(aux);
}
public ObservableCollection <Meniu> AllMenius()
{
RestaurantEntities1 context = new RestaurantEntities1();
//List<Preparat> preparate = context.Preparats.ToList();
ObservableCollection <Meniu> aux = new ObservableCollection <Meniu>();
foreach (var product in context.Menius.ToList())
{
aux.Add(product);
}
return(aux);
}
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);
}
}
}
public ObservableCollection <Categorie> ListaCategorii()
{
RestaurantEntities1 context = new RestaurantEntities1();
var a = context.Categories.SqlQuery("[AfisareCategorii]").ToList();
ObservableCollection <Categorie> result = new ObservableCollection <Categorie>();
foreach (var categorie in a)
{
result.Add(categorie);
}
return(result);
}
internal ObservableCollection <Meniu> Search(string meniuCautat)
{
RestaurantEntities1 context = new RestaurantEntities1();
ObservableCollection <Meniu> aux = new ObservableCollection <Meniu>();
foreach (var product in context.Menius.SqlQuery("[CautaMeniu] @denumire",
new SqlParameter("denumire", meniuCautat)).ToList())
{
aux.Add(product);
}
return(aux);
}
public ObservableCollection <Alergen> Alergeni(string denumire)
{
RestaurantEntities1 context = new RestaurantEntities1();
var alergeniPreparat = context.AlergenPreparats.SqlQuery("[AfisareListaAlergeniPreparat] @denumirePreparat", new SqlParameter("denumirePreparat", denumire)).ToList();
ObservableCollection <Alergen> alergeni = new ObservableCollection <Alergen>();
foreach (var alergenPreparat in alergeniPreparat)
{
var alergen = context.Alergens.SqlQuery("AfisareAlergen @id_alergen", new SqlParameter("id_alergen", alergenPreparat.id_alergen)).ToList();
alergenPreparat.Alergen = alergen.FirstOrDefault();
alergeni.Add(alergen.FirstOrDefault());
}
return(alergeni);
}
public string Status(int comanda)
{
RestaurantEntities1 context = new RestaurantEntities1();
string aux = "";
foreach (var status in context.StatusComandas.ToList())
{
if (status.id_status == comanda)
{
aux = status.denumire;
}
}
return(aux);
}
public int IdComanda(Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
int id = 0;
foreach (var comanda in context.Comandas.ToList())
{
if (comanda.id_cont == user.id_cont && comanda.id_status == 505)
{
id = comanda.id_comanda;
}
}
return(id);
}
public string NumarClient(int cont)
{
RestaurantEntities1 context = new RestaurantEntities1();
string aux = "";
foreach (var user in context.DetaliiConts.ToList())
{
if (user.id_cont == cont)
{
aux = user.telefon;
}
}
return(aux);
}
internal void AddDetails(Cont user, string nume, string prenume, string numar, string adresa)
{
RestaurantEntities1 context = new RestaurantEntities1();
if (nume == "" || nume == null || prenume == "" || prenume == null || numar == "" || numar == null || adresa == "" || adresa == null)
{
MessageBox.Show("Informatii incomplete!");
}
else
{
context.AdaugareDetaliiCont(nume, prenume, adresa, int.Parse(numar.ToString()), user.email);
MessageBox.Show("Detalii Salvate!");
MainViewModel.Instance.ActiveScreen = new CartViewModel(user);
}
}
public ObservableCollection <Fotografie> AfisarePoze(int idPreparat)
{
RestaurantEntities1 context = new RestaurantEntities1();
var poze = context.Fotografies.ToList();
ObservableCollection <Fotografie> pozePreparat = new ObservableCollection <Fotografie>();
foreach (var poza in poze)
{
if (poza.id_preparat == idPreparat)
{
pozePreparat.Add(poza);
}
}
return(pozePreparat);
}
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 ObservableCollection <Preparat> PreparateMeniu(Meniu meniuAles)
{
RestaurantEntities1 context = new RestaurantEntities1();
var preparate = context.AfisarePreparateMeniu(meniuAles.denumireMeniu).ToList();
ObservableCollection <Preparat> result = new ObservableCollection <Preparat>();
foreach (var preparat in preparate)
{
Preparat aux = new Preparat();
aux.id_categorie = preparat.id_categorie;
aux.id_preparat = preparat.id_preparat;
aux.pret = preparat.pret;
aux.cantitate = preparat.cantitate;
aux.cantitate_totala = preparat.cantitate_totala;
aux.denumire = preparat.denumire;
result.Add(aux);
}
return(result);
}
public Fotografie FotografieCurenta(Preparat preparat)
{
RestaurantEntities1 context = new RestaurantEntities1();
Fotografie aux = new Fotografie();
foreach (var product in context.Preparats.SqlQuery("[CautaPreparat] @denumire",
new SqlParameter("denumire", preparat.denumire)).ToList())
{
var poze = context.Fotografies.ToList();
foreach (var poza in poze)
{
if (poza.id_preparat == product.id_preparat)
{
aux = poza;
break;
}
}
}
return(aux);
}
public ObservableCollection <Meniu> Meniuri(Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
int idComanda = IdComanda(user);
ObservableCollection <Meniu> aux = new ObservableCollection <Meniu>();
foreach (var comanda in context.MeniuComandas.ToList())
{
if (idComanda == comanda.id_comanda)
{
foreach (var meniu in context.Menius.ToList())
{
if (meniu.id_meniu == comanda.id_meniu)
{
aux.Add(meniu);
}
}
}
}
return(aux);
}
public ObservableCollection <Preparat> Preparate(Cont user)
{
RestaurantEntities1 context = new RestaurantEntities1();
int idComanda = IdComanda(user);
ObservableCollection <Preparat> aux = new ObservableCollection <Preparat>();
foreach (var comanda in context.PreparatComandas.ToList())
{
if (idComanda == comanda.id_comanda)
{
foreach (var preparat in context.Preparats.ToList())
{
if (preparat.id_preparat == comanda.id_preparat)
{
aux.Add(preparat);
}
}
}
}
return(aux);
}
