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); } }