public ActionResult EventApplication(int ID, string button)
{
EventApplicationModel eventApplication = new EventApplicationModel();
eventApplication.ID = ID;
Console.WriteLine("id: " + eventApplication.ID);
Console.WriteLine("btn: " + button);
if (button == "refresh")
{
StringBuilder applicationListHtml = new StringBuilder("<table id=\"pplTbl\"><tr><th>ID</th><th>Event ID</th><th>Club ID</th><th>Club Name</th><th>Gender</th><th>Date</th></tr>");
events = SqliteDataAccess.LoadEventApplication();
int i = 1;
foreach (var app in events)
{
applicationListHtml.Append("<tr id=" + i + "><td>");
applicationListHtml.Append(app.ID);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.eventID);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.clubID);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.clubname);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.gender);
applicationListHtml.Append("</td><td>");
applicationListHtml.Append(app.startdate);
applicationListHtml.Append("</td></tr>");
}
applicationListHtml.Append("</table>");
Console.WriteLine(applicationListHtml);
TempData["EventApps"] = applicationListHtml.ToString();
}
else if (button == "accept" && ID != 0)
{
eventApplication.eventID = SqliteDataAccess.SingleObjectString(eventApplication, "eventapplication", "ID", "eventID");
eventApplication.clubID = Int32.Parse(SqliteDataAccess.SingleObjectString(eventApplication, "eventapplication", "ID", "clubID"));
Console.WriteLine("event id: " + eventApplication.eventID);
Console.WriteLine("club id: " + eventApplication.clubID);
SqliteDataAccess.ApproveEvent(eventApplication);
}
else if (button == "deny" && ID != 0)
{
SqliteDataAccess.DenyEvent(eventApplication);
}
else
{
Console.WriteLine("Shit went wrong!");
}
return(RedirectToAction("Managment", "Home"));
}
public ActionResult RoleApplication(int userIDField, string button)
{
Console.WriteLine("LoadRoleApplication triggered!");
RoleApplicationModel applicant = new RoleApplicationModel();
applicant.userID = userIDField;
Console.WriteLine("ID: " + applicant.userID);
Console.WriteLine("role: " + applicant.role);
if (button == "refresh")
{
StringBuilder applicationListHtml = new StringBuilder("<table id=\"pplTbl\"><tr><th>User ID</th><th>First Name</th><th>Last Name</th><th>Role</th></tr>");
applications = SqliteDataAccess.LoadRoleApplication();
foreach (var app in applications)
{
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><td>");
applicationListHtml.Append(app.role);
applicationListHtml.Append("</td></tr>");
}
applicationListHtml.Append("</table>");
Console.WriteLine(applicationListHtml);
TempData["RoleApps"] = applicationListHtml.ToString();
}
else if (button == "accept" && userIDField != 0)
{
//Finds the requested role
applicant.role = SqliteDataAccess.SingleObjectString(applicant, "roleapplication", "userID", "role");
//Approves request
SqliteDataAccess.ApproveRole(applicant);
}
else if (button == "deny" && userIDField != 0)
{
SqliteDataAccess.DenyRole(applicant);
}
else
{
Console.WriteLine("Shit went wrong!");
}
return(RedirectToAction("Managment", "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
}
}