public static void mostrarProductos(BBDDRODRIEntities db)
{
Console.WriteLine("\nPRODUCTS: \n");
var info2 = from product in db.Products select product;
foreach (Products row in info2)
{
Console.WriteLine(row.idProduct + " -- " + row.name + " -- " + row.price);
}
Console.WriteLine();
}
public static void mostrarManufacters(BBDDRODRIEntities db)
{
Console.WriteLine("\nMANUFACTERS: \n");
var info3 = from manufacturer in db.Manufacturers select manufacturer;
foreach (Manufacturers row in info3)
{
Console.WriteLine(row.idManufacturer + " -- " + row.name + " -- " + row.adress);
}
Console.WriteLine();
}
public static void mostrarClientes(BBDDRODRIEntities db)
{
Console.WriteLine("\nCLIENTS: \n");
var info1 = from client in db.Clients select client;
foreach (Clients row in info1)
{
Console.WriteLine(row.idClient + " -- " + row.name + " -- " + row.adress);
}
Console.WriteLine();
}
static void Main(string[] args)
{
menu();
string option = Console.ReadLine().Trim().ToUpper();
using (BBDDRODRIEntities db = new BBDDRODRIEntities())
{
while (option != "H")
{
switch (option)
{
case "A":
db.Clients.Add(newClient());
db.SaveChanges();
break;
case "B":
db.Products.Add(newProduct());
db.SaveChanges();
break;
case "C":
db.Manufacturers.Add(newManufacturer());
db.SaveChanges();
break;
case "D":
mostrarClientes(db);
break;
case "E":
mostrarProductos(db);
break;
default:
Console.WriteLine("Inserta una opción correcta.");
break;
}
menu();
option = Console.ReadLine().Trim().ToUpper();
}
}
}
