private void AddVocableToDatabase(object sender, RoutedEventArgs e)
{
try
{
if (string.IsNullOrWhiteSpace(Infinitiv.Text) || string.IsNullOrWhiteSpace(SimplePast.Text) ||
string.IsNullOrWhiteSpace(PastParticiple.Text) || string.IsNullOrWhiteSpace(Translation.Text))
{
throw new Exception("Fields must NOT be empty FOOL!");
}
var vokabel = new VokabelModel
{
Infinitiv = Infinitiv.Text,
SimplePast = SimplePast.Text,
PastParticiple = PastParticiple.Text,
Translation = Translation.Text
};
SqliteDataAccess.SpeichereVokabel(vokabel);
Infinitiv.Text = string.Empty;
SimplePast.Text = string.Empty;
PastParticiple.Text = string.Empty;
Translation.Text = string.Empty;
}
catch (Exception ex)
{
MessageBox.Show("An exception just occurred: " + ex.Message, "ERROR", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
public static void SpeichereVokabel(VokabelModel vokabel)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("insert into Vokabel (Infinitiv, SimplePast, PastParticiple, Translation) values (@Infinitiv, @SimplePast, @PastParticiple, @Translation)",
vokabel);
}
}
private void RemoveVocableFromList(object sender, RoutedEventArgs e)
{
try
{
var ausgewählteVokabeln = VokabelListGrid.SelectedItems;
if (ausgewählteVokabeln.Count == 0)
{
throw new Exception("You need to select Data, if you want to delete it LOL scrub");
}
var listOfVocabulary = new List <VokabelModel>();
foreach (VokabelModel vokabel in ausgewählteVokabeln)
{
var retValVokabel = new VokabelModel
{
Infinitiv = vokabel.Infinitiv,
SimplePast = vokabel.SimplePast,
PastParticiple = vokabel.PastParticiple,
Translation = vokabel.Translation
};
listOfVocabulary.Add(retValVokabel);
}
SqliteDataAccess.LöscheVokabeln(listOfVocabulary);
RefreshList(sender, e);
}
catch (Exception ex)
{
MessageBox.Show("An exception just occurred: " + ex.Message, "ERROR", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
