public System.Collections.Generic.IEnumerable<NorthwindWebNHibernate.Business.Territories> Search(string territoryId, string territoryDescription, NorthwindWebNHibernate.Business.Region fkTerritoriesRegion)
        {
            return _context.NorthwindDbo.CreateCriteria<NorthwindWebNHibernate.Business.Territories>()
                                    .Add(NHibernate.Criterion.Restrictions.Eq("territoryId", territoryId))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("territoryDescription", territoryDescription))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("fkTerritoriesRegion", fkTerritoriesRegion))

                        .List<NorthwindWebNHibernate.Business.Territories>();
        }
 public void Update(NorthwindWebNHibernate.Business.Sysdiagrams v)
 {
     using(NHibernate.ITransaction tx = _context.NorthwindDbo.BeginTransaction())
     {
         try
         {
             _context.NorthwindDbo.Update(v);
             tx.Commit();
         }
         catch
         {
             tx.Rollback();
             throw;
         }
     }
 }
 public void Delete(NorthwindWebNHibernate.Business.Categories v)
 {
     using (NHibernate.ITransaction tx = _context.NorthwindDbo.BeginTransaction())
     {
         try
         {
             _context.NorthwindDbo.Delete(v);
             tx.Commit();
         }
         catch
         {
             tx.Rollback();
             throw;
         }
     }
 }
Пример #4
0
 public void Create(NorthwindWebNHibernate.Business.Customers v)
 {
     using(NHibernate.ITransaction tx = _context.NorthwindDbo.BeginTransaction())
     {
         try
         {
             _context.NorthwindDbo.Save(v);
             tx.Commit();
         }
         catch
         {
             tx.Rollback();
             throw;
         }
     }
 }
Пример #5
0
        public System.Collections.Generic.IEnumerable<NorthwindWebNHibernate.Business.Products> Search(int productId, string productName, string quantityPerUnit, decimal unitPrice, short unitsInStock, short unitsOnOrder, short reorderLevel, bool discontinued, NorthwindWebNHibernate.Business.Categories fkProductsCategories, NorthwindWebNHibernate.Business.Suppliers fkProductsSuppliers)
        {
            return _context.NorthwindDbo.CreateCriteria<NorthwindWebNHibernate.Business.Products>()
                                    .Add(NHibernate.Criterion.Restrictions.Eq("productId", productId))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("productName", productName))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("quantityPerUnit", quantityPerUnit))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("unitPrice", unitPrice))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("unitsInStock", unitsInStock))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("unitsOnOrder", unitsOnOrder))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("reorderLevel", reorderLevel))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("discontinued", discontinued))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("fkProductsCategories", fkProductsCategories))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("fkProductsSuppliers", fkProductsSuppliers))

                        .List<NorthwindWebNHibernate.Business.Products>();
        }
Пример #6
0
        public System.Collections.Generic.IEnumerable<NorthwindWebNHibernate.Business.Orders> Search(int orderId, System.DateTime? orderDate, System.DateTime? requiredDate, System.DateTime? shippedDate, decimal freight, string shipName, string shipAddress, string shipCity, string shipRegion, string shipPostalCode, string shipCountry, NorthwindWebNHibernate.Business.Customers fkOrdersCustomers, NorthwindWebNHibernate.Business.Employees fkOrdersEmployees, NorthwindWebNHibernate.Business.Shippers fkOrdersShippers)
        {
            return _context.NorthwindDbo.CreateCriteria<NorthwindWebNHibernate.Business.Orders>()
                                    .Add(NHibernate.Criterion.Restrictions.Eq("orderId", orderId))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("orderDate", orderDate))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("requiredDate", requiredDate))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shippedDate", shippedDate))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("freight", freight))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shipName", shipName))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shipAddress", shipAddress))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shipCity", shipCity))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shipRegion", shipRegion))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shipPostalCode", shipPostalCode))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("shipCountry", shipCountry))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("fkOrdersCustomers", fkOrdersCustomers))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("fkOrdersEmployees", fkOrdersEmployees))
                                                .Add(NHibernate.Criterion.Restrictions.Eq("fkOrdersShippers", fkOrdersShippers))

                        .List<NorthwindWebNHibernate.Business.Orders>();
        }
 public SysdiagramsRepository(NorthwindWebNHibernate.Context context)
 {
     _context = context;
 }
 public CategoriesRepository(NorthwindWebNHibernate.Context context)
 {
     _context = context;
 }
Пример #9
0
 public CustomersRepository(NorthwindWebNHibernate.Context context)
 {
     _context = context;
 }
Пример #10
0
 public ProductsRepository(NorthwindWebNHibernate.Context context)
 {
     _context = context;
 }
Пример #11
0
 public ShippersRepository(NorthwindWebNHibernate.Context context)
 {
     _context = context;
 }