public ActionResult AdminViewPortal()
{
MajorProjectEntities sd = new MajorProjectEntities();
ViewBag.EventList = new SelectList(GetEventList(), "event_id", "event_name");
return(View());
}
public List <Event> GetEventList()
{
MajorProjectEntities sd = new MajorProjectEntities();
List <Event> events = sd.Events.ToList();
return(events);
}
public ActionResult ListofParticipants(int sportsid)
{
MajorProjectEntities sd = new MajorProjectEntities();
List <Sports_reg> userids = sd.Sports_reg.Where(x => x.sport_id == sportsid).ToList();
List <string> usernamelist = new List <string>();
List <User> users = new List <User>();
foreach (var item in userids)
{
users.Add(sd.Users.FirstOrDefault(x => x.uid == item.userid));
}
foreach (var item in users)
{
usernamelist.Add(item.username);
Console.WriteLine(item.username);
}
ViewBag.listof = usernamelist;
return(PartialView("ListofParticipants"));
}
public ActionResult GetSportsList(int SLid)
{
MajorProjectEntities sd = new MajorProjectEntities();
var mymodel = new MultiTable();
mymodel.reg1 = sd.Sport_tournamentlist.ToList();
mymodel.reg2 = sd.Cultural_eventlist.ToList();
if (SLid == 1)
{
ViewBag.Sportslist = new SelectList(sd.Sport_tournamentlist, "sports_evid", "sport_name");
ViewBag.Message = "sport";
}
else
{
ViewBag.Sportslist = new SelectList(sd.Cultural_eventlist, "cul_evid", "event_name");
ViewBag.Message = "event";
}
return(PartialView("DisplaySportsList"));
}
public ActionResult ListofParticipants11(int event_id)
{
MajorProjectEntities sd = new MajorProjectEntities();
List <Cultural_reg> culuserids = sd.Cultural_reg.Where(x => x.eventid == event_id).ToList();
List <string> culusernamelist = new List <string>();
List <User> culusers = new List <User>();
foreach (var item in culuserids)
{
culusers.Add(sd.Users.FirstOrDefault(x => x.uid == item.userid));
}
foreach (var item in culusers)
{
culusernamelist.Add(item.username);
Console.WriteLine(item.username);
}
ViewBag.listof1 = culusernamelist;
return(PartialView("ListofParticipants11"));
}
