public ActionResult Clubs()
{
string query = "select clubID, userID, clubname from club order by clubname";
//+ "where userID = @userID";
ClubModel clubObj = new ClubModel();
clubObj.userID = (int)HttpContext.Session.GetInt32("UserID");
clubs = SqliteDataAccess.LoadManyObjects(clubObj, query);
StringBuilder clubListHtml = new StringBuilder("<table id=\"clubTbl\">" +
"<tr><th>Club</th><th>Club Id</th></tr>");
foreach (var club in clubs)
{
clubListHtml.Append("<tr><td>");
clubListHtml.Append(club.clubname);
clubListHtml.Append("</td><td>");
clubListHtml.Append(club.clubID);
clubListHtml.Append("</td></tr>");
}
clubListHtml.Append("</table>");
ViewBag.Clubs = clubListHtml;
TempData["Clubs"] = clubListHtml.ToString();
return(RedirectToAction("Application", "Home"));
}
public ActionResult UppcomingEvents()
{
string query = "select * from event where startdate > date('now')";
EventModel eventObj = new EventModel();
eventObjList = SqliteDataAccess.LoadManyObjects(eventObj, query);
StringBuilder eventListHtml = new StringBuilder("<table id=\"pplTbl\"><tr><th style='width:25px'> </th><th>Name</th><th>Date</th><th>Gender</th></tr>");
int i = 1;
foreach (var e in eventObjList)
{
// onclick='javascript:alert(\"hej\")'
// eventListHtml.Append("<tr id=" + i + "><td id='add-icon-cell'><img src='~/images/plus_icon.png' class='icon' onclick='javascript:document.getElementById(\"eventID\").value=\"" + e.eventID + "\"'></td><td>");
eventListHtml.Append("<tr id=" + i + "><td class='add-icon-cell' onclick='javascript:document.getElementById(\"eventID\").value=\"" + e.eventID + "\"'</td><td>");
eventListHtml.Append(e.eventID);
eventListHtml.Append("</td><td>");
eventListHtml.Append(e.startdate);
eventListHtml.Append("</td><td>");
eventListHtml.Append(e.gender);
eventListHtml.Append("</td></tr>");
}
eventListHtml.Append("</table>");
TempData["UpcomingEvents"] = eventListHtml.ToString();
return(RedirectToAction("Application", "Home"));
}
//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"));
}
//Dynamic select options for enrollmember
public List <SelectListItem> ApprovedEventList(int userID)
{
CompetitorModel comp = new CompetitorModel();
comp.userID = userID;
string query = "select e.eventID from eventclub as ec inner join club as c on ec.clubID = c.clubID inner join event as e on e.eventID = ec.eventID where userID = @userID and startdate >= date('now')";
competitorList = SqliteDataAccess.LoadManyObjects(comp, query);
List <SelectListItem> events2 = new List <SelectListItem>();
foreach (var obj in competitorList)
{
events2.Add(new SelectListItem {
Text = obj.eventID, Value = obj.eventID
});
}
comp.eventList = events2;
return(events2);
}
public List <string> ApprovedEventList2(int userID)
{
CompetitorModel comp = new CompetitorModel();
comp.userID = userID;
string query = "select e.eventID from eventclub as ec inner join club as c on ec.clubID = c.clubID inner join event as e on e.eventID = ec.eventID where userID = 16 and startdate >= date('now')";
competitorList = SqliteDataAccess.LoadManyObjects(comp, query);
var events2 = new List <string>();
foreach (var obj in competitorList)
{
events2.Add(obj.eventID);
}
comp.eventListstring = events2.ToList();
return(events2.ToList());
}
public ActionResult ClubMembers()
{
string query = "select u.userID, u.club, u.fname, u.lname, " +
"u.birthdate, u.gender from user as u join club as c " +
"on u.club = c.clubID where c.userID = @userID";
UserModel userObj = new UserModel();
userObj.userID = (int)HttpContext.Session.GetInt32("UserID");
userList = SqliteDataAccess.LoadManyObjects(userObj, query);
StringBuilder userListHtml = new StringBuilder("<table id=\"pplTbl\">" +
"<tr><th>User ID</th><th>Club</th><th>First Name</th>" +
"<th>Last Name</th><th>Birthdate</th><th>Gender</th></tr>");
foreach (var person in userList)
{
userListHtml.Append("<tr onclick='javascript:document.getElementById(\"userID\").value = \"" + person.userID + "\"'><td>");
userListHtml.Append(person.userID);
userListHtml.Append("</td><td>");
userListHtml.Append(person.club);
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></tr>");
}
userListHtml.Append("</table>");
ViewBag.ClubMembers = userListHtml;
TempData["ClubMembers"] = userListHtml.ToString();
// return View("~/Views/Home/Application.cshtml");
return(RedirectToAction("Application", "Home"));
}
public void FinalScore(int jumpID, int groupnr, char style, float height, float dd)
{
Console.WriteLine("Finalscore - jump ID: " + jumpID);
string query = "update jump set finalscore = @finalscore where jumpID=@jumpID";
ScoreModel obj = new ScoreModel();
obj.jumpID = jumpID;
int count = Int32.Parse(SqliteDataAccess.SingleObjectString(obj, "score", "jumpID", "count(jumpID)"));
Console.WriteLine("Score count: " + count);
if (count == 3)
{
Console.WriteLine("All scores are submitted");
//fetch all three scores:
//discard highest and lowest
//muliply by 3
//multiply by (degree of difficulty)
//Fetch degree of difficulty
Console.WriteLine("degree of difficulty: " + dd);
//Fetch all judge scores
string query_all_scores = "select * from score where jumpID = @jumpID";
EventJumpModel jumpscores = new EventJumpModel();
jumpscores.jumpID = jumpID;
scoreList = SqliteDataAccess.LoadManyObjects(jumpscores, query_all_scores);
foreach (var c in scoreList)
{
Console.WriteLine("C: " + c.score);
}
int i, j;
//bubbelsort the three scores
for (i = 0; i < 2; i++)
{
for (j = 0; j < 2 - i; j++)
{
if (scoreList[j].score > scoreList[j + 1].score)
{
var temp = scoreList[j + 1];
scoreList[j + 1] = scoreList[i];
scoreList[j] = temp;
}
}
}
var median_score = scoreList[1].score;
Console.WriteLine("Median score: " + median_score);
//Calcualtes finalscore
var final_score = (median_score * 3) * dd;
Console.WriteLine("Final score: " + final_score);
final_score.ToString("0.00");
Console.WriteLine("fscore: " + final_score);
EventJumpModel finalScore = new EventJumpModel();
finalScore.finalscore = final_score;
finalScore.jumpID = jumpID;
var query_final = "update jump set finalscore = @finalscore where jumpID=@jumpID";
SqliteDataAccess.SaveSingleObject(finalScore, query_final);
}
else
{
//skip
}
}
public ActionResult ClubApplicationManagment(int userID, string button)
{
UserModel clubuser = new UserModel();
ClubModel club = new ClubModel();
UserModel user = new UserModel();
string query;
if (button == "refresh")
{
user.userID = (int)HttpContext.Session.GetInt32("UserID");
query = "select u.userID, u.fname, u.lname from user as u join clubapplication as ca on u.userID = ca.userID join club as c on c.clubID = ca.clubID where c.userID = @userID";
StringBuilder applicationListHtml = new StringBuilder("<table id=\"pplTbl\"><tr><th>User ID</th><th>First Name</th><th>Last Name</th></tr>");
users = SqliteDataAccess.LoadManyObjects(user, query);
foreach (var app in users)
{
applicationListHtml.Append("<tr><td>");
applicationListHtml.Append(app.userID);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.fname);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.lname);
applicationListHtml.Append("</td></tr>");
}
applicationListHtml.Append("</table>");
Console.WriteLine(applicationListHtml);
//ViewBag.ClubApps = applicationListHtml;
TempData["ClubApps"] = applicationListHtml.ToString();
}
else if (button == "accept" && userID != 0)
{
//check if userID + clubID exist in clubapplication
ClubModel exist = new ClubModel();
exist.userID = userID;
query = "select * from clubapplication where userID=@userID";
exist = SqliteDataAccess.SingleObject(exist, query);
if (exist == null)
{
Console.WriteLine("User has not applied to this club");
return(View("~/Views/Home/Application.cshtml"));
}
else
{
club.userID = (int)HttpContext.Session.GetInt32("UserID");
query = "select * from club where userID=@userID";
club = SqliteDataAccess.SingleObject(club, query);
user.userID = userID;
Console.WriteLine("user ID:" + user.userID);
user.club = club.clubID;
Console.WriteLine("user club:" + user.club);
query = "update user set club = @club where userID = @userID";
SqliteDataAccess.SaveSingleObject(user, query);
query = "delete from clubapplication where userID=@userID";
SqliteDataAccess.DenyApplication(user, query);
}
}
else if (button == "deny" && userID != 0)
{
query = "delete from clubapplication where userID=@userID";
user.userID = userID;
SqliteDataAccess.DenyApplication(user, query);
}
else
{
Console.WriteLine("Shit went wrong!");
}
return(RedirectToAction("Application", "Home"));
}
