public static void DBinitialize()
{
using (ITransaction transaction = NhibernateSessionManager.OpenSession().BeginTransaction())
{
mySession.Save(new User {
UserName = "******", FirstName = "administrator", LastName = "Administrator", HashedPassword = UserRepository.CalculateHash("admin", "admin"), UserMail = "*****@*****.**", UserRole = User.Role.admin
});
mySession.Save(new User {
UserName = "******", FirstName = "user", LastName = "User", HashedPassword = UserRepository.CalculateHash("user", "user"), UserMail = "*****@*****.**", UserRole = User.Role.user
});
mySession.Save(new User {
UserName = "******", FirstName = "visitor", LastName = "Visitor", HashedPassword = UserRepository.CalculateHash("visitor", "visitor"), UserMail = "*****@*****.**", UserRole = User.Role.visitor
});
mySession.Save(new Supplier {
FirstName = "John", LastName = "Papa", Ids = "12345", Grs = "12345", Tel1 = "123456789", Mob1 = "123456789", Email = "*****@*****.**", LblPrintText = "--"
});
mySession.Save(new Supplier {
FirstName = "Greek", LastName = "Freak", Ids = "123456", Grs = "123456", Tel1 = "123456789", Mob1 = "123456789", Email = "*****@*****.**", LblPrintText = "--"
});
mySession.Save(new Material {
Code = "001", Title = "Dole bananas", Description = "", TextBox_1 = "", TextBox_2 = "", Origin = "Ecuador", Type = "cavendish"
});
mySession.Save(new Material {
Code = "014", Title = "Orsero bananas", Description = "", TextBox_1 = "", TextBox_2 = "", Origin = "Ecuador", Type = "cavendish"
});
transaction.Commit();
};
}
public T FindById(int id)
{
try
{
return(NhibernateSessionManager.OpenSession().Load <T>(id));
}
catch (Exception ex)
{
((MainWindow)Application.Current.MainWindow).AddExceptionTextMsg(ex.ToString());
throw;
}
}
public IList <T> FindAll()
{
try
{
return(NhibernateSessionManager.OpenSession().CreateCriteria(typeof(T)).List <T>());
}
catch (Exception ex)
{
((MainWindow)Application.Current.MainWindow).AddExceptionTextMsg(ex.ToString());
throw;
}
}
public void Delete(T entity)
{
using (ITransaction transaction = NhibernateSessionManager.OpenSession().BeginTransaction())
{
try
{
var session = NhibernateSessionManager.OpenSession();
session.Delete(entity);
transaction.Commit();
session.Flush();
session.Clear();
}
catch (Exception ex)
{
transaction.Rollback();
((MainWindow)Application.Current.MainWindow).AddExceptionTextMsg(ex.ToString());
}
}
}
