public static async Task <int> CreateFundInvestorAsync(this MasterSideLetterDataAccess dataAccess, FundInvestor fundInvestor) { await dataAccess.ValidateFundInvestorAsync(fundInvestor); return(await dataAccess.ExecuteScalarAsync <int>( @" insert FundInvestor( FundId, FundSponsorName, FundBusinessUnitName, FundStrategyName, InvestorId, InvestorType, Entity, Commitment, Counsel, Notes, FundYear, FundSize ) output inserted.Id values( @FundId, @FundSponsorName, @FundBusinessUnitName, @FundStrategyName, @InvestorId, @InvestorType, @Entity, @Commitment, @Counsel, @Notes, @FundYear, @FundSize )", fundInvestor)); }
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)); }
public static Task <int> CreateBusinessUnitAsync(this MasterSideLetterDataAccess dataAccess, BusinessUnit businessUnit) { return(dataAccess.ExecuteScalarAsync <int>("insert into BusinessUnit(Name) output inserted.Id values(@Name)", businessUnit)); }
public static async Task <int> CreateProvisionAsync(this MasterSideLetterDataAccess dataAccess, Provision provision) { return(await dataAccess.ExecuteScalarAsync <int>(@"insert Provision (FundInvestorId, ProvisionType, Content , Notes) output inserted.Id values(@FundInvestorId, @ProvisionType, @Content, @Notes)", provision)); }
public static Task <int> CreateSponsorAsync(this MasterSideLetterDataAccess dataAccess, Sponsor sponsor) { return(dataAccess.ExecuteScalarAsync <int>("insert into Sponsor(Name) output inserted.Id values(@Name)", sponsor)); }
public static async Task <int> CreateInvestorAsync(this MasterSideLetterDataAccess dataAccess, Investor investor) { return(await dataAccess.ExecuteScalarAsync <int>("insert Investor(Name, InvestorType) output inserted.Id values(@Name, @InvestorType)", investor)); }
public static Task <int> CreateStrategyAsync(this MasterSideLetterDataAccess dataAccess, Strategy strategy) { return(dataAccess.ExecuteScalarAsync <int>("insert into Strategy(Name) output inserted.Id values(@Name)", strategy)); }