public void UpdateColor(VenueProductColor color)
        {
            var p = new DynamicParameters(new
            {
                RetailPrice = color.RetailPrice,
                Id          = color.Id
            });

            Connection.Execute("UpdateProductColor", p, commandType: CommandType.StoredProcedure);
        }
        public void InsertColor(VenueProductColor color)
        {
            var p = new DynamicParameters(new
            {
                Color       = color.ColorName,
                RetailPrice = color.RetailPrice,
                ImageUrl    = color.ImageUrl,
                ProductId   = color.ProductId,
                Sizes       = color.Sizes
            });



            Connection.Execute("InsertProductColor", p, commandType: CommandType.StoredProcedure);
        }