static void Main() { NhibernateHelper.Configurar(); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); }
static void Main(string[] args) { NhibernateHelper.Configurar(); AlunoController alunoController = new AlunoController(); alunoController.Cadastrar(); }
bool IBaseDao <User, long> .Delete(User entity) { ITransaction transaction = null; try { ISession session = null; session = NhibernateHelper.OpenSession(); transaction = session.BeginTransaction(); var obj = session.Get <User>(entity.Id); if (obj != null) { session.Delete(obj); } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } }
public void RackTest() { using (var session = NhibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { /*var rack = new Rack * { * Name = "First", * Code = 10, * Limit = 700, * Location = "First Flat" * };*/ Guid racckId = GetRackId(); Rack rack = session.Get <Rack>(racckId); session.Save(rack); transaction.Commit(); var res = session.Get <Rack>(rack.Id); Assert.AreEqual(rack.Limit, 700); } } }
public Guid GetRackItemLevelId() { using (ISession session = NhibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var ItemId = GetItemId(); Item item = session.Get <Item>(ItemId); var RackId = GetRackId(); Rack rack = session.Get <Rack>(RackId); RackItemLevel rackItemLevel = new RackItemLevel { CurrentQuantity = 10, InQuantity = 5, OutQuantity = 10, Rack = rack, Item = item }; session.Save(rackItemLevel); transaction.Commit(); rackItemLevel = session.Get <RackItemLevel>(rackItemLevel.Id); return(rackItemLevel.Id); } } }
static void Main(string[] args) { using (var session = NhibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { PurchaseOrderItem purchaseOrderItem = new PurchaseOrderItem { NetPrice = 30, UnitPrice = 50, Quantity = 900 }; session.Save(purchaseOrderItem); transaction.Commit(); List <PurchaseOrderItem> purchase = session.Query <PurchaseOrderItem>() .Where(x => x.Quantity == 900).ToList(); foreach (var p in purchase) { Console.WriteLine(p.Id); } Console.ReadKey(); } } }
public void PurchaseOrderItemTest() { using (var session = NhibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var itemId = GetItemId(); Item item = session.Get <Item>(itemId); var racckId = GetRackId(); Rack rack = session.Get <Rack>(racckId); PurchaseOrderItem purchaseOrderItem = new PurchaseOrderItem { NetPrice = 30, UnitPrice = 50, Quantity = 900, Item = item, Rack = rack }; session.Save(purchaseOrderItem); transaction.Commit(); var res = session.Get <PurchaseOrderItem>(purchaseOrderItem.Id); Assert.AreEqual(purchaseOrderItem.NetPrice, res.NetPrice); } } }
bool IUserManager.IsPasswordChanged(User entity) { bool isPasswordchanged = false; ITransaction transaction = null; try { ISession session = null; session = NhibernateHelper.OpenSession(); var usr = session.CreateCriteria(typeof(User)) .Add(Restrictions.Eq("UserName", entity.UserName)) .List <User>().FirstOrDefault(); if (usr != null) { if (usr.OldPassword == entity.OldPassword) { usr.NewPassword = entity.NewPassword; usr.OldPassword = entity.NewPassword; isPasswordchanged = true; } transaction = session.BeginTransaction(); session.SaveOrUpdate(usr); transaction.Commit(); session.Flush(); } return(isPasswordchanged); } catch { transaction.Rollback(); return(isPasswordchanged); } }
public bool IsUserCreated(User entity) { bool isUserCreated = false; ITransaction transaction = null; User usr = new User(); try { ISession session = null; session = NhibernateHelper.OpenSession(); var comp = session.CreateCriteria(typeof(User)) .Add(Restrictions.Eq("UserName", entity.UserName)) .List <User>().FirstOrDefault(); if (comp != null) { isUserCreated = false; } else { transaction = session.BeginTransaction(); isUserCreated = true; session.Save(entity); transaction.Commit(); session.Flush(); } return(isUserCreated); } catch { transaction.Rollback(); return(false); } }
public Cat GetCatById(long id) { ISession session = NhibernateHelper.GetSession(); Cat result = session.Get <Cat>(id); return(result); }
public ActionResult Listele() { using (var session = NhibernateHelper.OpenSession()) { var banks = session.Query <Models.Banka>().ToList(); return(View(banks)); } }
public ActionResult Edit(int id) { using (var session = NhibernateHelper.OpenSession()) { var oteller = session.Query <Models.Otel>().FirstOrDefault(x => x.Id == id); return(View(oteller)); } }
// GET: Sube public ActionResult Index() { using (var session = NhibernateHelper.OpenSession()) { var subeler = session.Query <Models.Sube>().ToList(); return(View(subeler)); } }
public ActionResult Edit(int id) { using (var session = NhibernateHelper.OpenSession()) { var dukkan = session.Query <Models.dukkan>().FirstOrDefault(x => x.Id_Zup == id); return(View(dukkan)); } }
public ICollection <User> GetAllUsers() { using (ISession session = NhibernateHelper.OpenSession()) { ICriteria criteria = session.CreateCriteria(typeof(User)); return(criteria.List <User>()); } }
// GET: CRUD/Edit/5 public ActionResult Edit(int id) { using (ISession session = NhibernateHelper.OpenSession()) { var task = session.Get <Task>(id); return(View(task)); } }
// GET: CRUD public ActionResult Index() { using (ISession session = NhibernateHelper.OpenSession()) { var tasks = session.QueryOver <Task>().List(); return(View(tasks)); } }
/// <summary> /// 获取所有该类型的对象列表 /// </summary> /// <typeparam name="T"></typeparam> /// <returns></returns> public static ICollection <T> GetAll <T>() { using (ISession session = NhibernateHelper.OpenSession()) { IList <T> list = session.CreateCriteria(typeof(T)).List <T>(); return(list); } }
public long SaveCat(Cat cat) { ISession session = NhibernateHelper.GetSession(); session.Save(cat); session.Flush(); return(cat.Id.Value); }
public ActionResult Edit(int id) { using (var session = NhibernateHelper.OpenSession()) { var bank = session.Query <Models.Banka>().FirstOrDefault(x => x.Id == id); return(View(bank)); } }
public ActionResult Index() { using (var session = NhibernateHelper.OpenSession()) { var sad = session.Query <Models.urun>().ToList(); return(View(sad)); } }
public ActionResult Listele() { using (var session = NhibernateHelper.OpenSession()) { var zup = session.Query <Models.dukkan>().ToList(); return(View(zup)); } }
public ICollection <Runoob_tbl> GetAllUser() { using (ISession session = NhibernateHelper.OpenSession()) //using 代表用完session就释放 { ICriteria criteria = session.CreateCriteria(typeof(Runoob_tbl)); return(criteria.List <Runoob_tbl>()); } }
public ActionResult Listele() { using (var session = NhibernateHelper.OpenSession()) { var oteller = session.Query <Models.Otel>().ToList(); return(View(oteller)); } }
/// <summary> /// 获取所有的用户 /// </summary> /// <returns></returns> public ICollection <userInfo> GetAllUsers() { using (ISession session = NhibernateHelper.openSession()) { IList <userInfo> users = session.CreateCriteria(typeof(userInfo)).List <userInfo>(); return(users); } }
// GET: Banka public ActionResult Index() { using (var session = NhibernateHelper.OpenSession()) { var banks = session.Query <Models.Banka>().Fetch(x => x.Subeler).ToList(); return(View(banks)); } }
public Runoob_tbl GetByUserName(string userName) //查询userName { using (ISession session = NhibernateHelper.OpenSession()) //using 代表用完session就释放 { ICriteria criteria = session.CreateCriteria(typeof(Runoob_tbl)); criteria.Add(Restrictions.Eq("Username", userName)); return(criteria.UniqueResult <Runoob_tbl>()); } }
public User GetById(int id)//查询条件不会更改数据所以不需要使用事务 { using (ISession session = NhibernateHelper.OpenSession()) { //进行操作 User user = session.Get <User>(id);//删除数据 return(user); } }
Ticket IBaseDao <Ticket, long> .FindById(long id) { ISession session = null; session = NhibernateHelper.OpenSession(); return(session.CreateCriteria(typeof(Ticket)) .Add(Restrictions.Eq("Id", id)).List <Ticket>().FirstOrDefault()); }
public ActionResult Listele2() { using (var session = NhibernateHelper.OpenSession()) { //var sube = session.Get<Models.Sube>(1); //var bnkF = session.Query<Models.Banka>().Where(x=> x.Id == 1).FirstOrDefault(); var bnkYeni = new Models.Banka() { Ad = "Yeni Banka", Sehir = "Bursa", Telefon = "0422212123" }; var Sube = new Models.Sube() { Ad = "Sube Yeni", Telefon = "02125334444" }; Sube.Banka = bnkYeni; //var sube = new Models.Sube(); //sube.Ad = "Nilufer"; //sube.Telefon = "02122121218"; //sube.Banka = bnkYeni; //bnkYeni.Subeler.Add(sube); session.SaveOrUpdate(Sube); session.Flush(); //var banka = session.Query<Models.Banka>().Where(x => x.Ad == "A Bankası").FirstOrDefault(); //sube.Banka = banka; //var t = banka.Subeler; //linq query //bnk.Ad = "E bankası"; //bnk.Sube = "Kadıköy"; //var bnkQ = session.Query<Models.Banka>().Where(x => x.Sehir == "Istanbul").ToList(); //rollback //commit //var bnk = new Models.Banka() //{ // Ad = "H Bankası", // Telefon = "312 2121211", // Sehir = "Ankara" //}; //var bnk = session.Query<Models.Banka>().FirstOrDefault(x => x.Id == 7); //session.SaveOrUpdate(bnk); //session.Delete(bnk); } return(View(Models.OgrenciVeri.VeriListe)); }
public void SetUp() { Configuration config = new Configuration(); config.DataBaseIntegration(db => { db.Dialect<MsSql2012Dialect>(); db.Driver<SqlClientDriver>(); db.ConnectionString = "Data Source=DESKTOP-0II3UCP\\MAINSERVER;Initial Catalog=travelme;Integrated Security=True"; }); var mapper = new ModelMapper(); mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes()); HbmMapping mapping = mapper.CompileMappingForAllExplicitlyAddedEntities(); config.AddMapping(mapping); MockConfig = new Mock<IDatabaseConfig>(); MockConfig.SetupSequence(o => o.GetConfig()).Returns(config); helper = new NhibernateHelper(MockConfig.Object); TestUser = new UserEntity() { ID = Guid.Parse("9fc0b724-d55f-441d-a1ae-ec726d7737f7"), FirstName = "Kiran", LastName = "Patel", DateOfBirth = new DateTime(1994, 08, 05, 10, 0, 0), Email = "*****@*****.**", UserPassword = "******", Registered = DateTime.Now, LastLogin = DateTime.Now, InvalidPasswordDate = DateTime.Now }; TestTrip = new Trip() { ID = Guid.Parse("209F9526-3611-4F30-A79C-55557FFBECF5"), TripName = "Australia", TripDescription = "Aussies", TripLocation = "Backpacking", RelationID = Guid.Parse("9fc0b724-d55f-441d-a1ae-ec726d7737f7") }; TestTrip2 = new Trip() { ID = Guid.Parse("6D8BCE5C-5681-472E-A1DC-97C5EA0C23FA"), TripName = "Thailand", TripDescription = "Thai!", TripLocation = "Backpacking", RelationID = Guid.Parse("9fc0b724-d55f-441d-a1ae-ec726d7737f7") }; TestPost = new Post() { ID = Guid.Parse("832B97D6-F958-497A-952D-0224F27C4E1A"), PostData = "PostName", PostLat = "Lat", PostLong = "Long", PostDate = new DateTime(2012,08,09,10,0,0), RelationID = Guid.Parse("209F9526-3611-4F30-A79C-55557FFBECF5") }; TestTrip.Posts.Add(TestPost); TestUser.Trips.Add(TestTrip); TestUser.Trips.Add(TestTrip2); toDeleteUser = new UserEntity() { ID = Guid.NewGuid(), FirstName = "Deleted", LastName = "Deleted", DateOfBirth = new DateTime(1994, 08, 05, 10, 0, 0), Email = "*****@*****.**", UserPassword = "******", InvalidPasswordDate = DateTime.Now, LastLogin = DateTime.Now, Registered = DateTime.Now }; UserEntityRepository ForDelete = new UserEntityRepository(helper); ForDelete.Insert(toDeleteUser); ForDelete = null; }
public void SetUp() { Configuration config = new Configuration(); config.DataBaseIntegration(db => { db.Dialect<MsSql2012Dialect>(); db.Driver<SqlClientDriver>(); db.ConnectionString = "Data Source=DESKTOP-0II3UCP\\MAINSERVER;Initial Catalog=travelme;Integrated Security=True"; }); var mapper = new ModelMapper(); mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes()); HbmMapping mapping = mapper.CompileMappingForAllExplicitlyAddedEntities(); config.AddMapping(mapping); this.MockConfig = new Mock<IDatabaseConfig>(); this.MockConfig.SetupSequence(o => o.GetConfig()).Returns(config); this.helper = new NhibernateHelper(this.MockConfig.Object); this.TestPost = new Post() { ID = Guid.Parse("B1CF1D84-77B1-423B-9BC1-EDE7DB7C6B0B"), PostData = "Test", PostDate = new DateTime(2012,05,08, 10, 0, 0), PostLat = "123", PostLong = "456", RelationID = Guid.Parse("E50E7C95-36D3-470C-905E-564321267F20") }; this.TestPost2 = new Post() { ID = Guid.Parse("5801D5D5-D945-44A2-8CDA-44DB247BAE11"), PostData = "Test2", PostDate = new DateTime(2012, 05, 08, 10, 0, 0), PostLat = "123", PostLong = "456", RelationID = Guid.Parse("E50E7C95-36D3-470C-905E-564321267F20") }; }
public void SetUp() { Configuration config = new Configuration(); config.DataBaseIntegration(db => { db.Dialect<MsSql2012Dialect>(); db.Driver<SqlClientDriver>(); db.ConnectionString = "Data Source=DESKTOP-0II3UCP\\MAINSERVER;Initial Catalog=travelme;Integrated Security=True"; }); var mapper = new ModelMapper(); mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes()); HbmMapping mapping = mapper.CompileMappingForAllExplicitlyAddedEntities(); config.AddMapping(mapping); this.MockConfig = new Mock<IDatabaseConfig>(); this.MockConfig.SetupSequence(o => o.GetConfig()).Returns(config); this.helper = new NhibernateHelper(this.MockConfig.Object); this.TestMedia = new Media() { ID = Guid.Parse("E66E84F1-F9AD-4F29-BA1C-6B38578EE2D8"), MediaData = "/Path/Content/Media.jpg", RelationID = Guid.Parse("522E9121-3F54-4127-B8A2-530B66E1C42C") }; this.TestMedia2 = new Media() { ID = Guid.Parse("173EDD9C-DA41-4FA7-9DDA-07664E7DE271"), MediaData = "Path", RelationID = Guid.Parse("522E9121-3F54-4127-B8A2-530B66E1C42C") }; }
public void GetSession_NormalCase_ReturnsSession() { NhibernateHelper helper = new NhibernateHelper(this.MockConfig.Object); ISession session = helper.GetSession(); Assert.AreEqual(typeof(NHibernate.Impl.SessionImpl), session.GetType()); }
public void GetSession_NullConfig_ThrowsNullReferenceException() { NhibernateHelper helper = new NhibernateHelper(null); helper.GetSession(); }