public void InsertIntoDataBase(IEnumerable <CreateProductsModel> list)
        {
            var repository = new ProductsRepository();

            foreach (var item in list)
            {
                var productlist = new Products();
                productlist.Category    = item.Category;
                productlist.ProductName = item.ProductName;
                productlist.UnitPrice   = item.Price;
                var _productID = repository.CreateProductDetail(productlist);


                var sizelist = new Size(); //productID
                sizelist.SizeType  = item.Size;
                sizelist.ProductID = _productID;
                var _sizeID = repository.CreateProductSize(sizelist);


                var StockColor = new StockColor();
                StockColor.Color  = item.Color;
                StockColor.Stock  = item.Stock;
                StockColor.SizeID = _sizeID;
                repository.CreateStockColor(StockColor);
            }
        }