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; }