public ActionResult MyListings(int?id)
{
checkCookie();
List <Sale> li = new List <Sale>();
ListCardListSale vm = new ListCardListSale()
{
Sales = li,
Users = new List <User>(),
};
if (Session["UserID"] == null)
{
Session["UserID"] = 0;
}
if (id == null)
{
return(RedirectToAction("Login", "Users"));
}
foreach (var i in db.Sales.Include("Card.Cardtype").Include("Watcher").Include("CardCondition").Include("CardGrade").Include("Seller.UserLevel").Where(x => x.Seller.ID == id & x.IsSold == false & x.ForAuction == false))
{
li.Add(i);
vm.Users.Add(i.Seller);
}
vm.Sales = li;
return(View(vm));
}
public ActionResult Search(string search)
{
checkCookie();
if (search == null)
{
return(RedirectToAction("Index"));
}
ListCardListSale li = new ListCardListSale()
{
Cards = new List <Card>(),
Sales = new List <Sale>(),
Users = new List <User>(),
};
foreach (var i in db.Sales.Include("Card.Cardtype").Include("CardGrade").Include("CardCondition").Include("Watcher").Include("Seller.UserLevel").Where(x => x.Card.name.Contains(search) & x.ForAuction == false | x.Card.print_tag.Contains(search) & x.ForAuction == false | x.Card.Cardtype.Name == search & x.ForAuction == false | x.Seller.Username == search & x.ForAuction == false | x.CardGrade.Grading == search & x.ForAuction == false | x.Card.rarity.Contains(search) & x.ForAuction == false))
{
if (i.ID != 1 & i.IsSold == false)
{
li.Sales.Add(i);
}
}
foreach (var i in db.Cards.Include("Cardtype").Where(x => x.name.Contains(search) | x.print_tag.Contains(search) | x.Cardtype.Name == search | x.rarity.Contains(search)))
{
if (li.Cards.Where(x => x.name == i.name).FirstOrDefault() == null)
{
if (i.ID != 1)
{
li.Cards.Add(i);
}
}
}
foreach (var i in db.Users.Where(x => x.Username.Contains(search)))
{
if (i.ID != 1)
{
li.Users.Add(i);
}
}
return(View(li));
}
