using demo_trade.Data.RemoteData.Entity;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace demo_trade.Data.Repository
{
    public class SQLProductRepository : IProductRepository
    {
        private TradeContext _tradeContext;

        public SQLProductRepository() {
            _tradeContext = new TradeContext(); 
        }
        public void Dispose()
        {
            GC.SuppressFinalize(this);
        }

        public Product? GetProductByArticleNumber(string articleNumber)
        {
            return _tradeContext.Products.Where(it => articleNumber == it.Productarticlenumber).FirstOrDefault();
        }

        public List<Product> GetProducts()
        {
            
            return _tradeContext.Products.Include(manfucture => manfucture.Manufacturer).Select(it => it).ToList();
        }

        public bool RemoveProductByArticleNumber(string articleNumber)
        {
            Product? product = GetProductByArticleNumber(articleNumber);
            if (product != null)
            { 
               _tradeContext.Products.Remove(product);
                return true;
            }
            return false;
        }

        public void Save()
        {
            _tradeContext.SaveChanges();
        }

        public Product? UpdateProductByArticleNumber(Product product)
        {
            _tradeContext.Entry(product).State = EntityState.Modified;
            return product;
        }
    }
}