private void Controller()
{
int menu;
using (var db = new DBEnterprise())
{
menu = SelectOption();
do
{
switch (menu)
{
case 1:
db.Product.Add(Product());
db.SaveChanges();
break;
case 2:
db.Customer.Add(Client());
db.SaveChanges();
break;
case 3:
db.Manufacturer.Add(Manufacturer());
db.SaveChanges();
break;
case 4:
ShowProducts();
break;
case 5:
ShowCustomers();
break;
case 6:
ShowManufacturers();
break;
case 7:
Environment.Exit(0);
break;
default:
Console.WriteLine("Key error, introduce 1/2/3/4/5/6/7");
break;
}
menu = SelectOption();
} while (menu != 7);
}
}
private void ShowManufacturers()
{
using (var db = new DBEnterprise())
{
var query = from manufacturers in db.Manufacturer
select manufacturers;
foreach (Manufacturer manufacturers in query)
{
Console.Write(manufacturers.ID + " " + manufacturers.Name + " " + manufacturers.Municipality);
Console.WriteLine();
}
Console.Write("Press any key to return menu: ");
Console.ReadKey();
Console.Clear();
}
}
private void ShowProducts()
{
using (var db = new DBEnterprise())
{
var query = from product in db.Product
select product;
foreach (Products product in query)
{
Console.Write(product.ID + " " + product.Title + " " + product.ManufacturerID + " " + product.Price);
Console.WriteLine();
}
Console.Write("Press any key to return menu: ");
Console.ReadKey();
Console.Clear();
}
}
private void ShowCustomers()
{
using (var db = new DBEnterprise())
{
var query = from customers in db.Customer
select customers;
foreach (Customer customers in query)
{
Console.Write(customers.ID + " " + customers.NIF + " " + customers.Name + " " + customers.Surname +
" " + customers.Birth_Date + " " + customers.Gender + " " + customers.Email + " " + customers.Phone_number
+ " " + customers.Credit_Card);
Console.WriteLine();
}
Console.Write("Press any key to return menu: ");
Console.ReadKey();
Console.Clear();
}
}
