public void EditBoats(int userChoice, int userBoatChoice, string newBoatLength, string newBoatype)
{
string showBoatQuery = "CALL `displayBoat`" + "(" + userChoice + ");";
sqlConnection.DeleteBoatSQL(showBoatQuery);
string editBoatQuery = "UPDATE boat SET boattypeID='" + newBoatype + "'" + ", boatlength='" + newBoatLength + "'" + " WHERE boatID='" + userBoatChoice + "'";
sqlConnection.AddUserAndEditBoatSQL(editBoatQuery);
}
public void addUser(string fname, string lname, int socialSecNumber)
{
string addUserQuery = "INSERT INTO member (firstname, lastname, socialsecuritynumber) VALUES ( " + "'" + fname + "'" + "," + "'" + lname + "'" + "," + "'" + socialSecNumber + "'" + ")";
sqlConnection.AddUserAndEditBoatSQL(addUserQuery);
}