//naar nieuwe detailpage gaan en de info meegeven
private void btnClickedInfo(object sender, EventArgs args)
{
Results2 g = (sender as Button).BindingContext as Results2;
var DetailPage = new Views.DetailPage(g);
Navigation.PushModalAsync(DetailPage);
}
private async Task NavigateToShoePage()
{
TrelloCard card = (TrelloCard)lvwTrelloLists.SelectedItem;
List <Results2> shoeData = await ShoesRepository.GetShoesByNameAsync(card.name);
Results2 shoe = shoeData[0];
var DetailPage = new Views.DetailPage(shoe);
Navigation.PushModalAsync(DetailPage);
}
private async Task addcard(Results2 result)
{
await DisplayAlert("Alert", "You added this shoe as favorite", "OK");
string listId = "5fd4e03623dc8d8494238fd9";
TrelloCard newCard = new TrelloCard {
name = result.Name, CardDesc = result.ImgUrl, IsClosed = false
};
await TrelloRepository.AddCardAsync(listId, newCard);
}
public ActionResult FinalReport(string term)
{
ViewBag.Term = term;
int t = int.Parse(term);
int studentID = int.Parse(Session["StudentID"].ToString());
var query = from s in db.Students
join ar in db.AssessmentResults on s.StudentID equals ar.StudentID
join a in db.Assessments on ar.AssessmentID equals a.AssessmentID
join c in db.Classes on a.ClassID equals c.ClassID
where s.StudentID == studentID && ar.result != -1 && a.term == t
select new { a.assessment_name, a.assessment_date, ar.result, c.subject_name, a.assessment_constribution };
List <Results> results = new List <Results>();
foreach (var item in query)
{
Results r = new Results();
r.date = item.assessment_date;
r.name = item.assessment_name;
r.mark = (item.result / 100) * item.assessment_constribution;
r.subject = item.subject_name;
results.Add(r);
}
var search = from r in results
group r by new { r.subject } into g
select new
{
subject = g.Key.subject,
mark = g.Select(x => x.mark).Sum()
};
List <Results2> results2 = new List <Results2>();
double accum = 0;
double count = 0;
foreach (var item in search)
{
Results2 r = new Results2();
r.subject = item.subject;
r.mark = Math.Round(item.mark);
accum += r.mark;
count += 1;
results2.Add(r);
}
if (count > 0)
{
ViewBag.Average = Math.Round(accum / count);
}
else
{
ViewBag.Average = "";
}
return(View("FinalReport", results2));
}
//Add favorite to Trello cards
private void AddFavorite(object sender, EventArgs e)
{
Results2 g = (sender as Button).BindingContext as Results2;
addcard(g);
}
public DetailPage(Results2 result)
{
InitializeComponent();
this.shoe = result;
ShowDetails();
}
