public void LoadProducts()
{
AzureDataServicePerson azureDataServicePerson;//load onto page
azureDataServicePerson = new AzureDataServicePerson();
try
{
azureDataServicePerson.LoadPersons();
}
catch (Exception er)
{
DisplayAlert("Alert", "Could not load products" + er, "Ok");
}
}
public async Task ExecuteDatabaseCommandAsync(string firstName, string lastName, string age, string ppsn, string cardNumber)
{
string enteredFirstName = FirstName.Text;
string enteredLastName = LastName.Text;
string enteredAge = (Age.Text);
string enteredPPSN = PPSN.Text;
string enteredCardN = (CardNumber.Text);
azureDataServicePerson = new AzureDataServicePerson();
//send accepted inputs to db
if (IsBusy)
{
return;
}
bool exists;
try
{
IsBusy = true;
exists = await azureDataServicePerson.CheckPPSN(enteredPPSN);// check ppsn as its unique
if (exists == true)
{
await DisplayAlert("Alert", "Name: " + firstName + " already exists, Please check person table", "Ok");
}
else if (exists == false)
{//if not in db insert
var coffee = await azureDataServicePerson.AddPerson(firstName, lastName, age, ppsn, cardNumber);
Coffees.Add(coffee);
await DisplayAlert("Alert", "Person Added", "Ok");
Navigation.PopAsync();
}
}
catch (Exception ex)
{
Debug.WriteLine("da error: " + ex);
//http://pmhsilva.org/validate-irish-ppsn-with-javascript-jquery/
}
finally
{
IsBusy = false;
}
}
private async Task updatePerson(object sender, EventArgs e)
{
editSelection.FirstName = FirstName.Text;
editSelection.LastName = LastName.Text;
editSelection.Age = (Age.Text);
editSelection.PPSN = PPSN.Text;
editSelection.CardNumber = (CardNumber.Text);
AzureDataServicePerson azureDataServicePerson;
azureDataServicePerson = new AzureDataServicePerson();
await azureDataServicePerson.UpdatePersons(editSelection);
await DisplayAlert("Person Updated", "You have updated " + editSelection.FirstName + " " + editSelection.LastName, "ok");
await Navigation.PushAsync(new MainPage());
}
async void OnItemSelected(object sender, SelectedItemChangedEventArgs e)
{
if (e.SelectedItem != null)
{
var selection = e.SelectedItem as Person;
var res = await DisplayAlert("Delete Person!!!", "Are you sure you want to delete: " + selection.FirstName, "ok", "Cancel");
if (res == true)//if ok is seected delete
{
AzureDataServicePerson azureDataServicePerson;
azureDataServicePerson = new AzureDataServicePerson();
await azureDataServicePerson.DeletePersons(selection);
await DisplayAlert("Person Deleted", "Person Deleted", "ok");
await Navigation.PopAsync();
}
}
}
