public ActionResult Index(int?id)
{
IQueryable <DB.Products> products = context.Products.OrderByDescending(x => x.AddedDate).Where(x => x.IsDeleted == false || x.IsDeleted == null);
DB.Categories category = null;
if (id.HasValue)
{
products = products.Where(x => x.Category_Id == id.Value);
category = context.Categories.FirstOrDefault(x => x.Id == id.Value);
}
var viewModel = new Models.i.indexModel()
{
Products = products.ToList(),
Category = category
};
return(View(viewModel));
}
public ActionResult Index(int?id)
{
IQueryable <DB.Products> products = context.Products;
DB.Categories category = null;
if (id.HasValue)
{
products = products.Where(x => x.Category_Id == id);
category = context.Categories.FirstOrDefault(x => x.Id == id);
}
var viewModel = new Models.i.indexModel
{
Products = products.ToList(),
Category = category
};
return(View(viewModel));
}
public ActionResult Index(int?id)
{
IQueryable <DB.Products> emlakList = emlakDBEntities.Products;
DB.Category category = null;
if (id > 0)
{
if (id == 1)//Konut Kısmı
{
emlakList = emlakList.Where(x => x.Category_Id == id || x.Category_Id == 5 || x.Category_Id == 6 || x.Category_Id == 7 || x.Category_Id == 8);
}
else if (id == 2)//Bina Kısmı
{
emlakList = emlakList.Where(x => x.Category_Id == id || x.Category_Id == 9 || x.Category_Id == 10);
}
else if (id == 3)//İşyeri Kısmı
{
emlakList = emlakList.Where(x => x.Category_Id == id || x.Category_Id == 11 || x.Category_Id == 12 || x.Category_Id == 13 || x.Category_Id == 14);
}
else if (id == 4)//Arsa Kısmı
{
emlakList = emlakList.Where(x => x.Category_Id == id || x.Category_Id == 15 || x.Category_Id == 16);
}
else if (id == 17)//Emlak Kısmı
{
emlakList = emlakList.Where(x => x.Category_Id == id || x.Category_Id == 5 || x.Category_Id == 6 || x.Category_Id == 7 || x.Category_Id == 8 || x.Category_Id == 9 || x.Category_Id == 10);
}
else
{
emlakList = emlakList.Where(x => x.Category_Id == id);
}
category = emlakDBEntities.Category.FirstOrDefault(x => x.id == id);
}
var viewModel = new Models.i.indexModel()
{
products = emlakList.ToList(),
Category = category
};
return(View(viewModel));
}
