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