public TOut LoadJewelryCollection <TOut>(TOut viewModel) where TOut : ITabsViewModel { var dynamicSQLObject = GetDynamicSQLStringBytabKeyAndID(tabKey, tabId); jewelRepository.Page(page); jewelRepository.ItemsPerPage(itemsPerPage); var jewelMediaType = JewelMediaTypeFilter.Value; jewelRepository.FilterMediaByMetal(jewelMediaType); jewelRepository.OrderJewelryItemsBy(OrderByPriceFilter.DynamicOrderBy()); if (CustomFiltersStateList.Count > 0) { var dynamicSQLList = CustomFiltersStateList.Select(x => ConvertCustomFilterStateToDynamicSQL(x)).ToList(); jewelRepository.AddFilterList(dynamicSQLList); } var jewelList = jewelRepository.GetJewelsByDynamicSQL(dynamicSQLObject); viewModel.JewelryInTabContainersCollection = MapJewelsToInTabContainers(jewelList); var totalItems = jewelRepository.TotalItems; viewModel.TotalPages = CalculateTotalPages(totalItems); return(viewModel); }
public ActionResult BestOfferWidget() { var jewels = _jewelRepository.GetJewelsByDynamicSQL(new DynamicSQLWhereObject("ONBARGAIN = @0", true)) .OrderBy(random => Guid.NewGuid()); ; var viewModel = new BestOfferWidgetViewModel { Jewels = jewels.Select(ToJewelDescriptor).Take(5).ToList(), Count = jewels.Count() }; return(View(viewModel)); }
public SpecialOffersBannervViewModel Build() { var jewel = jewelRepository.GetJewelsByDynamicSQL(new DynamicSQLWhereObject("onspecial = true")).OrderBy(x => Guid.NewGuid()).Take(1).ToList().FirstOrDefault(); return mapper.Map<Jewel, SpecialOffersBannervViewModel>(jewel); }