Server Error in '/' Application.

Mutator 'modify()' on '@Result' cannot be called on a null value.
select CommodityNServicePropertyID,
          isnull(CommodityNServiceProperty_CommodityNService_NameID,0) as CommodityNServiceProperty_CommodityNService_NameID,
          isnull(CommodityNServiceProperty_CommodityNService_CategoryParentID,0) as CommodityNServiceProperty_CommodityNService_CategoryParentID,
          isnull(CommodityNServiceProperty_CommodityNService_CategoryChildID,0) as CommodityNServiceProperty_CommodityNService_CategoryChildID,
  IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0))>0,1,2) as CommodityNServiceProperty_CommodityNService_Pricing_QualityID,
  CommodityNServiceProperty_Code,
  CASE
                      WHEN isnull(CommodityNServiceProperty_CnSSerialNumber,'')!=''
      THEN   CommodityNServiceProperty_Title +' ['+ isnull(CommodityNServiceProperty_CnSSerialNumber,'')+']'
  else
     CommodityNServiceProperty_Title  
                  end  as CommodityNServiceProperty_Title,
  
  isnull(CommodityNServiceProperty_ExpirationDateTime,'') as CommodityNServiceProperty_ExpirationDateTime,
  CommodityNService_CategoryParent_Title,
  CommodityNService_CategoryChild_Title,
  CommodityNService_Name_Title,
   IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0))>0,N'موجود',N'ناموجود') as CommodityNService_Pricing_Quality_Title,
  CommodityNServiceProperty_Icon,
  CommodityNServiceProperty_ShabnamCode,
  CommodityNServiceProperty_BateFlag,
  CommodityNServiceProperty_PriceIncreaseFlag,
  CommodityNServiceProperty_ConsumableFlag,
  CommodityNServiceProperty_PriceBasedNumberFlag,
  replace(CommodityNServiceProperty_Description,char(10),'<br/>') as CommodityNServiceProperty_Description,
  CommodityNServiceProperty_TotalPurchased  as  CommodityNServiceProperty_PurchasingPrice,
  CommodityNServiceProperty_Price,
  CommodityNServiceProperty_Barcode,  
  CommodityNService_Usage_Title,
  CommodityNService_Location_Title,
  CommodityNService_Pricing_CommodityTypeBasedPrice_Title,
  CommodityNServiceProperty_SellersFactor,
  isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0) AS Max_number_Order,
isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0) AS Movjoodi,
  isnull(CommodityNService_Location_Title,'') as CommodityNServiceProperty_Brand,
 replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/UsageDescription)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_UsageDescription,
  replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/Nokat)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_Nokat,
isnull(Content_HowToDisplay.PublicFlag,0) as likeFlag
From CommodityNServiceProperty_View
left join Content_HowToDisplay on Content_HowToDisplay.Content_GeneralID=CommodityNServiceProperty_View.CommodityNServicePropertyID
where CommodityNServiceProperty_SalableFlag=0 and CommodityNServiceProperty_DelFlag=0 and CommodityNServiceProperty_ActiveFlag=1 and CommodityNServicePropertyID=6140  for XML RAW
Warning: Null value is eliminated by an aggregate or other SET operation.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ServiceModel.FaultException: Mutator 'modify()' on '@Result' cannot be called on a null value.
select CommodityNServicePropertyID,
          isnull(CommodityNServiceProperty_CommodityNService_NameID,0) as CommodityNServiceProperty_CommodityNService_NameID,
          isnull(CommodityNServiceProperty_CommodityNService_CategoryParentID,0) as CommodityNServiceProperty_CommodityNService_CategoryParentID,
          isnull(CommodityNServiceProperty_CommodityNService_CategoryChildID,0) as CommodityNServiceProperty_CommodityNService_CategoryChildID,
  IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0))>0,1,2) as CommodityNServiceProperty_CommodityNService_Pricing_QualityID,
  CommodityNServiceProperty_Code,
  CASE
                      WHEN isnull(CommodityNServiceProperty_CnSSerialNumber,'')!=''
      THEN   CommodityNServiceProperty_Title +' ['+ isnull(CommodityNServiceProperty_CnSSerialNumber,'')+']'
  else
     CommodityNServiceProperty_Title  
                  end  as CommodityNServiceProperty_Title,
  
  isnull(CommodityNServiceProperty_ExpirationDateTime,'') as CommodityNServiceProperty_ExpirationDateTime,
  CommodityNService_CategoryParent_Title,
  CommodityNService_CategoryChild_Title,
  CommodityNService_Name_Title,
   IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0))>0,N'موجود',N'ناموجود') as CommodityNService_Pricing_Quality_Title,
  CommodityNServiceProperty_Icon,
  CommodityNServiceProperty_ShabnamCode,
  CommodityNServiceProperty_BateFlag,
  CommodityNServiceProperty_PriceIncreaseFlag,
  CommodityNServiceProperty_ConsumableFlag,
  CommodityNServiceProperty_PriceBasedNumberFlag,
  replace(CommodityNServiceProperty_Description,char(10),'<br/>') as CommodityNServiceProperty_Description,
  CommodityNServiceProperty_TotalPurchased  as  CommodityNServiceProperty_PurchasingPrice,
  CommodityNServiceProperty_Price,
  CommodityNServiceProperty_Barcode,  
  CommodityNService_Usage_Title,
  CommodityNService_Location_Title,
  CommodityNService_Pricing_CommodityTypeBasedPrice_Title,
  CommodityNServiceProperty_SellersFactor,
  isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0) AS Max_number_Order,
isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0) AS Movjoodi,
  isnull(CommodityNService_Location_Title,'') as CommodityNServiceProperty_Brand,
 replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/UsageDescription)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_UsageDescription,
  replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/Nokat)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_Nokat,
isnull(Content_HowToDisplay.PublicFlag,0) as likeFlag
From CommodityNServiceProperty_View
left join Content_HowToDisplay on Content_HowToDisplay.Content_GeneralID=CommodityNServiceProperty_View.CommodityNServicePropertyID
where CommodityNServiceProperty_SalableFlag=0 and CommodityNServiceProperty_DelFlag=0 and CommodityNServiceProperty_ActiveFlag=1 and CommodityNServicePropertyID=6140  for XML RAW
Warning: Null value is eliminated by an aggregate or other SET operation.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[FaultException: Mutator 'modify()' on '@Result' cannot be called on a null value.
select CommodityNServicePropertyID,
		           isnull(CommodityNServiceProperty_CommodityNService_NameID,0) as CommodityNServiceProperty_CommodityNService_NameID,
		           isnull(CommodityNServiceProperty_CommodityNService_CategoryParentID,0) as CommodityNServiceProperty_CommodityNService_CategoryParentID,
		           isnull(CommodityNServiceProperty_CommodityNService_CategoryChildID,0) as CommodityNServiceProperty_CommodityNService_CategoryChildID,
				   IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
					AND DelFlag=0 AND ActiveFlag=1
					),0))>0,1,2) as CommodityNServiceProperty_CommodityNService_Pricing_QualityID,
				   CommodityNServiceProperty_Code,
				   CASE
                       WHEN isnull(CommodityNServiceProperty_CnSSerialNumber,'')!=''
				       THEN   CommodityNServiceProperty_Title +' ['+ isnull(CommodityNServiceProperty_CnSSerialNumber,'')+']' 
				   else
				      CommodityNServiceProperty_Title  
                   end  as CommodityNServiceProperty_Title,
				   
				   isnull(CommodityNServiceProperty_ExpirationDateTime,'') as CommodityNServiceProperty_ExpirationDateTime,
				   CommodityNService_CategoryParent_Title,
				   CommodityNService_CategoryChild_Title,
				   CommodityNService_Name_Title,
				   	IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
					AND DelFlag=0 AND ActiveFlag=1
					),0))>0,N'موجود',N'ناموجود') as CommodityNService_Pricing_Quality_Title,
				   CommodityNServiceProperty_Icon,
				   CommodityNServiceProperty_ShabnamCode,
				   CommodityNServiceProperty_BateFlag,
				   CommodityNServiceProperty_PriceIncreaseFlag,
				   CommodityNServiceProperty_ConsumableFlag,
				   CommodityNServiceProperty_PriceBasedNumberFlag,
				   replace(CommodityNServiceProperty_Description,char(10),'<br/>') as CommodityNServiceProperty_Description,
				   CommodityNServiceProperty_TotalPurchased  as  CommodityNServiceProperty_PurchasingPrice,
				   CommodityNServiceProperty_Price,
				   CommodityNServiceProperty_Barcode,				  
				   CommodityNService_Usage_Title,
				   CommodityNService_Location_Title,
				   CommodityNService_Pricing_CommodityTypeBasedPrice_Title,
				   CommodityNServiceProperty_SellersFactor,
				   isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
					AND DelFlag=0 AND ActiveFlag=1
					),0) AS Max_number_Order,
					isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
					AND DelFlag=0 AND ActiveFlag=1
					),0) AS Movjoodi,
				   isnull(CommodityNService_Location_Title,'') as CommodityNServiceProperty_Brand,
				  replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/UsageDescription)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_UsageDescription,
				   replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/Nokat)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_Nokat,
 				isnull(Content_HowToDisplay.PublicFlag,0) as likeFlag
					From CommodityNServiceProperty_View 
					left join Content_HowToDisplay on Content_HowToDisplay.Content_GeneralID=CommodityNServiceProperty_View.CommodityNServicePropertyID
					where CommodityNServiceProperty_SalableFlag=0 and CommodityNServiceProperty_DelFlag=0 and CommodityNServiceProperty_ActiveFlag=1 and CommodityNServicePropertyID=6140  for XML RAW
Warning: Null value is eliminated by an aggregate or other SET operation.]
   System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +14764695
   System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +403
   TolueShop.DynamicServiceReference.IDynamicService.Show_List_ByMenuID(String username, String password, Int32 MenuID, Int32 pagelenth, Int32 order_column, String order_dir, Int32 startRecord, String condition) +0
   TolueShop.Page.Product.Page_Load(Object sender, EventArgs e) in C:\Users\S.Hasanzadeh\Source\Workspaces\TolueShop\TolueShop\Page\Product.aspx.cs:90
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0