Esempio n. 1
0
        }//UpdateItemListToDatabase

        //---------------------------------------------------------------------------------------------------------------
        ///<summary>
        /// UpdateItemToDatabase - update one record within "theTable" in the database
        ///</summary>
        ///<input>weakness r -  one item to be updated within the "theTable" in the database </input>
        ///<input> r.currentProject - the projectId to match with one database record</input>
        public void UpdateItemToDatabase(weakness r)
        {
            SqlConnection myConnection = DBUtils.GetNewSqlConnection();

            if (myConnection == null)
            {
                LogManager.writeToLog("New connection failed to open; in weakness_Table.cs: UpdateItemToDatabase.GetNewSqlConnection()");
                return;
            }

            //WARNING: A field, like "ID", defined with "IDENTITY" semantics, cannot be assigned a value since it Auto-Increments
            string strQuery = "UPDATE  " + theTable +
                              " SET " +
                              " notes=@notes," +
                              " processArea=@processArea," +
                              " specificGoal=@specificGoal," +
                              " specificPractice=@specificPractice," +
                              " genericGoal=@genericGoal," +
                              " genericPractice=@genericPractice" +
                              " WHERE " +
                              " projectId=@projectId"; // <<<---- match on the Primary Key  !!! TBD:  This is probably NOT going to work!  may keys will match on projectId????

            SqlCommand myCommand = new SqlCommand(strQuery, myConnection);


            //WARNING: myCommand.Parameters.AddWithValue("@ID", r.ID); //cannot assign/modify a field having IDENTITY semantics
            myCommand.Parameters.AddWithValue("@notes", r.notes);
            myCommand.Parameters.AddWithValue("@processArea", r.processArea);
            myCommand.Parameters.AddWithValue("@specificGoal", r.specificGoal);
            myCommand.Parameters.AddWithValue("@specificPractice", r.specificPractice);
            myCommand.Parameters.AddWithValue("@genericGoal", r.genericGoal);
            myCommand.Parameters.AddWithValue("@genericPractice", r.genericPractice);
            myCommand.Parameters.AddWithValue("@projectId", r.projectId);
            myCommand.ExecuteNonQuery();

            myConnection.Close();
        }//UpdateItemToDatabase