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