예제 #1
0
        public async Task <int> Create(SkuParameters data)
        {
            var dbparams = new DynamicParameters();

            dbparams.Add("SkuName", data.SkuName, DbType.String);
            var result = await Task.FromResult(_dapper.Insert <int>("[dbo].[p_CreateSku]"
                                                                    , dbparams,
                                                                    commandType: CommandType.StoredProcedure));

            return(result);
        }
예제 #2
0
        public Task <int> Update(int Id, SkuParameters data)
        {
            var dbPara = new DynamicParameters();

            dbPara.Add("Id", Id);
            dbPara.Add("Name", data.SkuName, DbType.String);

            var updateSku = Task.FromResult(_dapper.Update <int>("[dbo].[p_UpdateSku]",
                                                                 dbPara,
                                                                 commandType: CommandType.StoredProcedure));

            return(updateSku);
        }