private List <OrderDetailProductItem> GetProductRecipe(decimal todayCode, int categoryId) { var _cateRecipeDa = new CateRecipeDA(); var categoryIds = _cateRecipeDa.GetCategoryChild(categoryId); var list = _cateRecipeDa.GetProduct(categoryIds); return(list); }
public void GetProduct() { CateRecipeDA _cateRecipeDa = new CateRecipeDA(); var categories = _cateRecipeDa.GetCategoryChild(3); var list = _cateRecipeDa.GetProduct(categories); var b = _cateRecipeDa.GetProductFinal(list); ProduceDa _produceDa = new ProduceDa(); var lst = _produceDa.GetCategoryRecipe(3); }
private OrderGabModel GetProducts2(decimal todayCode) { var categoriesId = new int[] { 3 }; var _cateRecipeDa = new CateRecipeDA(); //get product customer order var listTmp = OrderDetailItems(todayCode, 3); var productWeight = listTmp.GroupBy(m => m.ProductID).Select(m => new OrderDetailProductItem() { ProductId = m.Key ?? 0, Weight = m.Sum(n => n.Weight ?? 0) }); var result = new OrderGabModel(); foreach (var categoryId in categoriesId) { var category = _categoryDa.GetItemById(categoryId); var categoryIds = _cateRecipeDa.GetCategoryChild(categoryId); var list = _cateRecipeDa.GetProduct(categoryIds); foreach (var orderDetailProductItem in list) { var product = productWeight.FirstOrDefault(m => m.ProductId == orderDetailProductItem.ProductId); orderDetailProductItem.Weight = product?.Weight ?? 0; } result = new OrderGabModel() { ID = categoryId, Name = category.Name, Products = list.Where(m => m.PriceUnit > 0).ToList(), }; } return(result); }
private OrderGabModel GetProducts(decimal todayCode) { var categoriesId = new int[] { 3 }; var _cateRecipeDa = new CateRecipeDA(); //get product customer order var products = _contactOrderDa.GetProductDetail(AgencyId, todayCode); var listTmp = new List <OrderDetailItem>(); foreach (var orderDetailItem in products) { var productRecipe = _productDetailRecipeDa.GetProductRecipe(orderDetailItem.ProductID ?? 0); if (productRecipe != null) { var productsRecipe = _productDetailRecipeDa.GetRecipeDetails(productRecipe.ID); foreach (var recipeProductDetail in productsRecipe) { if (recipeProductDetail.DetailID != null) { listTmp.Add(new OrderDetailItem() { ProductID = recipeProductDetail.DetailID.Value, Weight = recipeProductDetail.Quantity * orderDetailItem.Weight, }); } else { throw new Exception("ProductDetail_Recipe"); } } } else { listTmp.Add(orderDetailItem); } } var productWeight = listTmp.GroupBy(m => m.ProductID).Select(m => new OrderDetailProductItem() { ProductId = m.Key ?? 0, Weight = m.Sum(n => n.Weight ?? 0) }); var result = new OrderGabModel(); foreach (var categoryId in categoriesId) { var category = _categoryDa.GetItemById(categoryId); var categoryIds = _cateRecipeDa.GetCategoryChild(categoryId); var list = _cateRecipeDa.GetProduct(categoryIds); foreach (var orderDetailProductItem in list) { var product = productWeight.FirstOrDefault(m => m.ProductId == orderDetailProductItem.ProductId); orderDetailProductItem.Weight = product?.Weight ?? 0; } result = new OrderGabModel() { ID = categoryId, Name = category.Name, Products = list.Where(m => m.PriceUnit > 0).ToList(), }; } return(result); }