C#

ds = await SqlHelper.ExecuteDatasetAsync(ConnectionManager.GetConnectionString(), CommandType.StoredProcedure, "USP_InsertBMAsLineItem", spParameter);

ALTER PROC USP_InsertBMAsLineItem
 (
     @TickerID VARCHAR(20),
     @CommaSeparatedItems VARCHAR(MAX),
     @UserID VARCHAR(20)
 )
 AS
 BEGIN
     Declare @Start INT, @Count INT,@MaxOrder INT
     SET @Start=1
     SET @Count=1
     SET @MaxOrder=0
    
     BEGIN TRY
     BEGIN TRAN
     DROP TABLE IF EXISTS #Tmpdata
    
     CREATE TABLE #Tmpdata
     (
         ID  INT Identity,
         LineItem VARCHAR(MAX)
     )
    
     INSERT INTO #Tmpdata(LineItem) 
     (
         SELECT value as LineItem
         FROM STRING_SPLIT(@CommaSeparatedItems, ',')
     ) 
    
        
    
     MERGE INTO TblLineItemTemplate Trg
     USING
     (
         SELECT value as LineItem
         FROM STRING_SPLIT(@CommaSeparatedItems, ',')
     ) AS Src
     ON UPPER(TRIM(Trg.LineItem)) = UPPER(TRIM(Src.LineItem))
        AND Trg.TickerID = @TickerID
     WHEN MATCHED THEN
         UPDATE SET Trg.Action = 'U', ModifiedBy=@UserID
     WHEN NOT MATCHED THEN
         INSERT
         (
             TickerID,
             LineItem,
             Action,
             InsertedOn,
             InsertedBy
         )
         VALUES
         (TRIM(@TickerID), TRIM(Src.LineItem), 'I', GETDATE(),@UserID);
    
        
     SELECT @Start=MIN(ID) FROM #Tmpdata
     SELECT @Count=MAX(ID) FROM #Tmpdata
    
     WHILE (@Start<=@Count)
     BEGIN
         IF NOT EXISTS(SELECT * FROM tblSectionLineItemTemplate WHERE TickerID=@TickerID
             AND SectionID IN (SELECT SectionID FROM tblSectionTemplate WHERE TickerID=@TickerID AND Section='Model Output' AND Action<>'D')
             AND LineItemID IN (SELECT LineItemId FROM TblLineItemTemplate WHERE TickerID=@TickerID 
             AND LineItem IN (
                     SELECT LineItem FROM #Tmpdata WHERE ID=@Start           
             )))
         BEGIN
             SELECT @MaxOrder=MAX(ISNULL(OrderID,0))+1 FROM tblSectionLineItemTemplate WHERE TickerID=@TickerID
    
             INSERT INTO tblSectionLineItemTemplate
             (
                 TickerID,
                 SectionID,
                 LineItemID,
                 OrderID,
                 InsertedOn,
                 UserID
             )
             VALUES
             (
                 @TickerID,
                 (SELECT SectionID FROM tblSectionTemplate WHERE TickerID=@TickerID AND Section='Model Output'  AND Action<>'D'),
                 (SELECT LineItemId FROM TblLineItemTemplate WHERE TickerID=@TickerID AND LineItem IN (SELECT LineItem FROM #Tmpdata WHERE ID=@Start)),
                 @MaxOrder,
                 GETDate(),
                 @UserID
             )
         END
         SET @Start=@Start+1
    
     END
        
    
     SELECT L.LineItemId,L.LineItem from TblLineItemTemplate L INNER JOIN 
     (
         SELECT value as LineItem
         FROM STRING_SPLIT(@CommaSeparatedItems, ',')
     ) V
     ON UPPER(TRIM(L.LineItem))=UPPER(TRIM(V.LineItem)) AND L.TickerID=@TickerID
    
    
     DROP TABLE IF EXISTS #Tmpdata
     COMMIT TRAN
 END TRY
 BEGIN CATCH  
     ROLLBACK TRAN  
      
     DECLARE @ErrorMessage NVARCHAR(4000);  
     DECLARE @ErrorSeverity INT;  
     DECLARE @ErrorState INT;  
      
     SELECT @ErrorMessage = ERROR_MESSAGE(),  
            @ErrorSeverity = ERROR_SEVERITY(),  
            @ErrorState = ERROR_STATE();  
      
     --SET @Message = @ErrorMessage  
      
     RAISERROR(   @ErrorMessage,  -- Message text.                        
                  @ErrorSeverity, -- Severity.                        
                  @ErrorState     -- State.                        
              );  
      
 END CATCH  
 END

public async Task<ResponseContextDto> ConvertToPercentLineItem(string tickerid, string items)
             {
                 DataSet ds = new DataSet();
                 DataTable dt=new DataTable();
                 string userid = GlobalVariable.strLoginID;
                 ResponseContextDto oResponseContext = new ResponseContextDto();
                 string? message = "";
        
                 try
                 {
                     #region db operation start
                     SqlParameter[] spParameter = new SqlParameter[3];
        
                     spParameter[0] = new SqlParameter("@TickerID", SqlDbType.VarChar);
                     spParameter[0].Direction = ParameterDirection.Input;
                     spParameter[0].Value = tickerid;
        
                     spParameter[1] = new SqlParameter("@CommaSeparatedItems", SqlDbType.VarChar);
                     spParameter[1].Direction = ParameterDirection.Input;
                     spParameter[1].Value = items;
        
                     spParameter[2] = new SqlParameter("@UserID", SqlDbType.VarChar);
                     spParameter[2].Direction = ParameterDirection.Input;
                     spParameter[2].Value = userid;
        
                     ds = await SqlHelper.ExecuteDatasetAsync(ConnectionManager.GetConnectionString(), CommandType.StoredProcedure, "USP_InsertBMAsLineItem", spParameter);
        
                     oResponseContext.IsSuccess = Status.Success;
                     oResponseContext.Message = Status.Message(Status.Success);
                     if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                     {
                         dt = ds.Tables[0];
                         oResponseContext.ResponseData = dt;
                     }
                     else
                     {
                         oResponseContext.ResponseData = null;
                     }
        
                     #endregion
                 }
                 catch (Exception ex)
                 {
                     oResponseContext.IsSuccess = Status.Fail;
                     oResponseContext.Message = "Error " + ex.Message;
                     oResponseContext.ResponseData = null;
                 }
        
                 return oResponseContext;
             }

string userid = GlobalVariable.strLoginID;
             ResponseContextDto oResponseContext = new ResponseContextDto();
             DataTable table = new DataTable();
             using (var con = new SqlConnection(ConnectionManager.GetConnectionString()))
             using (var cmd = new SqlCommand("USP_InsertBMAsLineItem", con))
             using (var da = new SqlDataAdapter(cmd))
             {
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.Add(new SqlParameter("@TickerID", tickerid));
                 cmd.Parameters.Add(new SqlParameter("@CommaSeparatedItems", items));
                 cmd.Parameters.Add(new SqlParameter("@UserID", userid));
                 da.Fill(table);
             }

<interactivity:Interaction.Behaviors>
    <local:SfDataPagerBehavior_OnDemand />
    <local:SfDataPagerBehavior_File />
</interactivity:Interaction.Behaviors>

public class SfDataPagerBehavior_File : Behavior<EquipmentIdentitySetting>, IRecipient<FileFilterText>, IRecipient<UpdateDatagrid_Pdf>
{
    public SfDataPagerBehavior_File()
        {
            WeakReferenceMessenger.Default.Register<FileFilterText>(this);
            WeakReferenceMessenger.Default.Register<UpdateDatagrid_Pdf>(this);
        }
    protected override void OnAttached()
    {
        base.OnAttached();
        .
        .
        AssociatedObject.dataPager_file.OnDemandLoading += OnOnDemandLoading;
        //Some codes
        .
        .
    }
    protected override void OnDetaching()
    {
        base.OnDetaching();
        AssociatedObject.dataPager_file.OnDemandLoading -= OnOnDemandLoading;
    }
    public async void Receive(FileFilterText message)
    {
        //Some codes
    }
    public async void Receive(UpdateDatagrid_Pdf message)
    {
        //Some codes
    }
}

public class Equipment
    {
        [Key]
        public int EquipmentId { get; set; }
        [Required]
        public string EquipmentCode { get; set; }
        [Required]
        public string EquipmentTitle { get; set; }

        //Navigation Property
        [Required]
        public int CostCenterId { get; set; }
        public CostCenter CostCenter { get; set; }
        public int? InfoId { get; set; }
        [ForeignKey("InfoId")]
        public EqInfo? EqInfo { get; set; }
        public Catalogue? Catalogue { get; set; }
    }

public class EqInfo
    {
        [Key]
        public int InfoId { get; set; }
        [Required]
        public string InfoFileName { get; set; }

        //Navigation property
        public virtual List<Equipment> Equipments { get; set; }
    }

foreach (var row in AssociatedObject.dataGrid.SelectedItems)
                    {
                        var _sqliteContext = new SQLiteContext();
                        var selectedRecord = _sqliteContext.Equipments.Include(x => x.EqInfo).FirstOrDefault(x => x.EquipmentId == (int)reflector2.GetValue(row, "EquipmentId"));
                        selectedRecord.EqInfo = null;
                        list2.Add(selectedRecord);
                        _sqliteContext.Dispose();
                    }

using System.ComponentModel;

namespace TestApp
{
    // ExampleControlDesigner is an example control designer that 
    // demonstrates basic functions of a ControlDesigner. 
    public class ExampleControlDesigner : System.Windows.Forms.Design.ControlDesigner
    {
        // This Boolean state reflects whether the mouse is over the control.
        private bool mouseover = false;
        // This color is a private field for the OutlineColor property.
        private Color lineColor = Color.White;

        // This color is used to outline the control when the mouse is 
        // over the control.
        public Color OutlineColor
        {
            get
            {
                return lineColor;
            }
            set
            {
                lineColor = value;
            }
        }

        public ExampleControlDesigner()
        {
        }

        // Sets a value and refreshes the control's display when the 
        // mouse position enters the area of the control.
        protected override void OnMouseEnter()
        {
            this.mouseover = true;
            this.Control.Refresh();
        }

        // Sets a value and refreshes the control's display when the 
        // mouse position enters the area of the control.        
        protected override void OnMouseLeave()
        {
            this.mouseover = false;
            this.Control.Refresh();
        }

        // Draws an outline around the control when the mouse is 
        // over the control.    
        protected override void OnPaintAdornments(System.Windows.Forms.PaintEventArgs pe)
        {
            if (this.mouseover)
            {
                pe.Graphics.DrawRectangle(
                    new Pen(new SolidBrush(this.lineColor), 6),
                    0,
                    0,
                    this.Control.Size.Width,
                    this.Control.Size.Height);
            }
        }

        // Adds a property to this designer's control at design time 
        // that indicates the outline color to use. 
        // The DesignOnlyAttribute ensures that the OutlineColor
        // property is not serialized by the designer.
        protected override void PreFilterProperties(System.Collections.IDictionary properties)
        {
            PropertyDescriptor pd = TypeDescriptor.CreateProperty(
                typeof(ExampleControlDesigner),
                "OutlineColor",
                typeof(System.Drawing.Color),
                new Attribute[] { new DesignOnlyAttribute(true) });

            properties.Add("OutlineColor", pd);
        }
    }

    // This example control demonstrates the ExampleControlDesigner.
    [DesignerAttribute(typeof(ExampleControlDesigner))]
    public partial class UserControl1 : UserControl
    {
        public UserControl1()
        {
            InitializeComponent();
        }
    }
}