Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        public void AddBoatToMember(int userChoice, string boatLength, string boatType)
        {
            string addUserQuery = "INSERT INTO boat (memberID, boattypeID, boatlength) VALUES ( " + "'" + userChoice + "'" + "," + "'" + boatType + "'" + "," + "'" + boatLength + "'" + ")";

            sqlConnection.AddBoatSQL(addUserQuery);
        }