//Displays clubmembers who are enrolled in upcoming events
// Något galet här! fel userid och kön bland annat
public ActionResult EnrolledMembers()
{
string query = "select * from user as u inner join competitor as c " +
"on u.userID = c.userID " +
"inner join club as cl on cl.clubID = u.club " +
"inner join eventcompetitor as ec on ec.competitorID = c.competitorID " +
"inner join event as e on e.eventID = ec.eventID " +
"where cl.userID = @userID and startdate >= date('now')";
EnrolledUserModel userObj = new EnrolledUserModel();
userObj.userID = (int)HttpContext.Session.GetInt32("UserID");
enrolled = SqliteDataAccess.LoadManyObjects(userObj, query);
StringBuilder userListHtml = new StringBuilder("<table id=\"pplTbl\">" +
"<tr><th>Event</th><th>User ID</th><th>Club</th><th>First Name</th>" +
"<th>Last Name</th><th>Birthdate</th><th>Gender</th><th>Date</th></tr>");
foreach (var person in enrolled)
{
Console.WriteLine("event: " + person.eventID);
userListHtml.Append("<tr><td>");
userListHtml.Append(person.eventID);
userListHtml.Append("</td><td>");
userListHtml.Append(person.userID);
userListHtml.Append("</td><td>");
userListHtml.Append(person.clubname);
userListHtml.Append("</td><td>");
userListHtml.Append(person.fname);
userListHtml.Append("</td><td>");
userListHtml.Append(person.lname);
userListHtml.Append("</td><td>");
userListHtml.Append(person.birthdate);
userListHtml.Append("</td><td>");
userListHtml.Append(person.gender);
userListHtml.Append("</td><td>");
userListHtml.Append(person.startdate);
userListHtml.Append("</td></tr>");
}
userListHtml.Append("</table>");
ViewBag.EnrolledMembers = userListHtml;
TempData["EnrolledMembers"] = userListHtml.ToString();
return(RedirectToAction("Application", "Home"));
}
//Adds member to eventcompetitor if club is in eventclub table
public ActionResult EnrollMember(CompetitorModel comp)
{
//checks if club is allowed to submit members for said event
EnrolledUserModel obj = new EnrolledUserModel();
obj.eventID = comp.eventID;
obj.userID = (int)HttpContext.Session.GetInt32("UserID");
string query1 = "select * from eventclub as ec join club as c on ec.clubID = c.clubID where userID = @userID and ec.eventID = @eventID";
Console.WriteLine("1. " + comp.eventID + " " + comp.userID);
obj = SqliteDataAccess.SingleObject(obj, query1);
if (obj == null)
{
Console.WriteLine("NULL");
return(RedirectToAction("Application", "Home"));
}
else
{
CompetitorModel competitor = new CompetitorModel();
competitor.userID = comp.userID;
string query3 = "select * from competitor where userID = @userID";
competitor = SqliteDataAccess.SingleObject(competitor, query3);
competitor.eventID = comp.eventID;
string query2 = "insert into eventcompetitor(eventID, competitorID) values(@eventID, @competitorID)";
SqliteDataAccess.SaveSingleObject(competitor, query2);
for (int i = 1; i < 7; i++)
{
CompetitorModel comp2 = new CompetitorModel();
comp2.eventID = comp.eventID;
comp2.competitorID = competitor.competitorID;
comp2.jumpnr = i;
competitorList.Add(comp2);
}
string query4 = "insert into jump(eventID, competitorID, jumpnr) values(@eventID, @competitorID, @jumpnr)";
SqliteDataAccess.SaveManyObjects(competitorList, query4);
}
return(RedirectToAction("Application", "Home"));
}
