|
//------------------------------------------------------------------------------
// <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
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Program Manager in Sculpture project, Interesting in .NET Model driven development.