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;
}
