public async Task CreateMasterGameChangeRequest(MasterGameChangeRequest domainRequest)
{
var entity = new MasterGameChangeRequestEntity(domainRequest);
await using var connection = new MySqlConnection(_connectionString);
await connection.ExecuteAsync(
"insert into tbl_mastergame_changerequest(RequestID,UserID,RequestTimestamp,RequestNote,MasterGameID,OpenCriticID,GGToken,Answered,ResponseTimestamp,ResponseNote,Hidden) VALUES " +
"(@RequestID,@UserID,@RequestTimestamp,@RequestNote,@MasterGameID,@OpenCriticID,@GGToken,@Answered,@ResponseTimestamp,@ResponseNote,@Hidden);",
entity);
}
public async Task DeleteMasterGameChangeRequest(MasterGameChangeRequest request)
{
var deleteObject = new
{
requestID = request.RequestID
};
await using var connection = new MySqlConnection(_connectionString);
await connection.ExecuteAsync(
"delete from tbl_mastergame_changerequest where RequestID = @requestID;",
deleteObject);
}
public async Task DismissMasterGameChangeRequest(MasterGameChangeRequest request)
{
var dismissObject = new
{
requestID = request.RequestID
};
await using var connection = new MySqlConnection(_connectionString);
await connection.ExecuteAsync(
"update tbl_mastergame_changerequest SET Hidden = 1 where RequestID = @requestID;",
dismissObject);
}
public async Task CompleteMasterGameChangeRequest(MasterGameChangeRequest masterGameRequest, Instant responseTime, string responseNote)
{
string sql = "update tbl_mastergame_changerequest set Answered = 1, ResponseTimestamp = @responseTime, " +
"ResponseNote = @responseNote where RequestID = @requestID;";
await using var connection = new MySqlConnection(_connectionString);
await connection.ExecuteAsync(sql,
new
{
requestID = masterGameRequest.RequestID,
responseTime = responseTime.ToDateTimeUtc(),
responseNote
});
}
public MasterGameChangeRequestViewModel(MasterGameChangeRequest domain, IClock clock)
{
RequestID = domain.RequestID;
RequesterDisplayName = domain.User.DisplayName;
MasterGame = new MasterGameViewModel(domain.MasterGame, clock);
RequestNote = domain.RequestNote;
OpenCriticID = domain.OpenCriticID;
Answered = domain.Answered;
ResponseNote = domain.ResponseNote;
ResponseTimestamp = domain.ResponseTimestamp;
Hidden = domain.Hidden;
}
public MasterGameChangeRequestViewModel(MasterGameChangeRequest domain, LocalDate currentDate)
{
RequestID = domain.RequestID;
RequesterDisplayName = domain.User.UserName;
MasterGame = new MasterGameViewModel(domain.MasterGame, currentDate);
RequestNote = domain.RequestNote;
OpenCriticID = domain.OpenCriticID;
GGToken = domain.GGToken;
Answered = domain.Answered;
ResponseNote = domain.ResponseNote;
ResponseTimestamp = domain.ResponseTimestamp;
Hidden = domain.Hidden;
}
public MasterGameChangeRequestEntity(MasterGameChangeRequest domain)
{
RequestID = domain.RequestID;
UserID = domain.User.UserID;
RequestTimestamp = domain.RequestTimestamp.ToDateTimeUtc();
RequestNote = domain.RequestNote;
MasterGameID = domain.MasterGame.MasterGameID;
OpenCriticID = domain.OpenCriticID;
Answered = domain.Answered;
ResponseTimestamp = domain.ResponseTimestamp?.ToDateTimeUtc();
ResponseNote = domain.ResponseNote;
Hidden = domain.Hidden;
}
public MasterGameChangeRequestEntity(MasterGameChangeRequest domain)
{
RequestID = domain.RequestID;
UserID = domain.User.Id;
RequestTimestamp = domain.RequestTimestamp;
RequestNote = domain.RequestNote;
MasterGameID = domain.MasterGame.MasterGameID;
OpenCriticID = domain.OpenCriticID;
GGToken = domain.GGToken;
Answered = domain.Answered;
ResponseTimestamp = domain.ResponseTimestamp;
ResponseNote = domain.ResponseNote;
Hidden = domain.Hidden;
}
private async Task <IReadOnlyList <MasterGameChangeRequest> > ConvertMasterGameChangeRequestEntities(IEnumerable <MasterGameChangeRequestEntity> entities)
{
var masterGames = await GetMasterGames();
var users = await _userStore.GetAllUsers();
List <MasterGameChangeRequest> domainRequests = new List <MasterGameChangeRequest>();
foreach (var entity in entities)
{
var masterGame = masterGames.Single(x => x.MasterGameID == entity.MasterGameID);
MasterGameChangeRequest domain = entity.ToDomain(users.Single(x => x.UserID == entity.UserID), masterGame);
domainRequests.Add(domain);
}
return(domainRequests);
}
public async Task <IActionResult> CreateMasterGameChangeRequest([FromBody] MasterGameChangeRequestRequest request)
{
var currentUser = await _userManager.FindByNameAsync(User.Identity.Name);
if (!ModelState.IsValid)
{
return(BadRequest());
}
Maybe <MasterGame> masterGame = await _interLeagueService.GetMasterGame(request.MasterGameID);
if (masterGame.HasNoValue)
{
return(NotFound());
}
MasterGameChangeRequest domainRequest = request.ToDomain(currentUser, _clock.GetCurrentInstant(), masterGame.Value);
await _interLeagueService.CreateMasterGameChangeRequest(domainRequest);
return(Ok());
}
public async Task <IActionResult> CreateMasterGameChangeRequest([FromBody] MasterGameChangeRequestRequest request)
{
var currentUserResult = await GetCurrentUser();
if (currentUserResult.IsFailure)
{
return(BadRequest(currentUserResult.Error));
}
var currentUser = currentUserResult.Value;
MasterGame?masterGame = await _interLeagueService.GetMasterGame(request.MasterGameID);
if (masterGame is null)
{
return(NotFound());
}
MasterGameChangeRequest domainRequest = request.ToDomain(currentUser, _clock.GetCurrentInstant(), masterGame);
await _interLeagueService.CreateMasterGameChangeRequest(domainRequest);
return(Ok());
}
public Task DismissMasterGameChangeRequest(MasterGameChangeRequest request)
{
return(_masterGameRepo.DismissMasterGameChangeRequest(request));
}
public Task CompleteMasterGameChangeRequest(MasterGameChangeRequest masterGameRequest, Instant responseTime,
string responseNote)
{
return(_masterGameRepo.CompleteMasterGameChangeRequest(masterGameRequest, responseTime, responseNote));
}
public Task DeleteMasterGameChangeRequest(MasterGameChangeRequest request)
{
return(_masterGameRepo.DeleteMasterGameChangeRequest(request));
}
public Task CreateMasterGameChangeRequest(MasterGameChangeRequest domainRequest)
{
return(_masterGameRepo.CreateMasterGameChangeRequest(domainRequest));
}
public Task CreateMasterGameChangeRequest(MasterGameChangeRequest domainRequest)
{
throw new NotImplementedException();
}
public Task DismissMasterGameChangeRequest(MasterGameChangeRequest request)
{
throw new NotImplementedException();
}
public Task CompleteMasterGameChangeRequest(MasterGameChangeRequest masterGameRequest, Instant responseTime, string responseNote)
{
throw new NotImplementedException();
}
