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