using LoadStockDbFromTrans.models;

namespace LoadStockDbFromTrans.StocksProviders
{
    public interface IDapperStocksProvider
    {
        Task AddStock(StockMember stockMember);
        Task AddWebStockNames(string stockName);
        Task CleanStockNames();
        Task<IEnumerable<StockMember>> GetAllStocks();
        Task<IEnumerable<string>> GetStockNames();
        Task<IEnumerable<StockNames>> GetStockNameTable();
        Task<IEnumerable<StockMember>> GetStocksByStockId(string stockId, DateTime Affärsdag);
        Task<IEnumerable<StockMember>> GetStocksByStockIdPart(string stockIdPart, DateTime Affärsdag);
        Task RemoveStockById(int id);
        Task UpdateStock(StockMember stockMember);
        Task UpdateStockName(string stockNameBank, string stockNameWeb);
    }
}