public Persion GetPersionById(int id)
{
using (var session = SessionFactoryHandler.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var persionList = session.QueryOver <Persion>().Where(x => x.Id == id).List();
transaction.Commit();
return(persionList.FirstOrDefault());
}
}
}
public void SavePersion(Persion persion)
{
using (var session = SessionFactoryHandler.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
session.Save(persion);
session.Flush();
transaction.Commit();
}
}
}
public IList <Persion> GetPersionByName(string name)
{
using (var session = SessionFactoryHandler.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var persionList = session.QueryOver <Persion>().Where(x => x.Name == name);
transaction.Commit();
return(persionList.List());
}
}
}
public IList <Persion> GetAllPersion()
{
using (var session = SessionFactoryHandler.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var persionList = session.QueryOver <Persion>();
transaction.Commit();
return(persionList.List());
}
}
}
public void UpdatePersion(Persion persion)
{
using (var session = SessionFactoryHandler.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
//model.Name = persion.Name;
//model.Age = persion.Age;
session.Update(persion);
session.Flush();
transaction.Commit();
}
}
}
public void DeleteById(int id)
{
using (var session = SessionFactoryHandler.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
Persion p1 = new Persion();
p1.Id = id;
session.Delete(p1);
session.Flush();
transaction.Commit();
}
}
}
