public void EditUserInfo(string userEdit, string fName, string lName, string pNumber)
{
string editUserQuery = "UPDATE member SET firstname='" + fName + "'" + ", lastname='" + lName + "'" + ", socialsecuritynumber= '" + pNumber + "'" + " WHERE memberID='" + userEdit + "'";
sqlConnection.AddBoatSQL(editUserQuery);
}
public void AddBoatToMember(int userChoice, string boatLength, string boatType)
{
string addUserQuery = "INSERT INTO boat (memberID, boattypeID, boatlength) VALUES ( " + "'" + userChoice + "'" + "," + "'" + boatType + "'" + "," + "'" + boatLength + "'" + ")";
sqlConnection.AddBoatSQL(addUserQuery);
}
