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