public void Setup()
{
string productName = ProductName;
LinqCriteria<DepartmentStock> crit = new LinqCriteria<DepartmentStock>();
crit.AddCriteria(stk => stk.ProductMaster.ProductName == productName);
crit.AddCriteria(stk => stk.Quantity > 0);
crit.Fetch(stk => stk.Product);
crit.Fetch(stk => stk.ProductMaster);
crit.Fetch(stk => stk.ProductMaster.ProductType);
_stockList = DepartmentStockLogic.FindAll(crit);
//IList colors = MainStockLogic.GetColorsFromAvailProductInStock(productName);
//IList sizes = MainStockLogic.GetSizesFromAvailProductInStock(productName);
IList<DepartmentStock> _stocks = _stockList;
IList colors = _stocks.Select(s => s.Product.ProductColor).Distinct().ToList();
IList sizes = _stocks.Select(s => s.Product.ProductSize).Distinct().ToList();
ProductColorList = colors;
ProductSizeList = sizes;
SelectedProductColors = new ArrayList();
SelectedProductSizes = new ArrayList();
}
public IList<Product> FindAll(LinqCriteria<Product> crit)
{
return ProductDao.FindAll(crit);
}
public void Setup()
{
string productName = ProductName;
LinqCriteria<MainStock> crit = new LinqCriteria<MainStock>();
crit.AddCriteria(stk => stk.ProductMaster.ProductName == productName);
crit.AddCriteria(stk => stk.Quantity > 0);
/*crit.Fetch(i => i.Product);
crit.Fetch(i => i.ProductMaster);
crit.Fetch(i => i.ProductMaster.ProductType);*/
_stockList = (IList) MainStockLogic.FetchAll(crit);
//IList colors = MainStockLogic.GetColorsFromAvailProductInStock(productName);
//IList sizes = MainStockLogic.GetSizesFromAvailProductInStock(productName);
IList<MainStock> _stocks = ObjectConverter.ConvertTo<MainStock>(_stockList);
IList colors = _stocks.Select(s => s.Product.ProductColor).Distinct().ToList();
IList sizes = _stocks.Select(s => s.Product.ProductSize).Distinct().ToList();
ProductColorList = colors;
ProductSizeList = sizes;
SelectedProductColors = new ArrayList();
SelectedProductSizes = new ArrayList();
}
public IList<DepartmentStock> FindAll(LinqCriteria<DepartmentStock> criteria)
{
return DepartmentStockDao.FindAll(criteria);
}
public IList GetSizesWithProductName(string productName)
{
IList result = new ArrayList();
LinqCriteria<Product> prdCrit = new LinqCriteria<Product>();
prdCrit.AddCriteria(prd => prd.ProductMaster.ProductName.Equals(productName));
IList<ExProductSize> productColor = ProductDao.FindAllSubProperty(prdCrit, prd => prd.ProductSize);
ObjectUtility.AddToList(result, productColor, "SizeName");
return result;
}
public IList FindProductMasterAvailInStock(string name)
{
LinqCriteria<DepartmentStock> crit = new LinqCriteria<DepartmentStock>();
crit.AddCriteria(stk => stk.Quantity > 0);
crit.AddCriteria(stk => stk.ProductMaster.ProductName.Contains(name));
crit.MaxResult = 20;
IList<ProductMaster> list = DepartmentStockDao.FindAllSubProperty(crit, stk => stk.ProductMaster);
var reslist = new ArrayList();
ObjectUtility.AddToList(reslist, list, "ProductName");
return reslist;
}
/// <summary>
/// Useless method
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList<MainStock> FetchAll(LinqCriteria<MainStock> criteria)
{
return (IList<MainStock>)MainStockDao.ExecuteExposedSession(delegate(ISession session)
{
var query = from item in session.Query<MainStock>()
select item;
//Tack on query Criteria parameter
foreach (var criterion in criteria.Where)
{
query = query.Where<MainStock>(criterion);
}
foreach (var criterion in criteria.Order)
{
query = query.OrderBy(criterion);
}
//foreach (var linqCriterion in criteria.FetchProps)
//{
// query = query.FetchThrough(linqCriterion);
//}
/*//query = query.Where(stk => stk.ProductMaster.ProductName == productName);
query = query.Where(stk => stk.Quantity > 0);
crit.Fetch(i => i.Product);
crit.Fetch(i => i.ProductMaster);
crit.Fetch(i => i.ProductMaster.ProductType);*/
//query.Expand(i => i.Product.ProductMaster.ProductType);
//query.Expand(i => i.Product.ProductMaster.Category);
//query.Expand(i => i.Product.ProductColor);
//query.Expand(i => i.Product.ProductSize);
query = query.Fetch(i => i.Product).ThenFetch(i=>i.ProductSize);
query = query.Fetch(i => i.ProductMaster);
query = query.Fetch(i => i.ProductMaster).ThenFetch(i => i.ProductType);
query = query.Fetch(i => i.Product).ThenFetch(i => i.ProductColor);
if (criteria.MaxResult > 0)
{
}
return query.ToList();
});
}
public IList GetSizesFromAvailProductInStock(string productName)
{
LinqCriteria<MainStock> crit = new LinqCriteria<MainStock>();
crit.AddCriteria(stk => stk.Quantity > 0);
crit.AddCriteria(stk => stk.ProductMaster.ProductName == productName);
IList<ExProductSize> list = MainStockDao.FindAllSubProperty(crit, stk => stk.Product.ProductSize);
return ObjectConverter.ConvertFrom(list);
}
public IList FindAll(LinqCriteria<MainStock> crit)
{
return ObjectConverter.ConvertFrom(MainStockDao.FindAll(crit));
}
public UserRole FindRole(string username)
{
LinqCriteria<UserRole> linqCriteria = new LinqCriteria<UserRole>();
linqCriteria.AddCriteria(m => m.Userid.Equals(username));
var result = UserRoleDao.FindAll(linqCriteria);
return result.Count > 0 ? result[0] : null;
}
