public JsonResult GetProductAttributes(string category) { List <GbMAttributes> listGbMAttributes = null; List <FSCFoodAttributes> objFoodAttributes = new List <FSCFoodAttributes>(); try { int categoryId = 0; listGbMAttributes = new List <GbMAttributes>(); try { Int32.TryParse(category, out categoryId); } catch (Exception exc) { categoryId = 0; } listGbMAttributes = new ClsCommon().GetFoodAttributes(0, categoryId, ""); if (listGbMAttributes != null && listGbMAttributes.Count > 0) { var grpAttributes = listGbMAttributes.GroupBy(n => new { n.AttributeGroupCode, n.AttributeGroupDesc }) .Select(g => new { g.Key.AttributeGroupCode, g.Key.AttributeGroupDesc }).ToList(); foreach (var attr in grpAttributes) { FSCFoodAttributes fscAttribute = new FSCFoodAttributes(); fscAttribute.AttributeGroupCode = attr.AttributeGroupCode; fscAttribute.AttributeGroupDesc = attr.AttributeGroupDesc; List <FSCFoodAttributeValues> attributeValuesList = new List <FSCFoodAttributeValues>(); foreach (var att in listGbMAttributes) { if (att.AttributeGroupCode == attr.AttributeGroupCode) { FSCFoodAttributeValues attValue = new FSCFoodAttributeValues(); attValue.AttributeId = att.AttributeId; attValue.AttributeValue = att.AttributeValue; attValue.AttributeGroupCode = att.AttributeGroupCode; attValue.AttributeGroupDesc = att.AttributeGroupDesc; attributeValuesList.Add(attValue); } } fscAttribute.FoodAttributes = attributeValuesList; objFoodAttributes.Add(fscAttribute); } } return(Json(objFoodAttributes)); } catch (Exception ex) { throw ex; } finally { listGbMAttributes = null; } }
private void GetFoodProductViewBagData(Int64 productId, int categoryId) { ClsCommon clsCommon = new ClsCommon(); ViewBag.FoodProductIUCategory = clsCommon.GetCategory(0); ViewBag.FoodProductIUVendor = clsCommon.GetVendors(0); ViewBag.FoodProductIUCurrency = clsCommon.GetCurrency(0); if (productId > 0) { List <GbMProductAttribute> objProductAttributes = new ClsFoodProduct().GetProductAttributes(productId, 0); if (objProductAttributes != null && objProductAttributes.Count > 0) { ViewBag.FoodProductIUAttributes = objProductAttributes; } if (categoryId > 0 && objProductAttributes.Count > 0) { List <GbMAttributes> listGbMAttributes = new List <GbMAttributes>(); List <FSCFoodAttributes> objFoodAttributes = new List <FSCFoodAttributes>(); #region Get Master Attributes listGbMAttributes = new ClsCommon().GetFoodAttributes(0, categoryId, ""); if (listGbMAttributes != null && listGbMAttributes.Count > 0) { var grpAttributes = listGbMAttributes.GroupBy(n => new { n.AttributeGroupCode, n.AttributeGroupDesc }) .Select(g => new { g.Key.AttributeGroupCode, g.Key.AttributeGroupDesc }).ToList(); foreach (var attr in grpAttributes) { FSCFoodAttributes fscAttribute = new FSCFoodAttributes(); fscAttribute.AttributeGroupCode = attr.AttributeGroupCode; fscAttribute.AttributeGroupDesc = attr.AttributeGroupDesc; List <FSCFoodAttributeValues> attributeValuesList = new List <FSCFoodAttributeValues>(); foreach (var att in listGbMAttributes) { if (att.AttributeGroupCode == attr.AttributeGroupCode) { FSCFoodAttributeValues attValue = new FSCFoodAttributeValues(); attValue.AttributeId = att.AttributeId; attValue.AttributeValue = att.AttributeValue; attValue.AttributeGroupCode = att.AttributeGroupCode; attValue.AttributeGroupDesc = att.AttributeGroupDesc; attributeValuesList.Add(attValue); } } fscAttribute.FoodAttributes = attributeValuesList; objFoodAttributes.Add(fscAttribute); } } #endregion if (objFoodAttributes != null && objFoodAttributes.Count > 0) { ViewBag.FoodProductIUAllAttributes = objFoodAttributes; } } } }