public IActionResult ConditionFilter(bool isNew, bool myAdds = false) { var vm = new AddsViewModel { Categories = context.Categories.ToList() }; IQueryable <Add> adds; if (isNew) { adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => a.Article.IsNew); } else { adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => !a.Article.IsNew); } if (myAdds) { var userName = User.Identity.Name; if (userName != null) { var userId = context.Users.Single(u => u.UserName == userName).Id; vm.Adds = adds.Where(a => a.UserId == userId).ToList(); return(View("MyAdds", vm)); }//else mandar error aqui y en todos los filtros } vm.Adds = adds.ToList(); return(View("Index", vm)); }
public IActionResult Index() { var vm = new AddsViewModel { Categories = context.Categories.ToList(), Adds = context.Adds.Include(a => a.User).Include(a => a.Article) .Where(a => a.Amount > 0).ToList() }; return(View(vm)); }
public IActionResult MyAdds() { string currentUserName = User.Identity.Name; var userId = context.Users.Single(u => u.UserName == currentUserName).Id; var avm = new AddsViewModel { Categories = context.Categories.ToList(), Adds = context.Adds.Include(a => a.User).Include(a => a.Article) .Where(a => a.UserId == userId && a.Amount > 0).ToList(), UserIsAdmin = User.IsInRole("Admin") }; return(View(avm)); }
public IActionResult CategoryFilter(int categoryId, bool myAdds = false) { var vm = new AddsViewModel { Categories = context.Categories.ToList() }; if (myAdds) { var userName = User.Identity.Name; var userId = context.Users.Single(u => u.UserName == userName).Id; vm.Adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => a.Article.CategoryId == categoryId && a.UserId == userId).ToList(); return(View("MyAdds", vm)); } vm.Adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => a.Article.CategoryId == categoryId).ToList(); return(View("Index", vm)); }
public IActionResult Search(string search, bool myAdds = false) { var vm = new AddsViewModel { Categories = context.Categories.ToList() }; if (myAdds) { var userName = User.Identity.Name; var userId = context.Users.Single(u => u.UserName == userName).Id; vm.Adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => a.Article.Name.Contains(search) && a.UserId == userId).ToList(); return(View("MyAdds", vm)); } vm.Adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => a.Article.Name.Contains(search)).ToList(); return(View("Index", vm)); }
public IActionResult PriceFilter(float minp, float maxp, bool myAdds = false) { var vm = new AddsViewModel { Categories = context.Categories.ToList() }; if (myAdds) { var userName = User.Identity.Name; var userId = context.Users.Single(u => u.UserName == userName).Id; vm.Adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => (a.Article.Price >= minp && a.Article.Price <= maxp) && a.UserId == userId).ToList(); return(View("MyAdds", vm)); } vm.Adds = context.Adds.Include(a => a.Article).Include(a => a.User).Where(a => (a.Article.Price >= minp && a.Article.Price <= maxp)).ToList(); return(View("Index", vm)); }