public ActionResult Index(string query = null)
{
// notice that include is in using.system.data.entity
var upcominggigs = _context.Gigs.
Include(m => m.Artist).
Include(m => m.Genre).
Where(g => g.DateTime > DateTime.Now);
if (!string.IsNullOrWhiteSpace(query))
{
upcominggigs = upcominggigs
.Where(g =>
g.Artist.Name.Contains(query) ||
g.Genre.Name.Contains(query) ||
g.Venue.Contains(query));
}
var viewmodel = new Homeviewmodel
{
Upcominggigs = upcominggigs,
ShowActions = User.Identity.IsAuthenticated,
heading = " Upcoming Gigs",
SearchTerm = query
};
return(View("gigs", viewmodel));
}
public IActionResult Home(bool asc)
{
CarManger mgr = new CarManger(@"Data Source=.\sqlexpress;Initial Catalog=Cars;Integrated Security=True;");
Homeviewmodel hmv = new Homeviewmodel();
hmv.cars = mgr.GetAll(asc);
hmv.asc = asc;
return(View(hmv));
}
public ActionResult Index()
{
Homeviewmodel model = new Homeviewmodel
{
Owner = db.Owners.FirstOrDefault(),
ProtofolioItem = db.ProtofolioItems.ToList(),
};
return(View(model));
}
public ActionResult attending()
{
var userId = User.Identity.GetUserId();
var gigs = _Context.Attendances
.Where(a => a.AttendeeId == userId)
.Select(a => a.Gig)
.Include(a => a.Artist)
.Include(a => a.Genre)
.ToList();
var viewmodel = new Homeviewmodel()
{
Upcominggigs = gigs,
ShowActions = User.Identity.IsAuthenticated,
heading = " Gigs I'm attending "
};
return(View("gigs", viewmodel));
}
public ActionResult Search(Homeviewmodel viewmodel)
{
return(RedirectToAction("Index", "Home", new { query = viewmodel.SearchTerm }));
}
