private void appbarSaveResults_Click(object sender, RoutedEventArgs e) { DisplayMessage display = new DisplayMessage(); try { Lotto insert = new Lotto(); int storeValue = 0; bool txtBox = display.checkNullTextboxes(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtSix.Text, txtBonus.Text); bool final = display.checkForChar(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtSix.Text, txtBonus.Text); if (txtBox == true) { display.msgBox("textbox must not be left empty!!"); } else if (final == false) { display.msgBox("You must enter number/s and not character/s."); } else { bool blnValid = display.checkIntegerLottoResults(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtSix.Text, txtBonus.Text); if (blnValid == true && final == true) { storeValue = 1; } else if (blnValid == false) { display.msgBox("number must be within the 1-49 range."); } } if (storeValue == 1) { int check = 0; string line = dpDate.Date.ToString().Substring(0, 11).Trim();//date from datepicker string but = ((ComboBoxItem)cmbType.SelectedItem).Content.ToString(); if (but == "Lotto") { winnings.store(but, txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtSix.Text, txtBonus.Text); check = 1; } else if (but == "LottoPlus") { winnings.storeLottoPlus(but, txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtSix.Text, txtBonus.Text); check = 2; } /////////////FROM HERE STORE NUMBERS INTO THE DATABASE/////////// if (check == 1) { storeValues.setStoreLottoLiveResults(winnings.getNumbers(0), winnings.getNumbers(1), winnings.getNumbers(2), winnings.getNumbers(3), winnings.getNumbers(4), winnings.getNumbers(5), winnings.getNumbers(6), line); display.msgBox("all is good. refresh the page"); } else if (check == 2) { storeValues.setStoreLottoPlusResults(winnings.getLottoPlus(0), winnings.getLottoPlus(1), winnings.getLottoPlus(2), winnings.getLottoPlus(3), winnings.getLottoPlus(4), winnings.getLottoPlus(5), winnings.getLottoPlus(6), line); display.msgBox("all is good. refresh the page"); } ////////////FROM HERE STORE NUMBERS INTO THE DATABASE//////////// } } catch (Exception ex) { display.msgBox(ex.Message); } }