public override List<AttributeDTO> GetArray(List<int> values, List<int> values1) { try { using (var context = new PICEntities()) { var cnt = values.Count(); List<AttributeDTO> lst = null; List<AttributeDTO> lst1 = new List<AttributeDTO>(); List<long> pids = context.pic_attr_value.Select(g => g.product_id).Distinct().ToList(); foreach (var item in pids) { AttributeDTO attr = new AttributeDTO(); for (var i = 0; i < cnt; i++) { var productid = item; var att = values[i]; var attl = values1[i]; //var count = context.pic_attr_value.Count(a => a.attr_id == att && a.attr_lov_id == attl && a.product_id == productid); //if (count == 0) break; //if (i == cnt - 1) //{ var pavs = context.pic_attr_value.Where(a => a.attr_id == att && a.attr_lov_id == attl && a.product_id == productid).Select(g => g.product_id).Distinct().SingleOrDefault(); if (pavs!= 0) { var st = context.pic_product.SingleOrDefault(a => a.product_id == pavs); if (st.part_number != null && st.part_description!=null) { attr.AttrName = st.part_number; attr.temp = st.part_description; } if (attr != null && i == cnt - 1) { lst1.Add(attr); } } //} } } return lst1; } } catch (Exception) { return new List<AttributeDTO>(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)