C#

char[] buffer = new char[size];
int numberOfChars;
fixed (char* bufferptr = buffer)
fixed (byte* rawptr = raw)
    numberOfChars = MultiByteToWideChar(936, 0, rawptr, readSize, bufferptr, buffer.Length);

private void PdfReport(string address)
{
    //Load the stream from the local system.
    FileStream fs = new FileStream(address, FileMode.Open);
    PdfSource = fs;
}

private void PdfReport(string address)
{
    //Load the stream from the local system.
    FileStream fs = new FileStream(address, FileMode.Open);
    PdfSource = fs;
    fs.Dispose();
}

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);
             }