public static async Task <int> UpdateFundAsync(this MasterSideLetterDataAccess dataAccess, Fund fund) { await dataAccess.ValidateFundReferences(fund); return(await dataAccess.ExecuteAsync("update Fund set ModifiedDate = getdate(), Name = @Name, SponsorId = @SponsorId, BusinessUnitId = @BusinessUnitId, StrategyId = @StrategyId, Year = @Year, Size = @Size where Id = @Id", fund)); }
public static async Task <int> CreateFundAsync(this MasterSideLetterDataAccess dataAccess, Fund fund) { await dataAccess.ValidateFundReferences(fund); return(await dataAccess.ExecuteScalarAsync <int>( "insert Fund(Name, SponsorId, BusinessUnitId, StrategyId, Year, Size) output inserted.Id values(@Name, @SponsorId, @BusinessUnitId, @StrategyId, @Year, @Size)", fund)); }