private void UpdatePart()
{
Console.WriteLine("Update Part");
AddPartWindow partWindow = new AddPartWindow(selectedPart);
partWindow.ShowDialog();
//If the database gets updated in the update part call will need to read
ReadDataBase();
}
private void AddPart()
{
AddPartWindow partWindow = new AddPartWindow(partsList);
//partWindow.Show();
partWindow.ShowDialog();
//Now that it's back returning part may have a part to add
if (returningPart != null)
{
if (Part.isPartInPartsList(partsList, returningPart) == false)
{
//need to add to the database and then read the table
Console.WriteLine($"Part should be added as it's not in the list\n{returningPart.ToString()}");
using (SQLiteConnection connection = new SQLiteConnection(App.dataBasePath))
{
var tempPart = new Part();
tempPart.ModelName = returningPart.ModelName;
tempPart.PartNumber = returningPart.PartNumber;
tempPart.PartDescription = returningPart.PartDescription;
tempPart.Comments = returningPart.Comments;
//by using the using statement no need to close the database connection
connection.CreateTable <Part>();
//Once inserted into the database is where it will pickup the Id field.
connection.Insert(tempPart);
MessageBox.Show($"The {tempPart.PartDescription} was added to the database.");
}
ReadDataBase();
}
else
{
//Console.WriteLine($"Part is already in the database\n{returningPart.ToString()}");
MessageBox.Show($"The Part is already in the database, or has an empty part number or model number.\n{returningPart.ToString()}");
}
}
//if so can i set it back to null?
returningPart = null;
}