public ObservableCollection <MeniuriCuPreparate> GetMeniuriCuPreparate(Meniu meniu)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spMeniuriCuPreparate_GetPreparatFromMeniu", connection);
ObservableCollection <MeniuriCuPreparate> result = new ObservableCollection <MeniuriCuPreparate>();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramDenumireMeniu = new SqlParameter("@DenumireMeniu", meniu.Denumire);
cmd.Parameters.Add(paramDenumireMeniu);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result.Add(new MeniuriCuPreparate()
{
DenumirePreparat = reader["denumire"].ToString()
});
}
reader.Close();
return(result);
}
}
private void acasa_Click(object sender, RoutedEventArgs e)
{
Meniu form = new Meniu();
form.Show();
this.Hide();
}
Meniu()
{
if(mInstance!=null) {
Destroy(this);
}
mInstance=this;
}
public void OpenWindow(object obj)
{
string nr = obj as string;
switch (nr)
{
case "1":
Meniu menu = new Meniu();
menu.ShowDialog();
break;
case "2":
Search search = new Search();
search.ShowDialog();
break;
case "3":
LogIn logIn = new LogIn();
logIn.ShowDialog();
break;
case "4":
NewUser newUser = new NewUser();
newUser.ShowDialog();
break;
}
}
internal ObservableCollection <Meniu> GetAllMenu()
{
SqlConnection connection = HelpDAL.Connection;
try
{
SqlCommand cmd = new SqlCommand("spGetAllMenu", connection);
ObservableCollection <Meniu> result = new ObservableCollection <Meniu>();
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Meniu m = new Meniu();
m.MeniuId = reader.GetInt32(0);
m.Nume = reader.GetString(1);
m.Discount = reader.GetInt32(2);
m.Pret = reader.GetDecimal(3);
result.Add(m);
}
reader.Close();
return(result);
}
finally
{
connection.Close();
}
}
public void Add(Meniu b)
{
using (StreamWriter swFisierText = new StreamWriter(NumeFisier, true))
{
swFisierText.WriteLine(b.ConversieLaSir_PentruScriereInFisier());
}
}
/*
* public static Mancare AddMancare_Citire_Consola()
* {
* Mancare m;
* do
* {
* string denumire, pret;
*
* Console.WriteLine("\nIntroduceti informatiile despre mancarea pe care doriti sa o adaugati:");
* Console.WriteLine("\t-Denumire mancare:");
* denumire = Console.ReadLine();
* Console.WriteLine("\t-Pret produs:");
* pret = Console.ReadLine();
* pret = pret.Replace(',', '.');
*
* string add = $"{denumire};{pret}";
*
* bool consola = true;
* m = new Mancare(add, consola);
* } while (m.pret == -1);
*
* return m;
* }
*
* public static void AfisareMancare(List<> mancare)
* {
* Console.WriteLine("Bauturile din meniu sunt:");
* for (int i = 0; i < mancare.Count; i++)
* {
* Console.WriteLine(((Mancare)mancare[i]).ConversieLaSir_PentruAfisare());
* }
* }
*/
public static Meniu AddMeniu()
{
Meniu meniu;
do
{
string nume, pret;
int tip = 0;
Console.WriteLine("\nIntroduceti informatiile pe care doriti sa le adaugati:");
Console.WriteLine("\t-Tip aliment:");
Console.WriteLine("1. Mancare");
Console.WriteLine("2. Bautura");
Console.WriteLine("3. Desert");
bool gasit;
do
{
gasit = false;
try
{
Console.WriteLine("\nIntroduceti cifra corespunzatoare optiunii dorite: ");
tip = Convert.ToInt32(Console.ReadLine());
}
catch (FormatException)
{
Console.WriteLine("Optiune inexistenta!");
gasit = true;
}
if (gasit == false)
{
if (tip < 1 || tip > 3)
{
Console.WriteLine("Optiune inexistenta!");
gasit = true;
}
else
{
gasit = false;
}
}
} while (gasit == true);
Console.WriteLine("\tNume: ");
nume = Console.ReadLine();
Console.WriteLine("\t-Pret produs:");
pret = Console.ReadLine();
pret = pret.Replace(',', '.');
string add = $"{nume};{pret};{Convert.ToString((Tip_aliment)(tip))}";
bool consola = true;
meniu = new Meniu(add, consola);
} while (meniu.pret == -1);
return(meniu);
}
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 AddMeniu(Meniu meniu)
{
if (String.IsNullOrEmpty(meniu.Denumire))
{
return;
}
meniuDAL.AddMeniu(meniu);
//UserList.Add(user);
}
public AddItemsForms(Meniu menu, Reciept reciept)
{
ItemList = new List <Item>();
OldReciept = reciept;
this.Width = 600;
this.Height = 400;
InitializeComponent();
this.Menu = menu;
this.GenerateMenu();
}
internal void DeleteMeniu(Meniu meniu)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spMeniuri_Delete", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramDenumire = new SqlParameter("@Denumire", meniu.Denumire);
cmd.Parameters.Add(paramDenumire);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public static void LogIn()
{
while (true)
{
Console.Clear();
Console.WriteLine("LOGIN: \n");
Console.Write("Enter nickname: ");
string nickName = Console.ReadLine();
Console.Write("Enter password: "******".xml";
if (File.Exists(path))
{
//Hero hero = new Hero();
Hero.Instance.Name = nickName;
Hero.LoadHero(ref Hero.Instance);
if (Hero.Instance.Password == passWord)
{
Console.Clear();
Console.WriteLine("Login successful!");
Console.WriteLine("\nPress any key to continue...");
Console.ReadKey();
Meniu.MeniuPrincipal();
break;
}
else
{
Console.Clear();
Console.WriteLine("Login or password incorrect... Try again!");
Console.WriteLine("\nPress any key to continue...");
Console.ReadKey();
}
}
else
{
Console.Clear();
Console.WriteLine("Account inexistent");
Console.WriteLine("\nPress any key to continue...");
Console.ReadKey();
Meniu.MeniuLogin();
}
}
}
private void inapoi_Click(object sender, RoutedEventArgs e)
{
if (parametru == 0)
{
Optiuni form = new Optiuni();
form.Show();
}
else if (parametru == 1)
{
Meniu form = new Meniu();
form.Show();
}
this.Hide();
}
private void SelectedIndexChanged(object sender, EventArgs e)// eveniment pentru itemul selectat din meeniu
{
IStocareMeniu stocare_info_meniu = new Administrare_meniu();
Meniu camp_selectat = stocare_info_meniu.GetInfo(Convert.ToInt32(lstAfisareInfo.SelectedIndex - 1));
if (camp_selectat != null)
{
lblGetTip.Text = camp_selectat.tip_aliment.ToString();
lblGetDenumire.Text = camp_selectat.denumire;
lblGetPret.Text = camp_selectat.pret.ToString();
}
else
{
lblGetPret.Text = "";
}
}
internal void AddMeniuInComanda(Comenzi comanda, Meniu meniu, int cantitate)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spMeniuri_InsertMeniuInMeniuriComandate", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramComandaId = new SqlParameter("@ComandaId", comanda.ComandaId);
SqlParameter paramMeniuId = new SqlParameter("@MeniuId", meniu.MeniuId);
SqlParameter paramCantitate = new SqlParameter("@Cantitate", cantitate);
cmd.Parameters.Add(paramComandaId);
cmd.Parameters.Add(paramMeniuId);
cmd.Parameters.Add(paramCantitate);
connection.Open();
cmd.ExecuteNonQuery();
}
}
internal void AddMeniu(Meniu meniu)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spMeniuri_Insert", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramDenumire = new SqlParameter("@Denumire", meniu.Denumire);
SqlParameter paramPret = new SqlParameter("@Pret", meniu.Pret);
SqlParameter paramCategorieId = new SqlParameter("@CategorieId", meniu.CategorieId);
cmd.Parameters.Add(paramDenumire);
cmd.Parameters.Add(paramPret);
cmd.Parameters.Add(paramCategorieId);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public Meniu GetInfo(int index) // functie de cautare -- folosita la modificare
{
using (StreamReader sr = new StreamReader(NumeFisier))
{
string line;
//citeste cate o linie si creaza un obiect de tip Meniu pe baza datelor din linia citita
while ((line = sr.ReadLine()) != null)
{
Meniu meniu = new Meniu(line);
if (meniu.id == index)
{
return(meniu);
}
}
}
return(null);
}
public List <Meniu> GetInfo() // preluare informatii din fisier
{
List <Meniu> _meniu = new List <Meniu>();
using (StreamReader sr = new StreamReader(NumeFisier))
{
string line;
//citeste cate o linie si creaza un obiect de tip Studenumiret pe baza datelor din linia citita
while ((line = sr.ReadLine()) != null)
{
Meniu meniu = new Meniu(line);
_meniu.Add(meniu);
}
}
return(_meniu);
}
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 DetaliiMeniuViewModel(Meniu meniuAles, Cont user)
{
actions = new MeniuActions();
MeniuAles = meniuAles;
if (user != null)
{
User = user;
if (user.statut == "Angajat")
{
Visibility = "Visible";
}
else
{
Visibility = "Hidden";
}
}
else
{
Visibility = "Hidden";
}
}
public AdaugareMeniuViewModel(Cont user, Meniu meniu)
{
actions = new MeniuActions();
ListaPreparateDinMeniu = new ObservableCollection <Preparat>();
Discount = double.Parse(ConfigurationManager.AppSettings["discountMeniu"].ToString());
NumeMeniu = meniu.denumireMeniu;
ListaPreparateDinMeniu = actions.PreparateMeniu(meniu);
PretFinal = double.Parse(meniu.pret.ToString());
PretInitial = actions.PretMeniu(ListaPreparateDinMeniu);
ExistingRecord = true;
MeniuAles = meniu;
User = user;
if (user.statut == "Angajat")
{
Visibility = "Visible";
}
else
{
Visibility = "Hidden";
}
}
public static void SignIn()
{
while (true)
{
Console.Clear();
Console.WriteLine("REGISTER: \n");
Console.Write("Enter nickname: ");
string nickName = Console.ReadLine();
Console.Write("Enter password: "******".xml";
if (File.Exists(path))
{
Console.Clear();
Console.WriteLine("Account exists, try other nickname...");
Console.WriteLine("\nPress any key to continue...");
Console.ReadKey();
}
else
{
Hero.Instance.ResetHero();
Hero.Instance.Name = nickName;
Hero.Instance.Password = passWord;
Hero.Instance.SaveHero();
Console.Clear();
Console.WriteLine("Account created succesifully!");
Console.WriteLine("\nPress any key to continue...");
Console.ReadKey();
Meniu.MeniuLogin();
break;
}
}
}
private void btnAdminAdauga_Modifica_Click(object sender, EventArgs e)// Buton de modificare meniu pentru rolul de administrator
{
validare = true;
if (btn_pentru_mese == false) // am selectat in admin optiunea de adaugare meniu
{
lblTextCamp1.ForeColor = Color.Black;
lblTextCamp2.ForeColor = Color.Black;
lblTextCamp3.ForeColor = Color.Black;
if (rdbAdmin_rdb1.Checked == false && rdbAdmin_rdb2.Checked == false && rdbAdmin_rdb3.Checked == false)
{
lblEroareCamp1.Text = "Selectati locatia mesei";
lblEroareCamp1.ForeColor = Color.Green;
lblEroareCamp1.Visible = true;
validare = false;
}
if (txtAdminCamp2.Text == "")
{
lblEroareCamp2.Text = "Introduceti denumirea produsului";
lblEroareCamp2.ForeColor = Color.Green;
lblEroareCamp2.Visible = true;
validare = false;
}
if (txtAdminCamp3.Text == "")
{
lblEroareCamp3.Text = "Introduceti pretul produsului";
lblEroareCamp3.ForeColor = Color.Green;
lblEroareCamp3.Visible = true;
validare = false;
}
if (validare == true)
{
IStocareMeniu stocare_info_meniu = new Administrare_meniu();
List <Meniu> list_meniu = stocare_info_meniu.GetInfo();
Meniu add_meniu = new Meniu();
if (rdbAdmin_rdb1.Checked == true)
{
add_meniu.tip_aliment = rdbAdmin_rdb1.Text;
}
else
if (rdbAdmin_rdb2.Checked == true)
{
add_meniu.tip_aliment = rdbAdmin_rdb2.Text;
}
else
if (rdbAdmin_rdb3.Checked == true)
{
add_meniu.tip_aliment = rdbAdmin_rdb3.Text;
}
add_meniu.denumire = txtAdminCamp2.Text;
string pret_nou = "";
string pret = txtAdminCamp3.Text;
for (int i = 0; i < pret.Length; i++)
{
if (pret[i] == '.')
{
pret_nou += '.';
}
else
if (pret[i] == ',')
{
pret_nou += '.';
}
else
if (char.IsDigit(pret[i]))
{
pret_nou += pret[i];
}
}
add_meniu.pret = float.Parse(pret_nou, System.Globalization.CultureInfo.InvariantCulture);
if (list_meniu.Count != 0)
{
add_meniu.id = Meniu.last_id;
stocare_info_meniu.UpdateMeniu(add_meniu);
}
else
{
add_meniu.id = 1;
stocare_info_meniu.UpdateMeniu(add_meniu, true);
}
MessageBox.Show("Produsul a fost adăugat!");
rdbAdmin_rdb1.Checked = false;
rdbAdmin_rdb2.Checked = false;
rdbAdmin_rdb3.Checked = false;
admin_reset_controale_meniu();
btnAfiseazaInfo_Click(sender, e);
}
}
// adaugare mese
else
{
if (rdbAdmin_rdb1.Checked == false && rdbAdmin_rdb2.Checked == false && rdbAdmin_rdb3.Checked == false)
{
lblEroareCamp1.Text = "Selectati locatia mesei";
lblEroareCamp1.ForeColor = Color.Green;
lblEroareCamp1.Visible = true;
validare = false;
}
if (rdb2locuri.Checked == false && rdb3locuri.Checked == false && rdb5locuri.Checked == false && rdb7locuri.Checked == false && rdb9locuri.Checked == false)
{
lblEroareCamp3.Text = "Selectati numarul de locuri";
lblEroareCamp3.ForeColor = Color.Green;
lblEroareCamp3.Visible = true;
validare = false;
}
if (validare == true)
{
lblEroareCamp1.Text = "";
lblEroareCamp2.Text = "";
lblEroareCamp3.Text = "";
lblEroareCamp1.ForeColor = Color.Transparent;
lblEroareCamp2.ForeColor = Color.Transparent;
lblEroareCamp3.ForeColor = Color.Transparent;
string _locatie = "";
int _locuri = 0;
if (rdbAdmin_rdb1.Checked == true)
{
_locatie = rdbAdmin_rdb1.Text;
}
else
if (rdbAdmin_rdb2.Checked == true)
{
_locatie = rdbAdmin_rdb2.Text;
}
else
if (rdbAdmin_rdb3.Checked == true)
{
_locatie = rdbAdmin_rdb3.Text;
}
if (rdb2locuri.Checked)
{
_locuri = Convert.ToInt32(rdb2locuri.Text);
}
if (rdb3locuri.Checked)
{
_locuri = Convert.ToInt32(rdb3locuri.Text);
}
if (rdb5locuri.Checked)
{
_locuri = Convert.ToInt32(rdb5locuri.Text);
}
if (rdb7locuri.Checked)
{
_locuri = Convert.ToInt32(rdb7locuri.Text);
}
if (rdb9locuri.Checked)
{
_locuri = Convert.ToInt32(rdb9locuri.Text);
}
Masa b = new Masa();
b.locuri = b.GenerareCodUnic();
IStocareMasa stocare_info_masa = new Administrare_masa();
List <Masa> list_masa = stocare_info_masa.GetInfo();
if (list_masa.Count != 0)
{
// Verificare numar mese
int nr1 = 0;
foreach (Masa m in list_masa)
{
if (m.locatie == _locatie)
{
nr1++;
}
}
if (nr1 < 4)
{
stocare_info_masa.UpdateMasa(Masa.last_id, false, _locuri, _locatie);
}
if (nr1 == 4)
{
MessageBox.Show($"Nu se mai pot adauga mese in {_locatie}!\nNumar maxim de mese: 4");
}
}
else
{
stocare_info_masa.UpdateMasa(1, false, _locuri, _locatie);
}
MessageBox.Show("Masa a fost adăugată!");
rdbAdmin_rdb1.Checked = false;
rdbAdmin_rdb2.Checked = false;
rdbAdmin_rdb3.Checked = false;
rdb2locuri.Checked = false;
rdb3locuri.Checked = false;
rdb5locuri.Checked = false;
rdb7locuri.Checked = false;
rdb9locuri.Checked = false;
txtAdminCamp1.Text = "";
txtAdminCamp2.Text = "";
txtAdminCamp3.Text = "";
}
}
}
private void meniu2_Click(object sender, RoutedEventArgs e)
{
Meniu menu = new Meniu(idUser);
menu.ShowDialog();
}
internal ObservableCollection <Preparate> GetPreparatForMeniu(Meniu meniu)
{
return(preparateDAL.GetPreparateForMeniu(meniu));
}
internal ObservableCollection <MeniuriCuPreparate> GetAllMeniuriCuPreparate(Meniu meniu)
{
return(meniuriCuPreparateDAL.GetMeniuriCuPreparate(meniu));
}
internal void AddMeniuInComanda(Comenzi comanda, Meniu meniu, int cantitate)
{
meniuDAL.AddMeniuInComanda(comanda, meniu, cantitate);
}
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);
}
}
}
internal void DeleteMeniu(Meniu meniu)
{
meniuDAL.DeleteMeniu(meniu);
}
static void Main(string[] args)
{
Meniu.MeniuPrincipal();
}
