Introduction to Model Driven Development with Sculpture – Part 1

//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by Sculpture Code Generation Engine.
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
//     Generated On : 28/08/2008 06:20:10 م
// </auto-generated>
//------------------------------------------------------------------------------

using System;
using NHibernate;
using NHibernate.Expression;
using System.Collections.Generic;
using Entities;

namespace DataAccess
{
	
	/// <summary>
	/// Data Repository Class - ProductsRepository
	/// </summary>
	public partial class ProductsRepository : RepositoryBase, IProductsRepository
	{
	
		#region Select Methods
		
		public List<Products> GetAll()
		{
			List<Products> productsList = new List<Products>();
            NHibernateSession.CreateCriteria(typeof(Products)).List(productsList);
            return productsList;
		}
		
		public Products GetById(System.Int32 productid)
		{
			return NHibernateSession.Load(typeof(Products), productid) as Products;
		}
		
		public List<Products> Find(string ConditionString)
		{
			
			if (string.IsNullOrEmpty(ConditionString))
            {
				List<Products> productsList = new List<Products>();
				NHibernateSession.CreateCriteria(typeof(Products)).List(productsList);
				return productsList;
            }
            else
            {
                IQuery query = NHibernateSession.CreateQuery(string.Format("From {0} where {1}", "Products", ConditionString));
				return new List<Products>(query.List<Products>());
            }
		}
		

		public List<Products> GetByCategories(System.Int32 CategoryID)
		{
			List<Products> _Products = new List<Products>();
			ICriteria criteria = NHibernateSession.CreateCriteria(typeof(Products));
			criteria.Add(Expression.Eq("CategoryID", CategoryID));
			criteria.List(_Products);
			return _Products;
		}

		#endregion
		
		#region Insert Methods
		
		public void Insert(Products _Products)
		{
			NHibernateSession.Save(_Products);
			_Products.EntityState = EntityState.Unchanged;
		}
		
		public void Insert(List<Products> _Productss)
		{
			foreach(Products _Products in _Productss)
			{
				NHibernateSession.Save(_Products);
				_Products.EntityState = EntityState.Unchanged;
			}
		}
		
		#endregion
		
		#region Update Methods
		
		public void Update(Products _Products)
		{
			NHibernateSession.SaveOrUpdate(_Products);
			_Products.EntityState = EntityState.Unchanged;
		}
		
		public void Update(List<Products> _Productss)
		{
			foreach(Products _Products in _Productss)
			{
				NHibernateSession.SaveOrUpdate(_Products);
				_Products.EntityState = EntityState.Unchanged;
            }
		}
		
		#endregion
		
		#region Delete Methods
		
		public void Delete(Products _Products)
		{
			NHibernateSession.Delete(_Products);
			_Products.EntityState = EntityState.Deleted;
		}
		
		public void Delete(List<Products> _Productss)
		{
			foreach(Products _Products in _Productss)
			{
				NHibernateSession.Delete(_Products);
				_Products.EntityState = EntityState.Deleted;
			}
		}
		
		public void Delete(string ConditionString)
		{
			foreach(Products _Products in Find(ConditionString))
			{
				NHibernateSession.Delete(_Products);
				_Products.EntityState = EntityState.Deleted;
			}
		}
		
		#endregion

	}
}