using System;
using System.Data.Entity.Migrations;
using System.Runtime.Remoting.Contexts;

namespace ExampleCodeFirst
{
    static class Program
    {
        static void Main(string[] args)
        {
            var dep1 = new Departments { Name = "Phong Ke Hoach" };
            var dep2 = new Departments { Name = "Phong Nhan Su" };

            var em1 = new Employee { FirstName = "A", LastName = "Le Minh", Birthday = Convert.ToDateTime("26/06/1987"), DepId = 1 };
            var em2 = new Employee { FirstName = "B", LastName = "Nguyen Van", Birthday = Convert.ToDateTime("12/05/1981"), DepId = 1 };
            var em3 = new Employee { FirstName = "C", LastName = "Tran Thi", Birthday = Convert.ToDateTime("21/09/1985"), DepId = 2 };
            var em4 = new Employee { FirstName = "D", LastName = "Phan Van", Birthday = Convert.ToDateTime("06/02/1990"), DepId = 2 };


            using (var context = new ManagerDbContext())
            {
                context.Departmentses.Add(dep1);
                context.Departmentses.Add(dep2);

                context.Employees.Add(em1);
                context.Employees.Add(em2);
                context.Employees.Add(em3);
                context.Employees.Add(em4);

                context.SaveChanges();
                Console.WriteLine("Success !\n");
                Console.WriteLine("Departmentses Info:\n");
                foreach (var dep in context.Departmentses)
                {
                    Console.WriteLine(dep.Id + "\t" + dep.Name);
                }

                Console.WriteLine("\nListing of all employees: \n ");
                foreach (var em in context.Employees)
                {
                    Console.WriteLine(em.Id + '\t' + em.FirstName + " " + em.LastName + '\t' + em.Birthday + '\t' + em.Departments.Name);
                }
            }

            Console.ReadLine();
        }
    }
}