public void Update(ProductsInWarehousesDTO productInStock)
        {
            var mapper = new MapperConfiguration(
                configuration => configuration.
                CreateMap <ProductsInWarehousesDTO, ProductInWarehouse>()).
                         CreateMapper();

            Database.ProductsInWarehouses.
            Update(mapper.Map <ProductsInWarehousesDTO, ProductInWarehouse>(productInStock));
            Database.Save();
        }
        public void AddProductInStock(ProductsInWarehousesDTO item)
        {
            var n_item = new ProductInWarehouse
            {
                Id          = item.Id,
                ProductId   = item.ProductId,
                WarehouseId = item.WarehouseId
            };

            Database.ProductsInWarehouses.Create(n_item);
            Database.Save();
        }