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 05:49:33 م
// </auto-generated>
//------------------------------------------------------------------------------

using System;
using System.Data;
using System.Linq;
using System.Data.Linq;
using System.Collections.Generic;
using Entities;

namespace  DataAccess
{
	
	/// <summary>
	/// Data Repository Class - CategoriesRepository
	/// </summary>
	public partial class CategoriesRepository : RepositoryBase<Categories>, ICategoriesRepository
	{
		
		#region Select Methods
		
		public List<Categories> GetAll()
		{
			return new List<Categories>(_entityTable.ToList());
		}
		
		public Categories GetById(System.Int32 categoryid)
		{
			return (from _Categories in _entityTable
					where (_Categories.CategoryID == categoryid)
					select _Categories).Single<Categories>();
		}
		
		public List<Categories> Find(string ConditionString)
		{
			
			if (string.IsNullOrEmpty(ConditionString))
                return new List<Categories>(_entityTable.ToList());
            else
            {
                string sql = string.Format("select * from {0} where {1}", "dbo.Categories", ConditionString);
                return new List<Categories>(DataContext.ExecuteQuery<Categories>(sql).ToList());
            }
		}
		

		#endregion
		
		#region Insert Methods
		
		public void Insert(Categories _Categories)
		{
			_entityTable.InsertOnSubmit(_Categories);
			_Categories.EntityState = EntityState.Unchanged;
		}
		
		public void Insert(List<Categories> _Categoriess)
		{
			foreach(Categories _Categories in _Categoriess)
			{
				_entityTable.InsertOnSubmit(_Categories);
				_Categories.EntityState = EntityState.Unchanged;
			}
		}
		
		#endregion
		
		#region Update Methods
		
		public void Update(Categories _Categories)
		{
			if(!_entityTable.Contains(_Categories))
                _entityTable.Attach(_Categories);
			_Categories.EntityState = EntityState.Unchanged;
			
		}
		
		public void Update(List<Categories> _Categoriess)
		{
			foreach(Categories _Categories in _Categoriess)
			{
				if(!_entityTable.Contains(_Categories))
					_entityTable.Attach(_Categories);
				_Categories.EntityState = EntityState.Unchanged;
            }
		}
		
		#endregion
		
		#region Delete Methods
		
		public void Delete(Categories _Categories)
		{
			if(!_entityTable.Contains(_Categories))
                _entityTable.Attach(_Categories);
			_entityTable.DeleteOnSubmit(_Categories);
			_Categories.EntityState = EntityState.Deleted;
		}
		
		public void Delete(List<Categories> _Categoriess)
		{
			foreach(Categories _Categories in _Categoriess)
			{
				if(!_entityTable.Contains(_Categories))
					_entityTable.Attach(_Categories);
				_entityTable.DeleteOnSubmit(_Categories);
				
				_Categories.EntityState = EntityState.Deleted;
			}
		}
		
		public void Delete(string ConditionString)
		{
			foreach(Categories _Categories in Find(ConditionString))
			{
				if(!_entityTable.Contains(_Categories))
					_entityTable.Attach(_Categories);
				_entityTable.DeleteOnSubmit(_Categories);
				_Categories.EntityState = EntityState.Deleted;
			}
		}
		
		#endregion
		
	}
}