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