예제 #1
0
        public static void InsertEmp(string name, double salary, string position, string categoryName)
        {
            using (var session = Helper11.OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    var departments = session.CreateCriteria <Department>().List <Department>();
                    int id          = 0;
                    foreach (var cat in departments)
                    {
                        if (cat.name == categoryName)
                        {
                            id = cat.id;
                        }
                    }
                    var department = session.Get <Department>(id);



                    var employee = new Employee
                    {
                        name     = name,
                        salary   = salary,
                        position = position,
                    };

                    employee.Department = department;

                    session.Save(employee);
                    transaction.Commit();
                    Console.WriteLine($"Employee {name} added.");
                }
                Console.ReadKey();
            }
        }
예제 #2
0
 public static void FindEmployee()
 {
     using (var session = Helper11.OpenSession())
     {
         using (var transaction = session.BeginTransaction())
         {
             var data = session.Query <Employee>().Where(x => x.id == 2);
             foreach (var cp in data)
             {
                 Console.WriteLine($"Dept-id: {cp.id}\nName: {cp.name}\nSalary: {cp.salary}\nPosition: {cp.position}\nDepartment: {cp.Department.name}");
             }
         }
     }
 }
예제 #3
0
        public static void InsertDepartment(string deptName)
        {
            using (var session = Helper11.OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    var department = new Department
                    {
                        name = deptName,
                    };

                    session.Save(department);
                    transaction.Commit();
                    Console.WriteLine($"Departent: {deptName} added.");
                }
                Console.Read();
            }
        }
예제 #4
0
 public static void FetchDepartentAndEMp()
 {
     using (var session = Helper11.OpenSession())
     {
         using (var transaction = session.BeginTransaction())
         {
             var emp    = session.CreateCriteria <Employee>();
             var dept   = session.CreateCriteria <Department>();
             var result = from i in session.CreateCriteria <Department>().List <Department>()
                          join j in session.CreateCriteria <Employee>().List <Employee>()
                          on i.id equals j.Department.id
                          select new
             {
                 j.id, j.position, j.salary, i.name
             };
             foreach (var cp in result)
             {
                 Console.WriteLine("Empp Info:");
                 Console.WriteLine($"Emp-Id: {cp.id} Emp-Position: {cp.position} Emp-Salary: {cp.salary} Deptartment: {cp.name}");
             }
         }
     }
 }