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

namespace PharmaStoreReport.SqlHelper
{
    /// <summary>
    /// Oledb Connection
    /// </summary>
    public interface IConnections
    {
        /// <summary>
        /// Reading Sheet Data
        /// </summary>
        /// <param name="fileName"></param>
        /// <param name="fileExt"></param>
        /// <param name="sheetName"></param>
        /// <returns></returns>
        DataTable GetSheetData(string fileName, string fileExt, string sheetName);
        /// <summary>
        ///      Get Sheet Data by Column Names                                                                                                                                                                                                                                                           
        /// </summary>
        /// <param name="fileName"></param>
        /// <param name="fileExt"></param>
        /// <param name="sheetName"></param>
        /// <param name="ColumnName"></param>
        /// <returns></returns>
        DataTable GetSheetData(string fileName, string fileExt, string sheetName, List<string> ColumnName);
    }
}