using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace dbSandBox
{
class Program
{
static void Main(string[] args)
{
string command = "";
while (command != "exit")
{
Console.Write("#>");
command = Console.ReadLine();
switch (command)
{
case "list":
list();
break;
case "search":
search();
break;
case "add":
add();
break;
default:
Console.WriteLine("Command not found");
break;
}
}
}
public static void search()
{
string name;
Console.Write("Enter last name: ");
name = Console.ReadLine();
PeopleEntities2 db = new PeopleEntities2();
var result = from person in db.People
where person.lastname == name
select person;
foreach (Person person in result)
{
Console.WriteLine(person.firstname);
Console.WriteLine(person.lastname);
Console.WriteLine(person.country);
Console.WriteLine(person.job);
Console.WriteLine(person.ID);
}
}
public static void add()
{
Person person = new Person();
Console.Write("Enter first name: ");
person.firstname = Console.ReadLine();
Console.Write("Enter Last name: ");
person.lastname = Console.ReadLine();
Console.Write("Enter job: ");
person.job = Console.ReadLine();
Console.Write("Enter Country: ");
person.country = Console.ReadLine();
PeopleEntities2 db = new PeopleEntities2();
db.AddToPeople(person);
db.SaveChanges();
}
public static void list()
{
PeopleEntities2 db = new PeopleEntities2();
var result = from people in db.People
select people;
foreach (Person person in result)
{
Console.WriteLine("First Name: {0}", person.firstname);
Console.WriteLine("Last Name: {0}", person.lastname);
Console.WriteLine("Country: {0}", person.country);
Console.WriteLine("job: {0}", person.job);
Console.WriteLine("##############################################");
}
}
}
}