public ActionResult DisplayYourEvents() { // uzytkownik i jego eventy //trzeba zrobic widok z evetami urzytkownika List <DisplayEventViewModel> vm = new List <DisplayEventViewModel>(); using (var db = new ApplicationDbContext()) { var userCompetitions = db.Users.Include(n => n.SingleCompetition).Where(n => n.UserName == User.Identity.Name).First(); var competitions = userCompetitions.SingleCompetition.Where(n => n.StartDate >= DateTime.Today); foreach (var item in competitions) { DisplayEventViewModel _event = new DisplayEventViewModel(); _event.Category = item.Category.ToString(); _event.CompetitorsCount = item.Users.Count(); _event.Image = item.Image; _event.StartDate = item.StartDate; _event.Title = item.Title; _event.Description = item.Description; var _moderator = db.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault(); _event.ModeratorName = $"{_moderator.Informations.FirstName} {_moderator.Informations.LastName}"; vm.Add(_event); } } return(View(vm)); }
// GET: Home public ActionResult Index() { List <DisplayEventViewModel> vm = new List <DisplayEventViewModel>(); using (var db = new ApplicationDbContext()) { DateTime today = DateTime.Now; var min = db.SingleCompetition.Where(n => n.StartDate >= DateTime.Today).OrderBy(cv => cv.StartDate).Take(3); //var allCompetitions = db.SingleCompetition.Select((s => s.OrderByD=> x.Datescending(x e).FirstOrDefault()); foreach (var item in min) { DisplayEventViewModel _event = new DisplayEventViewModel(); _event.Title = item.Title; //_event.ModeratorName = (item as SingleCompetition).ModeratorId; _event.Category = item.Category.ToString(); _event.CompetitorsCount = item.Users.Count(); _event.Image = item.Image; _event.StartDate = item.StartDate; _event.Description = item.Description; _event.ID = item.Id; vm.Add(_event); } } return(View(vm)); }
public ActionResult DisplayEndedEvents() { List <DisplayEventViewModel> vm = new List <DisplayEventViewModel>(); using (var db = new ApplicationDbContext()) { var allCompetitions = db.SingleCompetition.Where(n => n.StartDate < DateTime.Today).ToList(); foreach (var item in allCompetitions) { DisplayEventViewModel _event = new DisplayEventViewModel(); _event.Category = item.Category.ToString(); _event.CompetitorsCount = item.Users.Count(); _event.Image = item.Image; _event.StartDate = item.StartDate; _event.Title = item.Title; _event.Description = item.Description; var _moderator = db.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault(); try { _event.ModeratorName = $"{_moderator.Informations.FirstName} {_moderator.Informations.LastName}"; } catch (Exception) { _event.ModeratorName = "Admin Pawel"; } vm.Add(_event); } } return(View("DisplayEvents", vm)); }