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