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