/// <summary>
/// Creates a stoolball competition and populates the <see cref="Competition.CompetitionId"/>
/// </summary>
/// <returns>The created competition</returns>
public async Task <Competition> CreateCompetition(Competition competition, Guid memberKey, string memberName)
{
if (competition is null)
{
throw new ArgumentNullException(nameof(competition));
}
if (string.IsNullOrWhiteSpace(memberName))
{
throw new ArgumentNullException(nameof(memberName));
}
var auditableCompetition = _copier.CreateAuditableCopy(competition);
auditableCompetition.CompetitionId = Guid.NewGuid();
auditableCompetition.Introduction = _htmlSanitiser.Sanitize(auditableCompetition.Introduction);
auditableCompetition.PublicContactDetails = _htmlSanitiser.Sanitize(auditableCompetition.PublicContactDetails);
auditableCompetition.PrivateContactDetails = _htmlSanitiser.Sanitize(auditableCompetition.PrivateContactDetails);
auditableCompetition.Facebook = _urlFormatter.PrefixHttpsProtocol(auditableCompetition.Facebook)?.ToString();
auditableCompetition.Twitter = _socialMediaAccountFormatter.PrefixAtSign(auditableCompetition.Twitter);
auditableCompetition.Instagram = _socialMediaAccountFormatter.PrefixAtSign(auditableCompetition.Instagram);
auditableCompetition.YouTube = _urlFormatter.PrefixHttpsProtocol(auditableCompetition.YouTube)?.ToString();
auditableCompetition.Website = _urlFormatter.PrefixHttpsProtocol(auditableCompetition.Website)?.ToString();
using (var connection = _databaseConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
auditableCompetition.CompetitionRoute = await _routeGenerator.GenerateUniqueRoute(
"/competitions", auditableCompetition.CompetitionName, NoiseWords.CompetitionRoute,
async route => await connection.ExecuteScalarAsync <int>($"SELECT COUNT(*) FROM {Tables.Competition} WHERE CompetitionRoute = @CompetitionRoute", new { auditableCompetition.CompetitionRoute }, transaction).ConfigureAwait(false)
).ConfigureAwait(false);
await connection.ExecuteAsync(
$@"INSERT INTO {Tables.Competition} (CompetitionId, PlayerType, Introduction, PublicContactDetails, PrivateContactDetails,
Facebook, Twitter, Instagram, YouTube, Website, CompetitionRoute, MemberGroupKey, MemberGroupName)
VALUES (@CompetitionId, @PlayerType, @Introduction, @PublicContactDetails, @PrivateContactDetails,
@Facebook, @Twitter, @Instagram, @YouTube, @Website, @CompetitionRoute, @MemberGroupKey, @MemberGroupName)",
new
{
auditableCompetition.CompetitionId,
auditableCompetition.PlayerType,
auditableCompetition.Introduction,
auditableCompetition.PublicContactDetails,
auditableCompetition.PrivateContactDetails,
auditableCompetition.Facebook,
auditableCompetition.Twitter,
auditableCompetition.Instagram,
auditableCompetition.YouTube,
auditableCompetition.Website,
auditableCompetition.CompetitionRoute,
auditableCompetition.MemberGroupKey,
auditableCompetition.MemberGroupName
}, transaction).ConfigureAwait(false);
await connection.ExecuteAsync($@"INSERT INTO {Tables.CompetitionVersion}
(CompetitionVersionId, CompetitionId, CompetitionName, ComparableName, FromDate, UntilDate)
VALUES (@CompetitionVersionId, @CompetitionId, @CompetitionName, @ComparableName, @FromDate, @UntilDate)",
new
{
CompetitionVersionId = Guid.NewGuid(),
auditableCompetition.CompetitionId,
auditableCompetition.CompetitionName,
ComparableName = auditableCompetition.ComparableName(),
FromDate = auditableCompetition.FromYear.HasValue ? new DateTime(auditableCompetition.FromYear.Value, 1, 1) : DateTime.UtcNow.Date,
UntilDate = auditableCompetition.UntilYear.HasValue ? new DateTime(auditableCompetition.UntilYear.Value, 12, 31) : (DateTime?)null
}, transaction).ConfigureAwait(false);
var redacted = _copier.CreateRedactedCopy(auditableCompetition);
await _auditRepository.CreateAudit(new AuditRecord
{
Action = AuditAction.Create,
MemberKey = memberKey,
ActorName = memberName,
EntityUri = auditableCompetition.EntityUri,
State = JsonConvert.SerializeObject(auditableCompetition),
RedactedState = JsonConvert.SerializeObject(redacted),
AuditDate = DateTime.UtcNow
}, transaction).ConfigureAwait(false);
transaction.Commit();
_logger.Info(GetType(), LoggingTemplates.Created, redacted, memberName, memberKey, GetType(), nameof(SqlServerCompetitionRepository.CreateCompetition));
}
}
return(auditableCompetition);
}
/// <summary>
/// Creates a team using an existing transaction
/// </summary>
public async Task <Team> CreateTeam(Team team, IDbTransaction transaction, string memberUsername)
{
if (team is null)
{
throw new ArgumentNullException(nameof(team));
}
if (transaction is null)
{
throw new ArgumentNullException(nameof(transaction));
}
if (string.IsNullOrWhiteSpace(memberUsername))
{
throw new ArgumentNullException(nameof(memberUsername));
}
var auditableTeam = _copier.CreateAuditableCopy(team);
auditableTeam.TeamId = Guid.NewGuid();
auditableTeam.Introduction = _htmlSanitiser.Sanitize(auditableTeam.Introduction);
auditableTeam.PlayingTimes = _htmlSanitiser.Sanitize(auditableTeam.PlayingTimes);
auditableTeam.Cost = _htmlSanitiser.Sanitize(auditableTeam.Cost);
auditableTeam.PublicContactDetails = _htmlSanitiser.Sanitize(auditableTeam.PublicContactDetails);
auditableTeam.PrivateContactDetails = _htmlSanitiser.Sanitize(auditableTeam.PrivateContactDetails);
auditableTeam.Facebook = _urlFormatter.PrefixHttpsProtocol(auditableTeam.Facebook)?.ToString();
auditableTeam.Twitter = _socialMediaAccountFormatter.PrefixAtSign(auditableTeam.Twitter);
auditableTeam.Instagram = _socialMediaAccountFormatter.PrefixAtSign(auditableTeam.Instagram);
auditableTeam.YouTube = _urlFormatter.PrefixHttpsProtocol(auditableTeam.YouTube)?.ToString();
auditableTeam.Website = _urlFormatter.PrefixHttpsProtocol(auditableTeam.Website)?.ToString();
// Create a route. Generally {team.teamRoute} will be blank, but allowing a pre-populated prefix is useful for transient teams
auditableTeam.TeamRoute = await _routeGenerator.GenerateUniqueRoute(
$"{auditableTeam.TeamRoute}/teams", auditableTeam.TeamName, NoiseWords.TeamRoute,
async route => await transaction.Connection.ExecuteScalarAsync <int>($"SELECT COUNT(*) FROM {Tables.Team} WHERE TeamRoute = @TeamRoute", new { auditableTeam.TeamRoute }, transaction).ConfigureAwait(false)
).ConfigureAwait(false);
// Create an owner group
var group = _memberGroupHelper.CreateOrFindGroup("team", auditableTeam.TeamName, NoiseWords.TeamRoute);
auditableTeam.MemberGroupKey = group.Key;
auditableTeam.MemberGroupName = group.Name;
// Assign the member to the group unless they're already admin
if (!_memberGroupHelper.MemberIsAdministrator(memberUsername))
{
_memberGroupHelper.AssignRole(memberUsername, group.Name);
}
await transaction.Connection.ExecuteAsync(
$@"INSERT INTO {Tables.Team} (TeamId, TeamType, AgeRangeLower, AgeRangeUpper, PlayerType, Introduction, PlayingTimes, Cost, ClubMark,
PublicContactDetails, PrivateContactDetails, Facebook, Twitter, Instagram, YouTube, Website, TeamRoute, MemberGroupKey, MemberGroupName)
VALUES (@TeamId, @TeamType, @AgeRangeLower, @AgeRangeUpper, @PlayerType, @Introduction, @PlayingTimes, @Cost, @ClubMark,
@PublicContactDetails, @PrivateContactDetails, @Facebook, @Twitter, @Instagram, @YouTube, @Website, @TeamRoute, @MemberGroupKey, @MemberGroupName)",
new
{
auditableTeam.TeamId,
TeamType = auditableTeam.TeamType.ToString(),
auditableTeam.AgeRangeLower,
auditableTeam.AgeRangeUpper,
PlayerType = auditableTeam.PlayerType.ToString(),
auditableTeam.Introduction,
auditableTeam.PlayingTimes,
auditableTeam.Cost,
auditableTeam.ClubMark,
auditableTeam.PublicContactDetails,
auditableTeam.PrivateContactDetails,
auditableTeam.Facebook,
auditableTeam.Twitter,
auditableTeam.Instagram,
auditableTeam.YouTube,
auditableTeam.Website,
auditableTeam.TeamRoute,
auditableTeam.MemberGroupKey,
auditableTeam.MemberGroupName
}, transaction).ConfigureAwait(false);
await transaction.Connection.ExecuteAsync($@"INSERT INTO {Tables.TeamVersion}
(TeamVersionId, TeamId, TeamName, ComparableName, FromDate, UntilDate) VALUES (@TeamVersionId, @TeamId, @TeamName, @ComparableName, @FromDate, @UntilDate)",
new
{
TeamVersionId = Guid.NewGuid(),
auditableTeam.TeamId,
auditableTeam.TeamName,
ComparableName = auditableTeam.ComparableName(),
FromDate = DateTime.UtcNow.Date,
UntilDate = auditableTeam.UntilYear.HasValue ? new DateTime(auditableTeam.UntilYear.Value, 12, 31).ToUniversalTime() : (DateTime?)null
}, transaction).ConfigureAwait(false);
await InsertNewMatchLocationsForTeam(auditableTeam, new List <Guid>(), transaction).ConfigureAwait(false);
return(auditableTeam);
}