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