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