Video opens in same Browser session

Hi Tuhin

  I have below code but videos open in different MsEdge sessions. 

public static List GetYouTubeVideoLinksFromDatabase(string connectionString)
        {
            List youtubevideoslinks = new List();

            string query = "SELECT videoid FROM videos"; 
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(query, connection);
                connection.Open();

                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    string videoLink = reader["videoid"].ToString();
                    youtubevideoslinks.Add(videoLink);
                }
                reader.Close();
            }

            return youtubevideoslinks;
        }
        public static async Task RunVideo(string videoId)
        {
            await semaphore.WaitAsync();

            //string url = $"watch?v={videoId}";
            string url = $"watch?v={videoId}";
            if (browserProcess == null || browserProcess.HasExited)
            {
                var process = new Process();
                var _process = new ProcessStartInfo(@"C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe", url);
                process.StartInfo = _process;
                process.Start();
                browserProcess = process;
            }
            else
            {
                browserProcess.StartInfo.Arguments = url;
                browserProcess.Start();
            }

            while (!browserProcess.HasExited)
            {
                // Wait for the video to finish playing
                await Task.Delay(1000);
            }

            semaphore.Release();
        }

Thanks

Hi Ramco,

In order to play the next video in the same session after the first video is finished, you can modify the RunVideo method to wait for the video to finish playing before closing the browser window. One way to achieve this is by using a SemaphoreSlim object to synchronize the threads and wait for the video to finish playing. Here's an example:

static SemaphoreSlim semaphore = new SemaphoreSlim(1, 1);
static Process browserProcess = null;
static async Task Main(string[] args)
{
    var datasource = @"MSSQLSERVER_2019";
    var database = "Videos";
    var username = "sa";
    var password = "sa@2019";

    string connectionString = @"Data Source=" + datasource + ";Initial Catalog="
        + database + ";Persist Security Info=True;User ID=" + username + ";Password=" + password;
    List youtubevideoslinks = GetYouTubeVideoLinksFromDatabase(connectionString);
    foreach (var item in youtubevideoslinks)
    {
        await RunVideo(item);
    }
}

public static List GetYouTubeVideoLinksFromDatabase(string connectionString)
{
    List youtubevideoslinks = new List();

    string query = "SELECT videoid FROM videos";
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(query, connection);
        connection.Open();

        SqlDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            string videoLink = reader["videoid"].ToString();
            youtubevideoslinks.Add(videoLink);
        }
        reader.Close();
    }

    return youtubevideoslinks;
}

public static async Task RunVideo(string videoId)
{
    await semaphore.WaitAsync();

    string url = $"watch?v={videoId}";
    if (browserProcess == null || browserProcess.HasExited)
    {
        var process = new Process();
        var _process = new ProcessStartInfo(@"C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe", url);
        process.StartInfo = _process;
        process.Start();
        browserProcess = process;
    }
    else
    {
        browserProcess.StartInfo.Arguments = url;
        browserProcess.Start();
    }

    while (!browserProcess.HasExited)
    {
        // Wait for the video to finish playing
        await Task.Delay(1000);
    }

    semaphore.Release();
}

In this code, a SemaphoreSlim object is used to synchronize the threads and ensure that only one thread is running the RunVideo method at a time. The await semaphore.WaitAsync() method call acquires the semaphore before the method is executed, and the semaphore.Release() method call releases the semaphore when the method is finished.

Inside the RunVideo method, a loop is used to wait for the video to finish playing. The loop checks whether the browser process has exited using the HasExited property of the Process object, and waits for 1 second using Task.Delay(1000) before checking again. When the video has finished playing, the semaphore is released, allowing the next thread to execute the RunVideo method and play the next video in the same session.