public List<Result> getAllResultsByRound(Round round) { var result = (from r in dc.Results where r.FK_Round== round.Round_Id select r).ToList<Result>(); return result; }
public List<Question> getAllQuestions(Round round) { if (round == null) { throw new Exception("Round must be given..."); } var result = (from q in dc.Questions where q.FK_Round == round.Round_Id select q).ToList<Question>(); return result; }
public void setRound(Round rnd) { round = rnd; //clear the lists and recreate the values playableQuestions.Clear(); List<Question> questions = gm.getAllQuestions(round); foreach (Question q in questions) { playableQuestions.Add(new PlayableQuestion(q)); } }
public PlayableRound(Round rnd) { //select the round round = rnd; if (round.Round_started != null) { DateTime maxTime = (DateTime)round.Round_started; maxTime = maxTime.AddSeconds((double)round.Max_Time); DateTime currentTime = DateTime.Now; isActive = (round.Round_started <= currentTime && currentTime < maxTime); } //get the questions and create playable questions List<Question> questions = gm.getAllQuestions(round); foreach(Question q in questions) { playableQuestions.Add(new PlayableQuestion(q)); } }
public Round getRoundByName(Round round) { if (round == null) { throw new Exception("Round must be given..."); } var result = (from r in dc.Rounds where r.Round_name == round.Round_name select r).SingleOrDefault(); return (Round)result; }
public int updateRound(Round round) { //query naar database om waarde te vinden Round result = (from r in dc.Rounds where r.Round_Id == round.Round_Id select r).Single(); //veranderingen aanbrengen if (round.FK_Quiz != null) result.FK_Quiz = round.FK_Quiz; if (round.Max_Time != null) result.Max_Time = round.Max_Time; if (round.Round_name != null) result.Round_name = round.Round_name; //updaten in db try { dc.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); throw new Exception("Value couldn't be updated..."); } return result.Round_Id; }
public Round stopRound(Round round) { //stop de ronde Round result = (from r in dc.Rounds where r.Round_Id == round.Round_Id select r).SingleOrDefault(); TimeSpan maxTime = (TimeSpan)(DateTime.Now - result.Round_started); result.Max_Time = (int)maxTime.TotalSeconds; //updaten in db try { dc.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); throw new Exception("Value couldn't be updated..."); } return result; }
public int insertRound(Round r) { dc.Rounds.InsertOnSubmit(r); try { dc.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); throw new Exception("Query couldn't be executed..."); } return r.Round_Id; }
private Round selectRound(String id) { GameModel gm = new GameModel(); Round round = new Round(); //kijk of de quiz gegeven is, anders gaan we de status aanpassen naar "no quiz given" int roundId; String status; try { roundId = int.Parse(id); try { round.Round_Id = roundId; round = gm.getRound(round); status = "success"; } catch (Exception e) { Console.WriteLine(e); status = "no round given"; } } catch (Exception e) { //als we hier terechtkomen is de id een textuele string (bv. "abc") try { round.Round_name = id; round = gm.getRoundByName(round); status = "success"; } catch (Exception ex) { Console.WriteLine(ex); status = "no round given"; } } if (status != "success") { return new Round(); } else { return round; } }
partial void DeleteRound(Round instance);
partial void UpdateRound(Round instance);
partial void InsertRound(Round instance);
private void detach_Rounds(Round entity) { this.SendPropertyChanging(); entity.Quiz = null; }
private void attach_Rounds(Round entity) { this.SendPropertyChanging(); entity.Quiz = this; }