public async Task <int> Create(ProductAttributeValueParameters data)
        {
            var dbparams = new DynamicParameters();

            dbparams.Add("ProductAttributeId", data.ProductAttributeId, DbType.Int32);
            dbparams.Add("AttributeValue", data.AttributeValue, DbType.String);

            var result = await Task.FromResult(_dapper.Insert <int>("[dbo].[p_CreateAttributesValues]"
                                                                    , dbparams,
                                                                    commandType: CommandType.StoredProcedure));

            return(result);
        }
        public Task <int> Update(int Id, ProductAttributeValueParameters data)
        {
            var dbParams = new DynamicParameters();

            dbParams.Add("Id", Id);
            dbParams.Add("ProductAttributeId", data.ProductAttributeId, DbType.Int32);
            dbParams.Add("AttributeValue", data.AttributeValue, DbType.String);

            var updateAttributes = Task.FromResult(_dapper.Update <int>("[dbo].[p_UpdateAttributesValues]",
                                                                        dbParams,
                                                                        commandType: CommandType.StoredProcedure));

            return(updateAttributes);
        }