public Livro GetLivro(int id)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Livro>().Where(x => x.CodLivro == id).List().FirstOrDefault());
}
}
public IList <Livro> GetLivrosEmDestaque(int quantidade)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Livro>().Where(x => x.QuantidadeDisponivel > 0).Take(quantidade).List());
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form_BillBook());
NHibernateUtils nHibernateUtils = new NHibernateUtils();
}
public IList <Livro> GetLivrosPorGenero(Generos genero)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Livro>().Where(x => x.Genero == genero).List());
}
}
public Usuario Get(string userName)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Usuario>().Where(x => x.Login == userName).List().FirstOrDefault());
}
}
public void ConfirmarAluguel(Aluguel aluguel)
{
// TODO: incluir mensagem ao resources
if (aluguel.Livros == null || aluguel.Livros.Count <= 0)
{
throw new ApplicationException("Nenhum livro selecionado para o aluguel.");
}
using (ISession session = NHibernateUtils.OpenSession())
{
using (ITransaction tran = session.BeginTransaction())
{
session.Save(aluguel);
foreach (Livro livro in aluguel.Livros)
{
livro.QuantidadeDisponivel--;
LivroRepository.GetInstance().Update(livro);
}
CarrinhoRepository.GetInstance().LimparCarrinho(aluguel.Usuario);
tran.Commit();
}
}
}
public Carrinho Get(Usuario user)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Carrinho>().Where(x => x.Usuario == user).List().FirstOrDefault());
}
}
public IList <Livro> GetLivrosPorNome(string titulo)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Livro>().Where(x => x.Titulo == titulo).List());
}
}
public Aluguel Get(int codigo)
{
using (ISession session = NHibernateUtils.OpenSession())
{
return(session.QueryOver <Aluguel>().Where(x => x.CodAluguel == codigo).List().FirstOrDefault());
}
}
public virtual IEnumerable <IWarehouseState> Get(Dddml.Support.Criterion.ICriterion filter, IList <string> orders = null, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <WarehouseState>();
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
AddNotDeletedRestriction(criteria);
return(criteria.List <WarehouseState>());
}
public virtual IEnumerable <IPermissionState> GetPermissionTreeRoots(IEnumerable <KeyValuePair <string, object> > filter, IList <string> orders, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <PermissionState>();
CriteriaAddRootParentIdCriterion(criteria);
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
return(criteria.List <PermissionState>());
}
public virtual IEnumerable <IOrderState> Get(IEnumerable <KeyValuePair <string, object> > filter, IList <string> orders = null, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <OrderState>();
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
AddNotDeletedRestriction(criteria);
return(criteria.List <OrderState>());
}
public virtual IEnumerable <IPermissionState> GetPermissionTreeChildren(string parentId, Dddml.Support.Criterion.ICriterion filter, IList <string> orders, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <PermissionState>();
NHibernateUtils.CriteriaAddCriterion(criteria, "ParentPermissionId", parentId);
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
return(criteria.List <PermissionState>());
}
public virtual IEnumerable <IOrganizationStructureState> GetOrganizationTreeRoots(Dddml.Support.Criterion.ICriterion filter, IList <string> orders, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <OrganizationStructureState>();
CriteriaAddOrganizationTreeRootParentIdCriterion(criteria);
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
return(criteria.List <OrganizationStructureState>());
}
private IList <BillItem> SelectByMonth(DateTime date)
{
ISession session = NHibernateUtils.GetCurrentSession();
string hql = "from BillItem where year(date)=" + date.Year + " and month(date)=" + date.Month;
IQuery query = session.CreateQuery(hql);
return(query.List <BillItem>());
}
public virtual IEnumerable <IOrganizationStructureState> GetOrganizationTreeChildren(string parentId, IEnumerable <KeyValuePair <string, object> > filter, IList <string> orders, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <OrganizationStructureState>();
NHibernateUtils.CriteriaAddCriterion(criteria, "Id.ParentId", parentId);
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
return(criteria.List <OrganizationStructureState>());
}
public virtual long GetCount(IEnumerable<KeyValuePair<string, object>> filter)
{
var criteria = CurrentSession.CreateCriteria<SellableInventoryItemState>();
criteria.SetProjection(Projections.RowCountInt64());
NHibernateUtils.CriteriaAddFilter(criteria, filter);
AddNotDeletedRestriction(criteria);
return criteria.UniqueResult<long>();
}
private IList <BillItem> SelectByDay(DateTime date)
{
ISession session = NHibernateUtils.GetCurrentSession();
string hql = "from BillItem where date='" + date.ToShortDateString() + "'";
IQuery query = session.CreateQuery(hql);
return(query.List <BillItem>());
}
public virtual long GetCount(IEnumerable <KeyValuePair <string, object> > filter)
{
var criteria = CurrentSession.CreateCriteria <AttributeSetInstanceExtensionFieldGroupState>();
criteria.SetProjection(Projections.RowCountInt64());
NHibernateUtils.CriteriaAddFilter(criteria, filter);
AddNotDeletedRestriction(criteria);
return(criteria.UniqueResult <long>());
}
public virtual long GetCount <T>(IEnumerable <KeyValuePair <string, object> > filter) where T : class, IPartyState
{
var criteria = CurrentSession.CreateCriteria <T>();
criteria.SetProjection(Projections.RowCountInt64());
NHibernateUtils.CriteriaAddFilter(criteria, filter);
AddNotDeletedRestriction(criteria);
return(criteria.UniqueResult <long>());
}
public virtual IEnumerable <Dddml.Wms.Domain.Party.IOrganizationState> GetOrganizationTreeRootOrganizations(IEnumerable <KeyValuePair <string, object> > filter, IList <string> orders, int firstResult = 0, int maxResults = int.MaxValue)
{
var criteria = CurrentSession.CreateCriteria <Dddml.Wms.Domain.Party.OrganizationState>();
var dc = DetachedCriteria.For <OrganizationStructureState>().SetProjection(Projections.Property("Id.SubsidiaryId"));
criteria.Add(Subqueries.PropertyNotIn("PartyId", dc));
NHibernateUtils.CriteriaAddFilterAndOrdersAndSetFirstResultAndMaxResults(criteria, filter, orders, firstResult, maxResults);
return(criteria.List <Dddml.Wms.Domain.Party.OrganizationState>());
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RegisterGlobalFilters(GlobalFilters.Filters);
RegisterRoutes(RouteTable.Routes);
ControllerBuilder.Current.SetControllerFactory(new NinjectControllerFactory());
NHibernateUtils.EnsureStartup();
}
public Form_BillBook()
{
InitializeComponent();
try
{
NHibernateUtils.InitSessionFactory();
}catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Usuario Get(string userName, string password)
{
using (ISession session = NHibernateUtils.OpenSession())
{
Usuario user = session.QueryOver <Usuario>().Where(x => x.Login == userName && x.Senha == password).List().FirstOrDefault();
if (user != null)
{
user.Senha = null;
}
return(user);
}
}
public bool saveNewBill(BillItem billItem)
{
try
{
ISession session = NHibernateUtils.GetCurrentSession();
ITransaction transaction = session.BeginTransaction();
transaction.Begin();
session.Save(billItem);
transaction.Commit();
return(true);
}
catch (Exception e)
{
Log.exceptionLog(e);
return(false);
}
}
private void CriteriaAddOrganizationTreeRootParentIdCriterion(ICriteria criteria)
{
IList <object> rootParentIdValues = new object[] { "" };
if (rootParentIdValues.Count == 1)
{
NHibernateUtils.CriteriaAddCriterion(criteria, "Id.ParentId", rootParentIdValues[0]);
}
else
{
var j = Restrictions.Disjunction();
foreach (var pIdValue in rootParentIdValues)
{
NHibernateUtils.DisjunctionAddCriterion(j, "Id.ParentId", pIdValue);
}
criteria.Add(j);
}
}
public void RegistrarDevolucao(Aluguel aluguel)
{
aluguel.DataDevolucao = DateTime.Now;
using (ISession session = NHibernateUtils.OpenSession())
{
using (ITransaction tran = session.BeginTransaction())
{
session.Update(aluguel);
foreach (Livro livro in aluguel.Livros)
{
livro.QuantidadeDisponivel++;
LivroRepository.GetInstance().Update(livro);
}
tran.Commit();
}
}
}
private void Button_Exit_Click(object sender, EventArgs e)
{
NHibernateUtils.ReleaseSessionFactory();
Application.Exit();
}
