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 - CategoriesRepository
	/// </summary>
	public partial class CategoriesRepository : RepositoryBase, ICategoriesRepository
	{
	
		#region Select Methods
		
		public List<Categories> GetAll()
		{
			List<Categories> categoriesList = new List<Categories>();
            NHibernateSession.CreateCriteria(typeof(Categories)).List(categoriesList);
            return categoriesList;
		}
		
		public Categories GetById(System.Int32 categoryid)
		{
			return NHibernateSession.Load(typeof(Categories), categoryid) as Categories;
		}
		
		public List<Categories> Find(string ConditionString)
		{
			
			if (string.IsNullOrEmpty(ConditionString))
            {
				List<Categories> categoriesList = new List<Categories>();
				NHibernateSession.CreateCriteria(typeof(Categories)).List(categoriesList);
				return categoriesList;
            }
            else
            {
                IQuery query = NHibernateSession.CreateQuery(string.Format("From {0} where {1}", "Categories", ConditionString));
				return new List<Categories>(query.List<Categories>());
            }
		}
		

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

	}
}