private void SaveButton_Clicked(object sender, EventArgs e)
{
// Check if filled in
if (String.IsNullOrEmpty(letterEntry.Text) || String.IsNullOrEmpty(valueEntry.Text))
{
DisplayAlert(AppResources.error, AppResources.notAllFieldFilledIn, AppResources.ok);
}
else
{
// Get input
string letter = letterEntry.Text;
float value = float.Parse(valueEntry.Text);
// Connect to database
using (SQLiteConnection connection = new SQLiteConnection(App.DatabaseLocation))
{
connection.CreateTable <FormulaLetter>();
// Check if letter already exists
List <FormulaLetter> formulaLetters = connection.Table <FormulaLetter>().ToList();
formulaLetters = (from formulaLetter in formulaLetters where formulaLetter.Letter == letter select formulaLetter).ToList();
if (formulaLetters.Count == 0) // Letter does not yet exist
{
// Insert new letter
FormulaLetter newFormulaLetter = new FormulaLetter {
Letter = letter, Value = value
};
int rows = connection.Insert(newFormulaLetter);
// Check for errors
if (rows > 0)
{
DisplayAlert(AppResources.succes, AppResources.succesLetterAdded, AppResources.ok);
Navigation.PopModalAsync();
}
else
{
DisplayAlert(AppResources.error, AppResources.errorDefault, AppResources.ok);
}
}
else // Letter does already exist
{
DisplayAlert(AppResources.error, AppResources.errorLetterAlreadyExists, AppResources.ok);
}
}
}
}
public FormulaEditLetterPage(FormulaLetter formulaLetter)
{
InitializeComponent();
this.formulaLetter = formulaLetter;
}
private void LettersListView_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
FormulaLetter formulaLetter = lettersListView.SelectedItem as FormulaLetter;
Navigation.PushModalAsync(new FormulaEditLetterPage(formulaLetter));
}
