private void FillBranchItemList() { var database = new QuizDatabase(Resources.GetString(Resource.String.quizDatabaseName)); branchItemList = new List<BranchItem>(); foreach (var branch in database.BranchQuery) { branchItemList.Add(new BranchItem { BranchName = branch.Name, QuestionCount = database.QuestionQuery.Where(x => x.BranchId == branch.Id).Count(), }); } }
private void BtnAdd_Click(object sender, EventArgs e) { dbSupport = new QuizDatabase(Resources.GetString(Resource.String.quizDatabaseName)); var n = dbSupport.BranchQuery.Where(x => x.Name.ToLower() == tvBranchName.Text.ToLower()).Count(); if (n == 0) { var branch = new Branch(tvBranchName.Text); dbSupport.InsertAndUpdate(branch); } else { Toast.MakeText(this, Resources.GetString(Resource.String.branchExsists), ToastLength.Long).Show(); } Finish(); }
private void AddToDatabase(int checkedOption) { AlertDialog.Builder alert = new AlertDialog.Builder(this); alert.SetTitle(Resource.String.AddRecordToDatabase); alert.SetPositiveButton(Resource.String.closeDialogPositive, (senderAlert, args) => { dbSupport = new QuizDatabase(Resources.GetString(Resource.String.quizDatabaseName)); Question question = new Question { BranchId = Intent.GetIntExtra("BranchId", -1), Content = tvQuestion.Text, CorrectAnswers = rbtnOption[checkedOption].Text }; dbSupport.InsertAndUpdate(question); OptionAnswers options = new OptionAnswers { QuestionId = GetQuestionCount(question.BranchId) + 1, FirstOption = rbtnOption[0].Text, SecondOption = rbtnOption[1].Text, ThirdOption = rbtnOption[2].Text, FourthOption = rbtnOption[3].Text }; dbSupport.InsertAndUpdate(options); Finish(); }); alert.SetNegativeButton(Resource.String.closeDialogNegative, (senderAlert, args) => { rbtnOption[checkedOption].Checked = false; }); Dialog dialog = alert.Create(); dialog.Show(); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.Game); dbSupport = new QuizDatabase(Resources.GetString(Resource.String.quizDatabaseName)); branchId = Intent.GetIntExtra("BranchId", -1); questionCount = dbSupport.QuestionQuery.Where(x => x.BranchId == branchId).Count(); FillItemList(); tvCount = FindViewById<TextView>(Resource.Id.textViewCount); tvQuestion = FindViewById<TextView>(Resource.Id.textViewQuestion); rbtnFirst = FindViewById<RadioButton>(Resource.Id.radioButtonFirst); rbtnFirst.Click += SelectFirstRadioButton; rbtnSecond = FindViewById<RadioButton>(Resource.Id.radioButtonSecond); rbtnSecond.Click += SelectSecondRadioButton; rbtnThird = FindViewById<RadioButton>(Resource.Id.radioButtonThird); rbtnThird.Click += SelectThirdRadioButton; rbtnFourth = FindViewById<RadioButton>(Resource.Id.radioButtonFourth); rbtnFourth.Click += SelectFourthRadioButton; btnNext = FindViewById<Button>(Resource.Id.buttonNext); btnNext.Click += NextQuestion; btnPrevious = FindViewById<Button>(Resource.Id.buttonPrevious); btnPrevious.Click += PreviousQuestion; FillForm(currentCount); }
public AnswerRepository(IQuizDatabaseSettings settings) { quizDatabase = new QuizDatabase(settings); }
public QuestionRepository(IQuizDatabaseSettings settings) { quizDatabase = new QuizDatabase(settings); }