CrusherScanner/crusherScanner/LimsAccess.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace crusherScanner
{
    internal class LimsAccess
    {
        /// <summary>
        ///  Check if barcode is found in LIMS samples.
        /// </summary>
        /// <param name="barcode">Barcode as string to check LIMS for.</param>
        public static Scan IsInLims(Scan barcode)
        {
            //TODO: Actully check LIMS for sample ID.
            barcode.isInLims = true;
            return barcode;
            //https://www.guru99.com/c-sharp-access-database.html#:~:text=Code%20Explanation%3A-%201%20The%20first%20step%20is%20to,connection%20to%20the%20database.%20...%20More%20items...%20
            //string connetionString;
            //SqlConnection cnn;
            //connetionString = @"Data Source=WIN-50GP30FGO75;Initial Catalog=Demodb;User ID=sa;Password=demol23";
            //cnn = new SqlConnection(connetionString);
            //cnn.Open();
            //MessageBox.Show("Connection Open  !");
            //cnn.Close();
            //or
            //https://dax.tips/2020/08/24/using-visual-studio-code-to-query-power-bi/
        }
    }
}