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