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