예제 #1
0
        /// <summary>
        /// This method registers in the current SQL Transaction a command to perform the
        /// Delete of a SubTask entity
        /// </summary>
        private void CreateSqlCommandToDeleteSubTask(int parentTaskId, int childTaskId)
        {
            const string paramNameParentTaskId = "@ParentTaskId";
            const string paramNameChildTaskId  = "@ChildTaskId";

            var paramParentTaskId = new SqlParameter(paramNameParentTaskId, parentTaskId);
            var paramChildTaskId  = new SqlParameter(paramNameChildTaskId, childTaskId);

            var rawSqlString = $"DELETE SubTasks WHERE ParentTaskId = {paramNameParentTaskId} and ChildTaskId = {paramNameChildTaskId} ";

            var rawSQlCommand = new RawSQlCommand(rawSqlString,
                                                  new object[] { paramParentTaskId, paramChildTaskId });

            //Include comand to a Listof commands that will be checked when the Commit is performed
            _uow.AddRawCommand(rawSQlCommand);
        }