protected override void OnAppearing() { base.OnAppearing(); using (var con = new SQLite.SQLiteConnection(App.FilePath)) { // create a table if it doesnt exist con.CreateTable <TrainingData>(); var myTest = new TrainingData() { Date = "03/01/2020", Rating = 7, Goals = 2, Assists = 1, Tackles = 4, Dribbles = 2, KeyPasses = 0, Stamina = 8 }; // int rowsAdded = con.Insert(myTest); var training = con.Table <TrainingData>().ToList(); TrainingViews.ItemsSource = training; // con.DropTable<TrainingData>(); // var dummyFromDB = con.Table<TrainingData>().ToList(); //Age.Text = dummyFromDB.First().Age.ToString(); //Name.Text = dummyFromDB.First().Name; } }
private void ButtonDelete_Click(object sender, EventArgs e) { if (DeleteButton.Text == "Delete") { DeleteButton.Text = "Confirm?"; DateContent.BackgroundColor = Color.Red; RatingContent.BackgroundColor = Color.Red; GoalsContent.BackgroundColor = Color.Red; AssistsContent.BackgroundColor = Color.Red; TacklesContent.BackgroundColor = Color.Red; DribblesContent.BackgroundColor = Color.Red; KeyPassesContent.BackgroundColor = Color.Red; StaminaContent.BackgroundColor = Color.Red; } else { using (var con = new SQLite.SQLiteConnection(App.FilePath)) { training = (TrainingData)TrainingViews.SelectedItem; var trainingToDelete = con.Find <TrainingData>(training.TrainingId); con.Delete <TrainingData>(trainingToDelete.TrainingId); TrainingViews.ItemsSource = null; sessions = con.Table <TrainingData>().ToList(); TrainingViews.ItemsSource = sessions; } DeleteButton.Text = "Delete"; DateContent.BackgroundColor = Color.Black; RatingContent.BackgroundColor = Color.Black; GoalsContent.BackgroundColor = Color.Black; AssistsContent.BackgroundColor = Color.Black; TacklesContent.BackgroundColor = Color.Black; DribblesContent.BackgroundColor = Color.Black; KeyPassesContent.BackgroundColor = Color.Black; StaminaContent.BackgroundColor = Color.Black; DateContent.Text = " "; RatingContent.Text = " "; GoalsContent.Text = " "; AssistsContent.Text = " "; TacklesContent.Text = " "; DribblesContent.Text = " "; KeyPassesContent.Text = " "; StaminaContent.Text = " "; } }
private async void ButtonEdit_Click(object sender, EventArgs e) { using (var con = new SQLite.SQLiteConnection(App.FilePath)) { training = (TrainingData)TrainingViews.SelectedItem; var trainingToEdit = con.Find <TrainingData>(training.TrainingId); await Navigation.PushAsync(new TrainingEditPage(trainingToEdit)); } }
private void ListViewSelection(object sender, SelectionChangedEventArgs e) { training = (TrainingData)TrainingViews.SelectedItem; if (training != null) { EditButton.IsEnabled = true; DeleteButton.IsEnabled = true; DateContent.Text = training.Date.ToString(); RatingContent.Text = training.Rating.ToString(); GoalsContent.Text = training.Goals.ToString(); AssistsContent.Text = training.Assists.ToString(); TacklesContent.Text = training.Tackles.ToString(); DribblesContent.Text = training.Dribbles.ToString(); KeyPassesContent.Text = training.KeyPasses.ToString(); StaminaContent.Text = training.Stamina.ToString(); } }
private void ButtonSave_Click(object sender, EventArgs e) { TrainingData newTraining = new TrainingData() { Date = DateEntry.Text, Rating = Convert.ToDouble(RatingEntry.Text), Goals = Convert.ToInt32(GoalsEntry.Text), Assists = Convert.ToInt32(AssistsEntry.Text), Tackles = Convert.ToInt32(AssistsEntry.Text), Dribbles = Convert.ToInt32(DribblesEntry.Text), KeyPasses = Convert.ToInt32(KeyPassesEntry.Text), Stamina = Convert.ToDouble(StaminaEntry.Text), }; using (SQLiteConnection con = new SQLiteConnection(App.FilePath)) { // if statement needs testing if (newTraining.Date != null) { con.CreateTable <TrainingData>(); int rowsAdded = con.Insert(newTraining); } } }
public TrainingEditPage(TrainingData Training) { InitializeComponent(); Training = training; }