public HomePageModel Get() { HomePageModel _HomePage = new HomePageModel(); CartModel CartModel = new CartModel(); using (var context = new RachnaDBContext()) { List <SubCategories> subCategories = new List <SubCategories>(); List <Product> products = new List <Product>(); _HomePage._categories = bCategory.List().Where(m => m.Category_Status == eStatus.Active.ToString()).ToList(); foreach (var item112 in _HomePage._categories) { List <SubCategories> subCategoriesTemp = new List <SubCategories>(); subCategoriesTemp = bSubCategory.List().Where(m => m.Category_Id == item112.Category_Id && m.SubCategory_Status == eStatus.Active.ToString()).ToList(); subCategories.AddRange(subCategoriesTemp); } _HomePage._dealoftheday = context.DealOfTheDay.Include("Product").ToList(); if (_HomePage._dealoftheday.Count > 0) { foreach (var item in _HomePage._dealoftheday) { item.Product.ProductBanner = context.ProductBanner.Where(m => m.Product_Id == item.Product_Id).ToList(); item.Product.ProdComments = context.ProdComments.Where(m => m.Product_Id == item.Product_Id).ToList(); } } _HomePage._ads = context.Advertisement.ToList(); _HomePage._prdeight = context.ProductEights.Include("Product").ToList(); foreach (var item in _HomePage._prdeight) { item.Product.ProductBanner = context.ProductBanner.Where(m => m.Product_Id == item.Product_Id).ToList(); } _HomePage._featureOurChoice = context.ProductFeature.Include("Product") .ToList().Where(m => m.Product_Feature_Type == eProductFeature.OurChoice.ToString()).ToList(); foreach (var item in _HomePage._featureOurChoice) { item.Product.ProductBanner = context.ProductBanner.Where(m => m.Product_Id == item.Product_Id).ToList(); } _HomePage._featureBest = context.ProductFeature.Include("Product") .ToList().Where(m => m.Product_Feature_Type == eProductFeature.Best.ToString()).ToList(); foreach (var item in _HomePage._featureBest) { item.Product.ProductBanner = context.ProductBanner.Where(m => m.Product_Id == item.Product_Id).ToList(); } _HomePage._featureHot = context.ProductFeature.Include("Product") .ToList().Where(m => m.Product_Feature_Type == eProductFeature.Hot.ToString()).ToList(); foreach (var item in _HomePage._featureHot) { item.Product.ProductBanner = context.ProductBanner.Where(m => m.Product_Id == item.Product_Id).ToList(); } _HomePage._recentAddition = context.Product.OrderByDescending(m => m.Product_CreatedDate) .Where(m => m.Product_Status == eProductStatus.Published.ToString()).ToList(); foreach (var item in _HomePage._recentAddition) { item.ProductBanner = context.ProductBanner.Where(m => m.Product_Id == item.Product_Id).ToList(); } _HomePage._stores = context.Store.ToList().Where(m => m.Store_Status == eStatus.Active.ToString()).ToList(); _HomePage._social = context.SocialNetworking.Where(m => m.Scl_Ntk_Status == eStatus.Active.ToString()).ToList(); } return(_HomePage); }