private void AppBarButton_Click_3(object sender, RoutedEventArgs e)
{
try
{
Lotto insert = new Lotto();
bool txtBox = display.checkTextboxesPowerball(txtP1.Text, txtP2.Text, txtP3.Text, txtP4.Text, txtP5.Text);
bool final = display.checkForCharactersPowerball(txtP1.Text, txtP2.Text, txtP3.Text, txtP4.Text, txtP5.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.checkIntegerPowerball(txtP1.Text, txtP2.Text, txtP3.Text, txtP4.Text, txtP5.Text);
if (blnValid == true && final == true)
{
insert.savePowerballGeneratedNumbers(Convert.ToInt32(txtP1.Text), Convert.ToInt32(txtP2.Text), Convert.ToInt32(txtP3.Text), Convert.ToInt32(txtP4.Text), Convert.ToInt32(txtP5.Text));
display.msgBox("Successfully added to the database.");
}
else if (blnValid == false)
{
display.msgBox("number must be within the 1-49 range.");
}
}
}
catch (Exception ex)
{
display.msgBox(ex.Message);
}
}
private void appbarSaveResults_Click(object sender, RoutedEventArgs e)
{
try
{
Lotto insert = new Lotto();
int storeValue = 0;
bool txtBox = message.checkTextboxes(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtBonus.Text);
bool final = message.checkForCharacters(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtBonus.Text);
if (txtBox == true)
{
message.msgBox("textbox must not be left empty!!");
}
else if (final == false)
{
message.msgBox("You must enter number/s and not character/s.");
}
else
{
bool blnValid = message.checkInteger(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtBonus.Text);
if (blnValid == true && final == true)
{
storeValue = 1;
}
else if (blnValid == false)
{
message.msgBox("number must be within the 1-49 range.");
}
}
if (storeValue == 1)
{
string line = dpDate.Date.ToString().Substring(0, 11);//date from datepicker
winnings.storePowerBall(txtOne.Text, txtTwo.Text, txtThree.Text, txtFour.Text, txtFive.Text, txtBonus.Text);
/////////////FROM HERE STORE NUMBERS INTO THE DATABASE///////////
storeValues.setStorePowerBallResults(winnings.getPowerBallNumbers(0), winnings.getPowerBallNumbers(1), winnings.getPowerBallNumbers(2), winnings.getPowerBallNumbers(3), winnings.getPowerBallNumbers(4), winnings.getPowerBallNumbers(5), line);
message.msgBox("all is good. refresh the page");
////////////FROM HERE STORE NUMBERS INTO THE DATABASE////////////
}
}
catch (Exception ex)
{
message.msgBox(ex.Message);
}
}
private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
try
{
txtblockFirstNameError.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
txtBlockSurnameError.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
if (textBoxFirstName.Text == "" && textBoxLastName.Text == "")
{
txtblockFirstNameError.Visibility = Windows.UI.Xaml.Visibility.Visible;
txtBlockSurnameError.Visibility = Windows.UI.Xaml.Visibility.Visible;
}
else if (textBoxLastName.Text == "")
{
txtBlockSurnameError.Visibility = Windows.UI.Xaml.Visibility.Visible;
}
else if (textBoxFirstName.Text == "")
{
txtblockFirstNameError.Visibility = Windows.UI.Xaml.Visibility.Visible;
}
else
{
//User addDetails = new User()
//{
// name = textBoxFirstName.Text,
// Surname = textBoxLastName.Text
//};
//SQLiteAsyncConnection conn = new SQLiteAsyncConnection("newProject.db");
//await conn.InsertAsync(addDetails);
Lotto insert = new Lotto();
insert.InsertUserDetails(textBoxFirstName.Text, textBoxLastName.Text);
message.msgBox("Successfully added into the database.");
}
}
catch (Exception ex)
{
message.msgBox(ex.Message);
}
}
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);
}
}
public ObservableCollection<Lotto> getIdValues()
{
maximum = new ObservableCollection<Lotto>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Query<LottoLiveResults>("select id from LottoLiveResults");
foreach (var collect in query)
{
var _collect = new Lotto()
{
IdNumber = collect.Id
};
maximum.Add(_collect);
}
}
return maximum;
}
public ObservableCollection<Lotto> getKeyValues()
{
highest = new ObservableCollection<Lotto>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Query<PowerBallResults>("select id from PowerBallResults");
foreach (var _call in query)
{
var call = new Lotto()
{
IdNumber = _call.Id
};
highest.Add(call);
}
}
return highest;
}
private void AppBarButton_Click_5(object sender, RoutedEventArgs e)
{
try
{
Lotto lottery = new Lotto();
int aa, bb, cc, dd, ee, ff;
aa = numbers[0];
bb = numbers[1];
cc = numbers[2];
dd = numbers[3];
ee = numbers[4];
ff = numbers[5];
lottery.setUserSavedNumbers(aa, bb, cc, dd, ee, ff);
msg.msgBox("Successfully Saved. You will can view your numbers on the results page and compare with the latest Lotto and Lotto Plus results");
}
catch (Exception ex)
{
msg.msgBox("Error Message: " + ex.Message);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
Lotto lottery = new Lotto();
int aa, bb, cc, dd, ee;
aa = numbers[0];
bb = numbers[1];
cc = numbers[2];
dd = numbers[3];
ee = numbers[4];
lottery.savePowerballGeneratedNumbers(aa, bb, cc, dd, ee);
//msg.msgBox("Successfully Saved. You will can view your numbers on the results page and compare with the latest Lotto and Lotto Plus results");
}
catch (Exception ex)
{
msg.msgBox("Error Message: " + ex.Message);
}
}