コード例 #1
0
        public String checkPackageStatus(String packagename)
        {
            ISessionFactory     factory = new NHibernate.Cfg.Configuration().Configure().BuildSessionFactory();
            List <TracePackage> packages;

            using (ISession session = factory.OpenSession())
            {
                packages = (List <TracePackage>)session.QueryOver <TracePackage>().Where(x => x.name == packagename).List();
                session.Close();
            }
            factory.Close();
            return(packages[0].currentCity);
        }
コード例 #2
0
        public List <TracePackage> getAllPackages(String username)
        {
            ISessionFactory     factory = new NHibernate.Cfg.Configuration().Configure().BuildSessionFactory();
            List <TracePackage> packages;

            using (ISession session = factory.OpenSession())
            {
                packages = (List <TracePackage>)session.QueryOver <TracePackage>().Where(x => x.sender == username || x.receiver == username).List();
                session.Close();
            }
            factory.Close();
            return(packages);
        }
コード例 #3
0
        private void Form1_Load(object sender, EventArgs e)
        {
            this.Text = Help.Help.EcManagementForm;
            System.Collections.IList siteList;
            ISessionFactory          factory =
                new NHibernate.Cfg.Configuration().Configure().BuildSessionFactory();

            using (ISession session = factory.OpenSession())
            {
                ICriteria sc = session.CreateCriteria(typeof(Site));
                siteList = sc.List();
                session.Close();
            }
            factory.Close();
        }
コード例 #4
0
        public void register(String Username, String Password)
        {
            User user = new User();

            user.Username = Username;
            user.Password = Password;
            user.Role     = "user";

            ISessionFactory factory = new NHibernate.Cfg.Configuration().Configure().BuildSessionFactory();

            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    session.Save(user);
                    transaction.Commit();
                }
                session.Close();
            }
            factory.Close();
        }
コード例 #5
0
        public String login(String Username, String Password)
        {
            ISessionFactory factory = new NHibernate.Cfg.Configuration().Configure().BuildSessionFactory();

            using (ISession session = factory.OpenSession())
            {
                User user = (User)session.Get <User>(Username);
                if (user != null)
                {
                    if (user.Password.Equals(Password))
                    {
                        return(user.Role);
                    }
                    else
                    {
                        return("fail");
                    }
                }
                session.Close();
            }
            factory.Close();
            return("fail");
        }