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