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);
}