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