public async Task <int> DeleteProdDefinitionAsync(ProdDefinitionDto prodDefDto) { DynamicParameters para = new DynamicParameters(); para.Add("PdDetailId", prodDefDto.AutoId); para.Add("PdHeaderId", prodDefDto.PDHeaderId); para.Add("UserId", prodDefDto.CreateUserId); para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output); var result = await DbConnection.ExecuteAsync("spMstrProductDefinitionDelete", para , commandType : CommandType.StoredProcedure); return(para.Get <int>("Result")); }
public async Task <ReturnDto> SaveProdDefinitionAsync(ProdDefinitionDto prodDefinitionDto) { DynamicParameters para = new DynamicParameters(); para.Add("PdHeaderId", prodDefinitionDto.PDHeaderId); para.Add("ProcessId", prodDefinitionDto.ProcessId); para.Add("Name", prodDefinitionDto.PDName.Trim().ToUpper()); para.Add("ReceiveSiteId", prodDefinitionDto.ReceiveSiteId); para.Add("DispatchSiteId", prodDefinitionDto.DispatchSiteId); para.Add("UserId", prodDefinitionDto.CreateUserId); //para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output); var result = await DbConnection.QueryFirstOrDefaultAsync <ReturnDto>("spMstrProductDefinitionSave", para , commandType : CommandType.StoredProcedure); return(result); }