예제 #1
0
        public static void CreateTeacher()
        {
            Console.WriteLine("Enter teachers name: ");
            string name = Console.ReadLine();

            Console.WriteLine("Enter teachers lastname: ");
            string lastName = Console.ReadLine();

            var teacher = new Teacher()
            {
                FirstName = name,
                LastName  = lastName
            };

            ISession session = NHibernateHelper.GetCurrentSession();

            try
            {
                using (var tx = session.BeginTransaction())
                {
                    session.Save(teacher);
                    tx.Commit();
                }
            }
            finally
            {
                NHibernateHelper.CloseCurrentSession();
            }
        }
예제 #2
0
        public static bool UpdateStudent(int id)
        {
            ISession session = NHibernateHelper.GetCurrentSession();

            try
            {
                using (var tx = session.BeginTransaction())
                {
                    var stdnt = session.Get <Student>(id);

                    if (stdnt == null)
                    {
                        Console.WriteLine("Theres not user with that ID, try again!");
                        return(false);
                    }
                    Console.WriteLine("Retrieved by ID");
                    Console.WriteLine("{0} \t{1},\t{2}", stdnt.ID, stdnt.FirstName,
                                      stdnt.LastName);
                    System.Console.WriteLine();
                    Console.WriteLine("Update the last name of Id = {0}", stdnt.ID);
                    System.Console.WriteLine();
                    Console.WriteLine("Update firstname:  ");
                    string firstName = Console.ReadLine();
                    System.Console.WriteLine("Update LastName: ");
                    string lastName = Console.ReadLine();

                    if (!string.IsNullOrWhiteSpace(firstName) && !string.IsNullOrWhiteSpace(lastName))
                    {
                        stdnt.FirstName = firstName;
                        stdnt.LastName  = lastName;
                    }
                    else if (!string.IsNullOrWhiteSpace(firstName) && string.IsNullOrWhiteSpace(lastName))
                    {
                        stdnt.FirstName = firstName;
                    }
                    else if (string.IsNullOrWhiteSpace(firstName) && !string.IsNullOrWhiteSpace(lastName))
                    {
                        stdnt.LastName = lastName;
                    }

                    session.Update(stdnt);

                    Console.WriteLine("\nFetch the complete list of again? Y/N");
                    string entireList = Console.ReadLine();

                    tx.Commit();
                    if (entireList == "Y".ToLower())
                    {
                        DisplayAllStudents();
                    }
                    return(true);
                }
            }
            finally
            {
                NHibernateHelper.CloseCurrentSession();
            }
        }
예제 #3
0
        public static bool GetOneUserById(int studentId)
        {
            ISession session = NHibernateHelper.GetCurrentSession();

            try
            {
                using (var tx = session.BeginTransaction())
                {
                    var stdnt = session.Get <Student>(studentId);

                    if (stdnt == null)
                    {
                        Console.WriteLine("Theres not user with that ID, try again!");
                        return(false);
                    }

                    Console.WriteLine("Retrieved by ID");
                    Console.WriteLine("{0} \t{1},\t{2}", stdnt.ID, stdnt.FirstName,
                                      stdnt.LastName);


                    Console.WriteLine("\nFetch the complete list of again? Y/N");
                    string entireList = Console.ReadLine();

                    tx.Commit();
                    if (entireList == "Y".ToLower())
                    {
                        DisplayAllStudents();
                    }
                    else
                    {
                        Console.WriteLine("Hej då");
                    }
                    return(true);
                }
            }
            finally
            {
                NHibernateHelper.CloseCurrentSession();
            }
        }
예제 #4
0
        public static void DisplayAllTeachers()
        {
            ISession session = NHibernateHelper.GetCurrentSession();

            try
            {
                using (var tx = session.BeginTransaction())
                {
                    var teachers = session.CreateCriteria <Teacher>().List <Teacher>();

                    foreach (var teacher in teachers)
                    {
                        Console.WriteLine("{0} \t{1}, \t{2}", teacher.ID, teacher.FirstName, teacher.LastName);
                    }
                    tx.Commit();
                }
                Console.ReadLine();
            }
            finally
            {
                NHibernateHelper.CloseCurrentSession();
            }
        }